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 |