SMPL_ID 
Base Object  SMPL_IRRAD 
Attribute Name  Sample Identifier 
ColumnName  SMPL_ID 
Logical Rolename   
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 Irradiation
Sample Identifier 
NO     
SMPL (Oracle)
SMPL_IRRAD
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 


INSTR_ID 
Base Object  SMPL_IRRAD 
Attribute Name  Instrument Identifier 
ColumnName  INSTR_ID 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
Instrument Identifier: Abbreviated identier for the instrument.
 
Note 
 

INSTR_ID Column Properties 
Datatype  VARCHAR2(20) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

INSTR_ID Security Types 
Name  Current Value 

INSTR_ID Bound Attachments 
Name  Current Value 

INSTR_ID Data Movement Rules 
Name  Type  Rule Text/Value 

INSTR_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Instrument Identifier 
NO     
SMPL (Oracle)
SMPL_IRRAD
INSTR_ID 
NO     

INSTR_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

INSTR_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


RMV_BEAM_DTE 
Base Object  SMPL_IRRAD 
Attribute Name  Remove From Beam Date 
ColumnName  RMV_BEAM_DTE 
Logical Rolename   
RoleName   
Domain  Date 
Physical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

RMV_BEAM_DTE Column Properties 
Datatype  DATE 
Nullable  NO 
Not Null Constraint   
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

RMV_BEAM_DTE Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

RMV_BEAM_DTE Security Types 
Name  Current Value 

RMV_BEAM_DTE Bound Attachments 
Name  Current Value 

RMV_BEAM_DTE Data Movement Rules 
Name  Type  Rule Text/Value 

RMV_BEAM_DTE Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Remove From Beam Date 
NO     
SMPL (Oracle)
SMPL_IRRAD
RMV_BEAM_DTE 
NO     

RMV_BEAM_DTE Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

RMV_BEAM_DTE Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

RMV_BEAM_DTE Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

RMV_BEAM_DTE Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BEAM_ENGY 
Base Object  SMPL_IRRAD 
Attribute Name  Beam Energy 
ColumnName  BEAM_ENGY 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

BEAM_ENGY Column Properties 
Datatype  BINARY_DOUBLE 
Nullable  NO 
Not Null Constraint   

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

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

BEAM_ENGY Security Types 
Name  Current Value 

BEAM_ENGY Bound Attachments 
Name  Current Value 

BEAM_ENGY Data Movement Rules 
Name  Type  Rule Text/Value 

BEAM_ENGY Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Beam Energy 
NO     
SMPL (Oracle)
SMPL_IRRAD
BEAM_ENGY 
NO     

BEAM_ENGY Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENGY Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENGY Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENGY Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BEAM_ENGY_UOM_ID 
Base Object  SMPL_IRRAD 
Attribute Name  Beam Energy Unit of Measure Identifier 
ColumnName  BEAM_ENGY_UOM_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

BEAM_ENGY_UOM_ID Column Properties 
Datatype  VARCHAR2(3) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

BEAM_ENGY_UOM_ID Security Types 
Name  Current Value 

BEAM_ENGY_UOM_ID Bound Attachments 
Name  Current Value 

BEAM_ENGY_UOM_ID Data Movement Rules 
Name  Type  Rule Text/Value 

BEAM_ENGY_UOM_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Beam Energy Unit of Measure Identifier 
NO     
SMPL (Oracle)
SMPL_IRRAD
BEAM_ENGY_UOM_ID 
NO     

BEAM_ENGY_UOM_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENGY_UOM_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENGY_UOM_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENGY_UOM_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


NORM_FACT 
Base Object  SMPL_IRRAD 
Attribute Name  Normalization Factor 
ColumnName  NORM_FACT 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

NORM_FACT Column Properties 
Datatype  BINARY_DOUBLE 
Nullable  NO 
Not Null Constraint   

NORM_FACT Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  50 
Percent Null 

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

NORM_FACT Security Types 
Name  Current Value 

NORM_FACT Bound Attachments 
Name  Current Value 

NORM_FACT Data Movement Rules 
Name  Type  Rule Text/Value 

NORM_FACT Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Normalization Factor 
NO     
SMPL (Oracle)
SMPL_IRRAD
NORM_FACT 
NO     

NORM_FACT Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

NORM_FACT Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

NORM_FACT Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

NORM_FACT Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TIME_IN_BEAM 
Base Object  SMPL_IRRAD 
Attribute Name  Time in Beam 
ColumnName  TIME_IN_BEAM 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

TIME_IN_BEAM Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  13 
Percent Null 

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

TIME_IN_BEAM Security Types 
Name  Current Value 

TIME_IN_BEAM Bound Attachments 
Name  Current Value 

TIME_IN_BEAM Data Movement Rules 
Name  Type  Rule Text/Value 

TIME_IN_BEAM Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Time in Beam 
NO     
SMPL (Oracle)
SMPL_IRRAD
TIME_IN_BEAM 
NO     

TIME_IN_BEAM Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIME_IN_BEAM Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIME_IN_BEAM Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TIME_IN_BEAM Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


TIME_UNIT_ID 
Base Object  SMPL_IRRAD 
Attribute Name  Time Unit Identifier 
ColumnName  TIME_UNIT_ID 
Logical Rolename   
RoleName   
Domain  Identifier 
Physical Only  NO 
Definition 
 
Note 
 

TIME_UNIT_ID Column Properties 
Datatype  VARCHAR2(5) 
Nullable  NO 
Not Null Constraint   
Character Set  BYTE 
Encrypted  NO 
Encryption Algorithm  -- 
SALT  -- 

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

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

TIME_UNIT_ID Security Types 
Name  Current Value 

TIME_UNIT_ID Bound Attachments 
Name  Current Value 

TIME_UNIT_ID Data Movement Rules 
Name  Type  Rule Text/Value 

TIME_UNIT_ID Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Time Unit Identifier 
NO     
SMPL (Oracle)
SMPL_IRRAD
TIME_UNIT_ID 
NO     

TIME_UNIT_ID Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIME_UNIT_ID Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

TIME_UNIT_ID Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

TIME_UNIT_ID Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BEAM_ENERGY_LOW 
Base Object  SMPL_IRRAD 
Attribute Name  Beam Energy Low 
ColumnName  BEAM_ENERGY_LOW 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

BEAM_ENERGY_LOW Column Properties 
Datatype  BINARY_DOUBLE 
Nullable  NO 
Not Null Constraint   

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

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

BEAM_ENERGY_LOW Security Types 
Name  Current Value 

BEAM_ENERGY_LOW Bound Attachments 
Name  Current Value 

BEAM_ENERGY_LOW Data Movement Rules 
Name  Type  Rule Text/Value 

BEAM_ENERGY_LOW Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Beam Energy Low 
NO     
SMPL (Oracle)
SMPL_IRRAD
BEAM_ENERGY_LOW 
NO     

BEAM_ENERGY_LOW Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENERGY_LOW Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENERGY_LOW Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENERGY_LOW Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


BEAM_ENERGY_HIGH 
Base Object  SMPL_IRRAD 
Attribute Name  Beam Energy High 
ColumnName  BEAM_ENERGY_HIGH 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

BEAM_ENERGY_HIGH Column Properties 
Datatype  BINARY_DOUBLE 
Nullable  NO 
Not Null Constraint   

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

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

BEAM_ENERGY_HIGH Security Types 
Name  Current Value 

BEAM_ENERGY_HIGH Bound Attachments 
Name  Current Value 

BEAM_ENERGY_HIGH Data Movement Rules 
Name  Type  Rule Text/Value 

BEAM_ENERGY_HIGH Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Beam Energy High 
NO     
SMPL (Oracle)
SMPL_IRRAD
BEAM_ENERGY_HIGH 
NO     

BEAM_ENERGY_HIGH Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENERGY_HIGH Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENERGY_HIGH Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

BEAM_ENERGY_HIGH Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


SPEC_CONFIG 
Base Object  SMPL_IRRAD 
Attribute Name  Special Configuration 
ColumnName  SPEC_CONFIG 
Logical Rolename   
RoleName   
Domain   
Physical Only  NO 
Definition 
 
Note 
 

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

SPEC_CONFIG Growth Metrics 
COLUMN METRIC  COLUMN METRIC VALUE 
Average Width  1000 
Percent Null 

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

SPEC_CONFIG Security Types 
Name  Current Value 

SPEC_CONFIG Bound Attachments 
Name  Current Value 

SPEC_CONFIG Data Movement Rules 
Name  Type  Rule Text/Value 

SPEC_CONFIG Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Sample Irradiation
Special Configuration 
NO     
SMPL (Oracle)
SMPL_IRRAD
SPEC_CONFIG 
NO     

SPEC_CONFIG Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

SPEC_CONFIG Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

SPEC_CONFIG Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

SPEC_CONFIG Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description