Sample Identifier 
Base Entity  Sample Delivery Request 
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 Delivery Request
Sample Identifier 
NO     
SMPL (Oracle)
SMPL_DELIV_REQ
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 Delivery Request 
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 Delivery Request
ControlArea Identifier 
NO     
SMPL (Oracle)
SMPL_DELIV_REQ
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 


Badge Number 
Base Entity  Sample Delivery Request 
Attribute Name  Badge Number 
Logical Rolename   
ColumnName  BN 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Badge Number Domain Restrictions 

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

Badge Number Bound Attachments 
Name  Current Value 

Badge Number Data Movement Rules 
Name  Type  Rule Text/Value 

Badge Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Delivery Request
Badge Number 
NO     
SMPL (Oracle)
SMPL_DELIV_REQ
BN 
NO     

Badge Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Badge Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SubArea Identifier 
Base Entity  Sample Delivery Request 
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  YES 

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 Delivery Request
SubArea Identifier 
NO     
SMPL (Oracle)
SMPL_DELIV_REQ
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 


Action Code 
Base Entity  Sample Delivery Request 
Attribute Name  Action Code 
Logical Rolename   
ColumnName  ACT_CD 
RoleName   
Domain   
Logical Only  NO 
Definition 
Action Code:  Used for controlling Inbox display.
 
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 Delivery Request
Action Code 
NO     
SMPL (Oracle)
SMPL_DELIV_REQ
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