| IndexAveragingIndicator |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexAveragingIndicator |
| Logical Rolename | |
| ColumnName | IndexAveragingIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | 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 |
| Note |
| IndexAveragingIndicator Logical Attribute Properties |
| Logical Attribute Name | IndexAveragingIndicator |
| Datatype | BIT |
| Nullable | NO |
| IndexAveragingIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexAveragingIndicator Bound Attachments |
| Name | Current Value |
| IndexAveragingIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexAveragingIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | INDEX_RULE |
| Attribute Name | SequenceNumber |
| Logical Rolename | |
| ColumnName | SequenceNumber |
| RoleName | |
| Domain | XSD:Integer |
| Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
| Note |
| SequenceNumber Logical Attribute Properties |
| Logical Attribute Name | SequenceNumber |
| Datatype | INTEGER |
| Nullable | YES |
| SequenceNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SequenceNumber Bound Attachments |
| Name | Current Value |
| SequenceNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SequenceNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexAveragingType |
| Logical Rolename | |
| ColumnName | IndexAveragingType |
| RoleName | |
| Domain | IndexAveragingEnum |
| Definition | Indicates if and how multiple index values are to be averaged to arrive at the value to be used in the interest rate calculation. |
| Note |
| IndexAveragingType Logical Attribute Properties |
| Logical Attribute Name | IndexAveragingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexAveragingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexAveragingType Reference Value (Bound to Domain) |
| Name | ValidationRule210 |
| Description | |
| Type | By List |
| Value | Value Description |
| AverageConsecutiveIndexValues | Average consecutive Index values from actual Index history. |
| AveragePeriodicIndexRates | Average periodic index rates from the Index History regardless of changes made to the loans interest rate. |
| AveragePreviousLoanIndexRates | Average consecutive index rates from the loans change file from previous scheduled IR change dates after getting the first value from Index History. |
| IndexAveragingType Bound Attachments |
| Name | Current Value |
| IndexAveragingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexAveragingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingValueCount |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexAveragingValueCount |
| Logical Rolename | |
| ColumnName | IndexAveragingValueCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | 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 |
| Note |
| IndexAveragingValueCount Logical Attribute Properties |
| Logical Attribute Name | IndexAveragingValueCount |
| Datatype | INTEGER |
| Nullable | NO |
| IndexAveragingValueCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexAveragingValueCount Bound Attachments |
| Name | Current Value |
| IndexAveragingValueCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexAveragingValueCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingValueCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingValueCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexAveragingValueCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexCalculationMethodType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexCalculationMethodType |
| Logical Rolename | |
| ColumnName | IndexCalculationMethodType |
| RoleName | |
| Domain | IndexCalculationMethodEnum |
| Definition | Indicates the method used to determine the index rate used to calculate the new interest rate. |
| Note |
| IndexCalculationMethodType Logical Attribute Properties |
| Logical Attribute Name | IndexCalculationMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexCalculationMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexCalculationMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule211 |
| Description | |
| Type | By List |
| Value | Value Description |
| AverageTwoIndexRates | Use the average value of two index rates. |
| CurrentDaysIndexRate | Use the index value that is effective on the date the ARM Change is performed. |
| HighestOfTwoIndexRates | Use the higher value of two index rates. |
| LowestOfTwoIndexRates | Use the lower value of two index rates. |
| SingleIndexRate | Use the index value rate in the ARM Index History. |
| IndexCalculationMethodType Bound Attachments |
| Name | Current Value |
| IndexCalculationMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexCalculationMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexCalculationMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexCalculationMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexCalculationMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexDesignationType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexDesignationType |
| Logical Rolename | |
| ColumnName | IndexDesignationType |
| RoleName | |
| Domain | IndexDesignationEnum |
| Definition | Specifies whether the index is the primary or secondary. |
| Note |
| IndexDesignationType Logical Attribute Properties |
| Logical Attribute Name | IndexDesignationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexDesignationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexDesignationType Reference Value (Bound to Domain) |
| Name | ValidationRule212 |
| Description | |
| Type | By List |
| Value | Value Description |
| Alternate | The alternate (second) index to use when index averaging is required. |
| Primary | The primary index to use. |
| IndexDesignationType Bound Attachments |
| Name | Current Value |
| IndexDesignationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexDesignationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexDesignationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexDesignationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexDesignationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLeadMonthsCount |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexLeadMonthsCount |
| Logical Rolename | |
| ColumnName | IndexLeadMonthsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | 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 |
| Note |
| IndexLeadMonthsCount Logical Attribute Properties |
| Logical Attribute Name | IndexLeadMonthsCount |
| Datatype | INTEGER |
| Nullable | NO |
| IndexLeadMonthsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexLeadMonthsCount Bound Attachments |
| Name | Current Value |
| IndexLeadMonthsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexLeadMonthsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLeadMonthsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLeadMonthsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLeadMonthsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexLookbackType |
| Logical Rolename | |
| ColumnName | IndexLookbackType |
| RoleName | |
| Domain | IndexLookbackEnum |
| Definition | 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. |
| Note |
| IndexLookbackType Logical Attribute Properties |
| Logical Attribute Name | IndexLookbackType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexLookbackType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexLookbackType Reference Value (Bound to Domain) |
| Name | ValidationRule214 |
| Description | |
| Type | By List |
| Value | Value Description |
| FirstMondayOfTheMonth | FirstMondayOfTheMonth |
| Other | Other |
| SecondTuesdayOfTheMonth | SecondTuesdayOfTheMonth |
| SpecificDayOfTheMonth | SpecificDayOfTheMonth |
| ThirdFridayOfTheMonth | ThirdFridayOfTheMonth |
| IndexLookbackType Bound Attachments |
| Name | Current Value |
| IndexLookbackType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexLookbackType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackTypeOtherDescription |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexLookbackTypeOtherDescription |
| Logical Rolename | |
| ColumnName | IndexLookbackTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Loan Index Lookback Type. |
| Note |
| IndexLookbackTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | IndexLookbackTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| IndexLookbackTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexLookbackTypeOtherDescription Bound Attachments |
| Name | Current Value |
| IndexLookbackTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexLookbackTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexLookbackTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingPercent |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexRoundingPercent |
| Logical Rolename | |
| ColumnName | IndexRoundingPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | 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. |
| Note |
| IndexRoundingPercent Logical Attribute Properties |
| Logical Attribute Name | IndexRoundingPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| IndexRoundingPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexRoundingPercent Bound Attachments |
| Name | Current Value |
| IndexRoundingPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexRoundingPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingTimingType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexRoundingTimingType |
| Logical Rolename | |
| ColumnName | IndexRoundingTimingType |
| RoleName | |
| Domain | IndexRoundingTimingEnum |
| Definition | Describes when rounding occurs relative to the minimum index movement rule. |
| Note |
| IndexRoundingTimingType Logical Attribute Properties |
| Logical Attribute Name | IndexRoundingTimingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexRoundingTimingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexRoundingTimingType Reference Value (Bound to Domain) |
| Name | ValidationRule216 |
| Description | |
| Type | By List |
| Value | Value Description |
| RoundIndexAfterCheckingMinimumIndexMovement | RoundIndexAfterCheckingMinimumIndexMovement |
| RoundIndexBeforeCheckingMinimumIndexMovement | RoundIndexBeforeCheckingMinimumIndexMovement |
| IndexRoundingTimingType Bound Attachments |
| Name | Current Value |
| IndexRoundingTimingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexRoundingTimingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingTimingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingTimingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingTimingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexRoundingType |
| Logical Rolename | |
| ColumnName | IndexRoundingType |
| RoleName | |
| Domain | IndexRoundingEnum |
| Definition | 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. |
| Note |
| IndexRoundingType Logical Attribute Properties |
| Logical Attribute Name | IndexRoundingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexRoundingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexRoundingType Reference Value (Bound to Domain) |
| Name | ValidationRule215 |
| Description | |
| Type | By List |
| Value | Value Description |
| Nearest | Nearest |
| NoRounding | NoRounding |
| Up | Up |
| IndexRoundingType Bound Attachments |
| Name | Current Value |
| IndexRoundingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexRoundingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexRoundingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexSourceType |
| Logical Rolename | |
| ColumnName | IndexSourceType |
| RoleName | |
| Domain | IndexSourceEnum |
| Definition | Specifies the type and source of index to be used to determine the interest rate at each adjustment. |
| Note |
| IndexSourceType Logical Attribute Properties |
| Logical Attribute Name | IndexSourceType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexSourceType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexSourceType Reference Value (Bound to Domain) |
| Name | ValidationRule217 |
| Description | |
| Type | By List |
| Value | Value Description |
| FHLBEleventhDistrictMonthlyCostOfFundsIndex | The monthly weighted average cost of savings, borrowings, and advances of members of the Federal Home Loan Bank of San Francisco (the Bank), as made available by the Bank. |
| LIBOROneMonthWSJ25thDayOfMonth | The average of interbank offered rates for one month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 25th day of each month. |
| LIBOROneMonthWSJ25thDayOfMonthOrNextBusinessDay | The average of interbank offered rates for one month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 25th day of each month (or next business day after the 25th day of the month if the 25th falls on a holiday or weekend). |
| LIBOROneMonthWSJDaily | The average of interbank offered rates for one month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal. |
| LIBOROneMonthWSJFifteenthDayOfMonth | The average of interbank offered rates for one month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 15th day of each month. |
| LIBOROneMonthWSJFifteenthDayOfMonthOrNextBusinessDay | The average of interbank offered rates for one month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 15th day of each month (or next business day after the 15th day of the month if the 15th falls on a holiday or weekend). |
| LIBOROneYearWSJDaily | The average of interbank offered rates for one year U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal. |
| LIBORSixMonthWSJ25thDayOfMonth | The average of interbank offered rates for six month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 25th day of each month. |
| LIBORSixMonthWSJ25thDayOfMonthOrNextBusinessDay | The average of interbank offered rates for six month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 25th day of each month (or next business day after the 25th day of the month if the 25th falls on a holiday or weekend). |
| LIBORSixMonthWSJFifteenthDayOfMonth | The average of interbank offered rates for six month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 15th day of each month. |
| LIBORSixMonthWSJFifteenthDayOfMonthOrNextBusinessDay | The average of interbank offered rates for six month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the 15th day of each month (or next business day after the 15th day of the month if the 15th falls on a holiday or weekend). |
| LIBORSixMonthWSJLastBusinessDayOfMonth | The average of interbank offered rates for six month U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal on the last business day of the month. |
| MonthlyFiveYearTreasurySecuritiesConstantMaturityFRBH15 | The monthly average yield on United States Treasury securities adjusted to constant maturity of five years, as made available by the Federal Reserve Board. |
| MonthlyOneYearTreasurySecuritiesConstantMaturityFRBH15 | The monthly average yield on United States Treasury securities adjusted to constant maturity of one year, as made available by the Federal Reserve Board. |
| MonthlyThreeYearTreasurySecuritiesConstantMaturityFRBH15 | The monthly average yield on United States Treasury securities adjusted to constant maturity of three years, as made available by the Federal Reserve Board. |
| NationalAverageContractMortgageRate | The National Average Contract Mortgage Rate, as derived from the Federal Housing Finance Board monthly interest rate survey (MIRS). |
| NationalMonthlyMedianCostOfFundsIndexOTS | NationalMonthlyMedianCostOfFundsIndexOTS |
| Other | Other |
| PrimeRateWSJEffectiveDate | The Prime Rate (effective as of the published Effective Date) as published in the Money Rates section of the Wall Street Journal. |
| PrimeRateWSJPublicationDate | The Prime Rate as published in the Money Rates section of the Wall Street Journal. |
| SixMonthLIBOR_WSJDaily | The average of the interbank offered rates for six months U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal. |
| SixMonthLIBOR_WSJFirstBusinessDayOfTheMonth | The average of the interbank offered rates for six months U.S. dollar-denominated deposits in the London market (LIBOR), as published in the Wall Street Journal. The most recent index figure available as of the first business day of the month immediately preceding the month in which the Change Date occurs is the Current Index. |
| SixMonthUSTBillMonthlyAuctionDiscountRateCalculated | The twelve (12) month average of the monthly auction average (discount rate) on United States Treasury bills with a maturity of six months [or twenty-six weeks], as made available by the Federal Reserve Board |
| SixMonthUSTBillMonthlyAuctionInvestmentYieldCalculated | The monthly auction average (investment yield) on United States Treasury bills with a maturity of six months [or twenty-six weeks], as made available by the Federal Reserve Board. |
| SixMonthUSTBillWeeklyAuctionDiscountRateUST | The weekly auction average (discount rate) on United States Treasury bills with a maturity of six months [or twenty-six weeks], as made available by the U.S. Treasury after the sale of these securities. |
| SixMonthUSTBillWeeklyAuctionInvestmentYieldUST | The weekly auction average (investment yield) on United States Treasury bills with a maturity of six months [or twenty-six weeks], as made available by the U.S. Treasury after the sale of these securities. |
| WeeklyFiveYearTreasurySecuritiesConstantMaturityFRBH15 | The weekly average yield on United States Treasury securities adjusted to constant maturity of five years, as made available by the Federal Reserve Board. |
| WeeklyOneYearTreasurySecuritiesConstantMaturityFRBH15 | The weekly average yield on United States Treasury securities adjusted to constant maturity of one year, as made available by the Federal Reserve Board. |
| WeeklySixMonthCertificateOfDepositSecondaryMarketFRBH15 | The weekly average yield of the secondary market interest rates on six-month negotiable certificates of deposit, as made by the Federal Reserve Board. |
| WeeklyTenYearTreasurySecuritiesConstantMaturityFRBH15 | The weekly average yield on United States Treasury securities adjusted to constant maturity of ten years, as made available by the Federal Reserve Board. |
| WeeklyThreeYearTreasurySecuritiesConstantMaturityFRBH15 | The weekly average yield on United States Treasury securities adjusted to constant maturity of three years, as made available by the Federal Reserve Board. |
| IndexSourceType Bound Attachments |
| Name | Current Value |
| IndexSourceType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexSourceType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceTypeOtherDescription |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexSourceTypeOtherDescription |
| Logical Rolename | |
| ColumnName | IndexSourceTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | 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. |
| Note |
| IndexSourceTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | IndexSourceTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| IndexSourceTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexSourceTypeOtherDescription Bound Attachments |
| Name | Current Value |
| IndexSourceTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexSourceTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexSourceTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexType |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexType |
| Logical Rolename | |
| ColumnName | IndexType |
| RoleName | |
| Domain | IndexEnum |
| Definition | Specifies the general category of mortgage index upon which adjustments will be based. |
| Note |
| IndexType Logical Attribute Properties |
| Logical Attribute Name | IndexType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| IndexType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexType Reference Value (Bound to Domain) |
| Name | ValidationRule213 |
| Description | |
| Type | By List |
| Value | Value Description |
| BankPrimeLoan | Often referred to as Prime Rate |
| CertificateOfDepositIndex | Often referred to as CODI |
| ConstantMaturityTreasury | Often refered to as CMT |
| CostOfSavingsIndex | Often referred to as COSI |
| EleventhDistrictCostOfFundsIndex | Often referred to as COFI |
| LIBOR | London Interbank Offered Rate |
| Other | Other |
| TreasuryBill | Often referred to as T-Bill |
| TwelveMonthTreasuryAverage | Often referred to as MTA |
| IndexType Bound Attachments |
| Name | Current Value |
| IndexType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexTypeOtherDescription |
| Base Entity | INDEX_RULE |
| Attribute Name | IndexTypeOtherDescription |
| Logical Rolename | |
| ColumnName | IndexTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field to collect additional information when Other is selected for Index Type. |
| Note |
| IndexTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | IndexTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| IndexTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| IndexTypeOtherDescription Bound Attachments |
| Name | Current Value |
| IndexTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| IndexTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| IndexTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAdjustmentIndexLeadDaysCount |
| Base Entity | INDEX_RULE |
| Attribute Name | InterestAdjustmentIndexLeadDaysCount |
| Logical Rolename | |
| ColumnName | InterestAdjustmentIndexLeadDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | 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. |
| Note |
| InterestAdjustmentIndexLeadDaysCount Logical Attribute Properties |
| Logical Attribute Name | InterestAdjustmentIndexLeadDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| InterestAdjustmentIndexLeadDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestAdjustmentIndexLeadDaysCount Bound Attachments |
| Name | Current Value |
| InterestAdjustmentIndexLeadDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestAdjustmentIndexLeadDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAdjustmentIndexLeadDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAdjustmentIndexLeadDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAdjustmentIndexLeadDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAndPaymentAdjustmentIndexLeadDaysCount |
| Base Entity | INDEX_RULE |
| Attribute Name | InterestAndPaymentAdjustmentIndexLeadDaysCount |
| Logical Rolename | |
| ColumnName | InterestAndPaymentAdjustmentIndexLeadDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | 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. |
| Note |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Logical Attribute Properties |
| Logical Attribute Name | InterestAndPaymentAdjustmentIndexLeadDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Bound Attachments |
| Name | Current Value |
| InterestAndPaymentAdjustmentIndexLeadDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestAndPaymentAdjustmentIndexLeadDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MinimumIndexMovementRatePercent |
| Base Entity | INDEX_RULE |
| Attribute Name | MinimumIndexMovementRatePercent |
| Logical Rolename | |
| ColumnName | MinimumIndexMovementRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | 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. |
| Note |
| MinimumIndexMovementRatePercent Logical Attribute Properties |
| Logical Attribute Name | MinimumIndexMovementRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| MinimumIndexMovementRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MinimumIndexMovementRatePercent Bound Attachments |
| Name | Current Value |
| MinimumIndexMovementRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MinimumIndexMovementRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MinimumIndexMovementRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MinimumIndexMovementRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MinimumIndexMovementRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenIndexValuesCount |
| Base Entity | INDEX_RULE |
| Attribute Name | PaymentsBetweenIndexValuesCount |
| Logical Rolename | |
| ColumnName | PaymentsBetweenIndexValuesCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of payments between the index values that should be used for index averaging. |
| Note |
| PaymentsBetweenIndexValuesCount Logical Attribute Properties |
| Logical Attribute Name | PaymentsBetweenIndexValuesCount |
| Datatype | INTEGER |
| Nullable | NO |
| PaymentsBetweenIndexValuesCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PaymentsBetweenIndexValuesCount Bound Attachments |
| Name | Current Value |
| PaymentsBetweenIndexValuesCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PaymentsBetweenIndexValuesCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenIndexValuesCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenIndexValuesCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsBetweenIndexValuesCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsToFirstIndexValueCount |
| Base Entity | INDEX_RULE |
| Attribute Name | PaymentsToFirstIndexValueCount |
| Logical Rolename | |
| ColumnName | PaymentsToFirstIndexValueCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | 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. |
| Note |
| PaymentsToFirstIndexValueCount Logical Attribute Properties |
| Logical Attribute Name | PaymentsToFirstIndexValueCount |
| Datatype | INTEGER |
| Nullable | NO |
| PaymentsToFirstIndexValueCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PaymentsToFirstIndexValueCount Bound Attachments |
| Name | Current Value |
| PaymentsToFirstIndexValueCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PaymentsToFirstIndexValueCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsToFirstIndexValueCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsToFirstIndexValueCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PaymentsToFirstIndexValueCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |