| Equip Id |
| Base Entity | Equipment |
| 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 Equipment Equip Id |
NO | ||
| EQUIP (Oracle) EQUIP EQUIP_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP 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 |
| Mnfctr Id |
| Base Entity | Equipment |
| Attribute Name | Mnfctr Id |
| Logical Rolename | |
| ColumnName | Mnfctr Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Manufacturer Identifier: The unique identifier for the manufacturer. |
| Note |
| Mnfctr Id Logical Attribute Properties |
| Logical Attribute Name | Mnfctr Id |
| Datatype | NUMERIC(4, 0) |
| Nullable | NO |
| Mnfctr Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Mnfctr Id Security Types |
| Name | Current Value |
| Mnfctr Id Bound Attachments |
| Name | Current Value |
| Mnfctr Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mnfctr Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Mnfctr Id |
NO | ||
| EQUIP (Oracle) EQUIP MNFCTR_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Mnfctr Id |
NO |
| Mnfctr Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl Nbr |
| Base Entity | Equipment |
| Attribute Name | Mdl Nbr |
| Logical Rolename | |
| ColumnName | Mdl Nbr |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Model Number: The unique identifier for the manufacturer's model number. |
| Note |
| Mdl Nbr Logical Attribute Properties |
| Logical Attribute Name | Mdl Nbr |
| Datatype | VARCHAR(75) |
| Nullable | NO |
| Mdl Nbr Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Mdl Nbr Security Types |
| Name | Current Value |
| Mdl Nbr Bound Attachments |
| Name | Current Value |
| Mdl Nbr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mdl Nbr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Mdl Nbr |
NO | ||
| EQUIP (Oracle) EQUIP MDL_NBR |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Mdl Nbr |
NO |
| Mdl Nbr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl Nbr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl Nbr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mdl Nbr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Nm |
| Base Entity | Equipment |
| Attribute Name | Equip Nm |
| Logical Rolename | |
| ColumnName | Equip Nm |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Equipment Name: The name associated with the piece of equipment. If a manufacturer model name is available this field will automatically be populated with the model name. The user may select a "standard" equipment name from the "equipment name" table. |
| Note |
| Equip Nm Logical Attribute Properties |
| Logical Attribute Name | Equip Nm |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Equip Nm Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Equip Nm Security Types |
| Name | Current Value |
| Equip Nm Bound Attachments |
| Name | Current Value |
| Equip Nm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Nm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Equip Nm |
NO | ||
| EQUIP (Oracle) EQUIP EQUIP_NM |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Equip Nm |
NO |
| Equip Nm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Nm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Nm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Nm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier |
| Base Entity | Equipment |
| Attribute Name | Operation Group Identifier |
| Logical Rolename | |
| ColumnName | OPER_GRP_ID |
| RoleName | |
| Domain | Operation Group |
| Logical Only | NO |
| Definition | Equipment Category Identifier: The unique identifier for a specific equipment category. |
| Note |
| Operation Group Identifier Logical Attribute Properties |
| Logical Attribute Name | Operation Group Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Operation Group Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Operation Group Identifier Security Types |
| Name | Current Value |
| Operation Group Identifier Bound Attachments |
| Name | Current Value |
| Operation Group Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Operation Group Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Operation Group Identifier |
NO | ||
| EQUIP (Oracle) EQUIP EQUIP_CAT_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP OPER_GRP_ID |
NO |
| Operation Group Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Operation Group Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Subcat Id |
| Base Entity | Equipment |
| Attribute Name | Equip Subcat Id |
| Logical Rolename | |
| ColumnName | Equip Subcat Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
| Note |
| Equip Subcat Id Logical Attribute Properties |
| Logical Attribute Name | Equip Subcat Id |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Equip Subcat Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Equip Subcat Id Security Types |
| Name | Current Value |
| Equip Subcat Id Bound Attachments |
| Name | Current Value |
| Equip Subcat Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Subcat Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Equip Subcat Id |
NO | ||
| EQUIP (Oracle) EQUIP EQUIP_SUBCAT_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Equip Subcat Id |
NO |
| Equip Subcat Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Subcat Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Subcat Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Subcat Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Sub Subcat ID |
| Base Entity | Equipment |
| Attribute Name | Equip Sub Subcat ID |
| Logical Rolename | |
| ColumnName | Equip Sub Subcat ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Equipment Sub Subcategory Identifier: The unique identifer for an equipment sub subcategory. |
| Note |
| Equip Sub Subcat ID Logical Attribute Properties |
| Logical Attribute Name | Equip Sub Subcat ID |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Equip Sub Subcat ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Equip Sub Subcat ID Security Types |
| Name | Current Value |
| Equip Sub Subcat ID Bound Attachments |
| Name | Current Value |
| Equip Sub Subcat ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| Equip Sub Subcat ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Equip Sub Subcat ID |
NO | ||
| EQUIP (Oracle) EQUIP EQUIP_SUB_SUBCAT_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Equip Sub Subcat ID |
NO |
| Equip Sub Subcat ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Sub Subcat ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Sub Subcat ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Equip Sub Subcat ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equipment ID |
| Base Entity | Equipment |
| Attribute Name | Equip Id |
| Logical Rolename | Parent Equipment ID |
| ColumnName | Parent Equipment ID |
| RoleName | Parent Equipment ID |
| Domain | Asset Identifier |
| Logical Only | NO |
| Definition | Parent Equipment Identifier: If the current piece of equipment is a component of another piece of equipment, this field will contain the parent equipment identifier. |
| Note |
| Parent Equipment ID Logical Attribute Properties |
| Logical Attribute Name | Equip Id |
| Datatype | VARCHAR(30) |
| Nullable | YES |
| Parent Equipment ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Parent Equipment ID Security Types |
| Name | Current Value |
| Parent Equipment ID Bound Attachments |
| Name | Current Value |
| Parent Equipment ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| Parent Equipment ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Equip Id |
NO | ||
| EQUIP (Oracle) EQUIP EQUIP_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Parent Equipment ID |
NO |
| Parent Equipment ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equipment ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equipment ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Equipment ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Prop Nbr |
| Base Entity | Equipment |
| Attribute Name | ORNL Prop Nbr |
| Logical Rolename | |
| ColumnName | ORNL Prop Nbr |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Oak Ridge National Laboratory Property Number: A unique number assigned by ORNL to the equipment for tracking and inventory purposes. |
| Note |
| ORNL Prop Nbr Logical Attribute Properties |
| Logical Attribute Name | ORNL Prop Nbr |
| Datatype | VARCHAR(7) |
| Nullable | YES |
| ORNL Prop Nbr Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| ORNL Prop Nbr Security Types |
| Name | Current Value |
| ORNL Prop Nbr Bound Attachments |
| Name | Current Value |
| ORNL Prop Nbr Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL Prop Nbr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment ORNL Prop Nbr |
NO | ||
| EQUIP (Oracle) EQUIP ORNL_PROP_NBR |
NO | ||
| XAL_OPTICS (Oracle) EQUIP ORNL Prop Nbr |
NO |
| ORNL Prop Nbr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Prop Nbr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Prop Nbr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Prop Nbr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Nbr |
| Base Entity | Equipment |
| Attribute Name | Drw Nbr |
| Logical Rolename | |
| ColumnName | Drw Nbr |
| RoleName | |
| Domain | Default Text |
| Logical Only | NO |
| Definition | Drawing Number: The number assigned to the drawing depicting the configuration of the equipment. |
| Note |
| Drw Nbr Logical Attribute Properties |
| Logical Attribute Name | Drw Nbr |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| Drw Nbr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Drw Nbr Security Types |
| Name | Current Value |
| Drw Nbr Bound Attachments |
| Name | Current Value |
| Drw Nbr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Drw Nbr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Drw Nbr |
NO | ||
| EQUIP (Oracle) EQUIP DRW_NBR |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Drw Nbr |
NO |
| Drw Nbr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Nbr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Nbr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Nbr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ser Nbr |
| Base Entity | Equipment |
| Attribute Name | Ser Nbr |
| Logical Rolename | |
| ColumnName | Ser Nbr |
| RoleName | |
| Domain | Default Text |
| Logical Only | NO |
| Definition | Serial Number: The manufacturer serial number of the equipment. |
| Note |
| Ser Nbr Logical Attribute Properties |
| Logical Attribute Name | Ser Nbr |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Ser Nbr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Ser Nbr Security Types |
| Name | Current Value |
| Ser Nbr Bound Attachments |
| Name | Current Value |
| Ser Nbr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Ser Nbr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Ser Nbr |
NO | ||
| EQUIP (Oracle) EQUIP SER_NBR |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Ser Nbr |
NO |
| Ser Nbr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ser Nbr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ser Nbr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Ser Nbr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Dte |
| Base Entity | Equipment |
| Attribute Name | Mnfctr Dte |
| Logical Rolename | |
| ColumnName | Mnfctr Dte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Manufacture Date: The day the item was created by the manufacturer. |
| Note |
| Mnfctr Dte Logical Attribute Properties |
| Logical Attribute Name | Mnfctr Dte |
| Datatype | DATE |
| Nullable | YES |
| Mnfctr Dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Mnfctr Dte Security Types |
| Name | Current Value |
| Mnfctr Dte Bound Attachments |
| Name | Current Value |
| Mnfctr Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mnfctr Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Mnfctr Dte |
NO | ||
| EQUIP (Oracle) EQUIP MNFCTR_DTE |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Mnfctr Dte |
NO |
| Mnfctr Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mnfctr Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Rqd Ind |
| Base Entity | Equipment |
| Attribute Name | Calib Rqd Ind |
| Logical Rolename | |
| ColumnName | Calib Rqd Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Calibration Required Indicator: When set to "Y" indicated the equipment requires calibration. Default is "N" |
| Note |
| Calib Rqd Ind Logical Attribute Properties |
| Logical Attribute Name | Calib Rqd Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| Calib Rqd Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Calib Rqd 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 |
| Calib Rqd Ind Security Types |
| Name | Current Value |
| Calib Rqd Ind Bound Attachments |
| Name | Current Value |
| Calib Rqd Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Calib Rqd Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Calib Rqd Ind |
NO | ||
| EQUIP (Oracle) EQUIP CALIB_RQD_IND |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Calib Rqd Ind |
NO |
| Calib Rqd Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Rqd Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Rqd Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Rqd Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Freq Id |
| Base Entity | Equipment |
| Attribute Name | Calib Freq Id |
| Logical Rolename | |
| ColumnName | Calib Freq Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Calibration Frequency Identifier: The unique identifier for a calibration frequency. |
| Note |
| Calib Freq Id Logical Attribute Properties |
| Logical Attribute Name | Calib Freq Id |
| Datatype | CHAR(2) |
| Nullable | YES |
| Calib Freq Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Calib Freq Id Security Types |
| Name | Current Value |
| Calib Freq Id Bound Attachments |
| Name | Current Value |
| Calib Freq Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Calib Freq Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Calib Freq Id |
NO | ||
| EQUIP (Oracle) EQUIP CALIB_FREQ_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Calib Freq Id |
NO |
| Calib Freq Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Freq Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Freq Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Freq Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Method Id |
| Base Entity | Equipment |
| Attribute Name | Calib Method Id |
| Logical Rolename | |
| ColumnName | Calib Method Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Calibration Frequency Identifier: Indicates the periodic interval a piece of equipment must be calibrated. |
| Note |
| Calib Method Id Logical Attribute Properties |
| Logical Attribute Name | Calib Method Id |
| Datatype | CHAR(5) |
| Nullable | YES |
| Calib Method Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Calib Method Id Security Types |
| Name | Current Value |
| Calib Method Id Bound Attachments |
| Name | Current Value |
| Calib Method Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Calib Method Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Calib Method Id |
NO | ||
| EQUIP (Oracle) EQUIP CALIB_METHOD_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Calib Method Id |
NO |
| Calib Method Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Method Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Method Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Calib Method Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Calib Dte |
| Base Entity | Equipment |
| Attribute Name | Last Calib Dte |
| Logical Rolename | |
| ColumnName | Last Calib Dte |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Last Calibration Date: The date when the equipment was last calibrated. |
| Note |
| Last Calib Dte Logical Attribute Properties |
| Logical Attribute Name | Last Calib Dte |
| Datatype | DATE |
| Nullable | NO |
| Last Calib Dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Last Calib Dte Security Types |
| Name | Current Value |
| Last Calib Dte Bound Attachments |
| Name | Current Value |
| Last Calib Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Last Calib Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Last Calib Dte |
NO | ||
| EQUIP (Oracle) EQUIP LAST_CALIB_DTE |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Last Calib Dte |
NO |
| Last Calib Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Calib Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Calib Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Calib Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qual Grade Lvl |
| Base Entity | Equipment |
| Attribute Name | Qual Grade Lvl |
| Logical Rolename | |
| ColumnName | Qual Grade Lvl |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Quality Grade Level: The quality grade level as defined in the Spallation Neutron Source Quality Assurance Plan: SNS-QA-P01 |
| Note |
| Qual Grade Lvl Logical Attribute Properties |
| Logical Attribute Name | Qual Grade Lvl |
| Datatype | CHAR(1) |
| Nullable | YES |
| Qual Grade Lvl Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Qual Grade Lvl Security Types |
| Name | Current Value |
| Qual Grade Lvl Bound Attachments |
| Name | Current Value |
| Qual Grade Lvl Data Movement Rules |
| Name | Type | Rule Text/Value |
| Qual Grade Lvl Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Qual Grade Lvl |
NO | ||
| EQUIP (Oracle) EQUIP QUAL_GRADE_LVL |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Qual Grade Lvl |
NO |
| Qual Grade Lvl Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qual Grade Lvl Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qual Grade Lvl Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Qual Grade Lvl Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Note |
| Base Entity | Equipment |
| Attribute Name | Note |
| Logical Rolename | |
| ColumnName | NOTE |
| RoleName | |
| Domain | Note |
| Logical Only | NO |
| Definition | Notes: A free form text field used to describe a piece of equipment. |
| 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 Equipment Note |
NO | ||
| EQUIP (Oracle) EQUIP NOTE |
NO | ||
| XAL_OPTICS (Oracle) EQUIP 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 |
| Lead Eng BN |
| Base Entity | Equipment |
| Attribute Name | Lead Eng BN |
| Logical Rolename | |
| ColumnName | Lead Eng BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | Lead Engineer Badge Number: The ORNL badge number of the lead engineer responsible for the equipment. |
| Note |
| Lead Eng BN Logical Attribute Properties |
| Logical Attribute Name | Lead Eng BN |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Lead Eng BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Lead Eng BN Security Types |
| Name | Current Value |
| Lead Eng BN Bound Attachments |
| Name | Current Value |
| Lead Eng BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| Lead Eng BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Lead Eng BN |
NO | ||
| EQUIP (Oracle) EQUIP LEAD_ENG_BN |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Lead Eng BN |
NO |
| Lead Eng BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lead Eng BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lead Eng BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Lead Eng BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Equipment |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: The day and time the Equipment record was 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 Equipment Modify Date |
NO | ||
| EQUIP (Oracle) EQUIP MOD_DTE |
NO | ||
| XAL_OPTICS (Oracle) EQUIP MOD_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 |
| Mod By Uid |
| Base Entity | Equipment |
| Attribute Name | Mod By Uid |
| Logical Rolename | |
| ColumnName | Mod By Uid |
| RoleName | |
| Domain | Mod By Uid |
| Logical Only | NO |
| Definition | Modified By Userid: The userid of the person who modified the equipment record. |
| Note |
| Mod By Uid Logical Attribute Properties |
| Logical Attribute Name | Mod By Uid |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| Mod By Uid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mod By Uid Security Types |
| Name | Current Value |
| Mod By Uid Bound Attachments |
| Name | Current Value |
| Mod By Uid Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mod By Uid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Equipment Mod By Uid |
NO | ||
| EQUIP (Oracle) EQUIP MOD_BY_UID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Mod By Uid |
NO |
| Mod By Uid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |