| AppraisalCompletionCertificateCommentDescription |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalCompletionCertificateCommentDescription |
| Logical Rolename | |
| ColumnName | AppraisalCompletionCertificateCommentDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free-form text field used to describe or comment on the Certification of Completion of property improvements that a property valuation was dependent upon. |
| Note |
| AppraisalCompletionCertificateCommentDescription Logical Attribute Properties |
| Logical Attribute Name | AppraisalCompletionCertificateCommentDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalCompletionCertificateCommentDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalCompletionCertificateCommentDescription Bound Attachments |
| Name | Current Value |
| AppraisalCompletionCertificateCommentDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalCompletionCertificateCommentDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateCommentDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateCommentDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateCommentDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateIndicator |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalCompletionCertificateIndicator |
| Logical Rolename | |
| ColumnName | AppraisalCompletionCertificateIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the appraisal report is a Certification of Completion of improvements upon which a previous appraisal report is dependent. |
| Note |
| AppraisalCompletionCertificateIndicator Logical Attribute Properties |
| Logical Attribute Name | AppraisalCompletionCertificateIndicator |
| Datatype | BIT |
| Nullable | NO |
| AppraisalCompletionCertificateIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalCompletionCertificateIndicator Bound Attachments |
| Name | Current Value |
| AppraisalCompletionCertificateIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalCompletionCertificateIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalCompletionCertificateIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalReviewOriginalAppraisalEffectiveDate |
| Base Entity | VALUATION_UPDATE |
| 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 |
| AppraisalReviewOriginalAppraisedValueAmount |
| Base Entity | VALUATION_UPDATE |
| 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 |
| AppraisalUpdateCommentDescription |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalUpdateCommentDescription |
| Logical Rolename | |
| ColumnName | AppraisalUpdateCommentDescription |
| RoleName | |
| Domain | MISMOString |
| Definition | A free form text field used to describe or comment on the Appraisal Update Report. |
| Note |
| AppraisalUpdateCommentDescription Logical Attribute Properties |
| Logical Attribute Name | AppraisalUpdateCommentDescription |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalUpdateCommentDescription Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalUpdateCommentDescription Bound Attachments |
| Name | Current Value |
| AppraisalUpdateCommentDescription User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalUpdateCommentDescription Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateCommentDescription Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateCommentDescription Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateCommentDescription Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateIndicator |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalUpdateIndicator |
| Logical Rolename | |
| ColumnName | AppraisalUpdateIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the appraisal report is an update to an existing appraisal report. |
| Note |
| AppraisalUpdateIndicator Logical Attribute Properties |
| Logical Attribute Name | AppraisalUpdateIndicator |
| Datatype | BIT |
| Nullable | NO |
| AppraisalUpdateIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalUpdateIndicator Bound Attachments |
| Name | Current Value |
| AppraisalUpdateIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalUpdateIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserCompanyName |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalUpdateOriginalAppraiserCompanyName |
| Logical Rolename | |
| ColumnName | AppraisalUpdateOriginalAppraiserCompanyName |
| RoleName | |
| Domain | MISMOString |
| Definition | Specifies the company name of the original appraiser whose appraisal report is being reviewed or updated. FORM SPECIFIC FIELD |
| Note |
| AppraisalUpdateOriginalAppraiserCompanyName Logical Attribute Properties |
| Logical Attribute Name | AppraisalUpdateOriginalAppraiserCompanyName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalUpdateOriginalAppraiserCompanyName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalUpdateOriginalAppraiserCompanyName Bound Attachments |
| Name | Current Value |
| AppraisalUpdateOriginalAppraiserCompanyName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalUpdateOriginalAppraiserCompanyName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserCompanyName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserCompanyName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserCompanyName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserUnparsedName |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalUpdateOriginalAppraiserUnparsedName |
| Logical Rolename | |
| ColumnName | AppraisalUpdateOriginalAppraiserUnparsedName |
| RoleName | |
| Domain | MISMOString |
| Definition | Specifies the unparsed name of the original appraiser whose appraisal report is being reviewed or updated. FORM SPECIFIC FIELD |
| Note |
| AppraisalUpdateOriginalAppraiserUnparsedName Logical Attribute Properties |
| Logical Attribute Name | AppraisalUpdateOriginalAppraiserUnparsedName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalUpdateOriginalAppraiserUnparsedName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalUpdateOriginalAppraiserUnparsedName Bound Attachments |
| Name | Current Value |
| AppraisalUpdateOriginalAppraiserUnparsedName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalUpdateOriginalAppraiserUnparsedName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserUnparsedName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserUnparsedName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalAppraiserUnparsedName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderAddressLineText |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalUpdateOriginalLenderAddressLineText |
| Logical Rolename | |
| ColumnName | AppraisalUpdateOriginalLenderAddressLineText |
| RoleName | |
| Domain | MISMOString |
| Definition | Specifies the unparsed address of the original lender on an appraisal report that is being reviewed or updated. FORM SPECIFIC FIELD |
| Note |
| AppraisalUpdateOriginalLenderAddressLineText Logical Attribute Properties |
| Logical Attribute Name | AppraisalUpdateOriginalLenderAddressLineText |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalUpdateOriginalLenderAddressLineText Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalUpdateOriginalLenderAddressLineText Bound Attachments |
| Name | Current Value |
| AppraisalUpdateOriginalLenderAddressLineText User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalUpdateOriginalLenderAddressLineText Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderAddressLineText Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderAddressLineText Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderAddressLineText Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderUnparsedName |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | AppraisalUpdateOriginalLenderUnparsedName |
| Logical Rolename | |
| ColumnName | AppraisalUpdateOriginalLenderUnparsedName |
| RoleName | |
| Domain | MISMOString |
| Definition | Specifies the unparsed name of the original lender on an appraisal report that is being reviewed or updated. FORM SPECIFIC FIELD |
| Note |
| AppraisalUpdateOriginalLenderUnparsedName Logical Attribute Properties |
| Logical Attribute Name | AppraisalUpdateOriginalLenderUnparsedName |
| Datatype | VARCHAR(0) |
| Nullable | NO |
| AppraisalUpdateOriginalLenderUnparsedName Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| AppraisalUpdateOriginalLenderUnparsedName Bound Attachments |
| Name | Current Value |
| AppraisalUpdateOriginalLenderUnparsedName User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| AppraisalUpdateOriginalLenderUnparsedName Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderUnparsedName Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderUnparsedName Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AppraisalUpdateOriginalLenderUnparsedName Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyImprovementsCompletedIndicator |
| Base Entity | VALUATION_UPDATE |
| Attribute Name | PropertyImprovementsCompletedIndicator |
| Logical Rolename | |
| ColumnName | PropertyImprovementsCompletedIndicator |
| RoleName | |
| Domain | MISMOIndicator |
| Definition | Indicates whether the improvements to the property have been completed. These are improvements generally in accordance with the requirements stated in an appraisal report. |
| Note |
| PropertyImprovementsCompletedIndicator Logical Attribute Properties |
| Logical Attribute Name | PropertyImprovementsCompletedIndicator |
| Datatype | BIT |
| Nullable | NO |
| PropertyImprovementsCompletedIndicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PropertyImprovementsCompletedIndicator Bound Attachments |
| Name | Current Value |
| PropertyImprovementsCompletedIndicator User-Defined Mappings |
| Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
| PropertyImprovementsCompletedIndicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyImprovementsCompletedIndicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyImprovementsCompletedIndicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyImprovementsCompletedIndicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PropertyMarketValueDecreasedIndicator |
| Base Entity | VALUATION_UPDATE |
| 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 |