ComponentAdjustmentAmount |
Base Entity | HEATING_SYSTEM |
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 |
SequenceNumber |
Base Entity | HEATING_SYSTEM |
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 |
ComponentClassificationType |
Base Entity | HEATING_SYSTEM |
Attribute Name | ComponentClassificationType |
Logical Rolename | |
ColumnName | ComponentClassificationType |
RoleName | |
Domain | ComponentClassificationEnum |
Definition | Specifies whether the component is considered real or personal property. |
Note |
ComponentClassificationType Logical Attribute Properties |
Logical Attribute Name | ComponentClassificationType |
Datatype | VARCHAR(0) |
Nullable | YES |
ComponentClassificationType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ComponentClassificationType Reference Value (Bound to Domain) |
Name | ValidationRule62 |
Description | |
Type | By List |
Value | Value Description |
PersonalProperty | PersonalProperty |
RealProperty | RealProperty |
ComponentClassificationType Bound Attachments |
Name | Current Value |
ComponentClassificationType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
ComponentClassificationType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComponentClassificationType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ComponentClassificationType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ComponentClassificationType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ConditionRatingDescription |
Base Entity | HEATING_SYSTEM |
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 | HEATING_SYSTEM |
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 |
HeatingFuelType |
Base Entity | HEATING_SYSTEM |
Attribute Name | HeatingFuelType |
Logical Rolename | |
ColumnName | HeatingFuelType |
RoleName | |
Domain | HeatingFuelEnum |
Definition | Indicates the type of fuel used by the heating system. |
Note |
HeatingFuelType Logical Attribute Properties |
Logical Attribute Name | HeatingFuelType |
Datatype | VARCHAR(0) |
Nullable | YES |
HeatingFuelType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HeatingFuelType Reference Value (Bound to Domain) |
Name | ValidationRule202 |
Description | |
Type | By List |
Value | Value Description |
Coal | Coal |
Electric | Electric |
Gas | Gas |
Other | Other |
Solar | Solar |
Wood | Wood |
HeatingFuelType Bound Attachments |
Name | Current Value |
HeatingFuelType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
HeatingFuelType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelTypeOtherDescription |
Base Entity | HEATING_SYSTEM |
Attribute Name | HeatingFuelTypeOtherDescription |
Logical Rolename | |
ColumnName | HeatingFuelTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | Free form description of fuel tuype if Type Other is selected. |
Note |
HeatingFuelTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | HeatingFuelTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
HeatingFuelTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HeatingFuelTypeOtherDescription Bound Attachments |
Name | Current Value |
HeatingFuelTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
HeatingFuelTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingFuelTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemDescription |
Base Entity | HEATING_SYSTEM |
Attribute Name | HeatingSystemDescription |
Logical Rolename | |
ColumnName | HeatingSystemDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe in detail the heating system identified by the heating system type. |
Note |
HeatingSystemDescription Logical Attribute Properties |
Logical Attribute Name | HeatingSystemDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
HeatingSystemDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HeatingSystemDescription Bound Attachments |
Name | Current Value |
HeatingSystemDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
HeatingSystemDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemPrimaryIndicator |
Base Entity | HEATING_SYSTEM |
Attribute Name | HeatingSystemPrimaryIndicator |
Logical Rolename | |
ColumnName | HeatingSystemPrimaryIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | Indicates that the heating system is the primary unit, not a secondary or additional system. |
Note |
HeatingSystemPrimaryIndicator Logical Attribute Properties |
Logical Attribute Name | HeatingSystemPrimaryIndicator |
Datatype | BIT |
Nullable | NO |
HeatingSystemPrimaryIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HeatingSystemPrimaryIndicator Bound Attachments |
Name | Current Value |
HeatingSystemPrimaryIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
HeatingSystemPrimaryIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemPrimaryIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemPrimaryIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemPrimaryIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemType |
Base Entity | HEATING_SYSTEM |
Attribute Name | HeatingSystemType |
Logical Rolename | |
ColumnName | HeatingSystemType |
RoleName | |
Domain | HeatingSystemEnum |
Definition | Specifies the type of heating |
Note |
HeatingSystemType Logical Attribute Properties |
Logical Attribute Name | HeatingSystemType |
Datatype | VARCHAR(0) |
Nullable | YES |
HeatingSystemType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HeatingSystemType Reference Value (Bound to Domain) |
Name | ValidationRule203 |
Description | |
Type | By List |
Value | Value Description |
ForcedWarmAir | ForcedWarmAir |
HotWaterBaseboard | HotWaterBaseboard |
Other | Other |
Radiant | Radiant |
HeatingSystemType Bound Attachments |
Name | Current Value |
HeatingSystemType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
HeatingSystemType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemTypeOtherDescription |
Base Entity | HEATING_SYSTEM |
Attribute Name | HeatingSystemTypeOtherDescription |
Logical Rolename | |
ColumnName | HeatingSystemTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Heating Type. |
Note |
HeatingSystemTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | HeatingSystemTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
HeatingSystemTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
HeatingSystemTypeOtherDescription Bound Attachments |
Name | Current Value |
HeatingSystemTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
HeatingSystemTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
HeatingSystemTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingDescription |
Base Entity | HEATING_SYSTEM |
Attribute Name | QualityRatingDescription |
Logical Rolename | |
ColumnName | QualityRatingDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe in detail the quality rating of the identified component. |
Note |
QualityRatingDescription Logical Attribute Properties |
Logical Attribute Name | QualityRatingDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
QualityRatingDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
QualityRatingDescription Bound Attachments |
Name | Current Value |
QualityRatingDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
QualityRatingDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingType |
Base Entity | HEATING_SYSTEM |
Attribute Name | QualityRatingType |
Logical Rolename | |
ColumnName | QualityRatingType |
RoleName | |
Domain | QualityRatingEnum |
Definition | A rating of the quality of the identified component type. |
Note |
QualityRatingType Logical Attribute Properties |
Logical Attribute Name | QualityRatingType |
Datatype | VARCHAR(0) |
Nullable | YES |
QualityRatingType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
QualityRatingType Reference Value (Bound to Domain) |
Name | ValidationRule63 |
Description | |
Type | By List |
Value | Value Description |
Average | Average |
Excellent | Excellent |
Fair | Fair |
Good | Good |
Poor | Poor |
QualityRatingType Bound Attachments |
Name | Current Value |
QualityRatingType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
QualityRatingType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SystemPermanentIndicator |
Base Entity | HEATING_SYSTEM |
Attribute Name | SystemPermanentIndicator |
Logical Rolename | |
ColumnName | SystemPermanentIndicator |
RoleName | |
Domain | MISMOIndicator |
Definition | When true indicates that the system specified is a permanent, attached system otherwise it is portable. |
Note |
SystemPermanentIndicator Logical Attribute Properties |
Logical Attribute Name | SystemPermanentIndicator |
Datatype | BIT |
Nullable | NO |
SystemPermanentIndicator Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SystemPermanentIndicator Bound Attachments |
Name | Current Value |
SystemPermanentIndicator User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
SystemPermanentIndicator Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SystemPermanentIndicator Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SystemPermanentIndicator Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SystemPermanentIndicator Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |