EQUIP_RCPT_ID |
Base Object | EQUIP_RCPT |
Attribute Name | Equip Rcpt Id |
ColumnName | EQUIP_RCPT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Equipment Receipt Identifier: A unique number generated by the system for a specific receipt event. |
Note |
EQUIP_RCPT_ID Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
EQUIP_RCPT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
EQUIP_RCPT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EQUIP_RCPT_ID Security Types |
Name | Current Value |
EQUIP_RCPT_ID Bound Attachments |
Name | Current Value |
EQUIP_RCPT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
EQUIP_RCPT_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT EQUIP_RCPT_ID |
NO |
EQUIP_RCPT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_VER |
Base Object | EQUIP_RCPT |
Attribute Name | Equip Rcpt Ver |
ColumnName | EQUIP_RCPT_VER |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Equipment Receipt Version: A numeric number representing the number of modification made to the equipment receipt information. The default value is "0" |
Note |
EQUIP_RCPT_VER Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
EQUIP_RCPT_VER Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
EQUIP_RCPT_VER Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EQUIP_RCPT_VER Security Types |
Name | Current Value |
EQUIP_RCPT_VER Bound Attachments |
Name | Current Value |
EQUIP_RCPT_VER Data Movement Rules |
Name | Type | Rule Text/Value |
EQUIP_RCPT_VER Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT EQUIP_RCPT_VER |
NO |
EQUIP_RCPT_VER Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_VER Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_VER Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EQUIP_RCPT_VER Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
CARRIER_ID |
Base Object | EQUIP_RCPT |
Attribute Name | Carrier Id |
ColumnName | CARRIER_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Carrier Identifier: The unique identifier for the carrier. |
Note |
CARRIER_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
CARRIER_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
CARRIER_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
CARRIER_ID Security Types |
Name | Current Value |
CARRIER_ID Bound Attachments |
Name | Current Value |
CARRIER_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CARRIER_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT CARRIER_ID |
NO |
CARRIER_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CARRIER_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CARRIER_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CARRIER_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DTE |
Base Object | EQUIP_RCPT |
Attribute Name | Rcpt Dte |
ColumnName | RCPT_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | Receipt Date: The day the equipment was physically received. |
Note |
RCPT_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
RCPT_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RCPT_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
RCPT_DTE Security Types |
Name | Current Value |
RCPT_DTE Bound Attachments |
Name | Current Value |
RCPT_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
RCPT_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT RCPT_DTE |
NO |
RCPT_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RPT_DTE |
Base Object | EQUIP_RCPT |
Attribute Name | Rpt Dte |
ColumnName | RPT_DTE |
Logical Rolename | |
RoleName | |
Domain | Date |
Physical Only | NO |
Definition | 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. |
Note |
RPT_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
RPT_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RPT_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
RPT_DTE Security Types |
Name | Current Value |
RPT_DTE Bound Attachments |
Name | Current Value |
RPT_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
RPT_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT RPT_DTE |
NO |
RPT_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RPT_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RPT_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RPT_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
WAYBILL |
Base Object | EQUIP_RCPT |
Attribute Name | Waybill |
ColumnName | WAYBILL |
Logical Rolename | |
RoleName | |
Domain | Default Text |
Physical Only | NO |
Definition | Way Bill Number: The carrier's tracking number for the shipment of equipment. |
Note |
WAYBILL Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
WAYBILL Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
WAYBILL Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
WAYBILL Security Types |
Name | Current Value |
WAYBILL Bound Attachments |
Name | Current Value |
WAYBILL Data Movement Rules |
Name | Type | Rule Text/Value |
WAYBILL Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT WAYBILL |
NO |
WAYBILL Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
WAYBILL Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
WAYBILL Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
WAYBILL Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PIECES_RCVD |
Base Object | EQUIP_RCPT |
Attribute Name | Pieces Rcvd |
ColumnName | PIECES_RCVD |
Logical Rolename | |
RoleName | |
Domain | Quantity |
Physical Only | NO |
Definition | 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. |
Note |
PIECES_RCVD Column Properties |
Datatype | NUMBER(38, 0) |
Nullable | NO |
PIECES_RCVD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
PIECES_RCVD Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 1 |
Bound Default |
PIECES_RCVD Security Types |
Name | Current Value |
PIECES_RCVD Bound Attachments |
Name | Current Value |
PIECES_RCVD Data Movement Rules |
Name | Type | Rule Text/Value |
PIECES_RCVD Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT PIECES_RCVD |
NO |
PIECES_RCVD Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PIECES_RCVD Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PIECES_RCVD Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PIECES_RCVD Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PO_NBR |
Base Object | EQUIP_RCPT |
Attribute Name | PO Nbr |
ColumnName | PO_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Purchase Order Number: The number created by the laboratory to authorize and track the equipment order. |
Note |
PO_NBR Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
PO_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
PO_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PO_NBR Security Types |
Name | Current Value |
PO_NBR Bound Attachments |
Name | Current Value |
PO_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
PO_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT PO_NBR |
NO |
PO_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PO_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PO_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PO_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DESC |
Base Object | EQUIP_RCPT |
Attribute Name | Rcpt Desc |
ColumnName | RCPT_DESC |
Logical Rolename | |
RoleName | |
Domain | Description |
Physical Only | NO |
Definition | Receipt Description: A free form text field used to store comments regarding the receipt. |
Note |
RCPT_DESC Column Properties |
Datatype | VARCHAR2(255) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
RCPT_DESC Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 255 |
Percent Null | 0 |
RCPT_DESC Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RCPT_DESC Security Types |
Name | Current Value |
RCPT_DESC Bound Attachments |
Name | Current Value |
RCPT_DESC Data Movement Rules |
Name | Type | Rule Text/Value |
RCPT_DESC Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT RCPT_DESC |
NO |
RCPT_DESC Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DESC Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DESC Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RCPT_DESC Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAB_ID |
Base Object | EQUIP_RCPT |
Attribute Name | Lab Id |
ColumnName | LAB_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Laboratory Identifier: The unique identifier for a laboratory. |
Note |
LAB_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
LAB_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
LAB_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
LAB_ID Security Types |
Name | Current Value |
LAB_ID Bound Attachments |
Name | Current Value |
LAB_ID Data Movement Rules |
Name | Type | Rule Text/Value |
LAB_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT LAB_ID |
NO |
LAB_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAB_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
LAB_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
LAB_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RCVD_BY_BN |
Base Object | EQUIP_RCPT |
Attribute Name | Rcvd By BN |
ColumnName | RCVD_BY_BN |
Logical Rolename | |
RoleName | |
Domain | Badge Number |
Physical Only | NO |
Definition | Received By Badge Number: The badge number of the authorized receiving agent. |
Note |
RCVD_BY_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
RCVD_BY_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
RCVD_BY_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RCVD_BY_BN Security Types |
Name | Current Value |
RCVD_BY_BN Bound Attachments |
Name | Current Value |
RCVD_BY_BN Data Movement Rules |
Name | Type | Rule Text/Value |
RCVD_BY_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
EQUIP (Oracle) EQUIP_RCPT RCVD_BY_BN |
NO |
RCVD_BY_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RCVD_BY_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RCVD_BY_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RCVD_BY_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
LEAD_ENG_BN |
Base Object | EQUIP_RCPT |
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 assigned to the lead engineer. |
Note |
LEAD_ENG_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
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 |
EQUIP (Oracle) EQUIP_RCPT 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_RCPT |
Attribute Name | Modify Date |
ColumnName | MOD_DTE |
Logical Rolename | |
RoleName | |
Domain | Modify Date |
Physical Only | NO |
Definition | Modify Date: The date the Equipment Receipt 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 |
EQUIP (Oracle) EQUIP_RCPT MOD_DTE |
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_RCPT |
Attribute Name | Mod By Uid |
ColumnName | MOD_BY_UID |
Logical Rolename | |
RoleName | |
Domain | Userid |
Physical Only | NO |
Definition | Modified By Userid: The userid of the person who last changed the Equipment Receipt 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 |
EQUIP (Oracle) EQUIP_RCPT 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 |