| BaseGuarantyFeePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | BaseGuarantyFeePercent |
| Logical Rolename | |
| ColumnName | BaseGuarantyFeePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The guaranty fee rate prior to applying any adjustments, such as buyup/buydown. This can be specified in a price sheet, commitment, or other agreement. The guaranty fee is a portion of the interest on the loan that is paid to a party to ensure the timely |
| Note |
| BaseGuarantyFeePercent Logical Attribute Properties |
| Logical Attribute Name | BaseGuarantyFeePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BaseGuarantyFeePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BaseGuarantyFeePercent Bound Attachments |
| Name | Current Value |
| BaseGuarantyFeePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BaseGuarantyFeePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BaseGuarantyFeePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BaseGuarantyFeePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BaseGuarantyFeePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentServicingTransferIndicator |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ConcurrentServicingTransferIndicator |
| Logical Rolename | |
| ColumnName | ConcurrentServicingTransferIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that servicing is transferred concurrent with loan delivery. |
| Note |
| ConcurrentServicingTransferIndicator Logical Attribute Properties |
| Logical Attribute Name | ConcurrentServicingTransferIndicator |
| Datatype | BIT |
| Nullable | NO |
| ConcurrentServicingTransferIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConcurrentServicingTransferIndicator Bound Attachments |
| Name | Current Value |
| ConcurrentServicingTransferIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConcurrentServicingTransferIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentServicingTransferIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentServicingTransferIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentServicingTransferIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCode |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ContractVarianceCode |
| Logical Rolename | |
| ColumnName | ContractVarianceCode |
| RoleName | |
| Domain | MISMOCode |
| Definition | A code assigned by the contracting system identifying a variance from the master contract. |
| Note |
| ContractVarianceCode Logical Attribute Properties |
| Logical Attribute Name | ContractVarianceCode |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ContractVarianceCode Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ContractVarianceCode Bound Attachments |
| Name | Current Value |
| ContractVarianceCode User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ContractVarianceCode Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCode Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCode Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCode Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ContractVarianceCodeIssuerType |
| Logical Rolename | |
| ColumnName | ContractVarianceCodeIssuerType |
| RoleName | |
| Domain | ContractVarianceCodeIssuerEnum |
| Definition | Identifying the party who issued the variance code. |
| Note |
| ContractVarianceCodeIssuerType Logical Attribute Properties |
| Logical Attribute Name | ContractVarianceCodeIssuerType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ContractVarianceCodeIssuerType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ContractVarianceCodeIssuerType Reference Value (Bound to Domain) |
| Name | ValidationRule75 |
| Description | |
| Type | By List |
| Value | Value Description |
| FHA | Federal Housing Administration |
| Investor | Investor |
| MI | MI |
| Other | Other |
| Seller | Seller |
| VA | Department of Veteran Affairs |
| ContractVarianceCodeIssuerType Bound Attachments |
| Name | Current Value |
| ContractVarianceCodeIssuerType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ContractVarianceCodeIssuerType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerTypeOtherDescription |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ContractVarianceCodeIssuerTypeOtherDescription |
| Logical Rolename | |
| ColumnName | ContractVarianceCodeIssuerTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | The description of the Contract Variance Code Issuer Type when Other is selected as the option from the enumerated list. |
| Note |
| ContractVarianceCodeIssuerTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | ContractVarianceCodeIssuerTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ContractVarianceCodeIssuerTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ContractVarianceCodeIssuerTypeOtherDescription Bound Attachments |
| Name | Current Value |
| ContractVarianceCodeIssuerTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ContractVarianceCodeIssuerTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ContractVarianceCodeIssuerTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExceptionInterestAdjustmentDayMethodType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ExceptionInterestAdjustmentDayMethodType |
| Logical Rolename | |
| ColumnName | ExceptionInterestAdjustmentDayMethodType |
| RoleName | |
| Domain | ExceptionInterestAdjustmentDayMethodEnum |
| Definition | The day basis on which the exception interest adjustment is computed based on the servicing contract. |
| Note |
| ExceptionInterestAdjustmentDayMethodType Logical Attribute Properties |
| Logical Attribute Name | ExceptionInterestAdjustmentDayMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ExceptionInterestAdjustmentDayMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ExceptionInterestAdjustmentDayMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule156 |
| Description | |
| Type | By List |
| Value | Value Description |
| ActualLastPaidInstallmentDueDate | ActualLastPaidInstallmentDueDate |
| FirstOfMonth | FirstOfMonth |
| ScheduledLastPaidInstallmentDueDate | ScheduledLastPaidInstallmentDueDate |
| ExceptionInterestAdjustmentDayMethodType Bound Attachments |
| Name | Current Value |
| ExceptionInterestAdjustmentDayMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ExceptionInterestAdjustmentDayMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExceptionInterestAdjustmentDayMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExceptionInterestAdjustmentDayMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExceptionInterestAdjustmentDayMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ExecutionType |
| Logical Rolename | |
| ColumnName | ExecutionType |
| RoleName | |
| Domain | ExecutionEnum |
| Definition | Specifies the type of execution through which the loan was purchased by an investor. |
| Note |
| ExecutionType Logical Attribute Properties |
| Logical Attribute Name | ExecutionType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ExecutionType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ExecutionType Reference Value (Bound to Domain) |
| Name | ValidationRule157 |
| Description | |
| Type | By List |
| Value | Value Description |
| Cash | Cash |
| Guarantor | Guarantor |
| Multilender | Multilender |
| Other | Other |
| ExecutionType Bound Attachments |
| Name | Current Value |
| ExecutionType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ExecutionType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionTypeOtherDescription |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ExecutionTypeOtherDescription |
| Logical Rolename | |
| ColumnName | ExecutionTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Execution Type. |
| Note |
| ExecutionTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | ExecutionTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| ExecutionTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ExecutionTypeOtherDescription Bound Attachments |
| Name | Current Value |
| ExecutionTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ExecutionTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ExecutionTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FundingInterestAdjustmentDayMethodType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | FundingInterestAdjustmentDayMethodType |
| Logical Rolename | |
| ColumnName | FundingInterestAdjustmentDayMethodType |
| RoleName | |
| Domain | FundingInterestAdjustmentDayMethodEnum |
| Definition | The day basis on which the funding interest adjustment is computed based on the purchase contract. |
| Note |
| FundingInterestAdjustmentDayMethodType Logical Attribute Properties |
| Logical Attribute Name | FundingInterestAdjustmentDayMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| FundingInterestAdjustmentDayMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| FundingInterestAdjustmentDayMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule156 |
| Description | |
| Type | By List |
| Value | Value Description |
| ActualLastPaidInstallmentDueDate | ActualLastPaidInstallmentDueDate |
| FirstOfMonth | FirstOfMonth |
| ScheduledLastPaidInstallmentDueDate | ScheduledLastPaidInstallmentDueDate |
| FundingInterestAdjustmentDayMethodType Bound Attachments |
| Name | Current Value |
| FundingInterestAdjustmentDayMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| FundingInterestAdjustmentDayMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FundingInterestAdjustmentDayMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| FundingInterestAdjustmentDayMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| FundingInterestAdjustmentDayMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuaranteeFeeAddOnIndicator |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | GuaranteeFeeAddOnIndicator |
| Logical Rolename | |
| ColumnName | GuaranteeFeeAddOnIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether an eligible Seller has elected the Add On or Post-Settlement delivery fees for a specific Mortgage. |
| Note |
| GuaranteeFeeAddOnIndicator Logical Attribute Properties |
| Logical Attribute Name | GuaranteeFeeAddOnIndicator |
| Datatype | BIT |
| Nullable | NO |
| GuaranteeFeeAddOnIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GuaranteeFeeAddOnIndicator Bound Attachments |
| Name | Current Value |
| GuaranteeFeeAddOnIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GuaranteeFeeAddOnIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuaranteeFeeAddOnIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuaranteeFeeAddOnIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuaranteeFeeAddOnIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeeAfterAlternatePaymentMethodPercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | GuarantyFeeAfterAlternatePaymentMethodPercent |
| Logical Rolename | |
| ColumnName | GuarantyFeeAfterAlternatePaymentMethodPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Contractual guaranty fee (after adjusting for the alternate payment method (APM) remittance cycle, if applicable) for an Mortgage Backed Security (MBS) pool mortgage. |
| Note |
| GuarantyFeeAfterAlternatePaymentMethodPercent Logical Attribute Properties |
| Logical Attribute Name | GuarantyFeeAfterAlternatePaymentMethodPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| GuarantyFeeAfterAlternatePaymentMethodPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GuarantyFeeAfterAlternatePaymentMethodPercent Bound Attachments |
| Name | Current Value |
| GuarantyFeeAfterAlternatePaymentMethodPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GuarantyFeeAfterAlternatePaymentMethodPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeeAfterAlternatePaymentMethodPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeeAfterAlternatePaymentMethodPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeeAfterAlternatePaymentMethodPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | GuarantyFeePercent |
| Logical Rolename | |
| ColumnName | GuarantyFeePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The guaranty fee rate after applying all adjustments to the guaranty fee, such as buyup/buydown. The guaranty fee is a portion of the interest on the loan that is paid to a party to guarantee the timely payment of interest and principal to the holders of |
| Note |
| GuarantyFeePercent Logical Attribute Properties |
| Logical Attribute Name | GuarantyFeePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| GuarantyFeePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| GuarantyFeePercent Bound Attachments |
| Name | Current Value |
| GuarantyFeePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| GuarantyFeePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| GuarantyFeePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestVarianceToleranceMaximumAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InterestVarianceToleranceMaximumAmount |
| Logical Rolename | |
| ColumnName | InterestVarianceToleranceMaximumAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The maximum allowed dollar amount variance between the reported and the expected or scheduled interest. |
| Note |
| InterestVarianceToleranceMaximumAmount Logical Attribute Properties |
| Logical Attribute Name | InterestVarianceToleranceMaximumAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InterestVarianceToleranceMaximumAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestVarianceToleranceMaximumAmount Bound Attachments |
| Name | Current Value |
| InterestVarianceToleranceMaximumAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestVarianceToleranceMaximumAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestVarianceToleranceMaximumAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestVarianceToleranceMaximumAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestVarianceToleranceMaximumAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCollateralProgramIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorCollateralProgramIdentifier |
| Logical Rolename | |
| ColumnName | InvestorCollateralProgramIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifies the collateral program associated with the loan as identified by a specific entity. The entity may be referenced using the OwnerURI attribute. |
| Note |
| InvestorCollateralProgramIdentifier Logical Attribute Properties |
| Logical Attribute Name | InvestorCollateralProgramIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorCollateralProgramIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorCollateralProgramIdentifier Bound Attachments |
| Name | Current Value |
| InvestorCollateralProgramIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorCollateralProgramIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCollateralProgramIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCollateralProgramIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCollateralProgramIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCommitmentTakeoutPricePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorCommitmentTakeoutPricePercent |
| Logical Rolename | |
| ColumnName | InvestorCommitmentTakeoutPricePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The investors committed takeout price for a loan expressed as a precentage. |
| Note |
| InvestorCommitmentTakeoutPricePercent Logical Attribute Properties |
| Logical Attribute Name | InvestorCommitmentTakeoutPricePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorCommitmentTakeoutPricePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorCommitmentTakeoutPricePercent Bound Attachments |
| Name | Current Value |
| InvestorCommitmentTakeoutPricePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorCommitmentTakeoutPricePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCommitmentTakeoutPricePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCommitmentTakeoutPricePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorCommitmentTakeoutPricePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorDealIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorDealIdentifier |
| Logical Rolename | |
| ColumnName | InvestorDealIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The unique identifier assigned by the investor to a single family structured transaction. |
| Note |
| InvestorDealIdentifier Logical Attribute Properties |
| Logical Attribute Name | InvestorDealIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorDealIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorDealIdentifier Bound Attachments |
| Name | Current Value |
| InvestorDealIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorDealIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorDealIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorDealIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorDealIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGroupingIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorGroupingIdentifier |
| Logical Rolename | |
| ColumnName | InvestorGroupingIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A unique identifier that segregates loans for a specific investor according to defined characteristics, such as interest rate, service fee, pool, asset group, etc. |
| Note |
| InvestorGroupingIdentifier Logical Attribute Properties |
| Logical Attribute Name | InvestorGroupingIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorGroupingIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorGroupingIdentifier Bound Attachments |
| Name | Current Value |
| InvestorGroupingIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorGroupingIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGroupingIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGroupingIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGroupingIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGuarantyFeeAfterBuyupBuydownPercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorGuarantyFeeAfterBuyupBuydownPercent |
| Logical Rolename | |
| ColumnName | InvestorGuarantyFeeAfterBuyupBuydownPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The investor guaranty fee rate after any addition or reduction to the base guaranty fee rate due to a guaranty fee buyup or buydown. The investor guaranty fee is a portion of the interest on the loan that is paid to a party to guarantee the timely payment |
| Note |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Logical Attribute Properties |
| Logical Attribute Name | InvestorGuarantyFeeAfterBuyupBuydownPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Bound Attachments |
| Name | Current Value |
| InvestorGuarantyFeeAfterBuyupBuydownPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorGuarantyFeeAfterBuyupBuydownPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorHeldCollateralPercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorHeldCollateralPercent |
| Logical Rolename | |
| ColumnName | InvestorHeldCollateralPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage of the Original Loan Balance that is being held as collateral by the investor for default costs on the loan. |
| Note |
| InvestorHeldCollateralPercent Logical Attribute Properties |
| Logical Attribute Name | InvestorHeldCollateralPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorHeldCollateralPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorHeldCollateralPercent Bound Attachments |
| Name | Current Value |
| InvestorHeldCollateralPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorHeldCollateralPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorHeldCollateralPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorHeldCollateralPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorHeldCollateralPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorInstitutionIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorInstitutionIdentifier |
| Logical Rolename | |
| ColumnName | InvestorInstitutionIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifies the secondary mortgage market institution (investor) associated with the lender or trading partner. |
| Note |
| InvestorInstitutionIdentifier Logical Attribute Properties |
| Logical Attribute Name | InvestorInstitutionIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorInstitutionIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorInstitutionIdentifier Bound Attachments |
| Name | Current Value |
| InvestorInstitutionIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorInstitutionIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorInstitutionIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorInstitutionIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorInstitutionIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanCommitmentExpirationDate |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorLoanCommitmentExpirationDate |
| Logical Rolename | |
| ColumnName | InvestorLoanCommitmentExpirationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The expiration date for acommitment by an investor to acquire a loan. |
| Note |
| InvestorLoanCommitmentExpirationDate Logical Attribute Properties |
| Logical Attribute Name | InvestorLoanCommitmentExpirationDate |
| Datatype | DATE |
| Nullable | NO |
| InvestorLoanCommitmentExpirationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorLoanCommitmentExpirationDate Bound Attachments |
| Name | Current Value |
| InvestorLoanCommitmentExpirationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorLoanCommitmentExpirationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanCommitmentExpirationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanCommitmentExpirationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanCommitmentExpirationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorLoanEarlyPayoffPenaltyWaiverIndicator |
| Logical Rolename | |
| ColumnName | InvestorLoanEarlyPayoffPenaltyWaiverIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the investor waives the full prepayment penalties |
| Note |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Logical Attribute Properties |
| Logical Attribute Name | InvestorLoanEarlyPayoffPenaltyWaiverIndicator |
| Datatype | BIT |
| Nullable | NO |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Bound Attachments |
| Name | Current Value |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEarlyPayoffPenaltyWaiverIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEffectiveDate |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorLoanEffectiveDate |
| Logical Rolename | |
| ColumnName | InvestorLoanEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The due date of the first payment to the investor. |
| Note |
| InvestorLoanEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | InvestorLoanEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| InvestorLoanEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorLoanEffectiveDate Bound Attachments |
| Name | Current Value |
| InvestorLoanEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorLoanEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorLoanPartialPrepaymentPenaltyWaiverIndicator |
| Logical Rolename | |
| ColumnName | InvestorLoanPartialPrepaymentPenaltyWaiverIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the investor waives the curtailment penalties |
| Note |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Logical Attribute Properties |
| Logical Attribute Name | InvestorLoanPartialPrepaymentPenaltyWaiverIndicator |
| Datatype | BIT |
| Nullable | NO |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Bound Attachments |
| Name | Current Value |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorLoanPartialPrepaymentPenaltyWaiverIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorMasterCommitmentIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorMasterCommitmentIdentifier |
| Logical Rolename | |
| ColumnName | InvestorMasterCommitmentIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | The unique identifier of the master commitment that states the terms under which a lender and an investor agree to deliver/receive mortgage loans in exchange for funds or securities. Subordinate commitments with further delineation of conditions are creat |
| Note |
| InvestorMasterCommitmentIdentifier Logical Attribute Properties |
| Logical Attribute Name | InvestorMasterCommitmentIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorMasterCommitmentIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorMasterCommitmentIdentifier Bound Attachments |
| Name | Current Value |
| InvestorMasterCommitmentIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorMasterCommitmentIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorMasterCommitmentIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorMasterCommitmentIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorMasterCommitmentIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipPercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorOwnershipPercent |
| Logical Rolename | |
| ColumnName | InvestorOwnershipPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Identifies the percentage amount of the loan owned by the investor |
| Note |
| InvestorOwnershipPercent Logical Attribute Properties |
| Logical Attribute Name | InvestorOwnershipPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorOwnershipPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorOwnershipPercent Bound Attachments |
| Name | Current Value |
| InvestorOwnershipPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorOwnershipPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorOwnershipType |
| Logical Rolename | |
| ColumnName | InvestorOwnershipType |
| RoleName | |
| Domain | InvestorOwnershipEnum |
| Definition | Identifies the ownership status of the investor. |
| Note |
| InvestorOwnershipType Logical Attribute Properties |
| Logical Attribute Name | InvestorOwnershipType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InvestorOwnershipType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorOwnershipType Reference Value (Bound to Domain) |
| Name | ValidationRule234 |
| Description | |
| Type | By List |
| Value | Value Description |
| Administered | The investor has a management interest in the loan but not ownership. |
| Participation | The investor owns something less than 100 percent interest in the loan. |
| Pending | Pending |
| Whole | Investor owns 100 percent interest in the loan. |
| InvestorOwnershipType Bound Attachments |
| Name | Current Value |
| InvestorOwnershipType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorOwnershipType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorOwnershipType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorProductPlanIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorProductPlanIdentifier |
| Logical Rolename | |
| ColumnName | InvestorProductPlanIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Specifies the source of the list for identifiers of the adjustable loan product being financed. Used for the Fannie Mae Product Plan, Freddie Mac Product Plan and other investor product plans. |
| Note |
| InvestorProductPlanIdentifier Logical Attribute Properties |
| Logical Attribute Name | InvestorProductPlanIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorProductPlanIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorProductPlanIdentifier Bound Attachments |
| Name | Current Value |
| InvestorProductPlanIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorProductPlanIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorProductPlanIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorProductPlanIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorProductPlanIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceDay |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorRemittanceDay |
| Logical Rolename | |
| ColumnName | InvestorRemittanceDay |
| RoleName | |
| Domain | MISMODay |
| Definition | The day of the month on which principal and interest for the loan are remitted by the servicer to the investor. |
| Note |
| InvestorRemittanceDay Logical Attribute Properties |
| Logical Attribute Name | InvestorRemittanceDay |
| Datatype | DATE |
| Nullable | NO |
| InvestorRemittanceDay Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorRemittanceDay Bound Attachments |
| Name | Current Value |
| InvestorRemittanceDay User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorRemittanceDay Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceDay Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceDay Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceDay Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorRemittanceType |
| Logical Rolename | |
| ColumnName | InvestorRemittanceType |
| RoleName | |
| Domain | InvestorRemittanceEnum |
| Definition | This describes the contractual accounting method used to calculate the funds received by the Servicer from the borrower that are due to the investor. |
| Note |
| InvestorRemittanceType Logical Attribute Properties |
| Logical Attribute Name | InvestorRemittanceType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InvestorRemittanceType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorRemittanceType Reference Value (Bound to Domain) |
| Name | ValidationRule236 |
| Description | |
| Type | By List |
| Value | Value Description |
| ActualInterestActualPrincipal | The service remits the actual interest net of servicing fees and actual principal collected from the borrower that is due to the investor. |
| Other | Other |
| ScheduledInterestActualPrincipal | The service remits the scheduled interest (less servicing fees), regardless of actual collections from the borrower plus actual principal collected from borrowers that is due to the investor. |
| ScheduledInterestScheduledPrincipal | The servicer remits the scheduled interest (less servicing fees) and the scheduled principal, regardless of actual collections from the borrower plus any unscheduled principal collected from the borrower that is due to the investor. |
| InvestorRemittanceType Bound Attachments |
| Name | Current Value |
| InvestorRemittanceType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorRemittanceType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceTypeOtherDescription |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorRemittanceTypeOtherDescription |
| Logical Rolename | |
| ColumnName | InvestorRemittanceTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to capture the Investor Remittance Type if Other is selected. |
| Note |
| InvestorRemittanceTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | InvestorRemittanceTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| InvestorRemittanceTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorRemittanceTypeOtherDescription Bound Attachments |
| Name | Current Value |
| InvestorRemittanceTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorRemittanceTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRemittanceTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorReportingMethodType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorReportingMethodType |
| Logical Rolename | |
| ColumnName | InvestorReportingMethodType |
| RoleName | |
| Domain | InvestorReportingMethodEnum |
| Definition | Specifies the reporting method required by the investor from the servicer. |
| Note |
| InvestorReportingMethodType Logical Attribute Properties |
| Logical Attribute Name | InvestorReportingMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| InvestorReportingMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorReportingMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule240 |
| Description | |
| Type | By List |
| Value | Value Description |
| ExceptionReporting | The servicer only reports activity other than the scheduled payment. |
| FullReporting | The servicer must report on all servicing activity, |
| InvestorReportingMethodType Bound Attachments |
| Name | Current Value |
| InvestorReportingMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorReportingMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorReportingMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorReportingMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorReportingMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRequiredMarginPercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorRequiredMarginPercent |
| Logical Rolename | |
| ColumnName | InvestorRequiredMarginPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Field used in the pass through calculation when the Bottom Up method is used. |
| Note |
| InvestorRequiredMarginPercent Logical Attribute Properties |
| Logical Attribute Name | InvestorRequiredMarginPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorRequiredMarginPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorRequiredMarginPercent Bound Attachments |
| Name | Current Value |
| InvestorRequiredMarginPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorRequiredMarginPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRequiredMarginPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRequiredMarginPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorRequiredMarginPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorServicingFeeAmount |
| Logical Rolename | |
| ColumnName | InvestorServicingFeeAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The fixed dollar amount that is paid to the servicer by the investor for servicing the mortgage if the service fee is not expressed as a rate. |
| Note |
| InvestorServicingFeeAmount Logical Attribute Properties |
| Logical Attribute Name | InvestorServicingFeeAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorServicingFeeAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorServicingFeeAmount Bound Attachments |
| Name | Current Value |
| InvestorServicingFeeAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorServicingFeeAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeRatePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | InvestorServicingFeeRatePercent |
| Logical Rolename | |
| ColumnName | InvestorServicingFeeRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The percentage of interest collected that is paid to the servicer by the investor for servicing the mortgage (gross) |
| Note |
| InvestorServicingFeeRatePercent Logical Attribute Properties |
| Logical Attribute Name | InvestorServicingFeeRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| InvestorServicingFeeRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InvestorServicingFeeRatePercent Bound Attachments |
| Name | Current Value |
| InvestorServicingFeeRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InvestorServicingFeeRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InvestorServicingFeeRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastReportedToInvestorPrincipalBalanceAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LastReportedToInvestorPrincipalBalanceAmount |
| Logical Rolename | |
| ColumnName | LastReportedToInvestorPrincipalBalanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Last principal balance reported to the investor |
| Note |
| LastReportedToInvestorPrincipalBalanceAmount Logical Attribute Properties |
| Logical Attribute Name | LastReportedToInvestorPrincipalBalanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LastReportedToInvestorPrincipalBalanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LastReportedToInvestorPrincipalBalanceAmount Bound Attachments |
| Name | Current Value |
| LastReportedToInvestorPrincipalBalanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LastReportedToInvestorPrincipalBalanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastReportedToInvestorPrincipalBalanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastReportedToInvestorPrincipalBalanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LastReportedToInvestorPrincipalBalanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LateDeliveryGraceDaysCount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LateDeliveryGraceDaysCount |
| Logical Rolename | |
| ColumnName | LateDeliveryGraceDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of days allowed for late delivery of the loan, beyond the scheduled delivery date. |
| Note |
| LateDeliveryGraceDaysCount Logical Attribute Properties |
| Logical Attribute Name | LateDeliveryGraceDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| LateDeliveryGraceDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LateDeliveryGraceDaysCount Bound Attachments |
| Name | Current Value |
| LateDeliveryGraceDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LateDeliveryGraceDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LateDeliveryGraceDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LateDeliveryGraceDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LateDeliveryGraceDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderTargetFundingDate |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LenderTargetFundingDate |
| Logical Rolename | |
| ColumnName | LenderTargetFundingDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the lender selects to have their Whole Loan purchase funded. Proceeds are typically wired to the lender 24 hours after the purchase of the loan. By selecting this date, the lender manages when the funds are to be wired. |
| Note |
| LenderTargetFundingDate Logical Attribute Properties |
| Logical Attribute Name | LenderTargetFundingDate |
| Datatype | DATE |
| Nullable | NO |
| LenderTargetFundingDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LenderTargetFundingDate Bound Attachments |
| Name | Current Value |
| LenderTargetFundingDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LenderTargetFundingDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderTargetFundingDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderTargetFundingDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderTargetFundingDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAcquisitionScheduledUPBAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanAcquisitionScheduledUPBAmount |
| Logical Rolename | |
| ColumnName | LoanAcquisitionScheduledUPBAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The scheduled unpaid principal balance of the mortgage as of loan acquisition or the issue date of the associated security. |
| Note |
| LoanAcquisitionScheduledUPBAmount Logical Attribute Properties |
| Logical Attribute Name | LoanAcquisitionScheduledUPBAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanAcquisitionScheduledUPBAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanAcquisitionScheduledUPBAmount Bound Attachments |
| Name | Current Value |
| LoanAcquisitionScheduledUPBAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanAcquisitionScheduledUPBAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAcquisitionScheduledUPBAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAcquisitionScheduledUPBAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAcquisitionScheduledUPBAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownBasisPointNumber |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanBuyupBuydownBasisPointNumber |
| Logical Rolename | |
| ColumnName | LoanBuyupBuydownBasisPointNumber |
| RoleName | |
| Domain | MISMONumeric |
| Definition | The number of basis points of loan level buyup/buydown selected by the seller for this mortgage. |
| Note |
| LoanBuyupBuydownBasisPointNumber Logical Attribute Properties |
| Logical Attribute Name | LoanBuyupBuydownBasisPointNumber |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanBuyupBuydownBasisPointNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanBuyupBuydownBasisPointNumber Bound Attachments |
| Name | Current Value |
| LoanBuyupBuydownBasisPointNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanBuyupBuydownBasisPointNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownBasisPointNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownBasisPointNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownBasisPointNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanBuyupBuydownType |
| Logical Rolename | |
| ColumnName | LoanBuyupBuydownType |
| RoleName | |
| Domain | LoanBuyupBuydownEnum |
| Definition | Specifies the type of buyup or buydown an eligible Seller has elected to exercise for a specific mortgage. |
| Note |
| LoanBuyupBuydownType Logical Attribute Properties |
| Logical Attribute Name | LoanBuyupBuydownType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanBuyupBuydownType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanBuyupBuydownType Reference Value (Bound to Domain) |
| Name | ValidationRule252 |
| Description | |
| Type | By List |
| Value | Value Description |
| Buydown | Buydown |
| Buyup | Buyup |
| BuyupBuydownDoesNotApply | BuyupBuydownDoesNotApply |
| Other | Other |
| LoanBuyupBuydownType Bound Attachments |
| Name | Current Value |
| LoanBuyupBuydownType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanBuyupBuydownType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownTypeOtherDescription |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanBuyupBuydownTypeOtherDescription |
| Logical Rolename | |
| ColumnName | LoanBuyupBuydownTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to provide additional information when Other is selected vor Loan Buyup Buydown Type. |
| Note |
| LoanBuyupBuydownTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | LoanBuyupBuydownTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanBuyupBuydownTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanBuyupBuydownTypeOtherDescription Bound Attachments |
| Name | Current Value |
| LoanBuyupBuydownTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanBuyupBuydownTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanBuyupBuydownTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultedReportingFrequencyType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanDefaultedReportingFrequencyType |
| Logical Rolename | |
| ColumnName | LoanDefaultedReportingFrequencyType |
| RoleName | |
| Domain | LoanDefaultedReportingFrequencyEnum |
| Definition | The frequency that the servicer must report for loans that are in default. |
| Note |
| LoanDefaultedReportingFrequencyType Logical Attribute Properties |
| Logical Attribute Name | LoanDefaultedReportingFrequencyType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanDefaultedReportingFrequencyType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanDefaultedReportingFrequencyType Reference Value (Bound to Domain) |
| Name | ValidationRule1 |
| Description | |
| Type | By List |
| Value | Value Description |
| Annually | Annually |
| Biweekly | Biweekly |
| Daily | Daily |
| Monthly | Monthly |
| Quarterly | Quarterly |
| Semiannually | Semiannually |
| Semimonthly | Semimonthly |
| Weekly | Weekly |
| LoanDefaultedReportingFrequencyType Bound Attachments |
| Name | Current Value |
| LoanDefaultedReportingFrequencyType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanDefaultedReportingFrequencyType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultedReportingFrequencyType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultedReportingFrequencyType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultedReportingFrequencyType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultLossPartyType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanDefaultLossPartyType |
| Logical Rolename | |
| ColumnName | LoanDefaultLossPartyType |
| RoleName | |
| Domain | LoanDefaultLossPartyEnum |
| Definition | Indicates the party that bears the default loss for the loan. |
| Note |
| LoanDefaultLossPartyType Logical Attribute Properties |
| Logical Attribute Name | LoanDefaultLossPartyType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanDefaultLossPartyType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanDefaultLossPartyType Reference Value (Bound to Domain) |
| Name | ValidationRule92 |
| Description | |
| Type | By List |
| Value | Value Description |
| Investor | Investor |
| Lender | Lender |
| LoanSeller | LoanSeller |
| MortgageInsuranceCompany | MortgageInsuranceCompany |
| Servicer | Servicer |
| Shared | Shared |
| LoanDefaultLossPartyType Bound Attachments |
| Name | Current Value |
| LoanDefaultLossPartyType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanDefaultLossPartyType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultLossPartyType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultLossPartyType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDefaultLossPartyType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyAdvanceDaysCount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanDelinquencyAdvanceDaysCount |
| Logical Rolename | |
| ColumnName | LoanDelinquencyAdvanceDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of days after which a servicer can stop advancing funds on a delinquent loan. |
| Note |
| LoanDelinquencyAdvanceDaysCount Logical Attribute Properties |
| Logical Attribute Name | LoanDelinquencyAdvanceDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| LoanDelinquencyAdvanceDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanDelinquencyAdvanceDaysCount Bound Attachments |
| Name | Current Value |
| LoanDelinquencyAdvanceDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanDelinquencyAdvanceDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyAdvanceDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyAdvanceDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanDelinquencyAdvanceDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingAdvancedAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanFundingAdvancedAmount |
| Logical Rolename | |
| ColumnName | LoanFundingAdvancedAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount disbursed under a loan agreement in advance of full funding. |
| Note |
| LoanFundingAdvancedAmount Logical Attribute Properties |
| Logical Attribute Name | LoanFundingAdvancedAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanFundingAdvancedAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanFundingAdvancedAmount Bound Attachments |
| Name | Current Value |
| LoanFundingAdvancedAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanFundingAdvancedAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingAdvancedAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingAdvancedAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingAdvancedAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPriorOwnerName |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanPriorOwnerName |
| Logical Rolename | |
| ColumnName | LoanPriorOwnerName |
| RoleName | |
| Domain | MISMOString |
| Definition | The name of the legal entity from which the seller acquired the loan. |
| Note |
| LoanPriorOwnerName Logical Attribute Properties |
| Logical Attribute Name | LoanPriorOwnerName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanPriorOwnerName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanPriorOwnerName Bound Attachments |
| Name | Current Value |
| LoanPriorOwnerName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanPriorOwnerName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPriorOwnerName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPriorOwnerName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPriorOwnerName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchaseDiscountAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanPurchaseDiscountAmount |
| Logical Rolename | |
| ColumnName | LoanPurchaseDiscountAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The difference between the dollar price paid for the loan and its UPB at the time of purchase when the UPB is less than price paid. |
| Note |
| LoanPurchaseDiscountAmount Logical Attribute Properties |
| Logical Attribute Name | LoanPurchaseDiscountAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanPurchaseDiscountAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanPurchaseDiscountAmount Bound Attachments |
| Name | Current Value |
| LoanPurchaseDiscountAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanPurchaseDiscountAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchaseDiscountAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchaseDiscountAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchaseDiscountAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchasePremiumAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanPurchasePremiumAmount |
| Logical Rolename | |
| ColumnName | LoanPurchasePremiumAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The difference between the dollar price paid for the loan and its UPB at the time of purchase when the UPB is more than price paid. |
| Note |
| LoanPurchasePremiumAmount Logical Attribute Properties |
| Logical Attribute Name | LoanPurchasePremiumAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanPurchasePremiumAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanPurchasePremiumAmount Bound Attachments |
| Name | Current Value |
| LoanPurchasePremiumAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanPurchasePremiumAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchasePremiumAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchasePremiumAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanPurchasePremiumAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingFeeBasisPointNumber |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanServicingFeeBasisPointNumber |
| Logical Rolename | |
| ColumnName | LoanServicingFeeBasisPointNumber |
| RoleName | |
| Domain | MISMONumeric |
| Definition | The number of basis points of servicing fee selected for this mortgage. |
| Note |
| LoanServicingFeeBasisPointNumber Logical Attribute Properties |
| Logical Attribute Name | LoanServicingFeeBasisPointNumber |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanServicingFeeBasisPointNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanServicingFeeBasisPointNumber Bound Attachments |
| Name | Current Value |
| LoanServicingFeeBasisPointNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanServicingFeeBasisPointNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingFeeBasisPointNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingFeeBasisPointNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingFeeBasisPointNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingIndicator |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanServicingIndicator |
| Logical Rolename | |
| ColumnName | LoanServicingIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the seller will identify specific loan level servicing values for this mortgage. |
| Note |
| LoanServicingIndicator Logical Attribute Properties |
| Logical Attribute Name | LoanServicingIndicator |
| Datatype | BIT |
| Nullable | NO |
| LoanServicingIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanServicingIndicator Bound Attachments |
| Name | Current Value |
| LoanServicingIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanServicingIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingRightsPurchaseOnlyIndicator |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanServicingRightsPurchaseOnlyIndicator |
| Logical Rolename | |
| ColumnName | LoanServicingRightsPurchaseOnlyIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the transaction on the Investors side is a Purchase of servicing rights rather than the purchase of an asset. |
| Note |
| LoanServicingRightsPurchaseOnlyIndicator Logical Attribute Properties |
| Logical Attribute Name | LoanServicingRightsPurchaseOnlyIndicator |
| Datatype | BIT |
| Nullable | NO |
| LoanServicingRightsPurchaseOnlyIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanServicingRightsPurchaseOnlyIndicator Bound Attachments |
| Name | Current Value |
| LoanServicingRightsPurchaseOnlyIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanServicingRightsPurchaseOnlyIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingRightsPurchaseOnlyIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingRightsPurchaseOnlyIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanServicingRightsPurchaseOnlyIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanYieldSpreadPremiumAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | LoanYieldSpreadPremiumAmount |
| Logical Rolename | |
| ColumnName | LoanYieldSpreadPremiumAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | A premium, expressed as a dollar amount, calculated based upon the difference between the interest rate of the loan and the market rate at the time of funding. |
| Note |
| LoanYieldSpreadPremiumAmount Logical Attribute Properties |
| Logical Attribute Name | LoanYieldSpreadPremiumAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| LoanYieldSpreadPremiumAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanYieldSpreadPremiumAmount Bound Attachments |
| Name | Current Value |
| LoanYieldSpreadPremiumAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanYieldSpreadPremiumAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanYieldSpreadPremiumAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanYieldSpreadPremiumAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanYieldSpreadPremiumAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCalculationMethodType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | PassThroughCalculationMethodType |
| Logical Rolename | |
| ColumnName | PassThroughCalculationMethodType |
| RoleName | |
| Domain | PassThroughCalculationMethodEnum |
| Definition | Determines what formula is used to calculate the investor pass through rate as defined in the investor contract. |
| Note |
| PassThroughCalculationMethodType Logical Attribute Properties |
| Logical Attribute Name | PassThroughCalculationMethodType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| PassThroughCalculationMethodType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PassThroughCalculationMethodType Reference Value (Bound to Domain) |
| Name | ValidationRule350 |
| Description | |
| Type | By List |
| Value | Value Description |
| BottomUp | The pass through rate is determined by adding the index to the contract margin (Investor required margin). Investor required margin is defined by investor contract. Other factors may apply. |
| TopDown | The pass through rate is determined by subtracting the Minimum Service Fee Rate and the Guaranty Fee Rate from the Note Rate after the new interest rate is determined. Service Fee Rate and Guaranty Fee Rate are defined by the investor contract. Other factors may apply. |
| PassThroughCalculationMethodType Bound Attachments |
| Name | Current Value |
| PassThroughCalculationMethodType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PassThroughCalculationMethodType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCalculationMethodType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCalculationMethodType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCalculationMethodType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCeilingRatePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | PassThroughCeilingRatePercent |
| Logical Rolename | |
| ColumnName | PassThroughCeilingRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | Investor rate ceiling used in bottom up calculations. |
| Note |
| PassThroughCeilingRatePercent Logical Attribute Properties |
| Logical Attribute Name | PassThroughCeilingRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PassThroughCeilingRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PassThroughCeilingRatePercent Bound Attachments |
| Name | Current Value |
| PassThroughCeilingRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PassThroughCeilingRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCeilingRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCeilingRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughCeilingRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughRatePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | PassThroughRatePercent |
| Logical Rolename | |
| ColumnName | PassThroughRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The rate at which interest is passed by the servicer to the investor. It equals the note rate less the service fee rate and excess service fee rate. |
| Note |
| PassThroughRatePercent Logical Attribute Properties |
| Logical Attribute Name | PassThroughRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PassThroughRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PassThroughRatePercent Bound Attachments |
| Name | Current Value |
| PassThroughRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PassThroughRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PassThroughRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrincipalVarianceToleranceMaximumAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | PrincipalVarianceToleranceMaximumAmount |
| Logical Rolename | |
| ColumnName | PrincipalVarianceToleranceMaximumAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The maximum allowed dollar amount variance between the reported and the expected or scheduled principal. |
| Note |
| PrincipalVarianceToleranceMaximumAmount Logical Attribute Properties |
| Logical Attribute Name | PrincipalVarianceToleranceMaximumAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| PrincipalVarianceToleranceMaximumAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PrincipalVarianceToleranceMaximumAmount Bound Attachments |
| Name | Current Value |
| PrincipalVarianceToleranceMaximumAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PrincipalVarianceToleranceMaximumAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrincipalVarianceToleranceMaximumAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrincipalVarianceToleranceMaximumAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrincipalVarianceToleranceMaximumAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedInvestorLoanIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | RelatedInvestorLoanIdentifier |
| Logical Rolename | |
| ColumnName | RelatedInvestorLoanIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Identifier of a loan from a related or original transaction. May be used for modifications and conversion of existing loans. |
| Note |
| RelatedInvestorLoanIdentifier Logical Attribute Properties |
| Logical Attribute Name | RelatedInvestorLoanIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| RelatedInvestorLoanIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RelatedInvestorLoanIdentifier Bound Attachments |
| Name | Current Value |
| RelatedInvestorLoanIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RelatedInvestorLoanIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedInvestorLoanIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedInvestorLoanIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedInvestorLoanIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | RelatedLoanInvestorType |
| Logical Rolename | |
| ColumnName | RelatedLoanInvestorType |
| RoleName | |
| Domain | RelatedLoanInvestorEnum |
| Definition | Specifies the investor of the associated loan. |
| Note |
| RelatedLoanInvestorType Logical Attribute Properties |
| Logical Attribute Name | RelatedLoanInvestorType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| RelatedLoanInvestorType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RelatedLoanInvestorType Reference Value (Bound to Domain) |
| Name | ValidationRule427 |
| Description | |
| Type | By List |
| Value | Value Description |
| FNM | FNM |
| FRE | FRE |
| Other | Other |
| Seller | Seller |
| Unknown | Unknown |
| RelatedLoanInvestorType Bound Attachments |
| Name | Current Value |
| RelatedLoanInvestorType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RelatedLoanInvestorType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorTypeOtherDescription |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | RelatedLoanInvestorTypeOtherDescription |
| Logical Rolename | |
| ColumnName | RelatedLoanInvestorTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Related Loan investor Type. |
| Note |
| RelatedLoanInvestorTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | RelatedLoanInvestorTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| RelatedLoanInvestorTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RelatedLoanInvestorTypeOtherDescription Bound Attachments |
| Name | Current Value |
| RelatedLoanInvestorTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RelatedLoanInvestorTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelatedLoanInvestorTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyType |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | REOMarketingPartyType |
| Logical Rolename | |
| ColumnName | REOMarketingPartyType |
| RoleName | |
| Domain | REOMarketingPartyEnum |
| Definition | Identifies the party responsible for marketing the property in case of default. |
| Note |
| REOMarketingPartyType Logical Attribute Properties |
| Logical Attribute Name | REOMarketingPartyType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| REOMarketingPartyType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| REOMarketingPartyType Reference Value (Bound to Domain) |
| Name | ValidationRule410 |
| Description | |
| Type | By List |
| Value | Value Description |
| Investor | Investor |
| Lender | Lender |
| MortgageInsuranceCompany | MortgageInsuranceCompany |
| Other | Other |
| Seller | The organization that sells the loan to the investor. |
| Servicer | Servicer |
| Unknown | Unknown |
| REOMarketingPartyType Bound Attachments |
| Name | Current Value |
| REOMarketingPartyType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| REOMarketingPartyType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyTypeOtherDescription |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | REOMarketingPartyTypeOtherDescription |
| Logical Rolename | |
| ColumnName | REOMarketingPartyTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for REO Marketing Party Type. |
| Note |
| REOMarketingPartyTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | REOMarketingPartyTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| REOMarketingPartyTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| REOMarketingPartyTypeOtherDescription Bound Attachments |
| Name | Current Value |
| REOMarketingPartyTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| REOMarketingPartyTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| REOMarketingPartyTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingFeeMinimumRatePercent |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ServicingFeeMinimumRatePercent |
| Logical Rolename | |
| ColumnName | ServicingFeeMinimumRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The minimum service fee rate, expressed as a percent, to be earned by the servicer. |
| Note |
| ServicingFeeMinimumRatePercent Logical Attribute Properties |
| Logical Attribute Name | ServicingFeeMinimumRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| ServicingFeeMinimumRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ServicingFeeMinimumRatePercent Bound Attachments |
| Name | Current Value |
| ServicingFeeMinimumRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ServicingFeeMinimumRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingFeeMinimumRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingFeeMinimumRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingFeeMinimumRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ThirdPartyLoanAcquisitionPriceAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | ThirdPartyLoanAcquisitionPriceAmount |
| Logical Rolename | |
| ColumnName | ThirdPartyLoanAcquisitionPriceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount that was paid by the seller to acquire the loan from a third party. |
| Note |
| ThirdPartyLoanAcquisitionPriceAmount Logical Attribute Properties |
| Logical Attribute Name | ThirdPartyLoanAcquisitionPriceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| ThirdPartyLoanAcquisitionPriceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ThirdPartyLoanAcquisitionPriceAmount Bound Attachments |
| Name | Current Value |
| ThirdPartyLoanAcquisitionPriceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ThirdPartyLoanAcquisitionPriceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ThirdPartyLoanAcquisitionPriceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ThirdPartyLoanAcquisitionPriceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ThirdPartyLoanAcquisitionPriceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPBVarianceToleranceMaximumAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | UPBVarianceToleranceMaximumAmount |
| Logical Rolename | |
| ColumnName | UPBVarianceToleranceMaximumAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The maximum allowed dollar amount variance between the reported and the expected or scheduled unpaid principal balance (UPB). |
| Note |
| UPBVarianceToleranceMaximumAmount Logical Attribute Properties |
| Logical Attribute Name | UPBVarianceToleranceMaximumAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| UPBVarianceToleranceMaximumAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| UPBVarianceToleranceMaximumAmount Bound Attachments |
| Name | Current Value |
| UPBVarianceToleranceMaximumAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| UPBVarianceToleranceMaximumAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPBVarianceToleranceMaximumAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPBVarianceToleranceMaximumAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPBVarianceToleranceMaximumAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseAdvanceAmount |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | WarehouseAdvanceAmount |
| Logical Rolename | |
| ColumnName | WarehouseAdvanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the advance against a warehouse line of credit. |
| Note |
| WarehouseAdvanceAmount Logical Attribute Properties |
| Logical Attribute Name | WarehouseAdvanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| WarehouseAdvanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WarehouseAdvanceAmount Bound Attachments |
| Name | Current Value |
| WarehouseAdvanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| WarehouseAdvanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseAdvanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseAdvanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseAdvanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseCommitmentSubcategoryIdentifier |
| Base Entity | INVESTOR_LOAN_INFORMATION |
| Attribute Name | WarehouseCommitmentSubcategoryIdentifier |
| Logical Rolename | |
| ColumnName | WarehouseCommitmentSubcategoryIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Uniquely identifies a subcategory of a warehouse commitment. |
| Note |
| WarehouseCommitmentSubcategoryIdentifier Logical Attribute Properties |
| Logical Attribute Name | WarehouseCommitmentSubcategoryIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| WarehouseCommitmentSubcategoryIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WarehouseCommitmentSubcategoryIdentifier Bound Attachments |
| Name | Current Value |
| WarehouseCommitmentSubcategoryIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| WarehouseCommitmentSubcategoryIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseCommitmentSubcategoryIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseCommitmentSubcategoryIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseCommitmentSubcategoryIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |