| EQUIP_ID |
| Base Object | EQUIP |
| 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 |
| 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 Object | EQUIP |
| Attribute Name | Mnfctr Id |
| ColumnName | MNFCTR_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Manufacturer Identifier: The unique identifier for the manufacturer. |
| Note |
| MNFCTR_ID Column Properties |
| Datatype | NUMBER(4, 0) |
| Nullable | NO |
| MNFCTR_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Mdl Nbr |
| ColumnName | MDL_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Model Number: The unique identifier for the manufacturer's model number. |
| Note |
| MDL_NBR Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| MDL_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Equip Nm |
| ColumnName | EQUIP_NM |
| Logical Rolename | |
| RoleName | |
| Domain | Name |
| Physical 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 Column Properties |
| Datatype | VARCHAR2(120) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| EQUIP_NM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 120 |
| Percent Null | 0 |
| 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 |
| EQUIP_CAT_ID |
| Base Object | EQUIP |
| Attribute Name | Operation Group Identifier |
| ColumnName | EQUIP_CAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Operation Group |
| Physical Only | NO |
| Definition | Equipment Category Identifier: The unique identifier for a specific equipment category. |
| Note |
| EQUIP_CAT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| EQUIP_CAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| EQUIP_CAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| EQUIP_CAT_ID Security Types |
| Name | Current Value |
| EQUIP_CAT_ID Bound Attachments |
| Name | Current Value |
| EQUIP_CAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| EQUIP_CAT_ID 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 EQUIP_CAT_ID |
NO |
| EQUIP_CAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_CAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_CAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_CAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EQUIP_SUBCAT_ID |
| Base Object | EQUIP |
| Attribute Name | Equip Subcat Id |
| ColumnName | EQUIP_SUBCAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Equipment Subcategory Identifier: The unique identifer for an equipment subcategory. |
| Note |
| EQUIP_SUBCAT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| EQUIP_SUBCAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Equip Sub Subcat ID |
| ColumnName | EQUIP_SUB_SUBCAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Equipment Sub Subcategory Identifier: The unique identifer for an equipment sub subcategory. |
| Note |
| EQUIP_SUB_SUBCAT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| EQUIP_SUB_SUBCAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Equip Id |
| ColumnName | PARENT_EQUIPMENT_ID |
| Logical Rolename | |
| RoleName | PARENT_EQUIPMENT_ID |
| Domain | Asset Identifier |
| Physical 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 Column Properties |
| Datatype | VARCHAR2(30) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| PARENT_EQUIPMENT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 11 |
| Percent Null | 0 |
| 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 PARENT_EQUIPMENT_ID |
NO | ||
| XAL_OPTICS (Oracle) EQUIP Equip 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 Object | EQUIP |
| Attribute Name | ORNL Prop Nbr |
| ColumnName | ORNL_PROP_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | VARCHAR2(7) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| ORNL_PROP_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Drw Nbr |
| ColumnName | DRW_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Default Text |
| Physical Only | NO |
| Definition | Drawing Number: The number assigned to the drawing depicting the configuration of the equipment. |
| Note |
| DRW_NBR Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| DRW_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Ser Nbr |
| ColumnName | SER_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | Default Text |
| Physical Only | NO |
| Definition | Serial Number: The manufacturer serial number of the equipment. |
| Note |
| SER_NBR Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| SER_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Mnfctr Dte |
| ColumnName | MNFCTR_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Manufacture Date: The day the item was created by the manufacturer. |
| Note |
| MNFCTR_DTE Column Properties |
| Datatype | DATE |
| Nullable | YES |
| MNFCTR_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Calib Rqd Ind |
| ColumnName | CALIB_RQD_IND |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Calibration Required Indicator: When set to "Y" indicated the equipment requires calibration. Default is "N" |
| Note |
| CALIB_RQD_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| CALIB_RQD_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Calib Freq Id |
| ColumnName | CALIB_FREQ_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Calibration Frequency Identifier: The unique identifier for a calibration frequency. |
| Note |
| CALIB_FREQ_ID Column Properties |
| Datatype | CHAR(2) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| CALIB_FREQ_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 2 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Calib Method Id |
| ColumnName | CALIB_METHOD_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Calibration Frequency Identifier: Indicates the periodic interval a piece of equipment must be calibrated. |
| Note |
| CALIB_METHOD_ID Column Properties |
| Datatype | CHAR(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| CALIB_METHOD_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Last Calib Dte |
| ColumnName | LAST_CALIB_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Last Calibration Date: The date when the equipment was last calibrated. |
| Note |
| LAST_CALIB_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| LAST_CALIB_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Qual Grade Lvl |
| ColumnName | QUAL_GRADE_LVL |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| QUAL_GRADE_LVL Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| 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 Object | EQUIP |
| Attribute Name | Note |
| ColumnName | NOTE |
| Logical Rolename | |
| RoleName | |
| Domain | Note |
| Physical Only | NO |
| Definition | Notes: A free form text field used to describe a piece of equipment. |
| 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 |
| 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 Object | EQUIP |
| Attribute Name | Lead Eng BN |
| ColumnName | LEAD_ENG_BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | Lead Engineer Badge Number: The ORNL badge number of the lead engineer responsible for the equipment. |
| Note |
| LEAD_ENG_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| LEAD_ENG_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| 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 |
| MOD_DTE |
| Base Object | EQUIP |
| Attribute Name | Modify Date |
| ColumnName | MOD_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Modify Date |
| Physical Only | NO |
| Definition | Modify Date: The day and time the Equipment record was 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 |
| Logical Equipment Modify Date |
NO | ||
| EQUIP (Oracle) EQUIP MOD_DTE |
NO | ||
| XAL_OPTICS (Oracle) EQUIP MOD_DATE |
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 |
| MOD_BY_UID |
| Base Object | EQUIP |
| Attribute Name | Mod By Uid |
| ColumnName | MOD_BY_UID |
| Logical Rolename | |
| RoleName | |
| Domain | Mod By Uid |
| Physical Only | NO |
| Definition | Modified By Userid: The userid of the person who modified the equipment record. |
| Note |
| MOD_BY_UID Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| MOD_BY_UID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| 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 |