INDEX_RULE

INDEX_RULE

EntityType	Independent
Logical Entity Name	INDEX_RULE
Default Table Name	DEAL/SERVICES/SERVICE/CREDIT/CREDIT_RESPONSE/LOANS/LOAN/ADJUSTMENT/CONVERSION_ADJUSTMENT/INDEX_RULES/INDEX_RULE
Definition
Note

INDEX_RULE Attributes

Attribute/Logical Rolename Domain Datatype NULL Definition

IndexAveragingIndicator MISMOIndicator BIT NO Indicates that several interest rates are to be averaged to calculate the new interest rate for an ARM change. The average interest rate value, if rate averaging is indicated, is used when the interest rate calculation method indicates some use of a speci

SequenceNumber XSD:Integer INTEGER YES An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.

IndexAveragingType IndexAveragingEnum VARCHAR(0) YES Indicates if and how multiple index values are to be averaged to arrive at the value to be used in the interest rate calculation.

IndexAveragingValueCount MISMOCount INTEGER NO The number of index values that should be averaged to arrive at the value to be used in the interest rate calculation. Used in conjunction with the Per Change Index Averaging Type which indicates how to arrive at the values to be counted and used for aver

IndexCalculationMethodType IndexCalculationMethodEnum VARCHAR(0) YES Indicates the method used to determine the index rate used to calculate the new interest rate.

IndexDesignationType IndexDesignationEnum VARCHAR(0) YES Specifies whether the index is the primary or secondary.

IndexLeadMonthsCount MISMOCount INTEGER NO The number of months prior to an interest rate effective date used to determine the date for the index value when calculating a new interest rate on a loan. Combined with Per Change Index Lead Days Count, with number of Months utilized first to arrive at

IndexLookbackType IndexLookbackEnum VARCHAR(0) YES Specifies the point in time prior to the effective date of the payment adjustment at which date the effective value of the published index is taken to compute the new payment.

IndexLookbackTypeOtherDescription MISMOString VARCHAR(0) NO A free form text field used to collect additional information when Other is selected for Loan Index Lookback Type.

IndexRoundingPercent MISMOPercent DECIMAL(0, 2) NO The percentage to which the index is rounded prior to use in the calculation of the new interest rate. This field is used in conjunction with the Index Rounding Type which indicates how rounding should occur.

IndexRoundingTimingType IndexRoundingTimingEnum VARCHAR(0) YES Describes when rounding occurs relative to the minimum index movement rule.

IndexRoundingType IndexRoundingEnum VARCHAR(0) YES Indicates how the index is rounded prior to use in the calculation of the new interest rate. The index can be rounded up, down or to the nearest factor. This field is used in conjunction with Index Rounding Factor which indicates the percentage to which the rounding occurs.

IndexSourceType IndexSourceEnum VARCHAR(0) YES Specifies the type and source of index to be used to determine the interest rate at each adjustment.

IndexSourceTypeOtherDescription MISMOString VARCHAR(0) NO A free-form text field used to collect additional information or a description of the index, used when Other is selected for the attribute Index Source Type.

IndexType IndexEnum VARCHAR(0) YES Specifies the general category of mortgage index upon which adjustments will be based.

IndexTypeOtherDescription MISMOString VARCHAR(0) NO A free form text field to collect additional information when Other is selected for Index Type.

InterestAdjustmentIndexLeadDaysCount MISMOCount INTEGER NO The number of days prior to an interest rate effective date used to determine the date for the index value when calculating a new interest rate on a loan.

InterestAndPaymentAdjustmentIndexLeadDaysCount MISMOCount INTEGER NO The number of days prior to an interest rate effective date used to determine the date for the index value when calculating both a new interest rate and a principal and interest payment.

MinimumIndexMovementRatePercent MISMOPercent DECIMAL(0, 2) NO The smallest financial index movement that requires an interest rate change. If the movement is less than this percent, then the interest rate will not change at the time of a scheduled adjustment.

PaymentsBetweenIndexValuesCount MISMOCount INTEGER NO The number of payments between the index values that should be used for index averaging.

PaymentsToFirstIndexValueCount MISMOCount INTEGER NO The number of payments from the interest rate change payment due date to the date of the first index rate to be used in index averaging.

INDEX_RULE Keys

Key Name Key Type Keys

INDEX_RULE Relationships

Parent Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Supertype

INDEX_RULES Non-Identifying Zero or One to Zero or More NO

Child Relationships:

Entity Name Type Cardinality Business Name VerbPhrase InversePhrase Foreign Keys Is Subtype

INDEX_RULE Check Constraints

Check Constraint Name CheckConstraint

INDEX_RULE Bound Attachments

Name Current Value

INDEX_RULE User-Defined Mappings

Model Name Description

INDEX_RULE Data Movement Rules

Name Type Rule Text/Value

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
IndexAveragingIndicator	MISMOIndicator	BIT	NO	Indicates that several interest rates are to be averaged to calculate the new interest rate for an ARM change. The average interest rate value, if rate averaging is indicated, is used when the interest rate calculation method indicates some use of a speci
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
IndexAveragingType	IndexAveragingEnum	VARCHAR(0)	YES	Indicates if and how multiple index values are to be averaged to arrive at the value to be used in the interest rate calculation.
IndexAveragingValueCount	MISMOCount	INTEGER	NO	The number of index values that should be averaged to arrive at the value to be used in the interest rate calculation. Used in conjunction with the Per Change Index Averaging Type which indicates how to arrive at the values to be counted and used for aver
IndexCalculationMethodType	IndexCalculationMethodEnum	VARCHAR(0)	YES	Indicates the method used to determine the index rate used to calculate the new interest rate.
IndexDesignationType	IndexDesignationEnum	VARCHAR(0)	YES	Specifies whether the index is the primary or secondary.
IndexLeadMonthsCount	MISMOCount	INTEGER	NO	The number of months prior to an interest rate effective date used to determine the date for the index value when calculating a new interest rate on a loan. Combined with Per Change Index Lead Days Count, with number of Months utilized first to arrive at
IndexLookbackType	IndexLookbackEnum	VARCHAR(0)	YES	Specifies the point in time prior to the effective date of the payment adjustment at which date the effective value of the published index is taken to compute the new payment.
IndexLookbackTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to collect additional information when Other is selected for Loan Index Lookback Type.
IndexRoundingPercent	MISMOPercent	DECIMAL(0, 2)	NO	The percentage to which the index is rounded prior to use in the calculation of the new interest rate. This field is used in conjunction with the Index Rounding Type which indicates how rounding should occur.
IndexRoundingTimingType	IndexRoundingTimingEnum	VARCHAR(0)	YES	Describes when rounding occurs relative to the minimum index movement rule.
IndexRoundingType	IndexRoundingEnum	VARCHAR(0)	YES	Indicates how the index is rounded prior to use in the calculation of the new interest rate. The index can be rounded up, down or to the nearest factor. This field is used in conjunction with Index Rounding Factor which indicates the percentage to which the rounding occurs.
IndexSourceType	IndexSourceEnum	VARCHAR(0)	YES	Specifies the type and source of index to be used to determine the interest rate at each adjustment.
IndexSourceTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free-form text field used to collect additional information or a description of the index, used when Other is selected for the attribute Index Source Type.
IndexType	IndexEnum	VARCHAR(0)	YES	Specifies the general category of mortgage index upon which adjustments will be based.
IndexTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field to collect additional information when Other is selected for Index Type.
InterestAdjustmentIndexLeadDaysCount	MISMOCount	INTEGER	NO	The number of days prior to an interest rate effective date used to determine the date for the index value when calculating a new interest rate on a loan.
InterestAndPaymentAdjustmentIndexLeadDaysCount	MISMOCount	INTEGER	NO	The number of days prior to an interest rate effective date used to determine the date for the index value when calculating both a new interest rate and a principal and interest payment.
MinimumIndexMovementRatePercent	MISMOPercent	DECIMAL(0, 2)	NO	The smallest financial index movement that requires an interest rate change. If the movement is less than this percent, then the interest rate will not change at the time of a scheduled adjustment.
PaymentsBetweenIndexValuesCount	MISMOCount	INTEGER	NO	The number of payments between the index values that should be used for index averaging.
PaymentsToFirstIndexValueCount	MISMOCount	INTEGER	NO	The number of payments from the interest rate change payment due date to the date of the first index rate to be used in index averaging.

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
INDEX_RULES	Non-Identifying	Zero or One to Zero or More					NO