Equipment 
EntityType  Independent, Supertype 
Logical Entity Name  Equipment 
Default Table Name  EQUIP 
Logical Only  NO 
Owner  EQUIP 
Definition  
Equipment: The list of equipment currently at the SNS site.  Equipment includes items than may or may not be used in Devices (i.e. beam line).
 
Note 
 

Equipment Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Equip Id(PK)  Asset Identifier  VARCHAR(30)  NO  
Equipment Identifier: The SNS barcode number used to uniquely identify equipment.
 
Mnfctr Id(FK)    NUMERIC(4, 0)  NO  
Manufacturer Identifier: The unique identifier for the manufacturer.
 
Mdl Nbr(FK)    VARCHAR(75)  NO  
Model Number: The unique identifier for the manufacturer's model number.
 
Equip Nm  Name  VARCHAR(120)  YES  
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.
 
Operation Group Identifier(FK)  Operation Group  VARCHAR(10)  NO  
Equipment Category  Identifier: The unique identifier for a specific equipment category.
 
Equip Subcat Id(FK)    VARCHAR(10)  NO  
Equipment Subcategory Identifier:  The unique identifer for an equipment subcategory.
 
Equip Sub Subcat ID(FK)    VARCHAR(10)  NO  
Equipment Sub  Subcategory Identifier:  The unique identifer for an equipment sub subcategory.
 
Parent Equipment ID(FK)  Asset Identifier  VARCHAR(30)  YES  
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.
 
ORNL Prop Nbr    VARCHAR(7)  YES  
Oak Ridge National Laboratory Property Number:  A unique number assigned by ORNL to the equipment for tracking and inventory  purposes.
 
Drw Nbr  Default Text  VARCHAR(50)  YES  
Drawing Number: The number assigned to the drawing depicting the configuration of the equipment.
 
Ser Nbr  Default Text  VARCHAR(50)  NO  
Serial Number: The manufacturer serial number of the equipment.
 
Mnfctr Dte  Date  DATE  YES  
Manufacture Date: The day the item was created by the manufacturer.
 
Calib Rqd Ind  Indicator  CHAR(1)  NO  
Calibration Required Indicator:  When set to "Y" indicated the equipment requires calibration.   Default is "N"
 
Calib Freq Id(FK)    CHAR(2)  YES  
Calibration Frequency Identifier: The unique identifier for a calibration frequency.
 
Calib Method Id(FK)    CHAR(5)  YES  
Calibration Frequency Identifier:   Indicates the periodic interval a piece of equipment must be calibrated.
 
Last Calib Dte  Date  DATE  NO  
Last Calibration Date:  The date when the equipment was last calibrated.
 
Qual Grade Lvl    CHAR(1)  YES  
Quality Grade Level:  The quality grade level as defined in the Spallation Neutron Source Quality Assurance Plan: SNS-QA-P01
 
Note  Note  VARCHAR(4000)  YES  
Notes:  A free form text field used to describe a piece of equipment.
 
Lead Eng BN(FK)  Badge Number  VARCHAR(10)  YES  
Lead Engineer Badge Number: The ORNL badge number of the lead engineer responsible for the equipment.
 
Modify Date  Modify Date  DATE  NO  
Modify Date: The day and time the Equipment record was modified.
 
Mod By Uid  Mod By Uid  VARCHAR(64)  NO  
Modified By Userid: The userid of the person who  modified the equipment record.
 

Equipment Keys 
Key Name  Key Type  Keys 
equip_pk  PrimaryKey  Equip Id 
equip_type_rf  Inversion Entry  Operation Group Identifier 
parent_equip_rf  Inversion Entry  Parent Equipment ID 
mnfctr_mdl_rf  Inversion Entry  Mnfctr Id, Mdl Nbr 

Equipment Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Calibration Frequency  Non-Identifying  Zero or One to Zero or More        Calib Freq Id  NO 
Calibration Method  Non-Identifying  Zero or One to Zero or More        Calib Method Id  NO 
Equipment Sub Subcategory  Non-Identifying  One To Zero or More        Operation Group Identifier, Equip Subcat Id, Equip Sub Subcat ID  NO 
Equipment Subcategory  Non-Identifying  One To Zero or More        Operation Group Identifier, Equip Subcat Id  NO 
Lead Engineer  Non-Identifying  Zero or One to Zero or More        Lead Eng BN  NO 
Equipment Category  Non-Identifying  One To Zero or More    describes  is assigned to  Operation Group Identifier  NO 
Manufacturer Model  Non-Identifying  One To Zero or More        Mnfctr Id, Mdl Nbr  YES 
Equipment  Non-Identifying  Zero or One to Zero or More        Parent Equipment ID  YES 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Equipment Usage  Identifying  One To Zero or More          NO 
User Inst  Identifying  One To Zero or More          YES 
Magnet  Identifying  One To Zero or More          YES 
Radio Frequency Cavity  Identifying  One To Zero or More          NO 
Power Supply  Identifying  One To Zero or More          NO 
Diagnostics Equipment History  Identifying  One To Zero or More          NO 
Diagnostics Equipment History  Non-Identifying  One To Zero or More          NO 
Chipmunk  Identifying  One To Zero or More          NO 
Equipment Device Assignment  Identifying  One To Zero or More          NO 
Equipment Location  Identifying  One To Zero or More          NO 
Signal Record Equipment Assignment  Identifying  One To Zero or More          NO 
Equipment Status  Identifying  One To Zero or More          NO 
Equipment  Non-Identifying  One To Zero or More          NO 

Equipment Check Constraints 
Check Constraint Name  CheckConstraint 

Equipment Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
Equipment Security Types 
Name  Current Value 

Equipment Bound Attachments 
Name  Current Value 

Equipment Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
EQUIP.Equipment 		 NO       
ALARM_MYSQL (MySQL)
Does Not Exist 		 NO       
ALARM_ORACLE (Oracle)
Does Not Exist 		 NO       
BICS (Oracle)
Does Not Exist 		 NO       
BLM (Oracle)
Does Not Exist 		 NO       
BYPASS_REQ (Oracle)
Does Not Exist 		 NO       
CHAN_ARCH (Oracle)
Does Not Exist 		 NO       
CNMS_PRPSL (Oracle)
Does Not Exist 		 NO       
DIAG (Oracle)
Does Not Exist 		 NO       
DIAG_MPS (Oracle)
Does Not Exist 		 NO       
ENGA (Oracle)
Does Not Exist 		 NO       
EPICS (Oracle)
Does Not Exist 		 NO       
EQUIP (Oracle)
EQUIP 		 NO       
EXPRESS (Oracle)
Does Not Exist 		 NO       
ICS_SFTW_APPL (Oracle)
Does Not Exist 		 NO       
INSTR (Oracle)
Does Not Exist 		 NO       
Instrument Logbook (Oracle)
Does Not Exist 		 NO       
INVT (Oracle)
Does Not Exist 		 NO       
IONSRC (Oracle)
Does Not Exist 		 NO       
IONSRC1 (Oracle)
Does Not Exist 		 NO       
IPTSv5 (Oracle)
Does Not Exist 		 NO       
IRMISBase (Oracle)
Does Not Exist 		 NO       
Logbook (Oracle)
Does Not Exist 		 NO       
Magnet (Oracle)
Does Not Exist 		 NO       
MPS (Oracle)
Does Not Exist 		 NO       
NS_OPER (Oracle)
Does Not Exist 		 NO       
OPER (Oracle)
Does Not Exist 		 NO       
PART (Oracle)
Does Not Exist 		 NO       
PRINT (Oracle)
Does Not Exist 		 NO       
PROC (Oracle)
Does Not Exist 		 NO       
PRPSL (Oracle)
Does Not Exist 		 NO       
PUBL (Oracle)
Does Not Exist 		 NO       
PUBL_V1 (Oracle)
Does Not Exist 		 NO       
PV_LOGGER (Oracle)
Does Not Exist 		 NO       
SCORE (Oracle)
Does Not Exist 		 NO       
SICAT (Oracle)
Does Not Exist 		 NO       
SMPL (Oracle)
Does Not Exist 		 NO       
SMPLACT (Oracle)
Does Not Exist 		 NO       
SURVEY (Oracle)
Does Not Exist 		 NO       
Watchman (Oracle)
Does Not Exist 		 NO       
XAL_OPTICS (Oracle)
EQUIP 		 NO       
XF_ADMIN (Oracle)
Does Not Exist 		 NO       

Equipment Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  Equipment 
Logical  Equipment - Equip Rcpt 
Logical  Power Supply 
Logical  XAL Optics 
EQUIP (Oracle)  Main Model 
XAL_OPTICS (Oracle)  Main Model 

Equipment Data Movement Rules 
Name  Type  Rule Text/Value