| EQUIP_ID |
| Base Object | EQUIP_LOC |
| Attribute Name | Equip Id |
| ColumnName | EQUIP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Asset Identifier |
| Physical Only | NO |
| Definition | Equipment Identifier: The unique identifier for the equipment. |
| Note |
| EQUIP_ID Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| EQUIP_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 11 |
| Percent Null | 0 |
| EQUIP_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EQUIP_ID Security Types |
| Name | Current Value |
| EQUIP_ID Bound Attachments |
| Name | Current Value |
| EQUIP_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EQUIP_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_LOC EQUIP_ID |
NO |
| EQUIP_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BDTE |
| Base Object | EQUIP_LOC |
| Attribute Name | Bdte |
| ColumnName | BDTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Begin Date: The date the equipment was originally stored in the building location. |
| Note |
| BDTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| BDTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| BDTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| BDTE Security Types |
| Name | Current Value |
| BDTE Bound Attachments |
| Name | Current Value |
| BDTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| BDTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_LOC BDTE |
NO |
| BDTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BDTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BDTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BDTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PPS_IND |
| Base Object | EQUIP_LOC |
| Attribute Name | PPS Ind |
| ColumnName | PPS_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Personal Protection System Indicator: Indicates whether the equipment was purchased for use in the Personal Protection System. |
| Note |
| PPS_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| PPS_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| PPS_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| PPS_IND Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| PPS_IND Security Types |
| Name | Current Value |
| PPS_IND Bound Attachments |
| Name | Current Value |
| PPS_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| PPS_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_LOC PPS_IND |
NO |
| PPS_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PPS_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PPS_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PPS_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EDTE |
| Base Object | EQUIP_LOC |
| Attribute Name | Edte |
| ColumnName | EDTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | End Date: The day the equipment was moved from it's current building location. |
| Note |
| EDTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| EDTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| EDTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| EDTE Security Types |
| Name | Current Value |
| EDTE Bound Attachments |
| Name | Current Value |
| EDTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| EDTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_LOC EDTE |
NO |
| EDTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EDTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EDTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EDTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| AREA_ID |
| Base Object | EQUIP_LOC |
| Attribute Name | Area Id |
| ColumnName | AREA_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Default Text |
| Physical Only | NO |
| Definition | Area Identifier: The unique identifier for the building area. |
| 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 |
| EQUIP (Oracle) EQUIP_LOC 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 |
| BLDG_ID |
| Base Object | EQUIP_LOC |
| 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 |
| EQUIP (Oracle) EQUIP_LOC 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 |