| AppraisalIdentifier |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalIdentifier |
| Logical Rolename | |
| ColumnName | AppraisalIdentifier |
| RoleName | |
| Domain | MISMOIdentifier |
| Definition | A unique identifier assigned by a party for all appraisal data delivered to the party for this loan. The party assigning the identifier can be provided using the IdentifierOwnerURI associated with a MISMO identifier. |
| Note |
| AppraisalIdentifier Logical Attribute Properties |
| Logical Attribute Name | AppraisalIdentifier |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalIdentifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalIdentifier Bound Attachments |
| Name | Current Value |
| AppraisalIdentifier User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalIdentifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalIdentifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalIdentifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalIdentifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewDisagreementDescription |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewDisagreementDescription |
| Logical Rolename | |
| ColumnName | AppraisalReviewDisagreementDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe or comment on the reasons for disagreement with the original opinion of market value in the appraisal report under review. FORM SPECIFIC FIELD |
| Note |
| AppraisalReviewDisagreementDescription Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewDisagreementDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalReviewDisagreementDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewDisagreementDescription Bound Attachments |
| Name | Current Value |
| AppraisalReviewDisagreementDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewDisagreementDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewDisagreementDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewDisagreementDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewDisagreementDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewExtraordinaryAssumptionsDescription |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewExtraordinaryAssumptionsDescription |
| Logical Rolename | |
| ColumnName | AppraisalReviewExtraordinaryAssumptionsDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe or comment on the extraordinary assumptions used in the appraisal review process. |
| Note |
| AppraisalReviewExtraordinaryAssumptionsDescription Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewExtraordinaryAssumptionsDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalReviewExtraordinaryAssumptionsDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewExtraordinaryAssumptionsDescription Bound Attachments |
| Name | Current Value |
| AppraisalReviewExtraordinaryAssumptionsDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewExtraordinaryAssumptionsDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewExtraordinaryAssumptionsDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewExtraordinaryAssumptionsDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewExtraordinaryAssumptionsDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewImprovementsCompletedIndicator |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewImprovementsCompletedIndicator |
| Logical Rolename | |
| ColumnName | AppraisalReviewImprovementsCompletedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the improvements specified in the original appraisal have been completed. |
| Note |
| AppraisalReviewImprovementsCompletedIndicator Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewImprovementsCompletedIndicator |
| Datatype | BIT |
| Nullable | NO |
| AppraisalReviewImprovementsCompletedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewImprovementsCompletedIndicator Bound Attachments |
| Name | Current Value |
| AppraisalReviewImprovementsCompletedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewImprovementsCompletedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewImprovementsCompletedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewImprovementsCompletedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewImprovementsCompletedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewMarketValueChangeCommentDescription |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewMarketValueChangeCommentDescription |
| Logical Rolename | |
| ColumnName | AppraisalReviewMarketValueChangeCommentDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to comment and describe the changes in the market value of the property between the original appraisal and the review of the appraisal. |
| Note |
| AppraisalReviewMarketValueChangeCommentDescription Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewMarketValueChangeCommentDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalReviewMarketValueChangeCommentDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewMarketValueChangeCommentDescription Bound Attachments |
| Name | Current Value |
| AppraisalReviewMarketValueChangeCommentDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewMarketValueChangeCommentDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewMarketValueChangeCommentDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewMarketValueChangeCommentDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewMarketValueChangeCommentDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisalEffectiveDate |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewOriginalAppraisalEffectiveDate |
| Logical Rolename | |
| ColumnName | AppraisalReviewOriginalAppraisalEffectiveDate |
| RoleName | |
| Domain | MISMODate |
| Definition | Specifies the original appraisal effective date and distinguishes it from all other effective dates during an appraisal review or appraisal update. FORM SPECIFIC FIELD |
| Note |
| AppraisalReviewOriginalAppraisalEffectiveDate Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewOriginalAppraisalEffectiveDate |
| Datatype | DATE |
| Nullable | NO |
| AppraisalReviewOriginalAppraisalEffectiveDate Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewOriginalAppraisalEffectiveDate Bound Attachments |
| Name | Current Value |
| AppraisalReviewOriginalAppraisalEffectiveDate User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewOriginalAppraisalEffectiveDate Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisalEffectiveDate Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisalEffectiveDate Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisalEffectiveDate Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewOriginalAppraisedValueAccurateIndicator |
| Logical Rolename | |
| ColumnName | AppraisalReviewOriginalAppraisedValueAccurateIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the original appraised value is accurate. |
| Note |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewOriginalAppraisedValueAccurateIndicator |
| Datatype | BIT |
| Nullable | NO |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Bound Attachments |
| Name | Current Value |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAmount |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewOriginalAppraisedValueAmount |
| Logical Rolename | |
| ColumnName | AppraisalReviewOriginalAppraisedValueAmount |
| RoleName | |
| Domain | MISMOAmount |
| Definition | The dollar amount of the original property valuation. This field distinguishes it from a new valuation amount determined during an appraisal review or appraisal update. FORM SPECIFIC FIELD |
| Note |
| AppraisalReviewOriginalAppraisedValueAmount Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewOriginalAppraisedValueAmount |
| Datatype | DECIMAL(0, 2) |
| Nullable | NO |
| AppraisalReviewOriginalAppraisedValueAmount Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewOriginalAppraisedValueAmount Bound Attachments |
| Name | Current Value |
| AppraisalReviewOriginalAppraisedValueAmount User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewOriginalAppraisedValueAmount Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAmount Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAmount Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisedValueAmount Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewValueConclusionCommentDescription |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | AppraisalReviewValueConclusionCommentDescription |
| Logical Rolename | |
| ColumnName | AppraisalReviewValueConclusionCommentDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe or summarize the reasons why the new data supports a different market value than was reported in the original appraisal report. |
| Note |
| AppraisalReviewValueConclusionCommentDescription Logical Attribute Properties |
| Logical Attribute Name | AppraisalReviewValueConclusionCommentDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalReviewValueConclusionCommentDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalReviewValueConclusionCommentDescription Bound Attachments |
| Name | Current Value |
| AppraisalReviewValueConclusionCommentDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalReviewValueConclusionCommentDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewValueConclusionCommentDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewValueConclusionCommentDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewValueConclusionCommentDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyMarketValueDecreasedIndicator |
| Base Entity | VALUATION_REVIEW_DETAIL |
| Attribute Name | PropertyMarketValueDecreasedIndicator |
| Logical Rolename | |
| ColumnName | PropertyMarketValueDecreasedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the market value of a property has decreased. Generally used when updating a previous appraisal on the same property. |
| Note |
| PropertyMarketValueDecreasedIndicator Logical Attribute Properties |
| Logical Attribute Name | PropertyMarketValueDecreasedIndicator |
| Datatype | BIT |
| Nullable | NO |
| PropertyMarketValueDecreasedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyMarketValueDecreasedIndicator Bound Attachments |
| Name | Current Value |
| PropertyMarketValueDecreasedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyMarketValueDecreasedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyMarketValueDecreasedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyMarketValueDecreasedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyMarketValueDecreasedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |