VALUATION_UPDATE Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
AppraisalCompletionCertificateCommentDescription	MISMOString	VARCHAR(0)	NO	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.
AppraisalCompletionCertificateIndicator	MISMOIndicator	BIT	NO	Indicates whether the appraisal report is a Certification of Completion of improvements upon which a previous appraisal report is dependent.
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
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
AppraisalUpdateCommentDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to describe or comment on the Appraisal Update Report.
AppraisalUpdateIndicator	MISMOIndicator	BIT	NO	Indicates whether the appraisal report is an update to an existing appraisal report.
AppraisalUpdateOriginalAppraiserCompanyName	MISMOString	VARCHAR(0)	NO	Specifies the company name of the original appraiser whose appraisal report is being reviewed or updated. FORM SPECIFIC FIELD
AppraisalUpdateOriginalAppraiserUnparsedName	MISMOString	VARCHAR(0)	NO	Specifies the unparsed name of the original appraiser whose appraisal report is being reviewed or updated. FORM SPECIFIC FIELD
AppraisalUpdateOriginalLenderAddressLineText	MISMOString	VARCHAR(0)	NO	Specifies the unparsed address of the original lender on an appraisal report that is being reviewed or updated. FORM SPECIFIC FIELD
AppraisalUpdateOriginalLenderUnparsedName	MISMOString	VARCHAR(0)	NO	Specifies the unparsed name of the original lender on an appraisal report that is being reviewed or updated. FORM SPECIFIC FIELD
PropertyImprovementsCompletedIndicator	MISMOIndicator	BIT	NO	Indicates whether the improvements to the property have been completed. These are improvements generally in accordance with the requirements stated in an 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_UPDATE Keys

Key Name

Key Type

Keys

VALUATION_UPDATE Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
VALUATION_REPORT	Identifying	One to Zero or One					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

VALUATION_UPDATE Check Constraints

Check Constraint Name

CheckConstraint

VALUATION_UPDATE Bound Attachments

Name	Current Value

VALUATION_UPDATE User-Defined Mappings

Model

Name

Description

VALUATION_UPDATE Data Movement Rules

Name

Type

Rule Text/Value