| PoolAccrualRateStructureType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolAccrualRateStructureType |
| Logical Rolename | |
| ColumnName | PoolAccrualRateStructureType |
| RoleName | |
| Domain | PoolAccrualRateStructureEnum |
| Definition | Specifies the structure used to determine the accrual interest rate for the pool. |
| Note |
| PoolAccrualRateStructureType Logical Attribute Properties |
| Logical Attribute Name | PoolAccrualRateStructureType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolAccrualRateStructureType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolAccrualRateStructureType Reference Value (Bound to Domain) |
| Name | ValidationRule365 |
| Description | |
| Type | By List |
| Value | Value Description |
| StatedStructure | StatedStructure |
| WeightedAverageStructure | WeightedAverageStructure |
| PoolAccrualRateStructureType Bound Attachments |
| Name | Current Value |
| PoolAccrualRateStructureType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolAccrualRateStructureType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAccrualRateStructureType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAccrualRateStructureType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAccrualRateStructureType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolAmortizationType |
| Logical Rolename | |
| ColumnName | PoolAmortizationType |
| RoleName | |
| Domain | AmortizationEnum |
| Definition | A classification or description for a pool of loans generally based on the variability of the rate or payment over time.The changeability of the rate or payment over time. |
| Note |
| PoolAmortizationType Logical Attribute Properties |
| Logical Attribute Name | PoolAmortizationType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolAmortizationType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolAmortizationType Reference Value (Bound to Domain) |
| Name | ValidationRule15 |
| Description | |
| Type | By List |
| Value | Value Description |
| AdjustableRate | A mortgage that allows the lender to adjust the interest rate in accordance with a specified index periodically. |
| Fixed | A mortgage in which the interest rate and payments remain the same for the life of the loan. |
| GEM | GEM (Growing Equity Mortgage) - A graduated payment mortgage in which increases in a borrowers mortgage payments are used to accelerate reduction of principal on the mortgage. Due to increased payment, the borrower acquires equity more rapidly and retires the debt earlier. |
| GPM | GPM - (Graduated Payment Mortgage) A type of flexible payment mortgage where the payments increase for a specified period of time and then level off. Usually involves negative amortization. |
| GraduatedPaymentARM | Periodic payments/rate changes with additional specified principal and interest changes as documented in the Security Instruments. |
| Other | Used to describe the amortization type if it is other than those specified in the enumerated list of Loan Amortization Types. |
| RateImprovementMortgage | A type of flexible mortgage where the interest rate may decrease based on payment history. |
| ReverseMortgage | A mortgage which uses present equity in the property to fund payments from the lender to the borrower-in lieu of the borrower receiving the proceeds of the loan in a lump sum. As a general rule no payments are made from the borrower to the lender and interest is accrued for payment at the end of the mortgage. |
| Step | Fixed periodic payment/rate changes up to 5 years without subsidy or negative amortization. |
| PoolAmortizationType Bound Attachments |
| Name | Current Value |
| PoolAmortizationType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolAmortizationType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationTypeOtherDescription |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolAmortizationTypeOtherDescription |
| Logical Rolename | |
| ColumnName | PoolAmortizationTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to collect additional information or a description of the mortgage type when Other is selected for Pool Amortization Type. |
| Note |
| PoolAmortizationTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | PoolAmortizationTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolAmortizationTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolAmortizationTypeOtherDescription Bound Attachments |
| Name | Current Value |
| PoolAmortizationTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolAmortizationTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAmortizationTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAssumabilityIndicator |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolAssumabilityIndicator |
| Logical Rolename | |
| ColumnName | PoolAssumabilityIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the pool is backed by loans that are assumable by another borrower. |
| Note |
| PoolAssumabilityIndicator Logical Attribute Properties |
| Logical Attribute Name | PoolAssumabilityIndicator |
| Datatype | BIT |
| Nullable | NO |
| PoolAssumabilityIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolAssumabilityIndicator Bound Attachments |
| Name | Current Value |
| PoolAssumabilityIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolAssumabilityIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAssumabilityIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAssumabilityIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolAssumabilityIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolBalloonIndicator |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolBalloonIndicator |
| Logical Rolename | |
| ColumnName | PoolBalloonIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether or not the pool is backed by loans where a final balloon payment is required under the terms of the loan repayment schedule to fully pay off the loan. |
| Note |
| PoolBalloonIndicator Logical Attribute Properties |
| Logical Attribute Name | PoolBalloonIndicator |
| Datatype | BIT |
| Nullable | NO |
| PoolBalloonIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolBalloonIndicator Bound Attachments |
| Name | Current Value |
| PoolBalloonIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolBalloonIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolBalloonIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolBalloonIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolBalloonIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolClassType |
| Logical Rolename | |
| ColumnName | PoolClassType |
| RoleName | |
| Domain | PoolClassEnum |
| Definition | Indicates the type of pool and its guarantor (if any). |
| Note |
| PoolClassType Logical Attribute Properties |
| Logical Attribute Name | PoolClassType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolClassType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolClassType Reference Value (Bound to Domain) |
| Name | ValidationRule366 |
| Description | |
| Type | By List |
| Value | Value Description |
| FNM | Fannie Mae Pool |
| FRE | Freddie Mac Pool |
| GNMAI | Ginnie Mae I_Class A Pool |
| GNMAII | Ginnie Mae II_Class B Pool |
| Other | Other |
| Private | Private Pool |
| PoolClassType Bound Attachments |
| Name | Current Value |
| PoolClassType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolClassType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassTypeOtherDescription |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolClassTypeOtherDescription |
| Logical Rolename | |
| ColumnName | PoolClassTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the Pool Class if Other is selected as the Pool Class Type. |
| Note |
| PoolClassTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | PoolClassTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolClassTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolClassTypeOtherDescription Bound Attachments |
| Name | Current Value |
| PoolClassTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolClassTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolClassTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentLoanCount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolCurrentLoanCount |
| Logical Rolename | |
| ColumnName | PoolCurrentLoanCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The current number of mortgages in the pool with principal balances as of the last cutoff. |
| Note |
| PoolCurrentLoanCount Logical Attribute Properties |
| Logical Attribute Name | PoolCurrentLoanCount |
| Datatype | INTEGER |
| Nullable | NO |
| PoolCurrentLoanCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolCurrentLoanCount Bound Attachments |
| Name | Current Value |
| PoolCurrentLoanCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolCurrentLoanCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentLoanCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentLoanCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentLoanCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentPrincipalBalanceAmount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolCurrentPrincipalBalanceAmount |
| Logical Rolename | |
| ColumnName | PoolCurrentPrincipalBalanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Total dollar amount of the remaining unpaid principal balance for a pool of mortgages as of the last cutoff. |
| Note |
| PoolCurrentPrincipalBalanceAmount Logical Attribute Properties |
| Logical Attribute Name | PoolCurrentPrincipalBalanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolCurrentPrincipalBalanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolCurrentPrincipalBalanceAmount Bound Attachments |
| Name | Current Value |
| PoolCurrentPrincipalBalanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolCurrentPrincipalBalanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentPrincipalBalanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentPrincipalBalanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCurrentPrincipalBalanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCUSIPIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolCUSIPIdentifier |
| Logical Rolename | |
| ColumnName | PoolCUSIPIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Unique identifier for a security according to the standards set by Committee on Uniform Security Identification Practices. The CUSIP is registered with the SEC and the Federal Reserve. |
| Note |
| PoolCUSIPIdentifier Logical Attribute Properties |
| Logical Attribute Name | PoolCUSIPIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolCUSIPIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolCUSIPIdentifier Bound Attachments |
| Name | Current Value |
| PoolCUSIPIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolCUSIPIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCUSIPIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCUSIPIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolCUSIPIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolFixedServicingFeePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolFixedServicingFeePercent |
| Logical Rolename | |
| ColumnName | PoolFixedServicingFeePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The servicing fee to be used in determining the rate of interest that accrues on an mortgage backed security (MBS) pool that has a weighted-average structure based on a fixed servicing fee. |
| Note |
| PoolFixedServicingFeePercent Logical Attribute Properties |
| Logical Attribute Name | PoolFixedServicingFeePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolFixedServicingFeePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolFixedServicingFeePercent Bound Attachments |
| Name | Current Value |
| PoolFixedServicingFeePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolFixedServicingFeePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolFixedServicingFeePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolFixedServicingFeePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolFixedServicingFeePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolGuarantyFeeRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolGuarantyFeeRatePercent |
| Logical Rolename | |
| ColumnName | PoolGuarantyFeeRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage of the guaranty fee rate that applies to loans in the pool that do not have a rate specified at the individual loan level. |
| Note |
| PoolGuarantyFeeRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolGuarantyFeeRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolGuarantyFeeRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolGuarantyFeeRatePercent Bound Attachments |
| Name | Current Value |
| PoolGuarantyFeeRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolGuarantyFeeRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolGuarantyFeeRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolGuarantyFeeRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolGuarantyFeeRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolIdentifier |
| Logical Rolename | |
| ColumnName | PoolIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The unique identifier for a group or pool of loans. May include relevant prefix and suffix when not parsed into applicable fields. See Pool Prefix Identifier or Pool Suffix Identifier. |
| Note |
| PoolIdentifier Logical Attribute Properties |
| Logical Attribute Name | PoolIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolIdentifier Bound Attachments |
| Name | Current Value |
| PoolIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolingMethodType |
| Logical Rolename | |
| ColumnName | PoolingMethodType |
| RoleName | |
| Domain | PoolingMethodEnum |
| Definition | Indicates the timing of the remittance of the scheduled principal and interest payment from the servicer to the certificate holders of a particular pool. |
| Note |
| PoolingMethodType Logical Attribute Properties |
| Logical Attribute Name | PoolingMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolingMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolingMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule368 |
| Description | |
| Type | By List |
| Value | Value Description |
| ConcurrentDate | Payments are remitted to investors 15 days after the loan scheduled due date. |
| InternalReserve | Payments are remitted to investors 45 days after due date. |
| Other | Other |
| PoolingMethodType Bound Attachments |
| Name | Current Value |
| PoolingMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolingMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodTypeOtherDescription |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolingMethodTypeOtherDescription |
| Logical Rolename | |
| ColumnName | PoolingMethodTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the Pooling Method Type if Other is selected. |
| Note |
| PoolingMethodTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | PoolingMethodTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolingMethodTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolingMethodTypeOtherDescription Bound Attachments |
| Name | Current Value |
| PoolingMethodTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolingMethodTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolingMethodTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAdjustmentIndexLeadDaysCount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInterestAdjustmentIndexLeadDaysCount |
| Logical Rolename | |
| ColumnName | PoolInterestAdjustmentIndexLeadDaysCount |
| 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 for a pool of loans. |
| Note |
| PoolInterestAdjustmentIndexLeadDaysCount Logical Attribute Properties |
| Logical Attribute Name | PoolInterestAdjustmentIndexLeadDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| PoolInterestAdjustmentIndexLeadDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInterestAdjustmentIndexLeadDaysCount Bound Attachments |
| Name | Current Value |
| PoolInterestAdjustmentIndexLeadDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInterestAdjustmentIndexLeadDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAdjustmentIndexLeadDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAdjustmentIndexLeadDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAdjustmentIndexLeadDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInterestAndPaymentAdjustmentIndexLeadDaysCount |
| Logical Rolename | |
| ColumnName | PoolInterestAndPaymentAdjustmentIndexLeadDaysCount |
| 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 for a pool of loans. |
| Note |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Logical Attribute Properties |
| Logical Attribute Name | PoolInterestAndPaymentAdjustmentIndexLeadDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Bound Attachments |
| Name | Current Value |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestAndPaymentAdjustmentIndexLeadDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestOnlyIndicator |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInterestOnlyIndicator |
| Logical Rolename | |
| ColumnName | PoolInterestOnlyIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether a pool is backed by loans with interest only payments. |
| Note |
| PoolInterestOnlyIndicator Logical Attribute Properties |
| Logical Attribute Name | PoolInterestOnlyIndicator |
| Datatype | BIT |
| Nullable | NO |
| PoolInterestOnlyIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInterestOnlyIndicator Bound Attachments |
| Name | Current Value |
| PoolInterestOnlyIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInterestOnlyIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestOnlyIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestOnlyIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestOnlyIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingPercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInterestRateRoundingPercent |
| Logical Rolename | |
| ColumnName | PoolInterestRateRoundingPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage to which the interest rate is rounded when a new interest rate is calculated for a pool. This field is used in conjunction with Pool Interest Rate Rounding Type which indicates how the rounding should occur. |
| Note |
| PoolInterestRateRoundingPercent Logical Attribute Properties |
| Logical Attribute Name | PoolInterestRateRoundingPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolInterestRateRoundingPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInterestRateRoundingPercent Bound Attachments |
| Name | Current Value |
| PoolInterestRateRoundingPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInterestRateRoundingPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInterestRateRoundingType |
| Logical Rolename | |
| ColumnName | PoolInterestRateRoundingType |
| RoleName | |
| Domain | InterestRateRoundingEnum |
| Definition | Indicates how the interest rate is rounded when a new interest rate is calculated for a pool of loans.Specifies how the interest rate is rounded when a new interest rate is calculated for an ARM change. The interest rate can be rounded Up, Down or to the Nearest Percent. This field is used in conjunction with Interest Rate Rounding Percent which indicates the percentage to which the rounding occurs. |
| Note |
| PoolInterestRateRoundingType Logical Attribute Properties |
| Logical Attribute Name | PoolInterestRateRoundingType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolInterestRateRoundingType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInterestRateRoundingType Reference Value (Bound to Domain) |
| Name | ValidationRule79 |
| Description | |
| Type | By List |
| Value | Value Description |
| Down | Down |
| Nearest | Nearest |
| NoRounding | NoRounding |
| Up | Up |
| PoolInterestRateRoundingType Bound Attachments |
| Name | Current Value |
| PoolInterestRateRoundingType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInterestRateRoundingType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateRoundingType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateTruncatedDigitsCount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInterestRateTruncatedDigitsCount |
| Logical Rolename | |
| ColumnName | PoolInterestRateTruncatedDigitsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | Indicates the number of digits the interest rate should be truncated for a pool. |
| Note |
| PoolInterestRateTruncatedDigitsCount Logical Attribute Properties |
| Logical Attribute Name | PoolInterestRateTruncatedDigitsCount |
| Datatype | INTEGER |
| Nullable | NO |
| PoolInterestRateTruncatedDigitsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInterestRateTruncatedDigitsCount Bound Attachments |
| Name | Current Value |
| PoolInterestRateTruncatedDigitsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInterestRateTruncatedDigitsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateTruncatedDigitsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateTruncatedDigitsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInterestRateTruncatedDigitsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInvestorProductPlanIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolInvestorProductPlanIdentifier |
| Logical Rolename | |
| ColumnName | PoolInvestorProductPlanIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifies the plan of the varying loan payment and/or rate change characteristics for a pool of loans issued by the servicer. |
| Note |
| PoolInvestorProductPlanIdentifier Logical Attribute Properties |
| Logical Attribute Name | PoolInvestorProductPlanIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolInvestorProductPlanIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolInvestorProductPlanIdentifier Bound Attachments |
| Name | Current Value |
| PoolInvestorProductPlanIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolInvestorProductPlanIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInvestorProductPlanIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInvestorProductPlanIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolInvestorProductPlanIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssueDate |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolIssueDate |
| Logical Rolename | |
| ColumnName | PoolIssueDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date a mortgage backed security is issued to investors. |
| Note |
| PoolIssueDate Logical Attribute Properties |
| Logical Attribute Name | PoolIssueDate |
| Datatype | DATE |
| Nullable | NO |
| PoolIssueDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolIssueDate Bound Attachments |
| Name | Current Value |
| PoolIssueDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolIssueDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssueDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssueDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssueDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssuerIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolIssuerIdentifier |
| Logical Rolename | |
| ColumnName | PoolIssuerIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identification number assigned by pool guarantor to the Issuer or current servicer of the pool. |
| Note |
| PoolIssuerIdentifier Logical Attribute Properties |
| Logical Attribute Name | PoolIssuerIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolIssuerIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolIssuerIdentifier Bound Attachments |
| Name | Current Value |
| PoolIssuerIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolIssuerIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssuerIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssuerIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolIssuerIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMarginRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMarginRatePercent |
| Logical Rolename | |
| ColumnName | PoolMarginRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The factor that is added to the ARM index value to calculate the pool accrual rate. |
| Note |
| PoolMarginRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolMarginRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolMarginRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMarginRatePercent Bound Attachments |
| Name | Current Value |
| PoolMarginRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMarginRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMarginRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMarginRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMarginRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaturityDate |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMaturityDate |
| Logical Rolename | |
| ColumnName | PoolMaturityDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the final payment is due on the pool. The pool maturity date is typically 15 to 45 days after the maturity date of the latest maturing mortgage in the mortgage-backed security. |
| Note |
| PoolMaturityDate Logical Attribute Properties |
| Logical Attribute Name | PoolMaturityDate |
| Datatype | DATE |
| Nullable | NO |
| PoolMaturityDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMaturityDate Bound Attachments |
| Name | Current Value |
| PoolMaturityDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMaturityDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaturityDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaturityDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaturityDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaximumAccrualRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMaximumAccrualRatePercent |
| Logical Rolename | |
| ColumnName | PoolMaximumAccrualRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The maximum rate, expressed as a percent, at which interest can accrue on a pool. |
| Note |
| PoolMaximumAccrualRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolMaximumAccrualRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolMaximumAccrualRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMaximumAccrualRatePercent Bound Attachments |
| Name | Current Value |
| PoolMaximumAccrualRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMaximumAccrualRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaximumAccrualRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaximumAccrualRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMaximumAccrualRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMinimumAccrualRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMinimumAccrualRatePercent |
| Logical Rolename | |
| ColumnName | PoolMinimumAccrualRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The minimum rate, expressed as a percent, at which interest can accrue on a pool. |
| Note |
| PoolMinimumAccrualRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolMinimumAccrualRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolMinimumAccrualRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMinimumAccrualRatePercent Bound Attachments |
| Name | Current Value |
| PoolMinimumAccrualRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMinimumAccrualRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMinimumAccrualRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMinimumAccrualRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMinimumAccrualRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMortgageRatePercent |
| Logical Rolename | |
| ColumnName | PoolMortgageRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The annual interest rate, expressed as a percent, of the mortgages in a pool as of last cutoff date. |
| Note |
| PoolMortgageRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolMortgageRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolMortgageRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMortgageRatePercent Bound Attachments |
| Name | Current Value |
| PoolMortgageRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMortgageRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMortgageType |
| Logical Rolename | |
| ColumnName | PoolMortgageType |
| RoleName | |
| Domain | MortgageEnum |
| Definition | Specifies mortgage type of the loans for the pool. |
| Note |
| PoolMortgageType Logical Attribute Properties |
| Logical Attribute Name | PoolMortgageType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolMortgageType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMortgageType Reference Value (Bound to Domain) |
| Name | ValidationRule316 |
| Description | |
| Type | By List |
| Value | Value Description |
| Conventional | Mortgage financing which is not insured or guaranteed by a government agency. |
| FHA | A loan originated in accordance with the guidelines of HUD’s Federal Housing Administration, a federal agency that provides mortgage insurance on single-family, multifamily, manufactured homes and hospital loans made by FHA-approved lenders throughout the United States and its territories. |
| LocalAgency | A loan originated in accordance with the guidelines of an agency governed by a municipal jurisdiction. |
| Other | Other |
| PublicAndIndianHousing | A loan originated in accordance with the guidelines of HUD’s Office of Native American Programs, which provides safe and affordable housing for lower-income Native American, Alaska Native and Native Hawaiian families. |
| StateAgency | A loan originated in accordance with the guidelines of an agency governed by a state jurisdiction. |
| USDARuralDevelopment | A loan originated in accordance with the guidelines of the USDA Rural Development Agency’s Housing and Community Facilities Program, which provides funding for single family homes in rural communities. |
| VA | A loan originated in accordance with the guidelines of the Department of Veterans Affairs’ Loan Guaranty Home Loan Program, which guarantees loans made by private lenders, such as banks, savings & loans, or mortgage companies to eligible veterans for the purchase of a home which must be for their own personal occupancy. |
| PoolMortgageType Bound Attachments |
| Name | Current Value |
| PoolMortgageType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMortgageType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageTypeOtherDescription |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolMortgageTypeOtherDescription |
| Logical Rolename | |
| ColumnName | PoolMortgageTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to collect additional information or a description of the mortgage type when Other is selected for Pool Mortgage Type. |
| Note |
| PoolMortgageTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | PoolMortgageTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolMortgageTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolMortgageTypeOtherDescription Bound Attachments |
| Name | Current Value |
| PoolMortgageTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolMortgageTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolMortgageTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalLoanCount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolOriginalLoanCount |
| Logical Rolename | |
| ColumnName | PoolOriginalLoanCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The total number of loans in the pool when the pool was set up. |
| Note |
| PoolOriginalLoanCount Logical Attribute Properties |
| Logical Attribute Name | PoolOriginalLoanCount |
| Datatype | INTEGER |
| Nullable | NO |
| PoolOriginalLoanCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolOriginalLoanCount Bound Attachments |
| Name | Current Value |
| PoolOriginalLoanCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolOriginalLoanCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalLoanCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalLoanCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalLoanCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalPrincipalBalanceAmount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolOriginalPrincipalBalanceAmount |
| Logical Rolename | |
| ColumnName | PoolOriginalPrincipalBalanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The total of the original principal balance of all the loans in the pool. For participations the principal balance contributed for an individual loan is adjusted based upon the participation percent. |
| Note |
| PoolOriginalPrincipalBalanceAmount Logical Attribute Properties |
| Logical Attribute Name | PoolOriginalPrincipalBalanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolOriginalPrincipalBalanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolOriginalPrincipalBalanceAmount Bound Attachments |
| Name | Current Value |
| PoolOriginalPrincipalBalanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolOriginalPrincipalBalanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalPrincipalBalanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalPrincipalBalanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOriginalPrincipalBalanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOwnershipPercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolOwnershipPercent |
| Logical Rolename | |
| ColumnName | PoolOwnershipPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Identifies the percentage amount of the pool owned by the investor. |
| Note |
| PoolOwnershipPercent Logical Attribute Properties |
| Logical Attribute Name | PoolOwnershipPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolOwnershipPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolOwnershipPercent Bound Attachments |
| Name | Current Value |
| PoolOwnershipPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolOwnershipPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOwnershipPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOwnershipPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolOwnershipPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolPrefixIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolPrefixIdentifier |
| Logical Rolename | |
| ColumnName | PoolPrefixIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The prefix associated with the pool identifier. |
| Note |
| PoolPrefixIdentifier Logical Attribute Properties |
| Logical Attribute Name | PoolPrefixIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolPrefixIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolPrefixIdentifier Bound Attachments |
| Name | Current Value |
| PoolPrefixIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolPrefixIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolPrefixIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolPrefixIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolPrefixIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledPrincipalAndInterestPaymentAmount |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolScheduledPrincipalAndInterestPaymentAmount |
| Logical Rolename | |
| ColumnName | PoolScheduledPrincipalAndInterestPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Total scheduled dollar amount of the principal and interest payments of the underlying loans as of the last cutoff date. |
| Note |
| PoolScheduledPrincipalAndInterestPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | PoolScheduledPrincipalAndInterestPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolScheduledPrincipalAndInterestPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolScheduledPrincipalAndInterestPaymentAmount Bound Attachments |
| Name | Current Value |
| PoolScheduledPrincipalAndInterestPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolScheduledPrincipalAndInterestPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledPrincipalAndInterestPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledPrincipalAndInterestPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledPrincipalAndInterestPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledRemittancePaymentDay |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolScheduledRemittancePaymentDay |
| Logical Rolename | |
| ColumnName | PoolScheduledRemittancePaymentDay |
| RoleName | |
| Domain | MISMODay |
| Definition | Indicates the day of the month the servicer must remit the scheduled pass through payment to the certificate holders of a particular pool. |
| Note |
| PoolScheduledRemittancePaymentDay Logical Attribute Properties |
| Logical Attribute Name | PoolScheduledRemittancePaymentDay |
| Datatype | DATE |
| Nullable | NO |
| PoolScheduledRemittancePaymentDay Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolScheduledRemittancePaymentDay Bound Attachments |
| Name | Current Value |
| PoolScheduledRemittancePaymentDay User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolScheduledRemittancePaymentDay Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledRemittancePaymentDay Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledRemittancePaymentDay Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolScheduledRemittancePaymentDay Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityInterestRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolSecurityInterestRatePercent |
| Logical Rolename | |
| ColumnName | PoolSecurityInterestRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The security interest rate, expressed as a percent, for the pool as of last cutoff date. |
| Note |
| PoolSecurityInterestRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolSecurityInterestRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolSecurityInterestRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolSecurityInterestRatePercent Bound Attachments |
| Name | Current Value |
| PoolSecurityInterestRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolSecurityInterestRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityInterestRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityInterestRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityInterestRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityIssueDateInterestRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolSecurityIssueDateInterestRatePercent |
| Logical Rolename | |
| ColumnName | PoolSecurityIssueDateInterestRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The security interest rate, expressed as a percent, for the pool as of the security issue date. |
| Note |
| PoolSecurityIssueDateInterestRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolSecurityIssueDateInterestRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolSecurityIssueDateInterestRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolSecurityIssueDateInterestRatePercent Bound Attachments |
| Name | Current Value |
| PoolSecurityIssueDateInterestRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolSecurityIssueDateInterestRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityIssueDateInterestRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityIssueDateInterestRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSecurityIssueDateInterestRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolServiceFeeRatePercent |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolServiceFeeRatePercent |
| Logical Rolename | |
| ColumnName | PoolServiceFeeRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The annualized rate, expressed as a percent, used to compute the fee paid to the servicer as of the last cutoff date. |
| Note |
| PoolServiceFeeRatePercent Logical Attribute Properties |
| Logical Attribute Name | PoolServiceFeeRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PoolServiceFeeRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolServiceFeeRatePercent Bound Attachments |
| Name | Current Value |
| PoolServiceFeeRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolServiceFeeRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolServiceFeeRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolServiceFeeRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolServiceFeeRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureType |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolStructureType |
| Logical Rolename | |
| ColumnName | PoolStructureType |
| RoleName | |
| Domain | PoolStructureEnum |
| Definition | Denotes the type of mortgage backed security structure. |
| Note |
| PoolStructureType Logical Attribute Properties |
| Logical Attribute Name | PoolStructureType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PoolStructureType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolStructureType Reference Value (Bound to Domain) |
| Name | ValidationRule367 |
| Description | |
| Type | By List |
| Value | Value Description |
| InvestorDefinedMultipleLender | InvestorDefinedMultipleLender |
| LenderInitiatedMultipleLender | LenderInitiatedMultipleLender |
| Other | Other |
| SingleLender | SingleLender |
| PoolStructureType Bound Attachments |
| Name | Current Value |
| PoolStructureType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolStructureType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureTypeOtherDescription |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolStructureTypeOtherDescription |
| Logical Rolename | |
| ColumnName | PoolStructureTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Pool Structure Type. |
| Note |
| PoolStructureTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | PoolStructureTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolStructureTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolStructureTypeOtherDescription Bound Attachments |
| Name | Current Value |
| PoolStructureTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolStructureTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolStructureTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSuffixIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolSuffixIdentifier |
| Logical Rolename | |
| ColumnName | PoolSuffixIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Suffix associated with the pool identifier. |
| Note |
| PoolSuffixIdentifier Logical Attribute Properties |
| Logical Attribute Name | PoolSuffixIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| PoolSuffixIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolSuffixIdentifier Bound Attachments |
| Name | Current Value |
| PoolSuffixIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolSuffixIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSuffixIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSuffixIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolSuffixIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolUnscheduledPrincipalPaymentDay |
| Base Entity | POOL_DETAIL |
| Attribute Name | PoolUnscheduledPrincipalPaymentDay |
| Logical Rolename | |
| ColumnName | PoolUnscheduledPrincipalPaymentDay |
| RoleName | |
| Domain | MISMODay |
| Definition | Indicates the day of the month the servicer must remit unscheduled principal payments to the certificate holders of a particular pool if they are to be remitted sooner than the scheduled remittance day. |
| Note |
| PoolUnscheduledPrincipalPaymentDay Logical Attribute Properties |
| Logical Attribute Name | PoolUnscheduledPrincipalPaymentDay |
| Datatype | DATE |
| Nullable | NO |
| PoolUnscheduledPrincipalPaymentDay Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PoolUnscheduledPrincipalPaymentDay Bound Attachments |
| Name | Current Value |
| PoolUnscheduledPrincipalPaymentDay User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PoolUnscheduledPrincipalPaymentDay Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolUnscheduledPrincipalPaymentDay Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolUnscheduledPrincipalPaymentDay Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PoolUnscheduledPrincipalPaymentDay Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeBookEntryDate |
| Base Entity | POOL_DETAIL |
| Attribute Name | SecurityTradeBookEntryDate |
| Logical Rolename | |
| ColumnName | SecurityTradeBookEntryDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date that the security will be delivered to the designated book entry account. |
| Note |
| SecurityTradeBookEntryDate Logical Attribute Properties |
| Logical Attribute Name | SecurityTradeBookEntryDate |
| Datatype | DATE |
| Nullable | NO |
| SecurityTradeBookEntryDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SecurityTradeBookEntryDate Bound Attachments |
| Name | Current Value |
| SecurityTradeBookEntryDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SecurityTradeBookEntryDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeBookEntryDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeBookEntryDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeBookEntryDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeCustomerAccountIdentifier |
| Base Entity | POOL_DETAIL |
| Attribute Name | SecurityTradeCustomerAccountIdentifier |
| Logical Rolename | |
| ColumnName | SecurityTradeCustomerAccountIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The securities trading account identifier assigned to a customer by an investor. |
| Note |
| SecurityTradeCustomerAccountIdentifier Logical Attribute Properties |
| Logical Attribute Name | SecurityTradeCustomerAccountIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| SecurityTradeCustomerAccountIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SecurityTradeCustomerAccountIdentifier Bound Attachments |
| Name | Current Value |
| SecurityTradeCustomerAccountIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SecurityTradeCustomerAccountIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeCustomerAccountIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeCustomerAccountIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SecurityTradeCustomerAccountIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |