| CombinedLTVRatioPercent |
| Base Entity | COMBINED_LTV |
| Attribute Name | CombinedLTVRatioPercent |
| Logical Rolename | |
| ColumnName | CombinedLTVRatioPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The result of dividing the combined unpaid principal balance (UPB) amounts of the first and all subordinate mortgages, excluding undrawn home equity lines of credit amounts, by the value of the subject property. |
| Note |
| CombinedLTVRatioPercent Logical Attribute Properties |
| Logical Attribute Name | CombinedLTVRatioPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| CombinedLTVRatioPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CombinedLTVRatioPercent Bound Attachments |
| Name | Current Value |
| CombinedLTVRatioPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| CombinedLTVRatioPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CombinedLTVRatioPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CombinedLTVRatioPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CombinedLTVRatioPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber |
| Base Entity | COMBINED_LTV |
| Attribute Name | SequenceNumber |
| Logical Rolename | |
| ColumnName | SequenceNumber |
| RoleName | |
| Domain | XSD:Integer |
| Definition | An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. |
| Note |
| SequenceNumber Logical Attribute Properties |
| Logical Attribute Name | SequenceNumber |
| Datatype | INTEGER |
| Nullable | YES |
| SequenceNumber Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SequenceNumber Bound Attachments |
| Name | Current Value |
| SequenceNumber User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SequenceNumber Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SequenceNumber Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeEquityCombinedLTVRatioPercent |
| Base Entity | COMBINED_LTV |
| Attribute Name | HomeEquityCombinedLTVRatioPercent |
| Logical Rolename | |
| ColumnName | HomeEquityCombinedLTVRatioPercent |
| RoleName | |
| Domain | MISMOPercent |
| Definition | The result of dividing the sum of the unpaid principal balance (UPB) of the first mortgage, the full amount of any home equity line of credit (whether drawn or undrawn), and the balance of any other subordinate financing by the value of the subject proper |
| Note |
| HomeEquityCombinedLTVRatioPercent Logical Attribute Properties |
| Logical Attribute Name | HomeEquityCombinedLTVRatioPercent |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| HomeEquityCombinedLTVRatioPercent Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HomeEquityCombinedLTVRatioPercent Bound Attachments |
| Name | Current Value |
| HomeEquityCombinedLTVRatioPercent User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| HomeEquityCombinedLTVRatioPercent Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeEquityCombinedLTVRatioPercent Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeEquityCombinedLTVRatioPercent Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HomeEquityCombinedLTVRatioPercent Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LTVCalculationDate |
| Base Entity | COMBINED_LTV |
| Attribute Name | LTVCalculationDate |
| Logical Rolename | |
| ColumnName | LTVCalculationDate |
| RoleName | |
| Domain | MISMODate |
| Definition | The date the LTV was calculated. |
| Note |
| LTVCalculationDate Logical Attribute Properties |
| Logical Attribute Name | LTVCalculationDate |
| Datatype | DATE |
| Nullable | NO |
| LTVCalculationDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LTVCalculationDate Bound Attachments |
| Name | Current Value |
| LTVCalculationDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LTVCalculationDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LTVCalculationDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LTVCalculationDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LTVCalculationDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLTVIndicator |
| Base Entity | COMBINED_LTV |
| Attribute Name | OriginalLTVIndicator |
| Logical Rolename | |
| ColumnName | OriginalLTVIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates that the combined LTV values are for the LOAN containers whose Loan State Type is At Closing. |
| Note |
| OriginalLTVIndicator Logical Attribute Properties |
| Logical Attribute Name | OriginalLTVIndicator |
| Datatype | BIT |
| Nullable | NO |
| OriginalLTVIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OriginalLTVIndicator Bound Attachments |
| Name | Current Value |
| OriginalLTVIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| OriginalLTVIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLTVIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLTVIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OriginalLTVIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |