AboveGradeIndicator 
Base Entity  ROOM_DETAIL 
Attribute Name  AboveGradeIndicator 
Logical Rolename   
ColumnName  AboveGradeIndicator 
RoleName   
Domain  MISMOIndicator 
Definition  Indicates the room is above grade and can be included in GLA. 
Note 
 

AboveGradeIndicator Logical Attribute Properties 
Logical Attribute Name  AboveGradeIndicator 
Datatype  BIT 
Nullable  NO 

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

AboveGradeIndicator Bound Attachments 
Name  Current Value 

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

AboveGradeIndicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AboveGradeIndicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AboveGradeIndicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AboveGradeIndicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ComponentAdjustmentAmount 
Base Entity  ROOM_DETAIL 
Attribute Name  ComponentAdjustmentAmount 
Logical Rolename   
ColumnName  ComponentAdjustmentAmount 
RoleName   
Domain  MISMOAmount 
Definition  The dollar amount (either positive or negative) adjustment being made for a specific component of the property. 
Note 
 

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

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

ComponentAdjustmentAmount Bound Attachments 
Name  Current Value 

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

ComponentAdjustmentAmount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComponentAdjustmentAmount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ComponentAdjustmentAmount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ComponentAdjustmentAmount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConditionRatingDescription 
Base Entity  ROOM_DETAIL 
Attribute Name  ConditionRatingDescription 
Logical Rolename   
ColumnName  ConditionRatingDescription 
RoleName   
Domain  MISMOString 
Definition  A free form text field used to describe in detail the condition rating of the identified component. 
Note 
 

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

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

ConditionRatingDescription Bound Attachments 
Name  Current Value 

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

ConditionRatingDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConditionRatingDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConditionRatingDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConditionRatingDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ConditionRatingType 
Base Entity  ROOM_DETAIL 
Attribute Name  ConditionRatingType 
Logical Rolename   
ColumnName  ConditionRatingType 
RoleName   
Domain  ConditionRatingEnum 
Definition  A rating of the quality of the identified component.  
Note 
 

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

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

ConditionRatingType Reference Value (Bound to Domain) 
Name  ValidationRule63 
Description   
Type  By List 
Value  Value Description 
Average  Average 
Excellent  Excellent 
Fair  Fair 
Good  Good 
Poor  Poor 

ConditionRatingType Bound Attachments 
Name  Current Value 

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

ConditionRatingType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConditionRatingType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ConditionRatingType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ConditionRatingType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LengthFeetNumber 
Base Entity  ROOM_DETAIL 
Attribute Name  LengthFeetNumber 
Logical Rolename   
ColumnName  LengthFeetNumber 
RoleName   
Domain  MISMONumeric 
Definition  The length measured in linear feet. 
Note 
 

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

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

LengthFeetNumber Bound Attachments 
Name  Current Value 

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

LengthFeetNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LengthFeetNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LengthFeetNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LengthFeetNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LevelType 
Base Entity  ROOM_DETAIL 
Attribute Name  LevelType 
Logical Rolename   
ColumnName  LevelType 
RoleName   
Domain  LevelEnum 
Definition  Specifies a particular level in the improvement of a property.  
Note 
 

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

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

LevelType Reference Value (Bound to Domain) 
Name  ValidationRule247 
Description   
Type  By List 
Value  Value Description 
Attic  Attic 
Basement  Basement 
LevelFive  LevelFive 
LevelFour  LevelFour 
LevelOne  LevelOne 
LevelThree  LevelThree 
LevelTwo  LevelTwo 
Other  Other 

LevelType Bound Attachments 
Name  Current Value 

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

LevelType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LevelType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LevelType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LevelType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


LevelTypeOtherDescription 
Base Entity  ROOM_DETAIL 
Attribute Name  LevelTypeOtherDescription 
Logical Rolename   
ColumnName  LevelTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe the level if Other is selected as the Level Type. 
Note 
 

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

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

LevelTypeOtherDescription Bound Attachments 
Name  Current Value 

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

LevelTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

LevelTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

LevelTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

LevelTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RoomType 
Base Entity  ROOM_DETAIL 
Attribute Name  RoomType 
Logical Rolename   
ColumnName  RoomType 
RoleName   
Domain  RoomEnum 
Definition  Specifies a type of room normally found in a living unit or residence .  
Note 
 

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

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

RoomType Reference Value (Bound to Domain) 
Name  ValidationRule435 
Description   
Type  By List 
Value  Value Description 
Bedroom  Bedroom 
BonusRoom  BonusRoom 
Den  Den 
DiningRoom  DiningRoom 
EnsuiteFullBath  EnsuiteFullBath 
ExcersizeRoom  ExcersizeRoom 
FamilyRoom  FamilyRoom 
Foyer  Foyer 
FullBathroom  FullBathroom 
GameRoom  GameRoom 
GreatRoom  GreatRoom 
HalfBath  HalfBath 
Kitchen  Kitchen 
Laundry  Laundry 
Library  Library 
LivingRoom  LivingRoom 
MasterBedroom  MasterBedroom 
MediaRoom  MediaRoom 
Office  Office 
Other  Other 
RecreationRoom  RecreationRoom 
UtilityRoom  UtilityRoom 
Workshop  Workshop 

RoomType Bound Attachments 
Name  Current Value 

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

RoomType Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RoomType Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RoomType Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RoomType Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RoomTypeOtherDescription 
Base Entity  ROOM_DETAIL 
Attribute Name  RoomTypeOtherDescription 
Logical Rolename   
ColumnName  RoomTypeOtherDescription 
RoleName   
Domain  MISMOString 
Definition  A free-form text field used to describe the room if Other is selected as the Room Type. 
Note 
 

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

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

RoomTypeOtherDescription Bound Attachments 
Name  Current Value 

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

RoomTypeOtherDescription Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RoomTypeOtherDescription Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RoomTypeOtherDescription Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RoomTypeOtherDescription Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RoomTypeSummaryCount 
Base Entity  ROOM_DETAIL 
Attribute Name  RoomTypeSummaryCount 
Logical Rolename   
ColumnName  RoomTypeSummaryCount 
RoleName   
Domain  MISMOCount 
Definition  Indicates the number of rooms of the type specified Room Type. (e.g. 2 dinning rooms, 3 bedrooms, etc. ) 
Note 
 

RoomTypeSummaryCount Logical Attribute Properties 
Logical Attribute Name  RoomTypeSummaryCount 
Datatype  INTEGER 
Nullable  NO 

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

RoomTypeSummaryCount Bound Attachments 
Name  Current Value 

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

RoomTypeSummaryCount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RoomTypeSummaryCount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RoomTypeSummaryCount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RoomTypeSummaryCount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SquareFeetNumber 
Base Entity  ROOM_DETAIL 
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 


WidthFeetNumber 
Base Entity  ROOM_DETAIL 
Attribute Name  WidthFeetNumber 
Logical Rolename   
ColumnName  WidthFeetNumber 
RoleName   
Domain  MISMONumeric 
Definition  The width measured in linear feet. 
Note 
 

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

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

WidthFeetNumber Bound Attachments 
Name  Current Value 

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

WidthFeetNumber Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

WidthFeetNumber Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

WidthFeetNumber Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

WidthFeetNumber Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description