EQUIP_RCPT 
Logical Entity Name  Equip Rcpt 
Default Table Name  EQUIP_RCPT 
Oracle Temporary Table  NO 
Physical Only  NO 
Do Not Generate  False 
Owner   
Definition  
Equipment Receipt:  Contains information relating to the receipt of equipment into the SNS facility.
 
Note 
 
PreSQL   
DDL Code  CREATE TABLE EQUIP_RCPT(
     EQUIP_RCPT_ID      NUMBER(38, 0)     NOT NULL,
     EQUIP_RCPT_VER     NUMBER(38, 0)     NOT NULL,
     CARRIER_ID         VARCHAR2(10)      NOT NULL,
     RCPT_DTE           DATE              DEFAULT sysdate NOT NULL,
     RPT_DTE            DATE              DEFAULT sysdate NOT NULL,
     WAYBILL            VARCHAR2(50),
     PIECES_RCVD        NUMBER(38, 0)     DEFAULT 1 NOT NULL,
     PO_NBR             VARCHAR2(50),
     RCPT_DESC          VARCHAR2(255),
     LAB_ID             VARCHAR2(10)      NOT NULL,
     RCVD_BY_BN         VARCHAR2(10)      NOT NULL,
     LEAD_ENG_BN        VARCHAR2(10)      NOT NULL,
     MOD_DTE            DATE              NOT NULL,
     MOD_BY_UID         VARCHAR2(64)      NOT NULL,
     CONSTRAINT EQUP_RCPT_PK PRIMARY KEY (EQUIP_RCPT_ID, EQUIP_RCPT_VER)
     USING INDEX
         PCTFREE 10
         INITRANS 2
         MAXTRANS 255
         TABLESPACE EQUIP_INDEX_TS
         LOGGING
         STORAGE(INITIAL 64K
                 NEXT 64K
                 MINEXTENTS 1
                 MAXEXTENTS UNLIMITED
                 PCTINCREASE 0
                 ),
     CONSTRAINT CARRIER_RCPT_RF FOREIGN KEY (CARRIER_ID)
     REFERENCES CARRIER(CARRIER_ID),
     CONSTRAINT EQUP_RCPT_RCVD_BY_RF FOREIGN KEY (RCVD_BY_BN)
     REFERENCES RCVD_BY(RCVD_BY_BN),
     CONSTRAINT EQUP_RCPT_LAB_RF FOREIGN KEY (LAB_ID)
     REFERENCES LAB(LAB_ID),
     CONSTRAINT EQUP_RCPT_LEAD_ENG_RF FOREIGN KEY (LEAD_ENG_BN)
     REFERENCES LEAD_ENG(LEAD_ENG_BN)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EQUIP_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
         NEXT 64K
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         )
NOCACHE
NOCOMPRESS
;
 
PostSQL   

EQUIP_RCPT Columns 
ColumnName  Domain  Datatype  NULL  Definition 
EQUIP_RCPT_ID(PK)    NUMBER(38, 0)  NO  
Equipment Receipt Identifier: A unique number generated by the system for a specific receipt event.
 
EQUIP_RCPT_VER(PK)    NUMBER(38, 0)  NO  
Equipment Receipt Version: A numeric number representing the number of modification made to the equipment receipt information.  The default value is "0"
 
CARRIER_ID(FK)    VARCHAR2(10)  NO  
Carrier Identifier: The unique identifier for the carrier.
 
RCPT_DTE  Date  DATE  NO  
Receipt Date: The day the equipment was physically received.
 
RPT_DTE  Date  DATE  NO  
Report Date: The date the receipt information was entered into the system.  The date may be different (greater than) the date the equipment was actually received.  The system shall automatically populate this field when a new record receipt is recorded.  For revisions the date remains the same as the original.
 
WAYBILL  Default Text  VARCHAR2(50)  YES  
Way Bill Number: The carrier's tracking number for the shipment of equipment.
 
PIECES_RCVD  Quantity  NUMBER(38, 0)  NO  
Pieces Received: Contain the number of boxes delivered by the carrier and received into the RATS facility.  The receipt identifier bar code is applied to each box.
 
PO_NBR    VARCHAR2(50)  YES  
Purchase Order Number: The number created by the laboratory to authorize and track the equipment order.
 
RCPT_DESC  Description  VARCHAR2(255)  YES  
Receipt Description: A free form text field used to store comments regarding the receipt.
 
LAB_ID(FK)    VARCHAR2(10)  NO  
Laboratory Identifier: The unique identifier for a laboratory.
 
RCVD_BY_BN(FK)  Badge Number  VARCHAR2(10)  NO  
Received By Badge Number:  The badge number of the authorized receiving agent.
 
LEAD_ENG_BN(FK)  Badge Number  VARCHAR2(10)  NO  
Lead Engineer Badge Number: The ORNL badge number assigned to the lead engineer.
 
MOD_DTE  Modify Date  DATE  NO  
Modify Date: The date the Equipment Receipt record was modified.
 
MOD_BY_UID  Userid  VARCHAR2(64)  NO  
Modified By Userid: The userid of the person who last changed the Equipment Receipt record.
 

EQUIP_RCPT Primary and Unique Keys 
Key Name  Key Type  Keys 
EQUP_RCPT_PK  PrimaryKey  EQUIP_RCPT_ID, EQUIP_RCPT_VER 

EQUIP_RCPT Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Deferrable  Initially Deferred 
CARRIER  Non-Identifying  One To Zero or More  CARRIER_RCPT_RF  is involved in  requries  CARRIER_ID  NO  NO  NO 
LAB  Non-Identifying  One To Zero or More  EQUP_RCPT_LAB_RF      LAB_ID  NO  NO  NO 
LEAD_ENG  Non-Identifying  One To Zero or More  EQUP_RCPT_LEAD_ENG_RF      LEAD_ENG_BN  NO  NO  NO 
RCVD_BY  Non-Identifying  One To Zero or More  EQUP_RCPT_RCVD_BY_RF      RCVD_BY_BN  NO  NO  NO 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Deferrable  Initially Deferred 
RCPT_ITEM  Identifying  One to One or More  EQUIP_RCPT_ITEM_RF        NO  NO  NO 

EQUIP_RCPT Check Constraints 
Check Constraint Name  CheckConstraint 

EQUIP_RCPT Storage 
STORAGE OPTION  STORAGE VALUE 
TABLESPACE  EQUIP_TS 
PctFree  10 
PCTUSED   40 
MinExtents  1 
MaxExtents  2147483645 
Initial  64 
Next  64 
PctIncrease  0 
InitTrans  1 
MaxTrans  255 
Organization  Heap 
Cache  NO 
Logging   
Parallel  NO 
Parallel Degrees   
Parallel Instances   
FREELISTS   
FREELIST GROUPS   
Buffer Pool   
Table Compression  NO 
Row Movement  Disabled 

EQUIP_RCPT Partitions 
PARTITION PROPERTY  PARTITION PROPERTY VALUE 

EQUIP_RCPT Growth Metrics 
TABLE METRIC  TABLE METRIC VALUE 
Current Row Count  0 
Growth  Static 
Growth Type  N/A 
Growth Period  N/A 
Maximum Rows  0 

EQUIP_RCPT Object Permissions 

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

EQUIP_RCPT Bound Attachments 
Name  Current Value 

EQUIP_RCPT Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
Does Not Exist 		 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_RCPT 		 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)
Does Not Exist 		 NO       
XF_ADMIN (Oracle)
Does Not Exist 		 NO       

EQUIP_RCPT Where Used - Submodel Usage 
Model  Submodel Usage 
EQUIP (Oracle)  Main Model 

EQUIP_RCPT Data Movement Rules 
Name  Type  Rule Text/Value