Equipment Receipt |
EntityType | Independent |
Logical Entity Name | Equipment Receipt |
Default Table Name | Equip_Rcpt |
Logical Only | NO |
Owner | EQUIP |
Definition | Equipment Receipt: Contains information relating to the receipt of equipment into the SNS facility. |
Note |
Equipment Receipt Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Equip Rcpt Id | INTEGER | NO | Equipment Receipt Identifier: A unique number generated by the system for a specific receipt event. |
|
Equip Rcpt Ver | INTEGER | 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 | VARCHAR(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 | VARCHAR(50) | YES | Way Bill Number: The carrier's tracking number for the shipment of equipment. |
Pieces Rcvd | Quantity | INTEGER | 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 | VARCHAR(50) | YES | Purchase Order Number: The number created by the laboratory to authorize and track the equipment order. |
|
Rcpt Desc | Description | VARCHAR(255) | YES | Receipt Description: A free form text field used to store comments regarding the receipt. |
Lab Id | VARCHAR(10) | NO | Laboratory Identifier: The unique identifier for a laboratory. |
|
Rcvd By BN | Badge Number | VARCHAR(10) | NO | Received By Badge Number: The badge number of the authorized receiving agent. |
Lead Eng BN | Badge Number | VARCHAR(10) | NO | Lead Engineer Badge Number: The ORNL badge number assigned to the lead engineer. |
Modify Date | Modify Date | DATE | NO | Modify Date: The date the Equipment Receipt record was modified. |
Mod By Uid | Userid | VARCHAR(64) | NO | Modified By Userid: The userid of the person who last changed the Equipment Receipt record. |
Equipment Receipt Keys |
Key Name | Key Type | Keys |
equp_rcpt_pk | PrimaryKey | Equip Rcpt Id, Equip Rcpt Ver |
carrier_rcpt_rf | Inversion Entry | Carrier Id |
Equipment Receipt Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Carrier | Non-Identifying | One To Zero or More | is involved in | requries | Carrier Id | NO | |
Laboratory | Non-Identifying | One To Zero or More | Lab Id | NO | |||
Lead Engineer | Non-Identifying | One To Zero or More | Lead Eng BN | NO | |||
Received By | Non-Identifying | One To Zero or More | Rcvd By BN | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Receipt Item | Identifying | One to One or More | NO |
Equipment Receipt Check Constraints |
Check Constraint Name | CheckConstraint |
Equipment Receipt Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Equipment Receipt Security Types |
Name | Current Value |
Equipment Receipt Bound Attachments |
Name | Current Value |
Equipment Receipt Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical EQUIP.Equipment Receipt |
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) Does Not Exist |
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 |
Equipment Receipt Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Equipment |
Logical | Equipment - Equip Rcpt |
Equipment Receipt Data Movement Rules |
Name | Type | Rule Text/Value |