| VALUATION_REVIEW_DETAIL |
| EntityType | Dependent |
| Logical Entity Name | VALUATION_REVIEW_DETAIL |
| Default Table Name | DEAL/SERVICES/SERVICE/VALUATION/VALUATION_RESPONSE/VALUATION_REPORT/VALUATION_REVIEW/VALUATION_REVIEW_DETAIL |
| Definition | A clooection of information about the Apprasail report review performed on the apprasal report parent record. |
| Note |
| VALUATION_REVIEW_DETAIL Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
| AppraisalIdentifier | MISMOIdentifier | VARCHAR(0) | NO | 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. |
| AppraisalReviewDisagreementDescription | MISMOString | VARCHAR(0) | NO | 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 |
| AppraisalReviewExtraordinaryAssumptionsDescription | MISMOString | VARCHAR(0) | NO | A free-form text field used to describe or comment on the extraordinary assumptions used in the appraisal review process. |
| AppraisalReviewImprovementsCompletedIndicator | MISMOIndicator | BIT | NO | Indicates whether the improvements specified in the original appraisal have been completed. |
| AppraisalReviewMarketValueChangeCommentDescription | MISMOString | VARCHAR(0) | NO | 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. |
| AppraisalReviewOriginalAppraisalEffectiveDate | MISMODate | DATE | NO | Specifies the original appraisal effective date and distinguishes it from all other effective dates during an appraisal review or appraisal update. FORM SPECIFIC FIELD |
| AppraisalReviewOriginalAppraisedValueAccurateIndicator | MISMOIndicator | BIT | NO | Indicates whether the original appraised value is accurate. |
| AppraisalReviewOriginalAppraisedValueAmount | MISMOAmount | DECIMAL(0, 2) | NO | 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 |
| AppraisalReviewValueConclusionCommentDescription | MISMOString | VARCHAR(0) | NO | 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. |
| PropertyMarketValueDecreasedIndicator | MISMOIndicator | BIT | NO | Indicates whether the market value of a property has decreased. Generally used when updating a previous appraisal on the same property. |
| VALUATION_REVIEW_DETAIL Keys |
| Key Name | Key Type | Keys |
| VALUATION_REVIEW_DETAIL Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| VALUATION_REVIEW | Identifying | One to Zero or One | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| VALUATION_REVIEW_DETAIL Check Constraints |
| Check Constraint Name | CheckConstraint |
| VALUATION_REVIEW_DETAIL Bound Attachments |
| Name | Current Value |
| VALUATION_REVIEW_DETAIL User-Defined Mappings |
| Model | Name | Description |
| VALUATION_REVIEW_DETAIL Data Movement Rules |
| Name | Type | Rule Text/Value |