| Equip Id |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Equip Id |
| Logical Rolename | |
| ColumnName | Equip Id |
| RoleName | |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
| Note |
| Equip Id Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | NO |
| 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 |
| Logical Diagnostics Equipment History 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 |
| Modify Date |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: The date the entity values were were created or modified. |
| Note |
| Modify Date Logical Attribute Properties |
| Logical Attribute Name | Modify Date |
| Datatype | DATE |
| Nullable | NO |
| Modify Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modify Date Security Types |
| Name | Current Value |
| Modify Date Bound Attachments |
| Name | Current Value |
| Modify Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modify Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Diagnostics Equipment History Modify Date |
NO |
| Modify Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equip Id |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Equip Id |
| Logical Rolename | Parent Equip Id |
| ColumnName | Parent Equip Id |
| RoleName | Parent Equip Id |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Equipment Identifier: The SNS barcode number used to uniquely identify equipment. |
| Note |
| Parent Equip Id Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | NO |
| Parent Equip Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Parent Equip Id Security Types |
| Name | Current Value |
| Parent Equip Id Bound Attachments |
| Name | Current Value |
| Parent Equip Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Parent Equip Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Diagnostics Equipment History Equip Id |
NO |
| Parent Equip Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equip Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equip Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equip Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Comment |
| Logical Rolename | |
| ColumnName | CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Comment Logical Attribute Properties |
| Logical Attribute Name | Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Comment Security Types |
| Name | Current Value |
| Comment Bound Attachments |
| Name | Current Value |
| Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Diagnostics Equipment History Comment |
NO |
| Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Hdw Ver Nbr |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Hdw Ver Nbr |
| Logical Rolename | |
| ColumnName | Hdw Ver Nbr |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Hardware Version Number: The hardware version number. |
| Note |
| Hdw Ver Nbr Logical Attribute Properties |
| Logical Attribute Name | Hdw Ver Nbr |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| 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 |
| Logical Diagnostics Equipment History 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 Entity | Diagnostics Equipment History |
| Attribute Name | Sftw Ver Nbr |
| Logical Rolename | |
| ColumnName | Sftw Ver Nbr |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Software Version Number: The version number of the software currently eecuting on the hardware. |
| Note |
| Sftw Ver Nbr Logical Attribute Properties |
| Logical Attribute Name | Sftw Ver Nbr |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| 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 |
| Logical Diagnostics Equipment History 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 Entity | Diagnostics Equipment History |
| Attribute Name | Note |
| Logical Rolename | |
| ColumnName | NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | |
| Note |
| Note Logical Attribute Properties |
| Logical Attribute Name | Note |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| 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 |
| Logical Diagnostics Equipment History 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 |
| Act Id |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Act Id |
| Logical Rolename | |
| ColumnName | Act Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Activity Identifer: A unique code assigned to the activity. |
| Note |
| Act Id Logical Attribute Properties |
| Logical Attribute Name | Act Id |
| Datatype | VARCHAR(5) |
| Nullable | NO |
| Act Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Act Id Security Types |
| Name | Current Value |
| Act Id Bound Attachments |
| Name | Current Value |
| Act Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Diagnostics Equipment History Act Id |
NO |
| Act Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number |
| Base Entity | Diagnostics Equipment History |
| Attribute Name | Modified By Badge Number |
| Logical Rolename | |
| ColumnName | MOD_BY_BN |
| RoleName | |
| Domain | Modied By Badge Number |
| Logical Only | NO |
| Definition | Modified by Badge Number: The ORNL badge number of the person who inserted or update a record in the table. |
| Note |
| Modified By Badge Number Logical Attribute Properties |
| Logical Attribute Name | Modified By Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Modified By Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modified By Badge Number Security Types |
| Name | Current Value |
| Modified By Badge Number Bound Attachments |
| Name | Current Value |
| Modified By Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modified By Badge Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Diagnostics Equipment History Modified By Badge Number |
NO |
| Modified By Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modified By Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |