Sample Identifier 
Base Entity  Sample Transfer 
Attribute Name  Sample Identifier 
Logical Rolename   
ColumnName  SMPL_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Sample Identifier Security Types 
Name  Current Value 

Sample Identifier Bound Attachments 
Name  Current Value 

Sample Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
Sample Identifier 		 NO     
SMPL (Oracle)
SMPL_TRANS
SMPL_ID 		 NO     

Sample Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier 
Base Entity  Sample Transfer 
Attribute Name  ControlArea Identifier 
Logical Rolename   
ColumnName  CTRL_AREA_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

ControlArea Identifier Security Types 
Name  Current Value 

ControlArea Identifier Bound Attachments 
Name  Current Value 

ControlArea Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

ControlArea Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
ControlArea Identifier 		 NO     
SMPL (Oracle)
SMPL_TRANS
CTRL_AREA_ID 		 NO     

ControlArea Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ControlArea Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier 
Base Entity  Sample Transfer 
Attribute Name  SubArea Identifier 
Logical Rolename   
ColumnName  SUBAREA_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

SubArea Identifier Security Types 
Name  Current Value 

SubArea Identifier Bound Attachments 
Name  Current Value 

SubArea Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

SubArea Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
SubArea Identifier 		 NO     
SMPL (Oracle)
SMPL_TRANS
SUBAREA_ID 		 NO     

SubArea Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date 
Base Entity  Sample Transfer 
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 Transfer
Current Date 		 NO     
SMPL (Oracle)
SMPL_TRANS
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 

To Subarea Identifier 
Base Entity  Sample Transfer 
Attribute Name  SubArea Identifier 
Logical Rolename  To Subarea Identifier 
ColumnName  TO_SUBAREA_ID 
RoleName  TO_SUBAREA_ID 
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

To Subarea Identifier Logical Attribute Properties 
Logical Attribute Name  SubArea Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

To Subarea Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

To Subarea Identifier Security Types 
Name  Current Value 

To Subarea Identifier Bound Attachments 
Name  Current Value 

To Subarea Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

To Subarea Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
SubArea Identifier 		 NO     
SMPL (Oracle)
SMPL_TRANS
TO_SUBAREA_ID 		 NO     

To Subarea Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

To Subarea Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

To Subarea Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

To Subarea Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

To Control Area Identifier 
Base Entity  Sample Transfer 
Attribute Name  ControlArea Identifier 
Logical Rolename  To Control Area Identifier 
ColumnName  TO_CTRL_AREA_ID 
RoleName  TO_CTRL_AREA_ID 
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

To Control Area Identifier Logical Attribute Properties 
Logical Attribute Name  ControlArea Identifier 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

To Control Area Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

To Control Area Identifier Security Types 
Name  Current Value 

To Control Area Identifier Bound Attachments 
Name  Current Value 

To Control Area Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

To Control Area Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
ControlArea Identifier 		 NO     
SMPL (Oracle)
SMPL_TRANS
TO_CTRL_AREA_ID 		 NO     

To Control Area Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

To Control Area Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

To Control Area Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

To Control Area Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Date 
Base Entity  Sample Transfer 
Attribute Name  Accept Date 
Logical Rolename   
ColumnName  ACCEPT_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

Accept Date Logical Attribute Properties 
Logical Attribute Name  Accept Date 
Datatype  DATE 
Nullable  YES 

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

Accept Date Security Types 
Name  Current Value 

Accept Date Bound Attachments 
Name  Current Value 

Accept Date Data Movement Rules 
Name  Type  Rule Text/Value 

Accept Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
Accept Date 		 NO     
SMPL (Oracle)
SMPL_TRANS
ACCEPT_DTE 		 NO     

Accept Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Badge Number 
Base Entity  Sample Transfer 
Attribute Name  Accept Badge Number 
Logical Rolename   
ColumnName  ACCEPT_BN 
RoleName   
Domain  Badge Number 
Logical Only  NO 
Definition 
 
Note 
 

Accept Badge Number Logical Attribute Properties 
Logical Attribute Name  Accept Badge Number 
Datatype  VARCHAR(10) 
Nullable  YES 

Accept Badge Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Accept Badge Number Security Types 
Name  Current Value 

Accept Badge Number Bound Attachments 
Name  Current Value 

Accept Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Accept Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
Accept Badge Number 		 NO     
SMPL (Oracle)
SMPL_TRANS
ACCEPT_BN 		 NO     

Accept Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Accept Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Action Code 
Base Entity  Sample Transfer 
Attribute Name  Action Code 
Logical Rolename   
ColumnName  ACT_CD 
RoleName   
Domain   
Logical Only  NO 
Definition  
Action Code: Used to control display on Inbox item.
 
Note 
 

Action Code Logical Attribute Properties 
Logical Attribute Name  Action Code 
Datatype  CHAR(1) 
Nullable  YES 

Action Code Domain Restrictions 

CheckConstraint  @var IN ('Y','N','T') 
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Action Code Security Types 
Name  Current Value 

Action Code Bound Attachments 
Name  Current Value 

Action Code Data Movement Rules 
Name  Type  Rule Text/Value 

Action Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Transfer
Action Code 		 NO     
SMPL (Oracle)
SMPL_TRANS
ACT_CD 		 NO     

Action Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Action Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Action Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Action Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description