| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Parent Equipment ID |
| Base Object | EQUIP |
| Attribute Name | Equip Id |
| ColumnName | Parent Equipment ID |
| Logical Rolename | Parent Equipment ID |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 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 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| 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 |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |
| MOD_DATE |
| Base Object | EQUIP |
| Attribute Name | Modify Date |
| ColumnName | MOD_DATE |
| Logical Rolename | |
| RoleName | |
| Domain | Modify Date |
| Physical Only | NO |
| Definition | Modify Date: The day and time the Equipment record was modified. |
| Note |
| MOD_DATE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MOD_DATE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| MOD_DATE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| MOD_DATE Security Types |
| Name | Current Value |
| MOD_DATE Bound Attachments |
| Name | Current Value |
| MOD_DATE Data Movement Rules |
| Name | Type | Rule Text/Value |
| MOD_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 |
| MOD_DATE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DATE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DATE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MOD_DATE 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 |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| 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 |