| EQUIP_ID |
| Base Object | DIAG_EQUIP_HIST |
| 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) DIAG_EQUIP_HIST 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 |
| MOD_DTE |
| Base Object | DIAG_EQUIP_HIST |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Modify Date |
| Physical Only | NO |
| Definition | Modify Date: The date the entity values were were created or modified. |
| Note |
| MOD_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| MOD_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| MOD_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_DTE Security Types |
| Name | Current Value |
| MOD_DTE Bound Attachments |
| Name | Current Value |
| MOD_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) DIAG_EQUIP_HIST MOD_DTE |
NO |
| MOD_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT |
| Base Object | DIAG_EQUIP_HIST |
| Attribute Name | Comment |
| ColumnName | CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| Note |
| CMNT Column Properties |
| Datatype | VARCHAR2(2000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| CMNT Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2000 |
| Percent Null | 0 |
| CMNT Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| CMNT Security Types |
| Name | Current Value |
| CMNT Bound Attachments |
| Name | Current Value |
| CMNT Data Movement Rules |
| Name | Type | Rule Text/Value |
| CMNT Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) DIAG_EQUIP_HIST CMNT |
NO |
| CMNT Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| CMNT Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HDW_VER_NBR |
| Base Object | DIAG_EQUIP_HIST |
| Attribute Name | Hdw Ver Nbr |
| ColumnName | HDW_VER_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Hardware Version Number: The hardware version number. |
| Note |
| HDW_VER_NBR Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| HDW_VER_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| HDW_VER_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| HDW_VER_NBR Security Types |
| Name | Current Value |
| HDW_VER_NBR Bound Attachments |
| Name | Current Value |
| HDW_VER_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| HDW_VER_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) DIAG_EQUIP_HIST HDW_VER_NBR |
NO |
| HDW_VER_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HDW_VER_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| HDW_VER_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| HDW_VER_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_VER_NBR |
| Base Object | DIAG_EQUIP_HIST |
| Attribute Name | Sftw Ver Nbr |
| ColumnName | SFTW_VER_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Software Version Number: The version number of the software currently eecuting on the hardware. |
| Note |
| SFTW_VER_NBR Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| SFTW_VER_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| SFTW_VER_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| SFTW_VER_NBR Security Types |
| Name | Current Value |
| SFTW_VER_NBR Bound Attachments |
| Name | Current Value |
| SFTW_VER_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| SFTW_VER_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) DIAG_EQUIP_HIST SFTW_VER_NBR |
NO |
| SFTW_VER_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_VER_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_VER_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SFTW_VER_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE |
| Base Object | DIAG_EQUIP_HIST |
| Attribute Name | Note |
| ColumnName | NOTE |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | |
| Note |
| NOTE Column Properties |
| Datatype | VARCHAR2(4000) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| NOTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4000 |
| Percent Null | 0 |
| NOTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| NOTE Security Types |
| Name | Current Value |
| NOTE Bound Attachments |
| Name | Current Value |
| NOTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| NOTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) DIAG_EQUIP_HIST NOTE |
NO |
| NOTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| NOTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN |
| Base Object | DIAG_EQUIP_HIST |
| Attribute Name | Modified By Badge Number |
| ColumnName | MOD_BY_BN |
| Logical Rolename | |
| RoleName | |
| Domain | Modied By Badge Number |
| Physical Only | NO |
| Definition | Modified by Badge Number: The ORNL badge number of the person who inserted or update a record in the table. |
| Note |
| MOD_BY_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| MOD_BY_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 6 |
| Percent Null | 0 |
| MOD_BY_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_BY_BN Security Types |
| Name | Current Value |
| MOD_BY_BN Bound Attachments |
| Name | Current Value |
| MOD_BY_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_BY_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| EQUIP (Oracle) DIAG_EQUIP_HIST MOD_BY_BN |
NO |
| MOD_BY_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_BY_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |