Sample Identifier 
Base Entity  Sample 
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
Sample Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_ID 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_ID 
NO     
SICAT (Oracle)
SAMPLE
SMPL_ID 
NO     
SMPL (Oracle)
SAMPLE
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 


Family Sample Identifier 
Base Entity  Sample 
Attribute Name  Sample Identifier 
Logical Rolename  Family Sample Identifier 
ColumnName  FAM_SMPL_ID 
RoleName  FAM_SMPL_ID 
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Family Sample Identifier Security Types 
Name  Current Value 

Family Sample Identifier Bound Attachments 
Name  Current Value 

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

Family Sample Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
FAM_SMPL_ID 
NO     
EXPRESS (Oracle)
SAMPLE
FAM_SMPL_ID 
NO     
SICAT (Oracle)
SAMPLE
FAM_SMPL_ID 
NO     
SMPL (Oracle)
SAMPLE
FAM_SMPL_ID 
NO     

Family Sample Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Family Sample Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Family Sample Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Family Sample Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Type Indicator 
Base Entity  Sample 
Attribute Name  Sample Type Indicator 
Logical Rolename   
ColumnName  SMPL_TYPE_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Sample Type Indicator Logical Attribute Properties 
Logical Attribute Name  Sample Type Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Sample Type Indicator Domain Restrictions 
CheckConstraint  SMPL_TYPE_IND IN('L','B') 
Check Constraint Name   
Bound Rule   
Declared Default  'L' 
Bound Default   

Sample Type 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 

Sample Type Indicator Security Types 
Name  Current Value 

Sample Type Indicator Bound Attachments 
Name  Current Value 

Sample Type Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Type Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Type Indicator 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_TYPE_IND 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_TYPE_IND 
NO     
SICAT (Oracle)
SAMPLE
SMPL_TYPE_IND 
NO     
SMPL (Oracle)
SAMPLE
SMPL_TYPE_IND 
NO     

Sample Type Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Type Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Type Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Type Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

Sample Name Logical Attribute Properties 
Logical Attribute Name  Sample Name 
Datatype  VARCHAR(120) 
Nullable  NO 

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

Sample Name Security Types 
Name  Current Value 

Sample Name Bound Attachments 
Name  Current Value 

Sample Name Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Name 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_NM 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_NM 
NO     
SICAT (Oracle)
SAMPLE
SMPL_NM 
NO     
SMPL (Oracle)
SAMPLE
SMPL_NM 
NO     

Sample Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Formula 
Base Entity  Sample 
Attribute Name  Sample Formula 
Logical Rolename   
ColumnName  SMPL_FMLA 
RoleName   
Domain   
Logical Only  NO 
Definition 
Sample Formula: Any sensible chemical formula.
 
Note 
 

Sample Formula Logical Attribute Properties 
Logical Attribute Name  Sample Formula 
Datatype  VARCHAR(2000) 
Nullable  YES 

Sample Formula Domain Restrictions 

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

Sample Formula Bound Attachments 
Name  Current Value 

Sample Formula Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Formula Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Formula 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_FMLA 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_FMLA 
NO     
SICAT (Oracle)
SAMPLE
SMPL_FMLA 
NO     
SMPL (Oracle)
SAMPLE
SMPL_FMLA 
NO     

Sample Formula Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Formula Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Formula Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Formula Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Description 
Base Entity  Sample 
Attribute Name  Sample Description 
Logical Rolename   
ColumnName  SMPL_DESCR 
RoleName   
Domain  Description 
Logical Only  NO 
Definition 
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Sample Description Logical Attribute Properties 
Logical Attribute Name  Sample Description 
Datatype  VARCHAR(2000) 
Nullable  NO 

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

Sample Description Security Types 
Name  Current Value 

Sample Description Bound Attachments 
Name  Current Value 

Sample Description Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Description 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_DESCR 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_DESCR 
NO     
SICAT (Oracle)
SAMPLE
SMPL_DESCR 
NO     
SMPL (Oracle)
SAMPLE
SMPL_DESCR 
NO     

Sample Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Volume Weight Amount 
Base Entity  Sample 
Attribute Name  Volume Weight Amount 
Logical Rolename   
ColumnName  VOL_WGT_AMT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Volume Weight Amount Logical Attribute Properties 
Logical Attribute Name  Volume Weight Amount 
Datatype  NUMERIC(8, 2) 
Nullable  NO 

Volume Weight Amount Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Volume Weight Amount Security Types 
Name  Current Value 

Volume Weight Amount Bound Attachments 
Name  Current Value 

Volume Weight Amount Data Movement Rules 
Name  Type  Rule Text/Value 

Volume Weight Amount Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Volume Weight Amount 
NO     
CHAN_ARCH (Oracle)
SAMPLE
VOL_WGT_AMT 
NO     
EXPRESS (Oracle)
SAMPLE
VOL_WGT_AMT 
NO     
SICAT (Oracle)
SAMPLE
VOL_WGT_AMT 
NO     
SMPL (Oracle)
SAMPLE
VOL_WGT_AMT 
NO     

Volume Weight Amount Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Volume Weight Amount Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Volume Weight Amount Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Volume Weight Amount Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Mass Unit Identifier 
Base Entity  Sample 
Attribute Name  Mass Unit Identifier 
Logical Rolename   
ColumnName  MASS_UNIT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Unit Identifier: Abbreviated unit of mass.
 
Note 
 

Mass Unit Identifier Logical Attribute Properties 
Logical Attribute Name  Mass Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  NO 

Mass Unit Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Mass Unit Identifier Security Types 
Name  Current Value 

Mass Unit Identifier Bound Attachments 
Name  Current Value 

Mass Unit Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Mass Unit Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Mass Unit Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
MASS_UNIT_ID 
NO     
EXPRESS (Oracle)
SAMPLE
MASS_UNIT_ID 
NO     
SICAT (Oracle)
SAMPLE
MASS_UNIT_ID 
NO     
SMPL (Oracle)
SAMPLE
MASS_UNIT_ID 
NO     

Mass Unit Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Mass Unit Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Mass Unit Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Mass Unit Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Height 
Base Entity  Sample 
Attribute Name  Sample Height 
Logical Rolename   
ColumnName  SMPL_HGT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Sample Height Logical Attribute Properties 
Logical Attribute Name  Sample Height 
Datatype  VARCHAR(5) 
Nullable  YES 

Sample Height Domain Restrictions 

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

Sample Height Bound Attachments 
Name  Current Value 

Sample Height Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Height Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Height 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_HGT 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_HGT 
NO     
SICAT (Oracle)
SAMPLE
SMPL_HGT 
NO     
SMPL (Oracle)
SAMPLE
SMPL_HGT 
NO     

Sample Height Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Height Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Height Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Height Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Length Unit Identifier 
Base Entity  Sample 
Attribute Name  Length Unit Identifier 
Logical Rolename   
ColumnName  LEN_UNIT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Length Unit Identifier Logical Attribute Properties 
Logical Attribute Name  Length Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Length Unit Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Length Unit Identifier Security Types 
Name  Current Value 

Length Unit Identifier Bound Attachments 
Name  Current Value 

Length Unit Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Length Unit Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Length Unit Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
LEN_UNIT_ID 
NO     
EXPRESS (Oracle)
SAMPLE
LEN_UNIT_ID 
NO     
SICAT (Oracle)
SAMPLE
LEN_UNIT_ID 
NO     
SMPL (Oracle)
SAMPLE
LEN_UNIT_ID 
NO     

Length Unit Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Length Unit Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Length Unit Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Length Unit Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Neutron Beam Indicator 
Base Entity  Sample 
Attribute Name  Neutron Beam Indicator 
Logical Rolename   
ColumnName  NEUTRON_BEAM_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Neutron Beam Indicator Logical Attribute Properties 
Logical Attribute Name  Neutron Beam Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Neutron Beam Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Neutron Beam 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 

Neutron Beam Indicator Security Types 
Name  Current Value 

Neutron Beam Indicator Bound Attachments 
Name  Current Value 

Neutron Beam Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Neutron Beam Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Neutron Beam Indicator 
NO     
CHAN_ARCH (Oracle)
SAMPLE
NEUTRON_BEAM_IND 
NO     
EXPRESS (Oracle)
SAMPLE
NEUTRON_BEAM_IND 
NO     
SICAT (Oracle)
SAMPLE
NEUTRON_BEAM_IND 
NO     
SMPL (Oracle)
SAMPLE
NEUTRON_BEAM_IND 
NO     

Neutron Beam Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron Beam Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron Beam Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Neutron Beam Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


ControlArea Identifier 
Base Entity  Sample 
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
ControlArea Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
CTRL_AREA_ID 
NO     
EXPRESS (Oracle)
SAMPLE
CTRL_AREA_ID 
NO     
SICAT (Oracle)
SAMPLE
CTRL_AREA_ID 
NO     
SMPL (Oracle)
SAMPLE
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 
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
SubArea Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SUBAREA_ID 
NO     
EXPRESS (Oracle)
SAMPLE
SUBAREA_ID 
NO     
SICAT (Oracle)
SAMPLE
SUBAREA_ID 
NO     
SMPL (Oracle)
SAMPLE
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 


SubArea1 Identifier 
Base Entity  Sample 
Attribute Name  SubArea1 Identifier 
Logical Rolename   
ColumnName  SUBAREA1_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

SubArea1 Identifier Security Types 
Name  Current Value 

SubArea1 Identifier Bound Attachments 
Name  Current Value 

SubArea1 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

SubArea1 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
SubArea1 Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SUBAREA1_ID 
NO     
EXPRESS (Oracle)
SAMPLE
SUBAREA1_ID 
NO     
SICAT (Oracle)
SAMPLE
SUBAREA1_ID 
NO     
SMPL (Oracle)
SAMPLE
SUBAREA1_ID 
NO     

SubArea1 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea1 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea1 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea1 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SubArea2 Identifier 
Base Entity  Sample 
Attribute Name  SubArea2 Identifier 
Logical Rolename   
ColumnName  SUBAREA2_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

SubArea2 Identifier Security Types 
Name  Current Value 

SubArea2 Identifier Bound Attachments 
Name  Current Value 

SubArea2 Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

SubArea2 Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
SubArea2 Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SUBAREA2_ID 
NO     
EXPRESS (Oracle)
SAMPLE
SUBAREA2_ID 
NO     
SICAT (Oracle)
SAMPLE
SUBAREA2_ID 
NO     
SMPL (Oracle)
SAMPLE
SUBAREA2_ID 
NO     

SubArea2 Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea2 Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea2 Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SubArea2 Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Disposition 
Base Entity  Sample 
Attribute Name  Sample Disposition 
Logical Rolename   
ColumnName  SMPL_DISP 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Sample Disposition Logical Attribute Properties 
Logical Attribute Name  Sample Disposition 
Datatype  VARCHAR(2000) 
Nullable  YES 

Sample Disposition Domain Restrictions 

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

Sample Disposition Bound Attachments 
Name  Current Value 

Sample Disposition Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Disposition Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Disposition 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_DISP 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_DISP 
NO     
SICAT (Oracle)
SAMPLE
SMPL_DISP 
NO     
SMPL (Oracle)
SAMPLE
SMPL_DISP 
NO     

Sample Disposition Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Disposition Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Disposition Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Disposition Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Container Identifier 
Base Entity  Sample 
Attribute Name  Container Identifier 
Logical Rolename   
ColumnName  CONT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Container Identifier Security Types 
Name  Current Value 

Container Identifier Bound Attachments 
Name  Current Value 

Container Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Container Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Container Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
CONT_ID 
NO     
EXPRESS (Oracle)
SAMPLE
CONT_ID 
NO     
SICAT (Oracle)
SAMPLE
CONT_ID 
NO     
SMPL (Oracle)
SAMPLE
CONT_ID 
NO     

Container Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Container Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Container Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Container Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Status Identifier 
Base Entity  Sample 
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
Status Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
STAT_ID 
NO     
EXPRESS (Oracle)
SAMPLE
STAT_ID 
NO     
SICAT (Oracle)
SAMPLE
STAT_ID 
NO     
SMPL (Oracle)
SAMPLE
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 


Material State Identifier 
Base Entity  Sample 
Attribute Name  State Id 
Logical Rolename  Material State Identifier 
ColumnName  ST_ID 
RoleName  ST_ID 
Domain   
Logical Only  NO 
Definition 
State Identifier: The material state.
 
Note 
 

Material State Identifier Logical Attribute Properties 
Logical Attribute Name  State Id 
Datatype  VARCHAR(6) 
Nullable  NO 

Material State Identifier Domain Restrictions 

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

Material State Identifier Bound Attachments 
Name  Current Value 

Material State Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Material State Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
State Id 
NO     
CHAN_ARCH (Oracle)
SAMPLE
ST_ID 
NO     
EXPRESS (Oracle)
SAMPLE
ST_ID 
NO     
SICAT (Oracle)
SAMPLE
ST_ID 
NO     
SMPL (Oracle)
SAMPLE
ST_ID 
NO     

Material State Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Material State Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Material State Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Material State Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Requirement Identifier 
Base Entity  Sample 
Attribute Name  Requirement Identifier 
Logical Rolename   
ColumnName  REQ_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Requirement Identifier Security Types 
Name  Current Value 

Requirement Identifier Bound Attachments 
Name  Current Value 

Requirement Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Requirement Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Requirement Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
REQ_ID 
NO     
EXPRESS (Oracle)
SAMPLE
REQ_ID 
NO     
SICAT (Oracle)
SAMPLE
REQ_ID 
NO     
SMPL (Oracle)
SAMPLE
REQ_ID 
NO     

Requirement Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Requirement Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Requirement Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Requirement Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Group Identifier 
Base Entity  Sample 
Attribute Name  Group Identifier 
Logical Rolename   
ColumnName  GRP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Group Identifier Logical Attribute Properties 
Logical Attribute Name  Group Identifier 
Datatype  VARCHAR(128) 
Nullable  YES 

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

Group Identifier Security Types 
Name  Current Value 

Group Identifier Bound Attachments 
Name  Current Value 

Group Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Group Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Group Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
GRP_ID 
NO     
EXPRESS (Oracle)
SAMPLE
GRP_ID 
NO     
SICAT (Oracle)
SAMPLE
GRP_ID 
NO     
SMPL (Oracle)
SAMPLE
GRP_ID 
NO     

Group Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Group Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Comment 
Base Entity  Sample 
Attribute Name  Comment 
Logical Rolename   
ColumnName  CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition 
Comment:  General comments.
 
Note 
 

Comment Logical Attribute Properties 
Logical Attribute Name  Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

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

Comment Security Types 
Name  Current Value 

Comment Bound Attachments 
Name  Current Value 

Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Comment 
NO     
CHAN_ARCH (Oracle)
SAMPLE
CMNT 
NO     
EXPRESS (Oracle)
SAMPLE
CMNT 
NO     
SICAT (Oracle)
SAMPLE
CMNT 
NO     
SMPL (Oracle)
SAMPLE
CMNT 
NO     

Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


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

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

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

Modify Date Security Types 
Name  Current Value 

Modify Date Bound Attachments 
Name  Current Value 

Modify Date Data Movement Rules 
Name  Type  Rule Text/Value 

Modify Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Modify Date 
NO     
CHAN_ARCH (Oracle)
SAMPLE
MOD_DTE 
NO     
EXPRESS (Oracle)
SAMPLE
MOD_DTE 
NO     
SICAT (Oracle)
SAMPLE
MOD_DTE 
NO     
SMPL (Oracle)
SAMPLE
MOD_DTE 
NO     

Modify Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Modify By Userid 
Base Entity  Sample 
Attribute Name  Modify By Userid 
Logical Rolename   
ColumnName  MOD_BY_USERID 
RoleName   
Domain  Userid 
Logical Only  NO 
Definition 
 
Note 
 

Modify By Userid Logical Attribute Properties 
Logical Attribute Name  Modify By Userid 
Datatype  VARCHAR(64) 
Nullable  NO 

Modify By Userid Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Modify By Userid Security Types 
Name  Current Value 

Modify By Userid Bound Attachments 
Name  Current Value 

Modify By Userid Data Movement Rules 
Name  Type  Rule Text/Value 

Modify By Userid Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Modify By Userid 
NO     
CHAN_ARCH (Oracle)
SAMPLE
MOD_BY_USERID 
NO     
EXPRESS (Oracle)
SAMPLE
MOD_BY_USERID 
NO     
SICAT (Oracle)
SAMPLE
MOD_BY_USERID 
NO     
SMPL (Oracle)
SAMPLE
MOD_BY_USERID 
NO     

Modify By Userid Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Modify By Userid Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Disposition Identifier 
Base Entity  Sample 
Attribute Name  Disposition Identifier 
Logical Rolename   
ColumnName  DISP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Disposition Identifier Security Types 
Name  Current Value 

Disposition Identifier Bound Attachments 
Name  Current Value 

Disposition Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Disposition Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Disposition Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DISP_ID 
NO     
EXPRESS (Oracle)
SAMPLE
DISP_ID 
NO     
SICAT (Oracle)
SAMPLE
DISP_ID 
NO     
SMPL (Oracle)
SAMPLE
DISP_ID 
NO     

Disposition Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Resource Conservation and Recovery Act Waste Code 
Base Entity  Sample 
Attribute Name  Resource Conservation and Recovery Act Waste Code 
Logical Rolename   
ColumnName  RCRA_WASTE_CD 
RoleName   
Domain   
Logical Only  NO 
Definition 
Resource Conservation and Recovery Act Waste Code:
 
Note 
 

Resource Conservation and Recovery Act Waste Code Logical Attribute Properties 
Logical Attribute Name  Resource Conservation and Recovery Act Waste Code 
Datatype  VARCHAR(50) 
Nullable  YES 

Resource Conservation and Recovery Act Waste Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Resource Conservation and Recovery Act Waste Code Security Types 
Name  Current Value 

Resource Conservation and Recovery Act Waste Code Bound Attachments 
Name  Current Value 

Resource Conservation and Recovery Act Waste Code Data Movement Rules 
Name  Type  Rule Text/Value 

Resource Conservation and Recovery Act Waste Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Resource Conservation and Recovery Act Waste Code 
NO     
CHAN_ARCH (Oracle)
SAMPLE
RCRA_WASTE_CD 
NO     
EXPRESS (Oracle)
SAMPLE
RCRA_WASTE_CD 
NO     
SICAT (Oracle)
SAMPLE
RCRA_WASTE_CD 
NO     
SMPL (Oracle)
SAMPLE
RCRA_WASTE_CD 
NO     

Resource Conservation and Recovery Act Waste Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Resource Conservation and Recovery Act Waste Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Resource Conservation and Recovery Act Waste Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Resource Conservation and Recovery Act Waste Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


UN Identifier 
Base Entity  Sample 
Attribute Name  UN Identifier 
Logical Rolename   
ColumnName  UN_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
UN Identifier: 
 
Note 
 

UN Identifier Logical Attribute Properties 
Logical Attribute Name  UN Identifier 
Datatype  VARCHAR(50) 
Nullable  YES 

UN Identifier Domain Restrictions 

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

UN Identifier Bound Attachments 
Name  Current Value 

UN Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

UN Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
UN Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
UN_ID 
NO     
EXPRESS (Oracle)
SAMPLE
UN_ID 
NO     
SICAT (Oracle)
SAMPLE
UN_ID 
NO     
SMPL (Oracle)
SAMPLE
UN_ID 
NO     

UN Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

UN Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

UN Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

UN Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DOT Division Number 
Base Entity  Sample 
Attribute Name  DOT Division Number 
Logical Rolename   
ColumnName  DOT_DIV_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

DOT Division Number Logical Attribute Properties 
Logical Attribute Name  DOT Division Number 
Datatype  CHAR(3) 
Nullable  YES 

DOT Division Number Domain Restrictions 

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

DOT Division Number Bound Attachments 
Name  Current Value 

DOT Division Number Data Movement Rules 
Name  Type  Rule Text/Value 

DOT Division Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
DOT Division Number 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DOT_DIV_NBR 
NO     
EXPRESS (Oracle)
SAMPLE
DOT_DIV_NBR 
NO     
SICAT (Oracle)
SAMPLE
DOT_DIV_NBR 
NO     
SMPL (Oracle)
SAMPLE
DOT_DIV_NBR 
NO     

DOT Division Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Division Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Division Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Division Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DOT Sub-Hazard Division Number 
Base Entity  Sample 
Attribute Name  DOT Division Number 
Logical Rolename  DOT Sub-Hazard Division Number 
ColumnName  DOT_SUB_HAZ_DIV_NBR 
RoleName  DOT_SUB_HAZ_DIV_NBR 
Domain   
Logical Only  NO 
Definition 
 
Note 
 

DOT Sub-Hazard Division Number Logical Attribute Properties 
Logical Attribute Name  DOT Division Number 
Datatype  CHAR(3) 
Nullable  YES 

DOT Sub-Hazard Division Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
DOT Sub-Hazard Division Number Security Types 
Name  Current Value 

DOT Sub-Hazard Division Number Bound Attachments 
Name  Current Value 

DOT Sub-Hazard Division Number Data Movement Rules 
Name  Type  Rule Text/Value 

DOT Sub-Hazard Division Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
DOT Division Number 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DOT_SUB_HAZ_DIV_NBR 
NO     
EXPRESS (Oracle)
SAMPLE
DOT_SUB_HAZ_DIV_NBR 
NO     
SICAT (Oracle)
SAMPLE
DOT_SUB_HAZ_DIV_NBR 
NO     
SMPL (Oracle)
SAMPLE
DOT_SUB_HAZ_DIV_NBR 
NO     

DOT Sub-Hazard Division Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Sub-Hazard Division Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Sub-Hazard Division Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Sub-Hazard Division Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Packing Group Identifier 
Base Entity  Sample 
Attribute Name  Packing Group Identifier 
Logical Rolename   
ColumnName  PKG_GRP_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Packing Group Identifier Logical Attribute Properties 
Logical Attribute Name  Packing Group Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Packing Group Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Packing Group Identifier Security Types 
Name  Current Value 

Packing Group Identifier Bound Attachments 
Name  Current Value 

Packing Group Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Packing Group Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Packing Group Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
PKG_GRP_ID 
NO     
EXPRESS (Oracle)
SAMPLE
PKG_GRP_ID 
NO     
SICAT (Oracle)
SAMPLE
PKG_GRP_ID 
NO     
SMPL (Oracle)
SAMPLE
PKG_GRP_ID 
NO     

Packing Group Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Packing Group Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Packing Group Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Packing Group Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Waste Characterization Comment 
Base Entity  Sample 
Attribute Name  Waste Characterization Comment 
Logical Rolename   
ColumnName  WASTE_CHAR_CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition 
Comment:  General comments.
 
Note 
 

Waste Characterization Comment Logical Attribute Properties 
Logical Attribute Name  Waste Characterization Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

Waste Characterization Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Waste Characterization Comment Security Types 
Name  Current Value 

Waste Characterization Comment Bound Attachments 
Name  Current Value 

Waste Characterization Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Waste Characterization Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Waste Characterization Comment 
NO     
CHAN_ARCH (Oracle)
SAMPLE
WASTE_CHAR_CMNT 
NO     
EXPRESS (Oracle)
SAMPLE
WASTE_CHAR_CMNT 
NO     
SICAT (Oracle)
SAMPLE
WASTE_CHAR_CMNT 
NO     
SMPL (Oracle)
SAMPLE
WASTE_CHAR_CMNT 
NO     

Waste Characterization Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Waste Characterization Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Waste Characterization Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Waste Characterization Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Lab Waste Certification Indicator 
Base Entity  Sample 
Attribute Name  Lab Waste Certification Indicator 
Logical Rolename   
ColumnName  LWS_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Lab Waste Certification Indicator Logical Attribute Properties 
Logical Attribute Name  Lab Waste Certification Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Lab Waste Certification Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Lab Waste Certification 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 

Lab Waste Certification Indicator Security Types 
Name  Current Value 

Lab Waste Certification Indicator Bound Attachments 
Name  Current Value 

Lab Waste Certification Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Lab Waste Certification Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Lab Waste Certification Indicator 
NO     
CHAN_ARCH (Oracle)
SAMPLE
LWS_IND 
NO     
EXPRESS (Oracle)
SAMPLE
LWS_IND 
NO     
SICAT (Oracle)
SAMPLE
LWS_IND 
NO     
SMPL (Oracle)
SAMPLE
LWS_IND 
NO     

Lab Waste Certification Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Lab Waste Certification Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Lab Waste Certification Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Lab Waste Certification Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DOT Class Number 
Base Entity  Sample 
Attribute Name  DOT Class Number 
Logical Rolename   
ColumnName  DOT_CLASS_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

DOT Class Number Logical Attribute Properties 
Logical Attribute Name  DOT Class Number 
Datatype  CHAR(1) 
Nullable  YES 

DOT Class Number Domain Restrictions 

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

DOT Class Number Bound Attachments 
Name  Current Value 

DOT Class Number Data Movement Rules 
Name  Type  Rule Text/Value 

DOT Class Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
DOT Class Number 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DOT_CLASS_NBR 
NO     
EXPRESS (Oracle)
SAMPLE
DOT_CLASS_NBR 
NO     
SICAT (Oracle)
SAMPLE
DOT_CLASS_NBR 
NO     
SMPL (Oracle)
SAMPLE
DOT_CLASS_NBR 
NO     

DOT Class Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Class Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Class Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Class Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


DOT Sub Class Number 
Base Entity  Sample 
Attribute Name  DOT Class Number 
Logical Rolename  DOT Sub Class Number 
ColumnName  DOT_SUB_CLASS_NBR 
RoleName  DOT_SUB_CLASS_NBR 
Domain   
Logical Only  NO 
Definition 
 
Note 
 

DOT Sub Class Number Logical Attribute Properties 
Logical Attribute Name  DOT Class Number 
Datatype  CHAR(1) 
Nullable  YES 

DOT Sub Class Number Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
DOT Sub Class Number Security Types 
Name  Current Value 

DOT Sub Class Number Bound Attachments 
Name  Current Value 

DOT Sub Class Number Data Movement Rules 
Name  Type  Rule Text/Value 

DOT Sub Class Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
DOT Class Number 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DOT_SUB_CLASS_NBR 
NO     
EXPRESS (Oracle)
SAMPLE
DOT_SUB_CLASS_NBR 
NO     
SICAT (Oracle)
SAMPLE
DOT_SUB_CLASS_NBR 
NO     
SMPL (Oracle)
SAMPLE
DOT_SUB_CLASS_NBR 
NO     

DOT Sub Class Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Sub Class Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Sub Class Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DOT Sub Class Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Owner Person Identifier 
Base Entity  Sample 
Attribute Name  Person Identifier 
Logical Rolename  Sample Owner Person Identifier 
ColumnName  smpl_owner_person_id 
RoleName  smpl_owner_person_id 
Domain   
Logical Only  NO 
Definition 
Person Identifier: Unique identifier for a person derived from XCAMS.
 
Note 
 

Sample Owner Person Identifier Logical Attribute Properties 
Logical Attribute Name  Person Identifier 
Datatype  VARCHAR(10) 
Nullable  YES 

Sample Owner Person Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Sample Owner Person Identifier Security Types 
Name  Current Value 

Sample Owner Person Identifier Bound Attachments 
Name  Current Value 

Sample Owner Person Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Owner Person Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Person Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
smpl_owner_person_id 
NO     
EXPRESS (Oracle)
SAMPLE
smpl_owner_person_id 
NO     
SICAT (Oracle)
SAMPLE
smpl_owner_person_id 
NO     
SMPL (Oracle)
SAMPLE
smpl_owner_person_id 
NO     

Sample Owner Person Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Owner Person Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Owner Person Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Owner Person Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Disposition Verified Indicator 
Base Entity  Sample 
Attribute Name  Disposition Verified Indicator 
Logical Rolename   
ColumnName  DISP_VERIF_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Disposition Verified Indicator: Simple placeholder indicating that all sample disposition items have been checked.
 
Note 
 

Disposition Verified Indicator Logical Attribute Properties 
Logical Attribute Name  Disposition Verified Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Disposition Verified Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Disposition Verified 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 

Disposition Verified Indicator Security Types 
Name  Current Value 

Disposition Verified Indicator Bound Attachments 
Name  Current Value 

Disposition Verified Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Disposition Verified Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Disposition Verified Indicator 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DISP_VERIF_IND 
NO     
EXPRESS (Oracle)
SAMPLE
DISP_VERIF_IND 
NO     
SICAT (Oracle)
SAMPLE
DISP_VERIF_IND 
NO     
SMPL (Oracle)
SAMPLE
DISP_VERIF_IND 
NO     

Disposition Verified Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Verified Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Verified Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Verified Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Return Name 
Base Entity  Sample 
Attribute Name  Sample Return Name 
Logical Rolename   
ColumnName  SMPL_RET_NM 
RoleName   
Domain   
Logical Only  NO 
Definition 
Item Return Name: The name of the person to which the experiment samples are to be returned.
 
Note 
 

Sample Return Name Logical Attribute Properties 
Logical Attribute Name  Sample Return Name 
Datatype  VARCHAR(75) 
Nullable  YES 

Sample Return Name Domain Restrictions 

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

Sample Return Name Bound Attachments 
Name  Current Value 

Sample Return Name Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Return Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Return Name 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_RET_NM 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_RET_NM 
NO     
SICAT (Oracle)
SAMPLE
SMPL_RET_NM 
NO     
SMPL (Oracle)
SAMPLE
SMPL_RET_NM 
NO     

Sample Return Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Return Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Return Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Return Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Sample Return Address 
Base Entity  Sample 
Attribute Name  Sample Return Address 
Logical Rolename   
ColumnName  SMPL_RET_ADDR 
RoleName   
Domain   
Logical Only  NO 
Definition 
Item Return Address: The address to which the experiment samples ae to be returned.
 
Note 
 

Sample Return Address Logical Attribute Properties 
Logical Attribute Name  Sample Return Address 
Datatype  VARCHAR(500) 
Nullable  YES 

Sample Return Address Domain Restrictions 

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

Sample Return Address Bound Attachments 
Name  Current Value 

Sample Return Address Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Return Address Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Sample Return Address 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SMPL_RET_ADDR 
NO     
EXPRESS (Oracle)
SAMPLE
SMPL_RET_ADDR 
NO     
SICAT (Oracle)
SAMPLE
SMPL_RET_ADDR 
NO     
SMPL (Oracle)
SAMPLE
SMPL_RET_ADDR 
NO     

Sample Return Address Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Return Address Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Return Address Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Return Address Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Can Identifier 
Base Entity  Sample 
Attribute Name  Can Identifier 
Logical Rolename   
ColumnName  CAN_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Can Identifier Logical Attribute Properties 
Logical Attribute Name  Can Identifier 
Datatype  VARCHAR(20) 
Nullable  YES 

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

Can Identifier Security Types 
Name  Current Value 

Can Identifier Bound Attachments 
Name  Current Value 

Can Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Can Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Can Identifier 
NO     
CHAN_ARCH (Oracle)
SAMPLE
CAN_ID 
NO     
EXPRESS (Oracle)
SAMPLE
CAN_ID 
NO     
SICAT (Oracle)
SAMPLE
CAN_ID 
NO     
SMPL (Oracle)
SAMPLE
CAN_ID 
NO     

Can Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Can Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Can Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Can Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Disposition Comment 
Base Entity  Sample 
Attribute Name  Disposition Comment 
Logical Rolename   
ColumnName  DISP_CMNT 
RoleName   
Domain  Comment 
Logical Only  NO 
Definition 
Comment:  General comments.
 
Note 
 

Disposition Comment Logical Attribute Properties 
Logical Attribute Name  Disposition Comment 
Datatype  VARCHAR(2000) 
Nullable  YES 

Disposition Comment Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Disposition Comment Security Types 
Name  Current Value 

Disposition Comment Bound Attachments 
Name  Current Value 

Disposition Comment Data Movement Rules 
Name  Type  Rule Text/Value 

Disposition Comment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Disposition Comment 
NO     
CHAN_ARCH (Oracle)
SAMPLE
DISP_CMNT 
NO     
EXPRESS (Oracle)
SAMPLE
DISP_CMNT 
NO     
SICAT (Oracle)
SAMPLE
DISP_CMNT 
NO     
SMPL (Oracle)
SAMPLE
DISP_CMNT 
NO     

Disposition Comment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Comment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Comment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Disposition Comment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Special Handling Plan Indicator 
Base Entity  Sample 
Attribute Name  Special Handling Plan Indicator 
Logical Rolename   
ColumnName  SPEC_HAND_PLAN_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
 
Note 
 

Special Handling Plan Indicator Logical Attribute Properties 
Logical Attribute Name  Special Handling Plan Indicator 
Datatype  CHAR(1) 
Nullable  NO 

Special Handling Plan Indicator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   

Special Handling Plan 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 

Special Handling Plan Indicator Security Types 
Name  Current Value 

Special Handling Plan Indicator Bound Attachments 
Name  Current Value 

Special Handling Plan Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Special Handling Plan Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Special Handling Plan Indicator 
NO     
CHAN_ARCH (Oracle)
SAMPLE
SPEC_HAND_PLAN_IND 
NO     
EXPRESS (Oracle)
SAMPLE
SPEC_HAND_PLAN_IND 
NO     
SICAT (Oracle)
SAMPLE
SPEC_HAND_PLAN_IND 
NO     
SMPL (Oracle)
SAMPLE
SPEC_HAND_PLAN_IND 
NO     

Special Handling Plan Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Special Handling Plan Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Special Handling Plan Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Special Handling Plan Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Theoretical Mass Density 
Base Entity  Sample 
Attribute Name  Theoretical Mass Density 
Logical Rolename   
ColumnName  THEOR_MASS_DENS 
RoleName   
Domain   
Logical Only  NO 
Definition 
Theoretical Mass Density: Measured in grams per centimeter cube (g/cm^3)
 
Note 
 

Theoretical Mass Density Logical Attribute Properties 
Logical Attribute Name  Theoretical Mass Density 
Datatype  NUMERIC(7, 5) 
Nullable  YES 

Theoretical Mass Density Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Theoretical Mass Density Security Types 
Name  Current Value 

Theoretical Mass Density Bound Attachments 
Name  Current Value 

Theoretical Mass Density Data Movement Rules 
Name  Type  Rule Text/Value 

Theoretical Mass Density Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample
Theoretical Mass Density 
NO     
CHAN_ARCH (Oracle)
SAMPLE
THEOR_MASS_DENS 
NO     
EXPRESS (Oracle)
SAMPLE
THEOR_MASS_DENS 
NO     
SICAT (Oracle)
SAMPLE
THEOR_MASS_DENS 
NO     
SMPL (Oracle)
SAMPLE
THEOR_MASS_DENS 
NO     

Theoretical Mass Density Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Theoretical Mass Density Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Theoretical Mass Density Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Theoretical Mass Density Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description