ComponentAdjustmentAmount |
Base Entity | WINDOW |
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 | WINDOW |
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 |
ConditionRatingDescription |
Base Entity | WINDOW |
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 | WINDOW |
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 |
MaterialDescription |
Base Entity | WINDOW |
Attribute Name | MaterialDescription |
Logical Rolename | |
ColumnName | MaterialDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe in detail the material used in the identified component. |
Note |
MaterialDescription Logical Attribute Properties |
Logical Attribute Name | MaterialDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
MaterialDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MaterialDescription Bound Attachments |
Name | Current Value |
MaterialDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
MaterialDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MaterialDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MaterialDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MaterialDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
QualityRatingDescription |
Base Entity | WINDOW |
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 | WINDOW |
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 |
WindowDescription |
Base Entity | WINDOW |
Attribute Name | WindowDescription |
Logical Rolename | |
ColumnName | WindowDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to describe in detail the identified window type. |
Note |
WindowDescription Logical Attribute Properties |
Logical Attribute Name | WindowDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
WindowDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WindowDescription Bound Attachments |
Name | Current Value |
WindowDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
WindowDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindowDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindowDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindowDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindowType |
Base Entity | WINDOW |
Attribute Name | WindowType |
Logical Rolename | |
ColumnName | WindowType |
RoleName | |
Domain | WindowEnum |
Definition | Specifies the type of windows on the property. |
Note |
WindowType Logical Attribute Properties |
Logical Attribute Name | WindowType |
Datatype | VARCHAR(0) |
Nullable | YES |
WindowType Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WindowType Reference Value (Bound to Domain) |
Name | ValidationRule500 |
Description | |
Type | By List |
Value | Value Description |
Aluminum | Aluminum |
Awning | Awning |
BayWindow | BayWindow |
BeveledGlass | BeveledGlass |
BowWindow | BowWindow |
Casement | Casement |
CenterPivot | CenterPivot |
CircleHead | CircleHead |
Clerestory | Clerestory |
Combination | Combination |
CrankOut | CrankOut |
Decorative | Decorative |
Dormer | Dormer |
DoubleHung | DoubleHung |
DoublePane | DoublePane |
EtchedGlass | EtchedGlass |
FixedPane | FixedPane |
French | French |
Hopper | Hopper |
HorizontalSliding | HorizontalSliding |
Insulated | Insulated |
Jalousie | Jalousie |
LeadedGlass | LeadedGlass |
LowE | LowE |
Oriel | Oriel |
Other | Other |
Palladian | Palladian |
Picture | Picture |
SingleHung | SingleHung |
Sliding | Sliding |
StainedGlass | StainedGlass |
Steel | Steel |
ThermalPane | ThermalPane |
TheromPane | TheromPane |
Transom | Transom |
Transverse | Transverse |
Vinyl | Vinyl |
Wood | Wood |
WindowType Bound Attachments |
Name | Current Value |
WindowType User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
WindowType Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindowType Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindowType Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindowType Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindowTypeOtherDescription |
Base Entity | WINDOW |
Attribute Name | WindowTypeOtherDescription |
Logical Rolename | |
ColumnName | WindowTypeOtherDescription |
RoleName | |
Domain | MISMOString |
Definition | A free form text field used to collect additional information when Other is selected for Window Type. |
Note |
WindowTypeOtherDescription Logical Attribute Properties |
Logical Attribute Name | WindowTypeOtherDescription |
Datatype | VARCHAR(0) |
Nullable | NO |
WindowTypeOtherDescription Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WindowTypeOtherDescription Bound Attachments |
Name | Current Value |
WindowTypeOtherDescription User-Defined Mappings |
Model | Name | RoleName | Parent Entity | Datatype | Domain | Description |
WindowTypeOtherDescription Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindowTypeOtherDescription Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WindowTypeOtherDescription Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WindowTypeOtherDescription Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |