| AcceleratedPaymentProgramIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | AcceleratedPaymentProgramIndicator |
| Logical Rolename | |
| ColumnName | AcceleratedPaymentProgramIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that mortgagor participates in some sort of accelerated principal re-payment program which may be administered by a third party. |
| Note |
| AcceleratedPaymentProgramIndicator Logical Attribute Properties |
| Logical Attribute Name | AcceleratedPaymentProgramIndicator |
| Datatype | BIT |
| Nullable | NO |
| AcceleratedPaymentProgramIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AcceleratedPaymentProgramIndicator Bound Attachments |
| Name | Current Value |
| AcceleratedPaymentProgramIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AcceleratedPaymentProgramIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AcceleratedPaymentProgramIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AcceleratedPaymentProgramIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AcceleratedPaymentProgramIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationReceivedDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ApplicationReceivedDate |
| Logical Rolename | |
| ColumnName | ApplicationReceivedDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the creditor or originator received the application from the borrower for the subject mortgage loan that would trigger the truth in lending disclosure. |
| Note |
| ApplicationReceivedDate Logical Attribute Properties |
| Logical Attribute Name | ApplicationReceivedDate |
| Datatype | DATE |
| Nullable | NO |
| ApplicationReceivedDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ApplicationReceivedDate Bound Attachments |
| Name | Current Value |
| ApplicationReceivedDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ApplicationReceivedDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationReceivedDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationReceivedDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ApplicationReceivedDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ArmsLengthIndicator |
| Logical Rolename | |
| ColumnName | ArmsLengthIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that this is an Arms Length Transaction. An Arms length transaction is between a willing buyer and a willing seller with no undue influence on either party and there is no relationship between the parties except that of the specific transaction. |
| Note |
| ArmsLengthIndicator Logical Attribute Properties |
| Logical Attribute Name | ArmsLengthIndicator |
| Datatype | BIT |
| Nullable | NO |
| ArmsLengthIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ArmsLengthIndicator Bound Attachments |
| Name | Current Value |
| ArmsLengthIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ArmsLengthIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ArmsLengthIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumabilityIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | AssumabilityIndicator |
| Logical Rolename | |
| ColumnName | AssumabilityIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan is assumable by another borrower. |
| Note |
| AssumabilityIndicator Logical Attribute Properties |
| Logical Attribute Name | AssumabilityIndicator |
| Datatype | BIT |
| Nullable | NO |
| AssumabilityIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssumabilityIndicator Bound Attachments |
| Name | Current Value |
| AssumabilityIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssumabilityIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumabilityIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumabilityIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumabilityIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | AssumedIndicator |
| Logical Rolename | |
| ColumnName | AssumedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the loan has been assumed |
| Note |
| AssumedIndicator Logical Attribute Properties |
| Logical Attribute Name | AssumedIndicator |
| Datatype | BIT |
| Nullable | NO |
| AssumedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AssumedIndicator Bound Attachments |
| Name | Current Value |
| AssumedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AssumedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AssumedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonGuaranteedRefinancingIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BalloonGuaranteedRefinancingIndicator |
| Logical Rolename | |
| ColumnName | BalloonGuaranteedRefinancingIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates refinancing of the balloon mortgage loan is guaranteed by the lender. |
| Note |
| BalloonGuaranteedRefinancingIndicator Logical Attribute Properties |
| Logical Attribute Name | BalloonGuaranteedRefinancingIndicator |
| Datatype | BIT |
| Nullable | NO |
| BalloonGuaranteedRefinancingIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BalloonGuaranteedRefinancingIndicator Bound Attachments |
| Name | Current Value |
| BalloonGuaranteedRefinancingIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BalloonGuaranteedRefinancingIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonGuaranteedRefinancingIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonGuaranteedRefinancingIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonGuaranteedRefinancingIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BalloonIndicator |
| Logical Rolename | |
| ColumnName | BalloonIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether or not a final balloon payment is required under the terms of the loan repayment schedule to fully pay off the loan. |
| Note |
| BalloonIndicator Logical Attribute Properties |
| Logical Attribute Name | BalloonIndicator |
| Datatype | BIT |
| Nullable | NO |
| BalloonIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BalloonIndicator Bound Attachments |
| Name | Current Value |
| BalloonIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BalloonIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonPaymentAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BalloonPaymentAmount |
| Logical Rolename | |
| ColumnName | BalloonPaymentAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the final, or lump sum, balloon payment. |
| Note |
| BalloonPaymentAmount Logical Attribute Properties |
| Logical Attribute Name | BalloonPaymentAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| BalloonPaymentAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BalloonPaymentAmount Bound Attachments |
| Name | Current Value |
| BalloonPaymentAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BalloonPaymentAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonPaymentAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonPaymentAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonPaymentAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BalloonResetIndicator |
| Logical Rolename | |
| ColumnName | BalloonResetIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the balloon loan has been reset to the current market rate. |
| Note |
| BalloonResetIndicator Logical Attribute Properties |
| Logical Attribute Name | BalloonResetIndicator |
| Datatype | BIT |
| Nullable | NO |
| BalloonResetIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BalloonResetIndicator Bound Attachments |
| Name | Current Value |
| BalloonResetIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BalloonResetIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BalloonResetIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BelowMarketSubordinateFinancingIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BelowMarketSubordinateFinancingIndicator |
| Logical Rolename | |
| ColumnName | BelowMarketSubordinateFinancingIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the seller provided below-market subordinate financing. |
| Note |
| BelowMarketSubordinateFinancingIndicator Logical Attribute Properties |
| Logical Attribute Name | BelowMarketSubordinateFinancingIndicator |
| Datatype | BIT |
| Nullable | NO |
| BelowMarketSubordinateFinancingIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BelowMarketSubordinateFinancingIndicator Bound Attachments |
| Name | Current Value |
| BelowMarketSubordinateFinancingIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BelowMarketSubordinateFinancingIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BelowMarketSubordinateFinancingIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BelowMarketSubordinateFinancingIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BelowMarketSubordinateFinancingIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BiweeklyToMonthlyOnDefaultIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BiweeklyToMonthlyOnDefaultIndicator |
| Logical Rolename | |
| ColumnName | BiweeklyToMonthlyOnDefaultIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the lender allows conversion from Bi-weekly payments to monthly upon a default by the borrower. |
| Note |
| BiweeklyToMonthlyOnDefaultIndicator Logical Attribute Properties |
| Logical Attribute Name | BiweeklyToMonthlyOnDefaultIndicator |
| Datatype | BIT |
| Nullable | NO |
| BiweeklyToMonthlyOnDefaultIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BiweeklyToMonthlyOnDefaultIndicator Bound Attachments |
| Name | Current Value |
| BiweeklyToMonthlyOnDefaultIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BiweeklyToMonthlyOnDefaultIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BiweeklyToMonthlyOnDefaultIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BiweeklyToMonthlyOnDefaultIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BiweeklyToMonthlyOnDefaultIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerCount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BorrowerCount |
| Logical Rolename | |
| ColumnName | BorrowerCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of borrowers obligated on the note. |
| Note |
| BorrowerCount Logical Attribute Properties |
| Logical Attribute Name | BorrowerCount |
| Datatype | INTEGER |
| Nullable | NO |
| BorrowerCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BorrowerCount Bound Attachments |
| Name | Current Value |
| BorrowerCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BorrowerCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BorrowerCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BuydownTemporarySubsidyFundingIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | BuydownTemporarySubsidyFundingIndicator |
| Logical Rolename | |
| ColumnName | BuydownTemporarySubsidyFundingIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether there is buydown funding on this loan. A buydown is money paid by the borrower or third party for the purpose of reducing the interest rate and/or the monthly payments on a temporary basis. |
| Note |
| BuydownTemporarySubsidyFundingIndicator Logical Attribute Properties |
| Logical Attribute Name | BuydownTemporarySubsidyFundingIndicator |
| Datatype | BIT |
| Nullable | NO |
| BuydownTemporarySubsidyFundingIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BuydownTemporarySubsidyFundingIndicator Bound Attachments |
| Name | Current Value |
| BuydownTemporarySubsidyFundingIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| BuydownTemporarySubsidyFundingIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BuydownTemporarySubsidyFundingIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BuydownTemporarySubsidyFundingIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BuydownTemporarySubsidyFundingIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedFeesIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | CapitalizedFeesIndicator |
| Logical Rolename | |
| ColumnName | CapitalizedFeesIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the mortgage balance includes capitalized origination fees. |
| Note |
| CapitalizedFeesIndicator Logical Attribute Properties |
| Logical Attribute Name | CapitalizedFeesIndicator |
| Datatype | BIT |
| Nullable | NO |
| CapitalizedFeesIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CapitalizedFeesIndicator Bound Attachments |
| Name | Current Value |
| CapitalizedFeesIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CapitalizedFeesIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedFeesIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedFeesIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedFeesIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedLoanIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | CapitalizedLoanIndicator |
| Logical Rolename | |
| ColumnName | CapitalizedLoanIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that interest accrued, escrow disbursements made and/or fees charged are included in the unpaid principal balance. |
| Note |
| CapitalizedLoanIndicator Logical Attribute Properties |
| Logical Attribute Name | CapitalizedLoanIndicator |
| Datatype | BIT |
| Nullable | NO |
| CapitalizedLoanIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CapitalizedLoanIndicator Bound Attachments |
| Name | Current Value |
| CapitalizedLoanIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CapitalizedLoanIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedLoanIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedLoanIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CapitalizedLoanIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ClosingCostFinancedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ClosingCostFinancedIndicator |
| Logical Rolename | |
| ColumnName | ClosingCostFinancedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that some or all of the closing costs were financed into the Borrower Requested Loan Amount. |
| Note |
| ClosingCostFinancedIndicator Logical Attribute Properties |
| Logical Attribute Name | ClosingCostFinancedIndicator |
| Datatype | BIT |
| Nullable | NO |
| ClosingCostFinancedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ClosingCostFinancedIndicator Bound Attachments |
| Name | Current Value |
| ClosingCostFinancedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ClosingCostFinancedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ClosingCostFinancedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ClosingCostFinancedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ClosingCostFinancedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CollateralPledgedToName |
| Base Entity | LOAN_DETAIL |
| Attribute Name | CollateralPledgedToName |
| Logical Rolename | |
| ColumnName | CollateralPledgedToName |
| RoleName | |
| Domain | MISMOString |
| Definition | Specifies to whom the loan has been pledged as collateral. |
| Note |
| CollateralPledgedToName Logical Attribute Properties |
| Logical Attribute Name | CollateralPledgedToName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| CollateralPledgedToName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CollateralPledgedToName Bound Attachments |
| Name | Current Value |
| CollateralPledgedToName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CollateralPledgedToName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CollateralPledgedToName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CollateralPledgedToName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CollateralPledgedToName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ConcurrentOriginationIndicator |
| Logical Rolename | |
| ColumnName | ConcurrentOriginationIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that a new first mortgage will be closed concurrently with a second or a HELOC loan. |
| Note |
| ConcurrentOriginationIndicator Logical Attribute Properties |
| Logical Attribute Name | ConcurrentOriginationIndicator |
| Datatype | BIT |
| Nullable | NO |
| ConcurrentOriginationIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConcurrentOriginationIndicator Bound Attachments |
| Name | Current Value |
| ConcurrentOriginationIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConcurrentOriginationIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationLenderIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ConcurrentOriginationLenderIndicator |
| Logical Rolename | |
| ColumnName | ConcurrentOriginationLenderIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that a concurrent loan is from the same lender. This is in conjunction with Concurrent Origination Indicator. |
| Note |
| ConcurrentOriginationLenderIndicator Logical Attribute Properties |
| Logical Attribute Name | ConcurrentOriginationLenderIndicator |
| Datatype | BIT |
| Nullable | NO |
| ConcurrentOriginationLenderIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConcurrentOriginationLenderIndicator Bound Attachments |
| Name | Current Value |
| ConcurrentOriginationLenderIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConcurrentOriginationLenderIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationLenderIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationLenderIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConcurrentOriginationLenderIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConformingIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ConformingIndicator |
| Logical Rolename | |
| ColumnName | ConformingIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the loan amount is a conforming loan amount by Fannie Mae and Freddie Mac standards. |
| Note |
| ConformingIndicator Logical Attribute Properties |
| Logical Attribute Name | ConformingIndicator |
| Datatype | BIT |
| Nullable | NO |
| ConformingIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConformingIndicator Bound Attachments |
| Name | Current Value |
| ConformingIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConformingIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConformingIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConformingIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConformingIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConstructionLoanIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ConstructionLoanIndicator |
| Logical Rolename | |
| ColumnName | ConstructionLoanIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether or not this is a construction loan. |
| Note |
| ConstructionLoanIndicator Logical Attribute Properties |
| Logical Attribute Name | ConstructionLoanIndicator |
| Datatype | BIT |
| Nullable | NO |
| ConstructionLoanIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConstructionLoanIndicator Bound Attachments |
| Name | Current Value |
| ConstructionLoanIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConstructionLoanIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConstructionLoanIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConstructionLoanIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConstructionLoanIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ConvertibleIndicator |
| Logical Rolename | |
| ColumnName | ConvertibleIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the loan has a convertible characteristic. |
| Note |
| ConvertibleIndicator Logical Attribute Properties |
| Logical Attribute Name | ConvertibleIndicator |
| Datatype | BIT |
| Nullable | NO |
| ConvertibleIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ConvertibleIndicator Bound Attachments |
| Name | Current Value |
| ConvertibleIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ConvertibleIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ConvertibleIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentInterestRatePercent |
| Base Entity | LOAN_DETAIL |
| Attribute Name | CurrentInterestRatePercent |
| Logical Rolename | |
| ColumnName | CurrentInterestRatePercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The current interest rate, expressed as a percent, for this loan. |
| Note |
| CurrentInterestRatePercent Logical Attribute Properties |
| Logical Attribute Name | CurrentInterestRatePercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| CurrentInterestRatePercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CurrentInterestRatePercent Bound Attachments |
| Name | Current Value |
| CurrentInterestRatePercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CurrentInterestRatePercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentInterestRatePercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentInterestRatePercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CurrentInterestRatePercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestBalanceAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | DeferredInterestBalanceAmount |
| Logical Rolename | |
| ColumnName | DeferredInterestBalanceAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Accrued Uncollected Interest |
| Note |
| DeferredInterestBalanceAmount Logical Attribute Properties |
| Logical Attribute Name | DeferredInterestBalanceAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| DeferredInterestBalanceAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DeferredInterestBalanceAmount Bound Attachments |
| Name | Current Value |
| DeferredInterestBalanceAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DeferredInterestBalanceAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestBalanceAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestBalanceAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DeferredInterestBalanceAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DemandFeatureIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | DemandFeatureIndicator |
| Logical Rolename | |
| ColumnName | DemandFeatureIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the loan has a demand feature. |
| Note |
| DemandFeatureIndicator Logical Attribute Properties |
| Logical Attribute Name | DemandFeatureIndicator |
| Datatype | BIT |
| Nullable | NO |
| DemandFeatureIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DemandFeatureIndicator Bound Attachments |
| Name | Current Value |
| DemandFeatureIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| DemandFeatureIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DemandFeatureIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DemandFeatureIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DemandFeatureIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EligibleForLenderPaidMIIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EligibleForLenderPaidMIIndicator |
| Logical Rolename | |
| ColumnName | EligibleForLenderPaidMIIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the mortgage loan is eligible for lender-paid MI. |
| Note |
| EligibleForLenderPaidMIIndicator Logical Attribute Properties |
| Logical Attribute Name | EligibleForLenderPaidMIIndicator |
| Datatype | BIT |
| Nullable | NO |
| EligibleForLenderPaidMIIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EligibleForLenderPaidMIIndicator Bound Attachments |
| Name | Current Value |
| EligibleForLenderPaidMIIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EligibleForLenderPaidMIIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EligibleForLenderPaidMIIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EligibleForLenderPaidMIIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EligibleForLenderPaidMIIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EmployeeLoanProgramIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EmployeeLoanProgramIndicator |
| Logical Rolename | |
| ColumnName | EmployeeLoanProgramIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the loan is part of an employee loan program. |
| Note |
| EmployeeLoanProgramIndicator Logical Attribute Properties |
| Logical Attribute Name | EmployeeLoanProgramIndicator |
| Datatype | BIT |
| Nullable | NO |
| EmployeeLoanProgramIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EmployeeLoanProgramIndicator Bound Attachments |
| Name | Current Value |
| EmployeeLoanProgramIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EmployeeLoanProgramIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EmployeeLoanProgramIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EmployeeLoanProgramIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EmployeeLoanProgramIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteCertifiedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ENoteCertifiedIndicator |
| Logical Rolename | |
| ColumnName | ENoteCertifiedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan delivery data has been automatically certified against eNote data. |
| Note |
| ENoteCertifiedIndicator Logical Attribute Properties |
| Logical Attribute Name | ENoteCertifiedIndicator |
| Datatype | BIT |
| Nullable | NO |
| ENoteCertifiedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ENoteCertifiedIndicator Bound Attachments |
| Name | Current Value |
| ENoteCertifiedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ENoteCertifiedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteCertifiedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteCertifiedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteCertifiedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ENoteIndicator |
| Logical Rolename | |
| ColumnName | ENoteIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that an eNote is used as part of this loan. |
| Note |
| ENoteIndicator Logical Attribute Properties |
| Logical Attribute Name | ENoteIndicator |
| Datatype | BIT |
| Nullable | NO |
| ENoteIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ENoteIndicator Bound Attachments |
| Name | Current Value |
| ENoteIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ENoteIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ENoteIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountLenderRequirementType |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EscrowAccountLenderRequirementType |
| Logical Rolename | |
| ColumnName | EscrowAccountLenderRequirementType |
| RoleName | |
| Domain | EscrowAccountLenderRequirementEnum |
| Definition | Identifies the escrow account status in terms of the requirements of the lender in the mortgage loan transaction. |
| Note |
| EscrowAccountLenderRequirementType Logical Attribute Properties |
| Logical Attribute Name | EscrowAccountLenderRequirementType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| EscrowAccountLenderRequirementType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EscrowAccountLenderRequirementType Reference Value (Bound to Domain) |
| Name | ValidationRule146 |
| Description | |
| Type | By List |
| Value | Value Description |
| EscrowsRequiredByLender | Indicates an escrow account is required by the lender. |
| EscrowsWaivedByLender | Indicates the escrow account requirement has been waived by the lender. |
| EscrowAccountLenderRequirementType Bound Attachments |
| Name | Current Value |
| EscrowAccountLenderRequirementType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EscrowAccountLenderRequirementType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountLenderRequirementType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountLenderRequirementType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountLenderRequirementType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountRequestedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EscrowAccountRequestedIndicator |
| Logical Rolename | |
| ColumnName | EscrowAccountRequestedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the establishment of an escrow account has been requested by the borrower(s) for the loan. |
| Note |
| EscrowAccountRequestedIndicator Logical Attribute Properties |
| Logical Attribute Name | EscrowAccountRequestedIndicator |
| Datatype | BIT |
| Nullable | NO |
| EscrowAccountRequestedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EscrowAccountRequestedIndicator Bound Attachments |
| Name | Current Value |
| EscrowAccountRequestedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EscrowAccountRequestedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountRequestedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountRequestedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowAccountRequestedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EscrowIndicator |
| Logical Rolename | |
| ColumnName | EscrowIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether or not escrows are associated with this loan. |
| Note |
| EscrowIndicator Logical Attribute Properties |
| Logical Attribute Name | EscrowIndicator |
| Datatype | BIT |
| Nullable | NO |
| EscrowIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EscrowIndicator Bound Attachments |
| Name | Current Value |
| EscrowIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EscrowIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowNotAllowedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EscrowNotAllowedIndicator |
| Logical Rolename | |
| ColumnName | EscrowNotAllowedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that, under applicable law, a servicer may not establish an escrow account for the mortgage loan being modified. |
| Note |
| EscrowNotAllowedIndicator Logical Attribute Properties |
| Logical Attribute Name | EscrowNotAllowedIndicator |
| Datatype | BIT |
| Nullable | NO |
| EscrowNotAllowedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EscrowNotAllowedIndicator Bound Attachments |
| Name | Current Value |
| EscrowNotAllowedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EscrowNotAllowedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowNotAllowedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowNotAllowedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowNotAllowedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowsElectedByBorrowerIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | EscrowsElectedByBorrowerIndicator |
| Logical Rolename | |
| ColumnName | EscrowsElectedByBorrowerIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates the borrower has elected to establish an escrow account. |
| Note |
| EscrowsElectedByBorrowerIndicator Logical Attribute Properties |
| Logical Attribute Name | EscrowsElectedByBorrowerIndicator |
| Datatype | BIT |
| Nullable | NO |
| EscrowsElectedByBorrowerIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EscrowsElectedByBorrowerIndicator Bound Attachments |
| Name | Current Value |
| EscrowsElectedByBorrowerIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| EscrowsElectedByBorrowerIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowsElectedByBorrowerIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowsElectedByBorrowerIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EscrowsElectedByBorrowerIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HELOCIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | HELOCIndicator |
| Logical Rolename | |
| ColumnName | HELOCIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether or not a loan is a Home Equity Line of Credit (HELOC). |
| Note |
| HELOCIndicator Logical Attribute Properties |
| Logical Attribute Name | HELOCIndicator |
| Datatype | BIT |
| Nullable | NO |
| HELOCIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HELOCIndicator Bound Attachments |
| Name | Current Value |
| HELOCIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HELOCIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HELOCIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HELOCIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HELOCIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeBuyersHomeownershipEducationCertificateIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | HomeBuyersHomeownershipEducationCertificateIndicator |
| Logical Rolename | |
| ColumnName | HomeBuyersHomeownershipEducationCertificateIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the Home Buyers/Home Ownership Education certificate is included in the loan file. |
| Note |
| HomeBuyersHomeownershipEducationCertificateIndicator Logical Attribute Properties |
| Logical Attribute Name | HomeBuyersHomeownershipEducationCertificateIndicator |
| Datatype | BIT |
| Nullable | NO |
| HomeBuyersHomeownershipEducationCertificateIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HomeBuyersHomeownershipEducationCertificateIndicator Bound Attachments |
| Name | Current Value |
| HomeBuyersHomeownershipEducationCertificateIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HomeBuyersHomeownershipEducationCertificateIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeBuyersHomeownershipEducationCertificateIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeBuyersHomeownershipEducationCertificateIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeBuyersHomeownershipEducationCertificateIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InitialFixedPeriodEffectiveMonthsCount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | InitialFixedPeriodEffectiveMonthsCount |
| Logical Rolename | |
| ColumnName | InitialFixedPeriodEffectiveMonthsCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of months that the initial fixed period of a hybrid ARM is in effect |
| Note |
| InitialFixedPeriodEffectiveMonthsCount Logical Attribute Properties |
| Logical Attribute Name | InitialFixedPeriodEffectiveMonthsCount |
| Datatype | INTEGER |
| Nullable | NO |
| InitialFixedPeriodEffectiveMonthsCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InitialFixedPeriodEffectiveMonthsCount Bound Attachments |
| Name | Current Value |
| InitialFixedPeriodEffectiveMonthsCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InitialFixedPeriodEffectiveMonthsCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InitialFixedPeriodEffectiveMonthsCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InitialFixedPeriodEffectiveMonthsCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InitialFixedPeriodEffectiveMonthsCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestCreditedToBorrowerIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | InterestCreditedToBorrowerIndicator |
| Logical Rolename | |
| ColumnName | InterestCreditedToBorrowerIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Identifies whether interest was credited to the borrower at time of closing for a closed-end mortgage. |
| Note |
| InterestCreditedToBorrowerIndicator Logical Attribute Properties |
| Logical Attribute Name | InterestCreditedToBorrowerIndicator |
| Datatype | BIT |
| Nullable | NO |
| InterestCreditedToBorrowerIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestCreditedToBorrowerIndicator Bound Attachments |
| Name | Current Value |
| InterestCreditedToBorrowerIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestCreditedToBorrowerIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestCreditedToBorrowerIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestCreditedToBorrowerIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestCreditedToBorrowerIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestOnlyIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | InterestOnlyIndicator |
| Logical Rolename | |
| ColumnName | InterestOnlyIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether loan is set up with interest only payments. |
| Note |
| InterestOnlyIndicator Logical Attribute Properties |
| Logical Attribute Name | InterestOnlyIndicator |
| Datatype | BIT |
| Nullable | NO |
| InterestOnlyIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| InterestOnlyIndicator Bound Attachments |
| Name | Current Value |
| InterestOnlyIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| InterestOnlyIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestOnlyIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestOnlyIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| InterestOnlyIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderSelfInsuredIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LenderSelfInsuredIndicator |
| Logical Rolename | |
| ColumnName | LenderSelfInsuredIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the Lender will provide self-insurance. |
| Note |
| LenderSelfInsuredIndicator Logical Attribute Properties |
| Logical Attribute Name | LenderSelfInsuredIndicator |
| Datatype | BIT |
| Nullable | NO |
| LenderSelfInsuredIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LenderSelfInsuredIndicator Bound Attachments |
| Name | Current Value |
| LenderSelfInsuredIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LenderSelfInsuredIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderSelfInsuredIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderSelfInsuredIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LenderSelfInsuredIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LienHolderSameAsSubjectLoanIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LienHolderSameAsSubjectLoanIndicator |
| Logical Rolename | |
| ColumnName | LienHolderSameAsSubjectLoanIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the lien holder of the related loan is the same as the lien holder of the subject loan. |
| Note |
| LienHolderSameAsSubjectLoanIndicator Logical Attribute Properties |
| Logical Attribute Name | LienHolderSameAsSubjectLoanIndicator |
| Datatype | BIT |
| Nullable | NO |
| LienHolderSameAsSubjectLoanIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LienHolderSameAsSubjectLoanIndicator Bound Attachments |
| Name | Current Value |
| LienHolderSameAsSubjectLoanIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LienHolderSameAsSubjectLoanIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LienHolderSameAsSubjectLoanIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LienHolderSameAsSubjectLoanIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LienHolderSameAsSubjectLoanIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAffordableIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanAffordableIndicator |
| Logical Rolename | |
| ColumnName | LoanAffordableIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the loan is classified as an affordable loan by the lender or the investor. |
| Note |
| LoanAffordableIndicator Logical Attribute Properties |
| Logical Attribute Name | LoanAffordableIndicator |
| Datatype | BIT |
| Nullable | NO |
| LoanAffordableIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanAffordableIndicator Bound Attachments |
| Name | Current Value |
| LoanAffordableIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanAffordableIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAffordableIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAffordableIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanAffordableIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanApprovalDate |
| Logical Rolename | |
| ColumnName | LoanApprovalDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the mortgage loan approval was made by the lender to the borrower. A loan approval involves verifying credit, down payment, employment history, etc. of the borrower(s) and will generally state that the borrower is approved for a loan upon satisf |
| Note |
| LoanApprovalDate Logical Attribute Properties |
| Logical Attribute Name | LoanApprovalDate |
| Datatype | DATE |
| Nullable | NO |
| LoanApprovalDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanApprovalDate Bound Attachments |
| Name | Current Value |
| LoanApprovalDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanApprovalDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalExpirationDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanApprovalExpirationDate |
| Logical Rolename | |
| ColumnName | LoanApprovalExpirationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the mortgage loan approval expires. |
| Note |
| LoanApprovalExpirationDate Logical Attribute Properties |
| Logical Attribute Name | LoanApprovalExpirationDate |
| Datatype | DATE |
| Nullable | NO |
| LoanApprovalExpirationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanApprovalExpirationDate Bound Attachments |
| Name | Current Value |
| LoanApprovalExpirationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanApprovalExpirationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalExpirationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalExpirationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalExpirationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalPeriodDaysCount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanApprovalPeriodDaysCount |
| Logical Rolename | |
| ColumnName | LoanApprovalPeriodDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of days the mortgage loan approval is in effect. |
| Note |
| LoanApprovalPeriodDaysCount Logical Attribute Properties |
| Logical Attribute Name | LoanApprovalPeriodDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| LoanApprovalPeriodDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanApprovalPeriodDaysCount Bound Attachments |
| Name | Current Value |
| LoanApprovalPeriodDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanApprovalPeriodDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalPeriodDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalPeriodDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanApprovalPeriodDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanClosingStatusType |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanClosingStatusType |
| Logical Rolename | |
| ColumnName | LoanClosingStatusType |
| RoleName | |
| Domain | LoanClosingStatusEnum |
| Definition | Defines whether the loan is a closed loan purchase or a table funded loan. |
| Note |
| LoanClosingStatusType Logical Attribute Properties |
| Logical Attribute Name | LoanClosingStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanClosingStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanClosingStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule253 |
| Description | |
| Type | By List |
| Value | Value Description |
| Closed | The loan has already been closed and is now being purchased by an investor. |
| TableFunded | The loan is being funded with money advanced by the lender at the closing table. |
| LoanClosingStatusType Bound Attachments |
| Name | Current Value |
| LoanClosingStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanClosingStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanClosingStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanClosingStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanClosingStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanCommitmentDate |
| Logical Rolename | |
| ColumnName | LoanCommitmentDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the mortgage loan commitment to the borrower was made. The loan commitment is a formal, binding offer from a lender that a specified amount of loan or line of credit will be made available to the named borrower at a certain interest rate, during |
| Note |
| LoanCommitmentDate Logical Attribute Properties |
| Logical Attribute Name | LoanCommitmentDate |
| Datatype | DATE |
| Nullable | NO |
| LoanCommitmentDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanCommitmentDate Bound Attachments |
| Name | Current Value |
| LoanCommitmentDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanCommitmentDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentExpirationDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanCommitmentExpirationDate |
| Logical Rolename | |
| ColumnName | LoanCommitmentExpirationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the mortgage loan commitment expires. |
| Note |
| LoanCommitmentExpirationDate Logical Attribute Properties |
| Logical Attribute Name | LoanCommitmentExpirationDate |
| Datatype | DATE |
| Nullable | NO |
| LoanCommitmentExpirationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanCommitmentExpirationDate Bound Attachments |
| Name | Current Value |
| LoanCommitmentExpirationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanCommitmentExpirationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentExpirationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentExpirationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentExpirationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentPeriodDaysCount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanCommitmentPeriodDaysCount |
| Logical Rolename | |
| ColumnName | LoanCommitmentPeriodDaysCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of days the mortgage loan commitment is in effect. |
| Note |
| LoanCommitmentPeriodDaysCount Logical Attribute Properties |
| Logical Attribute Name | LoanCommitmentPeriodDaysCount |
| Datatype | INTEGER |
| Nullable | NO |
| LoanCommitmentPeriodDaysCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanCommitmentPeriodDaysCount Bound Attachments |
| Name | Current Value |
| LoanCommitmentPeriodDaysCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanCommitmentPeriodDaysCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentPeriodDaysCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentPeriodDaysCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanCommitmentPeriodDaysCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanFundingDate |
| Logical Rolename | |
| ColumnName | LoanFundingDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the original lender funds were released to the borrower. |
| Note |
| LoanFundingDate Logical Attribute Properties |
| Logical Attribute Name | LoanFundingDate |
| Datatype | DATE |
| Nullable | NO |
| LoanFundingDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanFundingDate Bound Attachments |
| Name | Current Value |
| LoanFundingDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanFundingDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanFundingDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentType |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanRepaymentType |
| Logical Rolename | |
| ColumnName | LoanRepaymentType |
| RoleName | |
| Domain | LoanRepaymentEnum |
| Definition | Specifies whether the loan payment schedule has been calculated to fully repay the loan over the mortgage term. |
| Note |
| LoanRepaymentType Logical Attribute Properties |
| Logical Attribute Name | LoanRepaymentType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| LoanRepaymentType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanRepaymentType Reference Value (Bound to Domain) |
| Name | ValidationRule271 |
| Description | |
| Type | By List |
| Value | Value Description |
| ConstantPrincipal | ConstantPrincipal |
| Other | Other |
| PrincipalPaymentOption | PrincipalPaymentOption |
| ScheduledAmortization | ScheduledAmortization |
| LoanRepaymentType Bound Attachments |
| Name | Current Value |
| LoanRepaymentType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanRepaymentType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentTypeOtherDescription |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanRepaymentTypeOtherDescription |
| Logical Rolename | |
| ColumnName | LoanRepaymentTypeOtherDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to collect additional information when Other is selected for Loan Repayment Type. |
| Note |
| LoanRepaymentTypeOtherDescription Logical Attribute Properties |
| Logical Attribute Name | LoanRepaymentTypeOtherDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanRepaymentTypeOtherDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanRepaymentTypeOtherDescription Bound Attachments |
| Name | Current Value |
| LoanRepaymentTypeOtherDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanRepaymentTypeOtherDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentTypeOtherDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentTypeOtherDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanRepaymentTypeOtherDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSaleFundingDate |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanSaleFundingDate |
| Logical Rolename | |
| ColumnName | LoanSaleFundingDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the investor releases funds to the seller of the loan. |
| Note |
| LoanSaleFundingDate Logical Attribute Properties |
| Logical Attribute Name | LoanSaleFundingDate |
| Datatype | DATE |
| Nullable | NO |
| LoanSaleFundingDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanSaleFundingDate Bound Attachments |
| Name | Current Value |
| LoanSaleFundingDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanSaleFundingDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSaleFundingDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSaleFundingDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSaleFundingDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSellerProvidedInvestmentRatingDescription |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LoanSellerProvidedInvestmentRatingDescription |
| Logical Rolename | |
| ColumnName | LoanSellerProvidedInvestmentRatingDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | The widely-recognized alpha code (e.g., AA, A, B, etc.) provided by the seller which specifies the credit risk class of a financial asset (e.g. a loan or mortgage backed security). |
| Note |
| LoanSellerProvidedInvestmentRatingDescription Logical Attribute Properties |
| Logical Attribute Name | LoanSellerProvidedInvestmentRatingDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanSellerProvidedInvestmentRatingDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanSellerProvidedInvestmentRatingDescription Bound Attachments |
| Name | Current Value |
| LoanSellerProvidedInvestmentRatingDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanSellerProvidedInvestmentRatingDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSellerProvidedInvestmentRatingDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSellerProvidedInvestmentRatingDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanSellerProvidedInvestmentRatingDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LostNoteAffidavitIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | LostNoteAffidavitIndicator |
| Logical Rolename | |
| ColumnName | LostNoteAffidavitIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether or not a lost note affidavit (LNA) is associated with the loan. |
| Note |
| LostNoteAffidavitIndicator Logical Attribute Properties |
| Logical Attribute Name | LostNoteAffidavitIndicator |
| Datatype | BIT |
| Nullable | NO |
| LostNoteAffidavitIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LostNoteAffidavitIndicator Bound Attachments |
| Name | Current Value |
| LostNoteAffidavitIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LostNoteAffidavitIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LostNoteAffidavitIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LostNoteAffidavitIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LostNoteAffidavitIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIRequiredIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | MIRequiredIndicator |
| Logical Rolename | |
| ColumnName | MIRequiredIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that Mortgage Insurance is or was required as a condition for originating the loan. |
| Note |
| MIRequiredIndicator Logical Attribute Properties |
| Logical Attribute Name | MIRequiredIndicator |
| Datatype | BIT |
| Nullable | NO |
| MIRequiredIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MIRequiredIndicator Bound Attachments |
| Name | Current Value |
| MIRequiredIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MIRequiredIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIRequiredIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIRequiredIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MIRequiredIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MortgageModificationIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | MortgageModificationIndicator |
| Logical Rolename | |
| ColumnName | MortgageModificationIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that a loan modification exists. |
| Note |
| MortgageModificationIndicator Logical Attribute Properties |
| Logical Attribute Name | MortgageModificationIndicator |
| Datatype | BIT |
| Nullable | NO |
| MortgageModificationIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MortgageModificationIndicator Bound Attachments |
| Name | Current Value |
| MortgageModificationIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| MortgageModificationIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MortgageModificationIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MortgageModificationIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MortgageModificationIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegativeAmortizationIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | NegativeAmortizationIndicator |
| Logical Rolename | |
| ColumnName | NegativeAmortizationIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan allows negative amortization. |
| Note |
| NegativeAmortizationIndicator Logical Attribute Properties |
| Logical Attribute Name | NegativeAmortizationIndicator |
| Datatype | BIT |
| Nullable | NO |
| NegativeAmortizationIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NegativeAmortizationIndicator Bound Attachments |
| Name | Current Value |
| NegativeAmortizationIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| NegativeAmortizationIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegativeAmortizationIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegativeAmortizationIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NegativeAmortizationIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLoanStandardEscrowProvisionsIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | OriginalLoanStandardEscrowProvisionsIndicator |
| Logical Rolename | |
| ColumnName | OriginalLoanStandardEscrowProvisionsIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true indicates the original loan documents included standard Fannie Mae/Freddie Mac Uniform Instrument provisions for escrow items. |
| Note |
| OriginalLoanStandardEscrowProvisionsIndicator Logical Attribute Properties |
| Logical Attribute Name | OriginalLoanStandardEscrowProvisionsIndicator |
| Datatype | BIT |
| Nullable | NO |
| OriginalLoanStandardEscrowProvisionsIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OriginalLoanStandardEscrowProvisionsIndicator Bound Attachments |
| Name | Current Value |
| OriginalLoanStandardEscrowProvisionsIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OriginalLoanStandardEscrowProvisionsIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLoanStandardEscrowProvisionsIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLoanStandardEscrowProvisionsIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLoanStandardEscrowProvisionsIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OverdueInterestAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | OverdueInterestAmount |
| Logical Rolename | |
| ColumnName | OverdueInterestAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The amount of interest accrued but not yet paid for Daily Simple Interest loans. This interest is considered overdue interest and is paid first when a payment is applied. |
| Note |
| OverdueInterestAmount Logical Attribute Properties |
| Logical Attribute Name | OverdueInterestAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| OverdueInterestAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OverdueInterestAmount Bound Attachments |
| Name | Current Value |
| OverdueInterestAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OverdueInterestAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OverdueInterestAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OverdueInterestAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OverdueInterestAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PiggybackLoanIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | PiggybackLoanIndicator |
| Logical Rolename | |
| ColumnName | PiggybackLoanIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates a second lien being carried under the same loan number as a first mortgage. Generally one mortgage is covered by two notes and the borrower makes one combined payment. |
| Note |
| PiggybackLoanIndicator Logical Attribute Properties |
| Logical Attribute Name | PiggybackLoanIndicator |
| Datatype | BIT |
| Nullable | NO |
| PiggybackLoanIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PiggybackLoanIndicator Bound Attachments |
| Name | Current Value |
| PiggybackLoanIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PiggybackLoanIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PiggybackLoanIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PiggybackLoanIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PiggybackLoanIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | PrepaymentPenaltyIndicator |
| Logical Rolename | |
| ColumnName | PrepaymentPenaltyIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan includes a penalty charged to the borrower in the event of prepayment. |
| Note |
| PrepaymentPenaltyIndicator Logical Attribute Properties |
| Logical Attribute Name | PrepaymentPenaltyIndicator |
| Datatype | BIT |
| Nullable | NO |
| PrepaymentPenaltyIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PrepaymentPenaltyIndicator Bound Attachments |
| Name | Current Value |
| PrepaymentPenaltyIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PrepaymentPenaltyIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyWaivedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | PrepaymentPenaltyWaivedIndicator |
| Logical Rolename | |
| ColumnName | PrepaymentPenaltyWaivedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the prepayment penalty has been waived. |
| Note |
| PrepaymentPenaltyWaivedIndicator Logical Attribute Properties |
| Logical Attribute Name | PrepaymentPenaltyWaivedIndicator |
| Datatype | BIT |
| Nullable | NO |
| PrepaymentPenaltyWaivedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PrepaymentPenaltyWaivedIndicator Bound Attachments |
| Name | Current Value |
| PrepaymentPenaltyWaivedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PrepaymentPenaltyWaivedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyWaivedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyWaivedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentPenaltyWaivedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentRestrictionIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | PrepaymentRestrictionIndicator |
| Logical Rolename | |
| ColumnName | PrepaymentRestrictionIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the loan has any restrictions on the prepayment of the loan (i.e. paying off the principal and or interest at a rate faster than prescribed by the payment schedule). |
| Note |
| PrepaymentRestrictionIndicator Logical Attribute Properties |
| Logical Attribute Name | PrepaymentRestrictionIndicator |
| Datatype | BIT |
| Nullable | NO |
| PrepaymentRestrictionIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PrepaymentRestrictionIndicator Bound Attachments |
| Name | Current Value |
| PrepaymentRestrictionIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PrepaymentRestrictionIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentRestrictionIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentRestrictionIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PrepaymentRestrictionIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertiesFinancedByLenderCount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | PropertiesFinancedByLenderCount |
| Logical Rolename | |
| ColumnName | PropertiesFinancedByLenderCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | Case or loan level count of properties already financed by this lender for the borrower(s) named on the loan application. Does not include subject property |
| Note |
| PropertiesFinancedByLenderCount Logical Attribute Properties |
| Logical Attribute Name | PropertiesFinancedByLenderCount |
| Datatype | INTEGER |
| Nullable | NO |
| PropertiesFinancedByLenderCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertiesFinancedByLenderCount Bound Attachments |
| Name | Current Value |
| PropertiesFinancedByLenderCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertiesFinancedByLenderCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertiesFinancedByLenderCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertiesFinancedByLenderCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertiesFinancedByLenderCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyInspectionWaiverIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | PropertyInspectionWaiverIndicator |
| Logical Rolename | |
| ColumnName | PropertyInspectionWaiverIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether a documented inspection of the property has been waived. |
| Note |
| PropertyInspectionWaiverIndicator Logical Attribute Properties |
| Logical Attribute Name | PropertyInspectionWaiverIndicator |
| Datatype | BIT |
| Nullable | NO |
| PropertyInspectionWaiverIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyInspectionWaiverIndicator Bound Attachments |
| Name | Current Value |
| PropertyInspectionWaiverIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyInspectionWaiverIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyInspectionWaiverIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyInspectionWaiverIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyInspectionWaiverIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | RecoverableCorporateAdvanceBalanceFromBorrowerAmount |
| Logical Rolename | |
| ColumnName | RecoverableCorporateAdvanceBalanceFromBorrowerAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Monies advanced on the loan (i.e. delinquency expense, tax penalty, repairs, etc.). |
| Note |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Logical Attribute Properties |
| Logical Attribute Name | RecoverableCorporateAdvanceBalanceFromBorrowerAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Bound Attachments |
| Name | Current Value |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromBorrowerAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | RecoverableCorporateAdvanceBalanceFromThirdPartyAmount |
| Logical Rolename | |
| ColumnName | RecoverableCorporateAdvanceBalanceFromThirdPartyAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | Monies advanced on the loan (i.e. delinquency expense, tax penalty, repairs, etc.). |
| Note |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Logical Attribute Properties |
| Logical Attribute Name | RecoverableCorporateAdvanceBalanceFromThirdPartyAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Bound Attachments |
| Name | Current Value |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RecoverableCorporateAdvanceBalanceFromThirdPartyAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundOfOverpaidInterestCalendarYearAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | RefundOfOverpaidInterestCalendarYearAmount |
| Logical Rolename | |
| ColumnName | RefundOfOverpaidInterestCalendarYearAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The amount of overpaid interest refunded to the borrower for the calendar year. |
| Note |
| RefundOfOverpaidInterestCalendarYearAmount Logical Attribute Properties |
| Logical Attribute Name | RefundOfOverpaidInterestCalendarYearAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RefundOfOverpaidInterestCalendarYearAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RefundOfOverpaidInterestCalendarYearAmount Bound Attachments |
| Name | Current Value |
| RefundOfOverpaidInterestCalendarYearAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RefundOfOverpaidInterestCalendarYearAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundOfOverpaidInterestCalendarYearAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundOfOverpaidInterestCalendarYearAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RefundOfOverpaidInterestCalendarYearAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelocationLoanIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | RelocationLoanIndicator |
| Logical Rolename | |
| ColumnName | RelocationLoanIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates if the loan is part of a corporate relocation program. |
| Note |
| RelocationLoanIndicator Logical Attribute Properties |
| Logical Attribute Name | RelocationLoanIndicator |
| Datatype | BIT |
| Nullable | NO |
| RelocationLoanIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RelocationLoanIndicator Bound Attachments |
| Name | Current Value |
| RelocationLoanIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RelocationLoanIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelocationLoanIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelocationLoanIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RelocationLoanIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RemainingUnearnedInterestAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | RemainingUnearnedInterestAmount |
| Logical Rolename | |
| ColumnName | RemainingUnearnedInterestAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The remaining amount of interest scheduled to be paid on a rule of 78s loan. |
| Note |
| RemainingUnearnedInterestAmount Logical Attribute Properties |
| Logical Attribute Name | RemainingUnearnedInterestAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| RemainingUnearnedInterestAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RemainingUnearnedInterestAmount Bound Attachments |
| Name | Current Value |
| RemainingUnearnedInterestAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| RemainingUnearnedInterestAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RemainingUnearnedInterestAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RemainingUnearnedInterestAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RemainingUnearnedInterestAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferProhibitedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ServicingTransferProhibitedIndicator |
| Logical Rolename | |
| ColumnName | ServicingTransferProhibitedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | When true, indicates that the transfer of servicing is prohibited during life of the loan or for a designated period of time or until a certain event or condition is satisfied. |
| Note |
| ServicingTransferProhibitedIndicator Logical Attribute Properties |
| Logical Attribute Name | ServicingTransferProhibitedIndicator |
| Datatype | BIT |
| Nullable | NO |
| ServicingTransferProhibitedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ServicingTransferProhibitedIndicator Bound Attachments |
| Name | Current Value |
| ServicingTransferProhibitedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ServicingTransferProhibitedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferProhibitedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferProhibitedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferProhibitedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferStatusType |
| Base Entity | LOAN_DETAIL |
| Attribute Name | ServicingTransferStatusType |
| Logical Rolename | |
| ColumnName | ServicingTransferStatusType |
| RoleName | |
| Domain | ServicingTransferStatusEnum |
| Definition | Defines whether the servicing on the loan will be retained or transferred to another party. Typically only on closed loans. |
| Note |
| ServicingTransferStatusType Logical Attribute Properties |
| Logical Attribute Name | ServicingTransferStatusType |
| Datatype | VARCHAR(0) |
| Nullable | YES |
| ServicingTransferStatusType Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ServicingTransferStatusType Reference Value (Bound to Domain) |
| Name | ValidationRule448 |
| Description | |
| Type | By List |
| Value | Value Description |
| Released | The servicing rights are being transferred to another party. |
| Retained | The servicing rights are being retained by the seller. |
| ServicingTransferStatusType Bound Attachments |
| Name | Current Value |
| ServicingTransferStatusType User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| ServicingTransferStatusType Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferStatusType Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferStatusType Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ServicingTransferStatusType Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedAppreciationIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | SharedAppreciationIndicator |
| Logical Rolename | |
| ColumnName | SharedAppreciationIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates the loan is one in which the lender, in exchange for a loan with a favorable interest rate, participates in the profits (if any) the borrow receives when the property is eventually sold. |
| Note |
| SharedAppreciationIndicator Logical Attribute Properties |
| Logical Attribute Name | SharedAppreciationIndicator |
| Datatype | BIT |
| Nullable | NO |
| SharedAppreciationIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SharedAppreciationIndicator Bound Attachments |
| Name | Current Value |
| SharedAppreciationIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SharedAppreciationIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedAppreciationIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedAppreciationIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedAppreciationIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedEquityIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | SharedEquityIndicator |
| Logical Rolename | |
| ColumnName | SharedEquityIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates the mortgage is for resale-restricted, owner-occupied housing in which the rights, responsibilities, and benefits of residential property ownership are shared between individual homeowners and another party. |
| Note |
| SharedEquityIndicator Logical Attribute Properties |
| Logical Attribute Name | SharedEquityIndicator |
| Datatype | BIT |
| Nullable | NO |
| SharedEquityIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SharedEquityIndicator Bound Attachments |
| Name | Current Value |
| SharedEquityIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SharedEquityIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedEquityIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedEquityIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SharedEquityIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SignedAuthorizationToRequestTaxRecordsIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | SignedAuthorizationToRequestTaxRecordsIndicator |
| Logical Rolename | |
| ColumnName | SignedAuthorizationToRequestTaxRecordsIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records is present. |
| Note |
| SignedAuthorizationToRequestTaxRecordsIndicator Logical Attribute Properties |
| Logical Attribute Name | SignedAuthorizationToRequestTaxRecordsIndicator |
| Datatype | BIT |
| Nullable | NO |
| SignedAuthorizationToRequestTaxRecordsIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SignedAuthorizationToRequestTaxRecordsIndicator Bound Attachments |
| Name | Current Value |
| SignedAuthorizationToRequestTaxRecordsIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SignedAuthorizationToRequestTaxRecordsIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SignedAuthorizationToRequestTaxRecordsIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SignedAuthorizationToRequestTaxRecordsIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SignedAuthorizationToRequestTaxRecordsIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxRecordsObtainedIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | TaxRecordsObtainedIndicator |
| Logical Rolename | |
| ColumnName | TaxRecordsObtainedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the IRS form (4506 or 4506T) that gives the lender the authority to request copies of tax records has been executed by the lender. |
| Note |
| TaxRecordsObtainedIndicator Logical Attribute Properties |
| Logical Attribute Name | TaxRecordsObtainedIndicator |
| Datatype | BIT |
| Nullable | NO |
| TaxRecordsObtainedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TaxRecordsObtainedIndicator Bound Attachments |
| Name | Current Value |
| TaxRecordsObtainedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TaxRecordsObtainedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxRecordsObtainedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxRecordsObtainedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TaxRecordsObtainedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | TimelyPaymentRateReductionIndicator |
| Logical Rolename | |
| ColumnName | TimelyPaymentRateReductionIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Flag indicating if the loan is eligible for a rate reduction if payments are received in a timely manner. |
| Note |
| TimelyPaymentRateReductionIndicator Logical Attribute Properties |
| Logical Attribute Name | TimelyPaymentRateReductionIndicator |
| Datatype | BIT |
| Nullable | NO |
| TimelyPaymentRateReductionIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TimelyPaymentRateReductionIndicator Bound Attachments |
| Name | Current Value |
| TimelyPaymentRateReductionIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TimelyPaymentRateReductionIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TimelyPaymentRateReductionIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMortgagedPropertiesCount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | TotalMortgagedPropertiesCount |
| Logical Rolename | |
| ColumnName | TotalMortgagedPropertiesCount |
| RoleName | |
| Domain | MISMOCount |
| Definition | The number of 1-4 unit properties that are financed and owned and/or obligated on by the borrower(s). A jointly owned/obligated property by multiple borrowers would count only once. |
| Note |
| TotalMortgagedPropertiesCount Logical Attribute Properties |
| Logical Attribute Name | TotalMortgagedPropertiesCount |
| Datatype | INTEGER |
| Nullable | NO |
| TotalMortgagedPropertiesCount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalMortgagedPropertiesCount Bound Attachments |
| Name | Current Value |
| TotalMortgagedPropertiesCount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalMortgagedPropertiesCount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMortgagedPropertiesCount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMortgagedPropertiesCount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalMortgagedPropertiesCount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalSalesConcessionAmount |
| Base Entity | LOAN_DETAIL |
| Attribute Name | TotalSalesConcessionAmount |
| Logical Rolename | |
| ColumnName | TotalSalesConcessionAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The sum total dollar amount of the value of all sales concessions granted by an interested party including such items as furniture, carpeting, decorator allowances, automobiles, vacations, securities, giveaways or other sales incentives |
| Note |
| TotalSalesConcessionAmount Logical Attribute Properties |
| Logical Attribute Name | TotalSalesConcessionAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| TotalSalesConcessionAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| TotalSalesConcessionAmount Bound Attachments |
| Name | Current Value |
| TotalSalesConcessionAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| TotalSalesConcessionAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalSalesConcessionAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalSalesConcessionAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TotalSalesConcessionAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseLenderIndicator |
| Base Entity | LOAN_DETAIL |
| Attribute Name | WarehouseLenderIndicator |
| Logical Rolename | |
| ColumnName | WarehouseLenderIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | An indicator denoting whether a Warehouse Bank is involved in the mortgage loan transaction through a relationship with the lender. |
| Note |
| WarehouseLenderIndicator Logical Attribute Properties |
| Logical Attribute Name | WarehouseLenderIndicator |
| Datatype | BIT |
| Nullable | NO |
| WarehouseLenderIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| WarehouseLenderIndicator Bound Attachments |
| Name | Current Value |
| WarehouseLenderIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| WarehouseLenderIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseLenderIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseLenderIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| WarehouseLenderIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |