NewImprovementCostAmount 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  NewImprovementCostAmount 
Logical Rolename   
ColumnName  NewImprovementCostAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar value of total estimated costs to reproduce new the property improvement. (CALCULATED RESULTS FIELD) 
Note 
 

NewImprovementCostAmount Logical Attribute Properties 
Logical Attribute Name  NewImprovementCostAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

NewImprovementCostAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NewImprovementCostAmount Bound Attachments 
Name  Current Value 

NewImprovementCostAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

NewImprovementCostAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementCostAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementCostAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementCostAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SequenceNumber 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  SequenceNumber 
Logical Rolename   
ColumnName  SequenceNumber 
RoleName   
Domain  XSD:Integer 
Definition  An integer value used to provide an order to multi-instance sibling elements. The value must be unique for each sibling element. 
Note 
 

SequenceNumber Logical Attribute Properties 
Logical Attribute Name  SequenceNumber 
Datatype  INTEGER 
Nullable  YES 

SequenceNumber Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SequenceNumber Bound Attachments 
Name  Current Value 

SequenceNumber User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SequenceNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SequenceNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NewImprovementCostDescription 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  NewImprovementCostDescription 
Logical Rolename   
ColumnName  NewImprovementCostDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to capture additional information about new property improvement reproduction costs. 
Note 
 

NewImprovementCostDescription Logical Attribute Properties 
Logical Attribute Name  NewImprovementCostDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

NewImprovementCostDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NewImprovementCostDescription Bound Attachments 
Name  Current Value 

NewImprovementCostDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

NewImprovementCostDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementCostDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementCostDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementCostDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NewImprovementType 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  NewImprovementType 
Logical Rolename   
ColumnName  NewImprovementType 
RoleName   
Domain  NewImprovementEnum 
Definition  Specifies the type of property improvement whose costs to reproduce are being estimated.  
Note 
 

NewImprovementType Logical Attribute Properties 
Logical Attribute Name  NewImprovementType 
Datatype  VARCHAR(0) 
Nullable  YES 

NewImprovementType Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NewImprovementType Reference Value (Bound to Domain) 
Name  ValidationRule334 
Description   
Type  By List 
Value  Value Description 
Additional  Additional 
Dwelling  Dwelling 
EnergyEfficientItems  EnergyEfficientItems 
Garage  Garage 
LevelFive  LevelFive 
LevelFour  LevelFour 
LevelOne  LevelOne 
LevelThree  LevelThree 
LevelTwo  LevelTwo 
Other  Other 
PorchesPatios  PorchesPatios 
SectionFour  SectionFour 
SectionOne  SectionOne 
SectionThree  SectionThree 
SectionTwo  SectionTwo 

NewImprovementType Bound Attachments 
Name  Current Value 

NewImprovementType User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

NewImprovementType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NewImprovementTypeOtherDescription 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  NewImprovementTypeOtherDescription 
Logical Rolename   
ColumnName  NewImprovementTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to capture additional information when Other is selected for New Improvement Type. 
Note 
 

NewImprovementTypeOtherDescription Logical Attribute Properties 
Logical Attribute Name  NewImprovementTypeOtherDescription 
Datatype  VARCHAR(0) 
Nullable  NO 

NewImprovementTypeOtherDescription Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

NewImprovementTypeOtherDescription Bound Attachments 
Name  Current Value 

NewImprovementTypeOtherDescription User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

NewImprovementTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NewImprovementTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


PricePerSquareFootAmount 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  PricePerSquareFootAmount 
Logical Rolename   
ColumnName  PricePerSquareFootAmount 
RoleName   
Domain  MISMOAmount 
Definition  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) 
Note 
 

PricePerSquareFootAmount Logical Attribute Properties 
Logical Attribute Name  PricePerSquareFootAmount 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

PricePerSquareFootAmount Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

PricePerSquareFootAmount Bound Attachments 
Name  Current Value 

PricePerSquareFootAmount User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

PricePerSquareFootAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

PricePerSquareFootAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

PricePerSquareFootAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

PricePerSquareFootAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SquareFeetNumber 
Base Entity  NEW_IMPROVEMENT 
Attribute Name  SquareFeetNumber 
Logical Rolename   
ColumnName  SquareFeetNumber 
RoleName   
Domain  MISMONumeric 
Definition  Identifies the total area measured in square feet. 
Note 
 

SquareFeetNumber Logical Attribute Properties 
Logical Attribute Name  SquareFeetNumber 
Datatype  DECIMAL(0, 2) 
Nullable  NO 

SquareFeetNumber Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

SquareFeetNumber Bound Attachments 
Name  Current Value 

SquareFeetNumber User-Defined Mappings 
Model  Name  RoleName  Parent Entity  Datatype  Domain  Description 

SquareFeetNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SquareFeetNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SquareFeetNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SquareFeetNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description