BLDG_ID |
Base Object | BLDG |
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 Bldg Id |
NO | ||
EQUIP (Oracle) BLDG 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 |
BLDG_NM |
Base Object | BLDG |
Attribute Name | Bldg Nm |
ColumnName | BLDG_NM |
Logical Rolename | |
RoleName | |
Domain | Name |
Physical Only | NO |
Definition | Building Name: The name of the building within the SNS Facility |
Note |
BLDG_NM Column Properties |
Datatype | VARCHAR2(120) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
BLDG_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 120 |
Percent Null | 0 |
BLDG_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BLDG_NM Security Types |
Name | Current Value |
BLDG_NM Bound Attachments |
Name | Current Value |
BLDG_NM Data Movement Rules |
Name | Type | Rule Text/Value |
BLDG_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Building Bldg Nm |
NO | ||
EQUIP (Oracle) BLDG BLDG_NM |
NO |
BLDG_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ABBRV_CODE |
Base Object | BLDG |
Attribute Name | Bldg Abbrv Code |
ColumnName | BLDG_ABBRV_CODE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Building Abbreviation Code: A two character abbreviation for the building. |
Note |
BLDG_ABBRV_CODE Column Properties |
Datatype | CHAR(2) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
BLDG_ABBRV_CODE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2 |
Percent Null | 0 |
BLDG_ABBRV_CODE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BLDG_ABBRV_CODE Security Types |
Name | Current Value |
BLDG_ABBRV_CODE Bound Attachments |
Name | Current Value |
BLDG_ABBRV_CODE Data Movement Rules |
Name | Type | Rule Text/Value |
BLDG_ABBRV_CODE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Building Bldg Abbrv Code |
NO | ||
EQUIP (Oracle) BLDG BLDG_ABBRV_CODE |
NO |
BLDG_ABBRV_CODE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ABBRV_CODE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ABBRV_CODE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ABBRV_CODE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |