NEW_IMPROVEMENT Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
NewImprovementCostAmount	MISMOAmount	DECIMAL(0, 2)	NO	The dollar value of total estimated costs to reproduce new the property improvement. (CALCULATED RESULTS FIELD)
SequenceNumber	XSD:Integer	INTEGER	YES	An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element.
NewImprovementCostDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to capture additional information about new property improvement reproduction costs.
NewImprovementType	NewImprovementEnum	VARCHAR(0)	YES	Specifies the type of property improvement whose costs to reproduce are being estimated.
NewImprovementTypeOtherDescription	MISMOString	VARCHAR(0)	NO	A free form text field used to capture additional information when Other is selected for New Improvement Type.
PricePerSquareFootAmount	MISMOAmount	DECIMAL(0, 2)	NO	The price in terms of dollars per square foot. This is a ratio between a price and an area, but it is a monetary value rather than a factor or rate. (i.e. sales price per gross living area of a property)
SquareFeetNumber	MISMONumeric	DECIMAL(0, 2)	NO	Identifies the total area measured in square feet.

NEW_IMPROVEMENT Keys

Key Name

Key Type

Keys

NEW_IMPROVEMENT Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
NEW_IMPROVEMENTS	Identifying	One To Zero or More					NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

NEW_IMPROVEMENT Check Constraints

Check Constraint Name

CheckConstraint

NEW_IMPROVEMENT Bound Attachments

Name	Current Value

NEW_IMPROVEMENT User-Defined Mappings

Model

Name

Description

NEW_IMPROVEMENT Data Movement Rules

Name

Type

Rule Text/Value