| AppraisalReportEffectiveDate |
| Base Entity | VALUATION_REPORT_DETAIL |
| Attribute Name | AppraisalReportEffectiveDate |
| Logical Rolename | |
| ColumnName | AppraisalReportEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | Effective date of the appraisal report on the subject property. |
| Note |
| AppraisalReportEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | AppraisalReportEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| AppraisalReportEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReportEffectiveDate Bound Attachments |
| Name | Current Value |
| AppraisalReportEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReportEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReportEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReportEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReportEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserAdditionalFileIdentifier |
| Base Entity | VALUATION_REPORT_DETAIL |
| Attribute Name | AppraiserAdditionalFileIdentifier |
| Logical Rolename | |
| ColumnName | AppraiserAdditionalFileIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | Secondary report identifier used by the appraiser to identify appraisal reports. This field may carry the FHA number, case number, loan number or some other identifier.Used to indicate by name the type of identifier represented by AppraisersAdditionalFile |
| Note |
| AppraiserAdditionalFileIdentifier Logical Attribute Properties |
| Logical Attribute Name | AppraiserAdditionalFileIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraiserAdditionalFileIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraiserAdditionalFileIdentifier Bound Attachments |
| Name | Current Value |
| AppraiserAdditionalFileIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraiserAdditionalFileIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserAdditionalFileIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserAdditionalFileIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserAdditionalFileIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier |
| Base Entity | VALUATION_REPORT_DETAIL |
| Attribute Name | AppraiserFileIdentifier |
| Logical Rolename | |
| ColumnName | AppraiserFileIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | This is an identifier or number used by the appraiser to identify their reports. It is generally specific to the appraiser. |
| Note |
| AppraiserFileIdentifier Logical Attribute Properties |
| Logical Attribute Name | AppraiserFileIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraiserFileIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraiserFileIdentifier Bound Attachments |
| Name | Current Value |
| AppraiserFileIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraiserFileIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserFileIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserReportSignedDate |
| Base Entity | VALUATION_REPORT_DETAIL |
| Attribute Name | AppraiserReportSignedDate |
| Logical Rolename | |
| ColumnName | AppraiserReportSignedDate |
| RoleName | |
| Domain | MISMODate |
| Definition | Indicates the date the appraiser signed the appraisal report. |
| Note |
| AppraiserReportSignedDate Logical Attribute Properties |
| Logical Attribute Name | AppraiserReportSignedDate |
| Datatype | DATE |
| Nullable | NO |
| AppraiserReportSignedDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraiserReportSignedDate Bound Attachments |
| Name | Current Value |
| AppraiserReportSignedDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraiserReportSignedDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserReportSignedDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserReportSignedDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraiserReportSignedDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanOriginationSystemLoanIdentifier |
| Base Entity | VALUATION_REPORT_DETAIL |
| Attribute Name | LoanOriginationSystemLoanIdentifier |
| Logical Rolename | |
| ColumnName | LoanOriginationSystemLoanIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A control number (i.e. key) for the loan in the sending loan origination system. |
| Note |
| LoanOriginationSystemLoanIdentifier Logical Attribute Properties |
| Logical Attribute Name | LoanOriginationSystemLoanIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| LoanOriginationSystemLoanIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| LoanOriginationSystemLoanIdentifier Bound Attachments |
| Name | Current Value |
| LoanOriginationSystemLoanIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| LoanOriginationSystemLoanIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanOriginationSystemLoanIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanOriginationSystemLoanIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| LoanOriginationSystemLoanIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SupervisorReportSignedDate |
| Base Entity | VALUATION_REPORT_DETAIL |
| Attribute Name | SupervisorReportSignedDate |
| Logical Rolename | |
| ColumnName | SupervisorReportSignedDate |
| RoleName | |
| Domain | MISMODate |
| Definition | Indicates the date the supervisor signed the report. |
| Note |
| SupervisorReportSignedDate Logical Attribute Properties |
| Logical Attribute Name | SupervisorReportSignedDate |
| Datatype | DATE |
| Nullable | NO |
| SupervisorReportSignedDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SupervisorReportSignedDate Bound Attachments |
| Name | Current Value |
| SupervisorReportSignedDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| SupervisorReportSignedDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SupervisorReportSignedDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SupervisorReportSignedDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SupervisorReportSignedDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |