BLDG_ID |
Base Object | BLDG_SUBAREA |
Attribute Name | Bldg Id |
ColumnName | BLDG_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Building Code: The unique identifier for a building. |
Note |
BLDG_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
BLDG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
BLDG_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BLDG_ID Security Types |
Name | Current Value |
BLDG_ID Bound Attachments |
Name | Current Value |
BLDG_ID Data Movement Rules |
Name | Type | Rule Text/Value |
BLDG_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Building Subarea Bldg Id |
NO | ||
EQUIP (Oracle) BLDG_SUBAREA BLDG_ID |
NO |
BLDG_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
AREA_ID |
Base Object | BLDG_SUBAREA |
Attribute Name | Area Id |
ColumnName | AREA_ID |
Logical Rolename | |
RoleName | |
Domain | Default Text |
Physical Only | NO |
Definition | Area Identifier: The unique identifier for a location within a building. |
Note |
AREA_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
AREA_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
AREA_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
AREA_ID Security Types |
Name | Current Value |
AREA_ID Bound Attachments |
Name | Current Value |
AREA_ID Data Movement Rules |
Name | Type | Rule Text/Value |
AREA_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Building Subarea Area Id |
NO | ||
EQUIP (Oracle) BLDG_SUBAREA AREA_ID |
NO |
AREA_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
AREA_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
AREA_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
AREA_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBAREA_ID |
Base Object | BLDG_SUBAREA |
Attribute Name | Subarea Id |
ColumnName | SUBAREA_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Building Subarea: An location within an area. |
Note |
SUBAREA_ID Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
SUBAREA_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
SUBAREA_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SUBAREA_ID Security Types |
Name | Current Value |
SUBAREA_ID Bound Attachments |
Name | Current Value |
SUBAREA_ID Data Movement Rules |
Name | Type | Rule Text/Value |
SUBAREA_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Building Subarea Subarea Id |
NO | ||
EQUIP (Oracle) BLDG_SUBAREA SUBAREA_ID |
NO |
SUBAREA_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBAREA_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SUBAREA_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SUBAREA_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |