SMPL_ID 
Base Object  SMPL_CLASS 
Attribute Name  Sample Identifier 
ColumnName  SMPL_ID 
Logical Rolename  Sample Identifier 
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

SMPL_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

SMPL_ID Security Types 
Name  Current Value 

SMPL_ID Bound Attachments 
Name  Current Value 

SMPL_ID Data Movement Rules 
Name  Type  Rule Text/Value 

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

SMPL_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

SMPL_CLASS_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

SMPL_CLASS_ID Security Types 
Name  Current Value 

SMPL_CLASS_ID Bound Attachments 
Name  Current Value 

SMPL_CLASS_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SMPL_CLASS_ID 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     

SMPL_CLASS_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_CLASS_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_CLASS_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_CLASS_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SMPL_HAZ_ID 
Base Object  SMPL_CLASS 
Attribute Name  Sample Hazard Identifier 
ColumnName  SMPL_HAZ_ID 
Logical Rolename   
RoleName  SMPL_HAZ_ID 
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

SMPL_HAZ_ID Column Properties 
Datatype  NUMBER(38, 0) 
Nullable  YES 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

SMPL_HAZ_ID Security Types 
Name  Current Value 

SMPL_HAZ_ID Bound Attachments 
Name  Current Value 

SMPL_HAZ_ID Data Movement Rules 
Name  Type  Rule Text/Value 

SMPL_HAZ_ID 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     

SMPL_HAZ_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_HAZ_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_HAZ_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SMPL_HAZ_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

CHEM_RECID Column Properties 
Datatype  VARCHAR2(6) 
Nullable  YES 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

CHEM_RECID Security Types 
Name  Current Value 

CHEM_RECID Bound Attachments 
Name  Current Value 

CHEM_RECID Data Movement Rules 
Name  Type  Rule Text/Value 

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

CHEM_RECID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

CHEM_RECID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

CHEM_RECID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

CHEM_RECID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description