EQUIP_RCPT_ID 
Base Object  RCPT_ITEM 
Attribute Name  Equip Rcpt Id 
ColumnName  EQUIP_RCPT_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Equipment Receipt Identifier:  The unique identifier for an equipment receipt transaction.
 
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 

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)
RCPT_ITEM
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  RCPT_ITEM 
Attribute Name  Equip Rcpt Ver 
ColumnName  EQUIP_RCPT_VER 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Equipment Receipt Version: Indicates the version of the equipment receipt.  If a  receipt is changed the original information is saved and a new version is created.
 
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 

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)
RCPT_ITEM
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 


RCPT_ITEM_ID 
Base Object  RCPT_ITEM 
Attribute Name  Rcpt Item Id 
ColumnName  RCPT_ITEM_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Receipt Item Identifier: A numeric field used to represent each line item within a receipt.  A line item exists for each type of equipment received. The system automatically generates this number and increments it by 1 for each line item for a given receipt.
 
Note 
 

RCPT_ITEM_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 

RCPT_ITEM_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

RCPT_ITEM_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

RCPT_ITEM_ID Security Types 
Name  Current Value 

RCPT_ITEM_ID Bound Attachments 
Name  Current Value 

RCPT_ITEM_ID Data Movement Rules 
Name  Type  Rule Text/Value 

RCPT_ITEM_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
RCPT_ITEM_ID 
NO     

RCPT_ITEM_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RCPT_ITEM_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RCPT_ITEM_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RCPT_ITEM_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ITEM_DESC 
Base Object  RCPT_ITEM 
Attribute Name  Item Desc 
ColumnName  ITEM_DESC 
Logical Rolename   
RoleName   
Domain  Description 
Physical Only  NO 
Definition 
Item Description: A free form text field used identify the item received.
 
Note 
 

ITEM_DESC Column Properties 
Datatype  VARCHAR2(255) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

ITEM_DESC Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  255 
Percent Null 

ITEM_DESC Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ITEM_DESC Security Types 
Name  Current Value 

ITEM_DESC Bound Attachments 
Name  Current Value 

ITEM_DESC Data Movement Rules 
Name  Type  Rule Text/Value 

ITEM_DESC Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
ITEM_DESC 
NO     

ITEM_DESC Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ITEM_DESC Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ITEM_DESC Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ITEM_DESC Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


QTY_RCVD 
Base Object  RCPT_ITEM 
Attribute Name  Qty Rcvd 
ColumnName  QTY_RCVD 
Logical Rolename   
RoleName   
Domain  Quantity 
Physical Only  NO 
Definition 
Quantity Received: The number of units received for a specific item.
 
Note 
 

QTY_RCVD Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 

QTY_RCVD Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

QTY_RCVD Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default 
Bound Default   

QTY_RCVD Security Types 
Name  Current Value 

QTY_RCVD Bound Attachments 
Name  Current Value 

QTY_RCVD Data Movement Rules 
Name  Type  Rule Text/Value 

QTY_RCVD Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
QTY_RCVD 
NO     

QTY_RCVD Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

QTY_RCVD Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

QTY_RCVD Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

QTY_RCVD Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


QTY_REJECT 
Base Object  RCPT_ITEM 
Attribute Name  Qty Reject 
ColumnName  QTY_REJECT 
Logical Rolename   
RoleName   
Domain  Quantity Rejected 
Physical Only  NO 
Definition 
Quantity Rejected: The number of units for a particular item that were rejected.  The default value is 0.
 
Note 
 

QTY_REJECT Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 

QTY_REJECT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  20 
Percent Null 

QTY_REJECT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default 
Bound Default   

QTY_REJECT Security Types 
Name  Current Value 

QTY_REJECT Bound Attachments 
Name  Current Value 

QTY_REJECT Data Movement Rules 
Name  Type  Rule Text/Value 

QTY_REJECT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
QTY_REJECT 
NO     

QTY_REJECT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

QTY_REJECT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

QTY_REJECT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

QTY_REJECT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ACCPT_TEST_REQ_IND 
Base Object  RCPT_ITEM 
Attribute Name  Accpt Test Req Ind 
ColumnName  ACCPT_TEST_REQ_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Acceptance Test Required Indicator: Used to indicate if an acceptance test must be performed on the item received. Valid values include "Y" and "N."  Default value is "N."
 
Note 
 

ACCPT_TEST_REQ_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

ACCPT_TEST_REQ_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

ACCPT_TEST_REQ_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

ACCPT_TEST_REQ_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

ACCPT_TEST_REQ_IND Security Types 
Name  Current Value 

ACCPT_TEST_REQ_IND Bound Attachments 
Name  Current Value 

ACCPT_TEST_REQ_IND Data Movement Rules 
Name  Type  Rule Text/Value 

ACCPT_TEST_REQ_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
ACCPT_TEST_REQ_IND 
NO     

ACCPT_TEST_REQ_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACCPT_TEST_REQ_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ACCPT_TEST_REQ_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ACCPT_TEST_REQ_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TEST_INSPECT_STAT 
Base Object  RCPT_ITEM 
Attribute Name  Test Inspect Stat 
ColumnName  TEST_INSPECT_STAT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Test Inspection Status: Used to document whether the item inspected passed or failed the inspection.  Valid values include "pass" and "fail."
 
Note 
 

TEST_INSPECT_STAT Column Properties 
Datatype  CHAR(4) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

TEST_INSPECT_STAT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

TEST_INSPECT_STAT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

TEST_INSPECT_STAT Security Types 
Name  Current Value 

TEST_INSPECT_STAT Bound Attachments 
Name  Current Value 

TEST_INSPECT_STAT Data Movement Rules 
Name  Type  Rule Text/Value 

TEST_INSPECT_STAT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
TEST_INSPECT_STAT 
NO     

TEST_INSPECT_STAT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TEST_INSPECT_STAT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TEST_INSPECT_STAT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TEST_INSPECT_STAT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


CERT_RCVD_IND 
Base Object  RCPT_ITEM 
Attribute Name  Cert Rcvd Ind 
ColumnName  CERT_RCVD_IND 
Logical Rolename   
RoleName   
Domain  Indicator 
Physical Only  NO 
Definition 
Certification Received Indicator: Used to document if certification papers associated with the item received were received.  Valid values are "Y' and "N."  Default value is "Y."
 
Note 
 

CERT_RCVD_IND Column Properties 
Datatype  CHAR(1) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

CERT_RCVD_IND Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

CERT_RCVD_IND Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

CERT_RCVD_IND Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

CERT_RCVD_IND Security Types 
Name  Current Value 

CERT_RCVD_IND Bound Attachments 
Name  Current Value 

CERT_RCVD_IND Data Movement Rules 
Name  Type  Rule Text/Value 

CERT_RCVD_IND Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
CERT_RCVD_IND 
NO     

CERT_RCVD_IND Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CERT_RCVD_IND Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CERT_RCVD_IND Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CERT_RCVD_IND Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ITEM_CMNT 
Base Object  RCPT_ITEM 
Attribute Name  Item Cmnt 
ColumnName  ITEM_CMNT 
Logical Rolename   
RoleName   
Domain  Comment 
Physical Only  NO 
Definition 
Item Comment:  A free form text field used to record notes for a specific item within a receipt transaction.
 
Note 
 

ITEM_CMNT Column Properties 
Datatype  VARCHAR2(2000) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

ITEM_CMNT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  2000 
Percent Null 

ITEM_CMNT Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

ITEM_CMNT Security Types 
Name  Current Value 

ITEM_CMNT Bound Attachments 
Name  Current Value 

ITEM_CMNT Data Movement Rules 
Name  Type  Rule Text/Value 

ITEM_CMNT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
ITEM_CMNT 
NO     

ITEM_CMNT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ITEM_CMNT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ITEM_CMNT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ITEM_CMNT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BLDG_ID 
Base Object  RCPT_ITEM 
Attribute Name  Bldg Id 
ColumnName  BLDG_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Building Code: The unique identifier for a building. 
 
Note 
 

BLDG_ID Column Properties 
Datatype  VARCHAR2(10) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

BLDG_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  10 
Percent Null 

BLDG_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

BLDG_ID Security Types 
Name  Current Value 

BLDG_ID Bound Attachments 
Name  Current Value 

BLDG_ID Data Movement Rules 
Name  Type  Rule Text/Value 

BLDG_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
BLDG_ID 
NO     

BLDG_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BLDG_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BLDG_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BLDG_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


AREA_ID 
Base Object  RCPT_ITEM 
Attribute Name  Area Id 
ColumnName  AREA_ID 
Logical Rolename   
RoleName   
Domain  Default Text 
Physical Only  NO 
Definition 
 Area Identifier: The unique identifier for a location within a building.
 
Note 
 

AREA_ID Column Properties 
Datatype  VARCHAR2(50) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 

AREA_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  50 
Percent Null 

AREA_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

AREA_ID Security Types 
Name  Current Value 

AREA_ID Bound Attachments 
Name  Current Value 

AREA_ID Data Movement Rules 
Name  Type  Rule Text/Value 

AREA_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
AREA_ID 
NO     

AREA_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

AREA_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

AREA_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

AREA_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


EQUIP_ID 
Base Object  RCPT_ITEM 
Attribute Name  Equip Id 
ColumnName  EQUIP_ID 
Logical Rolename   
RoleName   
Domain  Asset Identifier 
Physical Only  NO 
Definition 
Barcode Identifier: The barcode number associated with the item.  This field is validated manually against the Equipment table.
 
Note 
 

EQUIP_ID Column Properties 
Datatype  VARCHAR2(30) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 

EQUIP_ID Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  11 
Percent Null 

EQUIP_ID Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

EQUIP_ID Security Types 
Name  Current Value 

EQUIP_ID Bound Attachments 
Name  Current Value 

EQUIP_ID Data Movement Rules 
Name  Type  Rule Text/Value 

EQUIP_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
EQUIP (Oracle)
RCPT_ITEM
EQUIP_ID 
NO     

EQUIP_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

EQUIP_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

EQUIP_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

EQUIP_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


MOD_DTE 
Base Object  RCPT_ITEM 
Attribute Name  Modify Date 
ColumnName  MOD_DTE 
Logical Rolename   
RoleName   
Domain  Modify Date 
Physical Only  NO 
Definition 
Modify Date: The date the Receipt Item record was modified.
 
Note 
 

MOD_DTE Column Properties 
Datatype  DATE 
Nullable  NO 

MOD_DTE Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width 
Percent Null 

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)
RCPT_ITEM
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  RCPT_ITEM 
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 made changes to the Receipt Item 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 

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)
RCPT_ITEM
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