Sample Identifier 
Base Entity  Sample Classification 
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 Classification
Sample Identifier 
NO     
SMPL (Oracle)
SMPL_CLASS
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 


Sample Classification Identifier 
Base Entity  Sample Classification 
Attribute Name  Sample Classification Identifier 
Logical Rolename   
ColumnName  SMPL_CLASS_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Sample Classification Identifier Security Types 
Name  Current Value 

Sample Classification Identifier Bound Attachments 
Name  Current Value 

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

Sample Classification Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Classification
Sample Classification Identifier 
NO     
SMPL (Oracle)
SMPL_CLASS
SMPL_CLASS_ID 
NO     

Sample Classification Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Classification Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Classification Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Classification Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Hazard Identifier 
Base Entity  Sample Classification 
Attribute Name  Sample Hazard Identifier 
Logical Rolename   
ColumnName  SMPL_HAZ_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Sample Hazard Identifier Security Types 
Name  Current Value 

Sample Hazard Identifier Bound Attachments 
Name  Current Value 

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

Sample Hazard Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Classification
Sample Hazard Identifier 
NO     
SMPL (Oracle)
SMPL_CLASS
SMPL_HAZ_ID 
NO     

Sample Hazard Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Hazard Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Hazard Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Hazard Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Chemical recId 
Base Entity  Sample Classification 
Attribute Name  Chemical recId 
Logical Rolename   
ColumnName  CHEM_RECID 
RoleName   
Domain   
Logical Only  NO 
Definition 
The record ID for the chemical - uniquely identifies the entry
 
Note 
 

Chemical recId Logical Attribute Properties 
Logical Attribute Name  Chemical recId 
Datatype  VARCHAR(6) 
Nullable  YES 

Chemical recId Domain Restrictions 

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

Chemical recId Bound Attachments 
Name  Current Value 

Chemical recId Data Movement Rules 
Name  Type  Rule Text/Value 

Chemical recId Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Classification
Chemical recId 
NO     
SMPL (Oracle)
SMPL_CLASS
CHEM_RECID 
NO     

Chemical recId Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Chemical recId Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Chemical recId Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Chemical recId Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description