Sample Shipment Identifier 
Base Entity  Sample Shipment 
Attribute Name  Sample Shipment Identifier 
Logical Rolename   
ColumnName  SMPL_SHIP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Sample Shipment Identifier Logical Attribute Properties 
Logical Attribute Name  Sample Shipment Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Sample Shipment Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Sample Shipment Identifier Security Types 
Name  Current Value 

Sample Shipment Identifier Bound Attachments 
Name  Current Value 

Sample Shipment Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Shipment Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Sample Shipment Identifier 
NO     
SMPL (Oracle)
SMPL_SHIP
SMPL_SHIP_ID 
NO     

Sample Shipment Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Shipment Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Shipment Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Shipment Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Current Date 
Base Entity  Sample Shipment 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Current Date Logical Attribute Properties 
Logical Attribute Name  Current Date 
Datatype  DATE 
Nullable  NO 

Current Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Current Date 
NO     
SMPL (Oracle)
SMPL_SHIP
CUR_DTE 
NO     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Shipment Facility Identifier 
Base Entity  Sample Shipment 
Attribute Name  Shipment Facility Identifier 
Logical Rolename   
ColumnName  SHIP_FACIL_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Shipment Facility Identifier Logical Attribute Properties 
Logical Attribute Name  Shipment Facility Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  YES 

Shipment Facility Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Shipment Facility Identifier Security Types 
Name  Current Value 

Shipment Facility Identifier Bound Attachments 
Name  Current Value 

Shipment Facility Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Shipment Facility Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Shipment Facility Identifier 
NO     
SMPL (Oracle)
SMPL_SHIP
SHIP_FACIL_ID 
NO     

Shipment Facility Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shipment Facility Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Shipment Facility Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Shipment Facility Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Status Identifier 
Base Entity  Sample Shipment 
Attribute Name  Status Identifier 
Logical Rolename   
ColumnName  STAT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Status Identifier Logical Attribute Properties 
Logical Attribute Name  Status Identifier 
Datatype  VARCHAR(25) 
Nullable  NO 

Status Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Status Identifier Security Types 
Name  Current Value 

Status Identifier Bound Attachments 
Name  Current Value 

Status Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Status Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Status Identifier 
NO     
SMPL (Oracle)
SMPL_SHIP
STAT_ID 
NO     

Status Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Facility Name 
Base Entity  Sample Shipment 
Attribute Name  Facility Name 
Logical Rolename   
ColumnName  FACIL_NM 
RoleName   
Domain  Name 
Logical Only  NO 
Definition 
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Facility Name Logical Attribute Properties 
Logical Attribute Name  Facility Name 
Datatype  VARCHAR(120) 
Nullable  YES 

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

Facility Name Security Types 
Name  Current Value 

Facility Name Bound Attachments 
Name  Current Value 

Facility Name Data Movement Rules 
Name  Type  Rule Text/Value 

Facility Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Facility Name 
NO     
SMPL (Oracle)
SMPL_SHIP
FACIL_NM 
NO     

Facility Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Facility Department 
Base Entity  Sample Shipment 
Attribute Name  Facility Department 
Logical Rolename   
ColumnName  FACIL_DEPT 
RoleName   
Domain  Name 
Logical Only  NO 
Definition 
Name: A long description name usually accompanied by an abbreviated code.
 
Note 
 

Facility Department Logical Attribute Properties 
Logical Attribute Name  Facility Department 
Datatype  VARCHAR(120) 
Nullable  YES 

Facility Department Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Facility Department Security Types 
Name  Current Value 

Facility Department Bound Attachments 
Name  Current Value 

Facility Department Data Movement Rules 
Name  Type  Rule Text/Value 

Facility Department Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Facility Department 
NO     
SMPL (Oracle)
SMPL_SHIP
FACIL_DEPT 
NO     

Facility Department Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Department Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Department Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Department Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Address 1 
Base Entity  Sample Shipment 
Attribute Name  Address 1 
Logical Rolename   
ColumnName  ADDR1 
RoleName   
Domain   
Logical Only  NO 
Definition 
Street: Street address of institute.
 
Note 
 

Address 1 Logical Attribute Properties 
Logical Attribute Name  Address 1 
Datatype  VARCHAR(100) 
Nullable  YES 

Address 1 Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Address 1 Security Types 
Name  Current Value 

Address 1 Bound Attachments 
Name  Current Value 

Address 1 Data Movement Rules 
Name  Type  Rule Text/Value 

Address 1 Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Address 1 
NO     
SMPL (Oracle)
SMPL_SHIP
ADDR1 
NO     

Address 1 Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Address 1 Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Address 1 Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Address 1 Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Address 2 
Base Entity  Sample Shipment 
Attribute Name  Address 2 
Logical Rolename   
ColumnName  ADDR2 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Address 2 Logical Attribute Properties 
Logical Attribute Name  Address 2 
Datatype  VARCHAR(25) 
Nullable  YES 

Address 2 Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Address 2 Security Types 
Name  Current Value 

Address 2 Bound Attachments 
Name  Current Value 

Address 2 Data Movement Rules 
Name  Type  Rule Text/Value 

Address 2 Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Address 2 
NO     
SMPL (Oracle)
SMPL_SHIP
ADDR2 
NO     

Address 2 Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Address 2 Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Address 2 Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Address 2 Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


City 
Base Entity  Sample Shipment 
Attribute Name  City 
Logical Rolename   
ColumnName  CITY 
RoleName   
Domain   
Logical Only  NO 
Definition 
City: City the institute is located.
 
Note 
 

City Logical Attribute Properties 
Logical Attribute Name  City 
Datatype  VARCHAR(100) 
Nullable  YES 

City Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
City Security Types 
Name  Current Value 

City Bound Attachments 
Name  Current Value 

City Data Movement Rules 
Name  Type  Rule Text/Value 

City Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
City 
NO     
SMPL (Oracle)
SMPL_SHIP
CITY 
NO     

City Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

City Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

City Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

City Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


State 
Base Entity  Sample Shipment 
Attribute Name  State 
Logical Rolename   
ColumnName  STATE 
RoleName   
Domain   
Logical Only  NO 
Definition 
State: State or provience the institute is located.
 
Note 
 

State Logical Attribute Properties 
Logical Attribute Name  State 
Datatype  VARCHAR(100) 
Nullable  YES 

State Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
State Security Types 
Name  Current Value 

State Bound Attachments 
Name  Current Value 

State Data Movement Rules 
Name  Type  Rule Text/Value 

State Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
State 
NO     
SMPL (Oracle)
SMPL_SHIP
STATE 
NO     

State Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

State Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

State Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

State Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Postal Code 
Base Entity  Sample Shipment 
Attribute Name  Postal Code 
Logical Rolename   
ColumnName  POSTAL_CD 
RoleName   
Domain   
Logical Only  NO 
Definition 
Postal Code: Postal code of the institute.
 
Note 
 

Postal Code Logical Attribute Properties 
Logical Attribute Name  Postal Code 
Datatype  VARCHAR(20) 
Nullable  YES 

Postal Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Postal Code Security Types 
Name  Current Value 

Postal Code Bound Attachments 
Name  Current Value 

Postal Code Data Movement Rules 
Name  Type  Rule Text/Value 

Postal Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Postal Code 
NO     
SMPL (Oracle)
SMPL_SHIP
POSTAL_CD 
NO     

Postal Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Postal Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Phone Number 
Base Entity  Sample Shipment 
Attribute Name  Phone Number 
Logical Rolename   
ColumnName  PHONE_NBR 
RoleName   
Domain  Phone 
Logical Only  NO 
Definition 
 
Note 
 

Phone Number Logical Attribute Properties 
Logical Attribute Name  Phone Number 
Datatype  VARCHAR(20) 
Nullable  YES 

Phone Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Phone Number Security Types 
Name  Current Value 

Phone Number Bound Attachments 
Name  Current Value 

Phone Number Data Movement Rules 
Name  Type  Rule Text/Value 

Phone Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Phone Number 
NO     
SMPL (Oracle)
SMPL_SHIP
PHONE_NBR 
NO     

Phone Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Phone Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Email Addr 
Base Entity  Sample Shipment 
Attribute Name  Email Addr 
Logical Rolename   
ColumnName  EMAIL_ADDR 
RoleName   
Domain  Email Addr 
Logical Only  NO 
Definition 
Email Address:
 
Note 
 

Email Addr Logical Attribute Properties 
Logical Attribute Name  Email Addr 
Datatype  VARCHAR(75) 
Nullable  YES 

Email Addr Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Email Addr Security Types 
Name  Current Value 

Email Addr Bound Attachments 
Name  Current Value 

Email Addr Data Movement Rules 
Name  Type  Rule Text/Value 

Email Addr Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Email Addr 
NO     
SMPL (Oracle)
SMPL_SHIP
EMAIL_ADDR 
NO     

Email Addr Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Email Addr Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Hazardous Material Indicator 
Base Entity  Sample Shipment 
Attribute Name  Hazardous Material Indicator 
Logical Rolename   
ColumnName  HAZ_MAT_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Hazardous Material Indicator Logical Attribute Properties 
Logical Attribute Name  Hazardous Material Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Hazardous Material Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Hazardous Material Indicator 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 

Hazardous Material Indicator Security Types 
Name  Current Value 

Hazardous Material Indicator Bound Attachments 
Name  Current Value 

Hazardous Material Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Hazardous Material Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Hazardous Material Indicator 
NO     
SMPL (Oracle)
SMPL_SHIP
HAZ_MAT_IND 
NO     

Hazardous Material Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Hazardous Material Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Hazardous Material Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Hazardous Material Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Tracking Number 
Base Entity  Sample Shipment 
Attribute Name  Tracking Number 
Logical Rolename   
ColumnName  TRACK_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Tracking Number Logical Attribute Properties 
Logical Attribute Name  Tracking Number 
Datatype  VARCHAR(25) 
Nullable  YES 

Tracking Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Tracking Number Security Types 
Name  Current Value 

Tracking Number Bound Attachments 
Name  Current Value 

Tracking Number Data Movement Rules 
Name  Type  Rule Text/Value 

Tracking Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Tracking Number 
NO     
SMPL (Oracle)
SMPL_SHIP
TRACK_NBR 
NO     

Tracking Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tracking Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tracking Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tracking Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modified By Badge Number 
Base Entity  Sample Shipment 
Attribute Name  Badge Number 
Logical Rolename  Modified By Badge Number 
ColumnName  MOD_BY_BN 
RoleName  MOD_BY_BN 
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Modified By Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  NO 

Modified By Badge Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Modified By Badge Number Security Types 
Name  Current Value 

Modified By Badge Number Bound Attachments 
Name  Current Value 

Modified By Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Modified By Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Badge Number 
NO     
SMPL (Oracle)
SMPL_SHIP
MOD_BY_BN 
NO     

Modified By Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modified By Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Ship Order Originated By Badge Number 
Base Entity  Sample Shipment 
Attribute Name  Badge Number 
Logical Rolename  Ship Order Originated By Badge Number 
ColumnName  SHIP_ORD_ORIG_BY_BN 
RoleName  SHIP_ORD_ORIG_BY_BN 
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Ship Order Originated By Badge Number Logical Attribute Properties 
Logical Attribute Name  Badge Number 
Datatype  VARCHAR(10) 
Nullable  YES 

Ship Order Originated By Badge Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Ship Order Originated By Badge Number Security Types 
Name  Current Value 

Ship Order Originated By Badge Number Bound Attachments 
Name  Current Value 

Ship Order Originated By Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Ship Order Originated By Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Shipment
Badge Number 
NO     
SMPL (Oracle)
SMPL_SHIP
SHIP_ORD_ORIG_BY_BN 
NO     

Ship Order Originated By Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Ship Order Originated By Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Ship Order Originated By Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Ship Order Originated By Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description