Equip Rcpt Id |
Base Entity | Equipment Receipt |
Attribute Name | Equip Rcpt Id |
Logical Rolename | |
ColumnName | Equip Rcpt Id |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Equipment Receipt Identifier: A unique number generated by the system for a specific receipt event. |
Note |
Equip Rcpt Id Logical Attribute Properties |
Logical Attribute Name | Equip Rcpt Id |
Datatype | INTEGER |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Equip Rcpt Ver |
Logical Rolename | |
ColumnName | Equip Rcpt Ver |
RoleName | |
Domain | |
Logical 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 Logical Attribute Properties |
Logical Attribute Name | Equip Rcpt Ver |
Datatype | INTEGER |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Carrier Id |
Logical Rolename | |
ColumnName | Carrier Id |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Carrier Identifier: The unique identifier for the carrier. |
Note |
Carrier Id Logical Attribute Properties |
Logical Attribute Name | Carrier Id |
Datatype | VARCHAR(10) |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Rcpt Dte |
Logical Rolename | |
ColumnName | Rcpt Dte |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Receipt Date: The day the equipment was physically received. |
Note |
Rcpt Dte Logical Attribute Properties |
Logical Attribute Name | Rcpt Dte |
Datatype | DATE |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Rpt Dte |
Logical Rolename | |
ColumnName | Rpt Dte |
RoleName | |
Domain | Date |
Logical 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 Logical Attribute Properties |
Logical Attribute Name | Rpt Dte |
Datatype | DATE |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Waybill |
Logical Rolename | |
ColumnName | Waybill |
RoleName | |
Domain | Default Text |
Logical Only | NO |
Definition | Way Bill Number: The carrier's tracking number for the shipment of equipment. |
Note |
Waybill Logical Attribute Properties |
Logical Attribute Name | Waybill |
Datatype | VARCHAR(50) |
Nullable | YES |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Pieces Rcvd |
Logical Rolename | |
ColumnName | Pieces Rcvd |
RoleName | |
Domain | Quantity |
Logical 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 Logical Attribute Properties |
Logical Attribute Name | Pieces Rcvd |
Datatype | INTEGER |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | PO Nbr |
Logical Rolename | |
ColumnName | PO Nbr |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Purchase Order Number: The number created by the laboratory to authorize and track the equipment order. |
Note |
PO Nbr Logical Attribute Properties |
Logical Attribute Name | PO Nbr |
Datatype | VARCHAR(50) |
Nullable | YES |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Rcpt Desc |
Logical Rolename | |
ColumnName | Rcpt Desc |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Receipt Description: A free form text field used to store comments regarding the receipt. |
Note |
Rcpt Desc Logical Attribute Properties |
Logical Attribute Name | Rcpt Desc |
Datatype | VARCHAR(255) |
Nullable | YES |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Lab Id |
Logical Rolename | |
ColumnName | Lab Id |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Laboratory Identifier: The unique identifier for a laboratory. |
Note |
Lab Id Logical Attribute Properties |
Logical Attribute Name | Lab Id |
Datatype | VARCHAR(10) |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Rcvd By BN |
Logical Rolename | |
ColumnName | Rcvd By BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | Received By Badge Number: The badge number of the authorized receiving agent. |
Note |
Rcvd By BN Logical Attribute Properties |
Logical Attribute Name | Rcvd By BN |
Datatype | VARCHAR(10) |
Nullable | NO |
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 |
Logical Equipment Receipt 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 Entity | Equipment Receipt |
Attribute Name | Lead Eng BN |
Logical Rolename | |
ColumnName | Lead Eng BN |
RoleName | |
Domain | Badge Number |
Logical Only | NO |
Definition | Lead Engineer Badge Number: The ORNL badge number assigned to the lead engineer. |
Note |
Lead Eng BN Logical Attribute Properties |
Logical Attribute Name | Lead Eng BN |
Datatype | VARCHAR(10) |
Nullable | NO |
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 |
Logical Equipment Receipt 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 |
Modify Date |
Base Entity | Equipment Receipt |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DATE |
RoleName | |
Domain | Modify Date |
Logical Only | NO |
Definition | Modify Date: The date the Equipment Receipt record was modified. |
Note |
Modify Date Logical Attribute Properties |
Logical Attribute Name | Modify Date |
Datatype | DATE |
Nullable | NO |
Modify Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Modify Date Security Types |
Name | Current Value |
Modify Date Bound Attachments |
Name | Current Value |
Modify Date Data Movement Rules |
Name | Type | Rule Text/Value |
Modify Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Equipment Receipt Modify Date |
NO |
Modify Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Mod By Uid |
Base Entity | Equipment Receipt |
Attribute Name | Mod By Uid |
Logical Rolename | |
ColumnName | Mod By Uid |
RoleName | |
Domain | Userid |
Logical Only | NO |
Definition | Modified By Userid: The userid of the person who last changed the Equipment Receipt record. |
Note |
Mod By Uid Logical Attribute Properties |
Logical Attribute Name | Mod By Uid |
Datatype | VARCHAR(64) |
Nullable | NO |
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 Receipt 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 |