| EQUIP_ID |
| Base Object | EQUIP_USAGE |
| Attribute Name | Equip Id |
| ColumnName | EQUIP_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Asset Identifier |
| Physical Only | NO |
| Definition | Equipment Identifier: The SNS barcode number used to uniquely identify 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_USAGE 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 |
| USAGE_STRT_DTE |
| Base Object | EQUIP_USAGE |
| Attribute Name | Usage Strt Dte |
| ColumnName | USAGE_STRT_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Datetime |
| Physical Only | NO |
| Definition | Usage Start Date: The date and time when the equipment was first assigned to an employee for use. |
| Note |
| USAGE_STRT_DTE Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | NO |
| Not Null Constraint | |
| Time Zone | NO |
| USAGE_STRT_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| USAGE_STRT_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USAGE_STRT_DTE Security Types |
| Name | Current Value |
| USAGE_STRT_DTE Bound Attachments |
| Name | Current Value |
| USAGE_STRT_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| USAGE_STRT_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_USAGE USAGE_STRT_DTE |
NO |
| USAGE_STRT_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_STRT_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_STRT_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_STRT_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN |
| Base Object | EQUIP_USAGE |
| Attribute Name | BN |
| ColumnName | BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | Employee Badge Number. |
| Note |
| BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| BN Security Types |
| Name | Current Value |
| BN Bound Attachments |
| Name | Current Value |
| BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_USAGE BN |
NO |
| BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_END_DTE |
| Base Object | EQUIP_USAGE |
| Attribute Name | Usage End Dte |
| ColumnName | USAGE_END_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Datetime |
| Physical Only | NO |
| Definition | Usage End Date: The date and time when the equipment was no longer used by an employee. |
| Note |
| USAGE_END_DTE Column Properties |
| Datatype | TIMESTAMP(6) |
| Nullable | YES |
| Not Null Constraint | |
| Time Zone | NO |
| USAGE_END_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| USAGE_END_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| USAGE_END_DTE Security Types |
| Name | Current Value |
| USAGE_END_DTE Bound Attachments |
| Name | Current Value |
| USAGE_END_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| USAGE_END_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) EQUIP_USAGE USAGE_END_DTE |
NO |
| USAGE_END_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_END_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_END_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| USAGE_END_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |