Experiment Resource Identifier 
Base Entity  Experiment Resource 
Attribute Name  Experiment Resource Identifier 
Logical Rolename   
ColumnName  EXPT_RSRC_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Experiment Resource Identifier Logical Attribute Properties 
Logical Attribute Name  Experiment Resource Identifier 
Datatype  VARCHAR(50) 
Nullable  NO 

Experiment Resource Identifier Domain Restrictions 

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

Experiment Resource Identifier Bound Attachments 
Name  Current Value 

Experiment Resource Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Resource Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Experiment Resource Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
EXPT_RSRC_ID 		 NO     

Experiment Resource Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Status Identifier 
Base Entity  Experiment Resource 
Attribute Name  Status Identifier 
Logical Rolename   
ColumnName  STAT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Status Identifier Logical Attribute Properties 
Logical Attribute Name  Status Identifier 
Datatype  VARCHAR(20) 
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
Experiment Resource
Status Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
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 

Experiment Management System Resource Identifier 
Base Entity  Experiment Resource 
Attribute Name  Experiment Management System Resource Identifier 
Logical Rolename   
ColumnName  EMS_RSRC_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Experiment Management System Resource Identifier Logical Attribute Properties 
Logical Attribute Name  Experiment Management System Resource Identifier 
Datatype  INTEGER 
Nullable  YES 

Experiment Management System Resource Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Experiment Management System Resource Identifier Security Types 
Name  Current Value 

Experiment Management System Resource Identifier Bound Attachments 
Name  Current Value 

Experiment Management System Resource Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Management System Resource Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Experiment Management System Resource Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
EMS_RSRC_ID 		 NO     

Experiment Management System Resource Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Management System Resource Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Management System Resource Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Management System Resource Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

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

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

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

Resource Name Security Types 
Name  Current Value 

Resource Name Bound Attachments 
Name  Current Value 

Resource Name Data Movement Rules 
Name  Type  Rule Text/Value 

Resource Name Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Resource Name 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
RSRC_NM 		 NO     

Resource Name Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Resource Name Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Resource Name Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Resource Name Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Type Identifier 
Base Entity  Experiment Resource 
Attribute Name  Experiment Resource Type Identifier 
Logical Rolename   
ColumnName  EXPT_RSRC_TYPE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Experiment Resource Type Identifier Logical Attribute Properties 
Logical Attribute Name  Experiment Resource Type Identifier 
Datatype  VARCHAR(50) 
Nullable  NO 

Experiment Resource Type Identifier Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Experiment Resource Type Identifier Security Types 
Name  Current Value 

Experiment Resource Type Identifier Bound Attachments 
Name  Current Value 

Experiment Resource Type Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Resource Type Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Experiment Resource Type Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
EXPT_RSRC_TYPE_ID 		 NO     

Experiment Resource Type Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Type Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Type Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Type Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Subtype Identifer 
Base Entity  Experiment Resource 
Attribute Name  Experiment Resource Subtype Identifer 
Logical Rolename   
ColumnName  EXPT_RSRC_SUBTYPE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Experiment Resource Subtype Identifer Logical Attribute Properties 
Logical Attribute Name  Experiment Resource Subtype Identifer 
Datatype  VARCHAR(50) 
Nullable  YES 

Experiment Resource Subtype Identifer Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Experiment Resource Subtype Identifer Security Types 
Name  Current Value 

Experiment Resource Subtype Identifer Bound Attachments 
Name  Current Value 

Experiment Resource Subtype Identifer Data Movement Rules 
Name  Type  Rule Text/Value 

Experiment Resource Subtype Identifer Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Experiment Resource Subtype Identifer 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
EXPT_RSRC_SUBTYPE_ID 		 NO     

Experiment Resource Subtype Identifer Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Subtype Identifer Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Subtype Identifer Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Experiment Resource Subtype Identifer Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Next Available Date 
Base Entity  Experiment Resource 
Attribute Name  Next Available Date 
Logical Rolename   
ColumnName  NEXT_AVAIL_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Next Available Date: Time when the equipment is expected to be available for a new commitment.
 
Note 
 

Next Available Date Logical Attribute Properties 
Logical Attribute Name  Next Available Date 
Datatype  DATE 
Nullable  YES 

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

Next Available Date Security Types 
Name  Current Value 

Next Available Date Bound Attachments 
Name  Current Value 

Next Available Date Data Movement Rules 
Name  Type  Rule Text/Value 

Next Available Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Next Available Date 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
NEXT_AVAIL_DTE 		 NO     

Next Available Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Next Available Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Next Available Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Next Available Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Uniform Resource Locator 
Base Entity  Experiment Resource 
Attribute Name  Uniform Resource Locator 
Logical Rolename   
ColumnName  URL 
RoleName   
Domain  URL 
Logical Only  NO 
Definition  
Universal Resource Locator: The global address of documents and other resources on the web. In this case the URL to the specifications of the equipment.
 
Note 
 

Uniform Resource Locator Logical Attribute Properties 
Logical Attribute Name  Uniform Resource Locator 
Datatype  VARCHAR(2048) 
Nullable  YES 

Uniform Resource Locator Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Uniform Resource Locator Security Types 
Name  Current Value 

Uniform Resource Locator Bound Attachments 
Name  Current Value 

Uniform Resource Locator Data Movement Rules 
Name  Type  Rule Text/Value 

Uniform Resource Locator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Uniform Resource Locator 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
URL 		 NO     

Uniform Resource Locator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Uniform Resource Locator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Uniform Resource Locator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Uniform Resource Locator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time 
Base Entity  Experiment Resource 
Attribute Name  Restore Time 
Logical Rolename   
ColumnName  RESTORE_TIME 
RoleName   
Domain   
Logical Only  NO 
Definition  
Restore Time: The typical amount of time in hours it takes to restore the equipment back to its base configuration.
 
Note 
 

Restore Time Logical Attribute Properties 
Logical Attribute Name  Restore Time 
Datatype  NUMERIC(2, 0) 
Nullable  YES 

Restore Time Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Restore Time Security Types 
Name  Current Value 

Restore Time Bound Attachments 
Name  Current Value 

Restore Time Data Movement Rules 
Name  Type  Rule Text/Value 

Restore Time Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Restore Time 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
RESTORE_TIME 		 NO     

Restore Time Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Restore Time Unit of Measure 
ColumnName  RESTORE_TIME_UOM 
RoleName  RESTORE_TIME_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Restore Time Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Restore Time Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Restore Time Unit of Measure Security Types 
Name  Current Value 

Restore Time Unit of Measure Bound Attachments 
Name  Current Value 

Restore Time Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Restore Time Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
RESTORE_TIME_UOM 		 NO     

Restore Time Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Restore Time Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time 
Base Entity  Experiment Resource 
Attribute Name  Setup Time 
Logical Rolename   
ColumnName  SETUP_TIME 
RoleName   
Domain   
Logical Only  NO 
Definition  
Setup Time: The typical amount of time in hours it takes to setup the equipment.
 
Note 
 

Setup Time Logical Attribute Properties 
Logical Attribute Name  Setup Time 
Datatype  NUMERIC(2, 0) 
Nullable  YES 

Setup Time Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Setup Time Security Types 
Name  Current Value 

Setup Time Bound Attachments 
Name  Current Value 

Setup Time Data Movement Rules 
Name  Type  Rule Text/Value 

Setup Time Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Setup Time 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
SETUP_TIME 		 NO     

Setup Time Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Setup Time Unit of Measure 
ColumnName  SETUP_TIME_UOM 
RoleName  SETUP_TIME_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Setup Time Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Setup Time Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Setup Time Unit of Measure Security Types 
Name  Current Value 

Setup Time Unit of Measure Bound Attachments 
Name  Current Value 

Setup Time Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Setup Time Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
SETUP_TIME_UOM 		 NO     

Setup Time Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Setup Time Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time 
Base Entity  Experiment Resource 
Attribute Name  Breakdown Time 
Logical Rolename   
ColumnName  BRKDWN_TIME 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Breakdown Time Logical Attribute Properties 
Logical Attribute Name  Breakdown Time 
Datatype  NUMERIC(2, 0) 
Nullable  YES 

Breakdown Time Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Breakdown Time Security Types 
Name  Current Value 

Breakdown Time Bound Attachments 
Name  Current Value 

Breakdown Time Data Movement Rules 
Name  Type  Rule Text/Value 

Breakdown Time Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Breakdown Time 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BRKDWN_TIME 		 NO     

Breakdown Time Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Breakdown Time Unit of Measure 
ColumnName  BRKDWN_TIME_UOM 
RoleName  BRKDWN_TIME_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Breakdown Time Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Breakdown Time Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Breakdown Time Unit of Measure Security Types 
Name  Current Value 

Breakdown Time Unit of Measure Bound Attachments 
Name  Current Value 

Breakdown Time Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Breakdown Time Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BRKDWN_TIME_UOM 		 NO     

Breakdown Time Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Breakdown Time Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Availibility 
Base Entity  Experiment Resource 
Attribute Name  Availibility 
Logical Rolename   
ColumnName  AVAIL 
RoleName   
Domain   
Logical Only  NO 
Definition  
Operating Schedule: The normal operating schedule in day and hours formatted as follows.



M T W T F | 8:00 - 16:00
 
Note 
 

Availibility Logical Attribute Properties 
Logical Attribute Name  Availibility 
Datatype  VARCHAR(50) 
Nullable  YES 

Availibility Domain Restrictions 

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

Availibility Bound Attachments 
Name  Current Value 

Availibility Data Movement Rules 
Name  Type  Rule Text/Value 

Availibility Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Availibility 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
AVAIL 		 NO     

Availibility Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Availibility Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Availibility Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Availibility Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Allocation Percentage 
Base Entity  Experiment Resource 
Attribute Name  Maximum Allocation Percentage 
Logical Rolename   
ColumnName  MAX_ALLOC_PER 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Maximum Allocation Percentage Logical Attribute Properties 
Logical Attribute Name  Maximum Allocation Percentage 
Datatype  NUMERIC(3, 0) 
Nullable  YES 

Maximum Allocation Percentage Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Maximum Allocation Percentage Security Types 
Name  Current Value 

Maximum Allocation Percentage Bound Attachments 
Name  Current Value 

Maximum Allocation Percentage Data Movement Rules 
Name  Type  Rule Text/Value 

Maximum Allocation Percentage Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Maximum Allocation Percentage 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
MAX_ALLOC_PER 		 NO     

Maximum Allocation Percentage Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Allocation Percentage Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Allocation Percentage Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Maximum Allocation Percentage Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Minimum 
Base Entity  Experiment Resource 
Attribute Name  Temperature Minimum 
Logical Rolename   
ColumnName  TEMP_MIN 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Temperature Minimum Logical Attribute Properties 
Logical Attribute Name  Temperature Minimum 
Datatype  VARCHAR(5) 
Nullable  YES 

Temperature Minimum Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Temperature Minimum Security Types 
Name  Current Value 

Temperature Minimum Bound Attachments 
Name  Current Value 

Temperature Minimum Data Movement Rules 
Name  Type  Rule Text/Value 

Temperature Minimum Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Temperature Minimum 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
TEMP_MIN 		 NO     

Temperature Minimum Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Minimum Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Minimum Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Minimum Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Maximum 
Base Entity  Experiment Resource 
Attribute Name  Temperature Maximum 
Logical Rolename   
ColumnName  TEMP_MAX 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Temperature Maximum Logical Attribute Properties 
Logical Attribute Name  Temperature Maximum 
Datatype  VARCHAR(5) 
Nullable  YES 

Temperature Maximum Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Temperature Maximum Security Types 
Name  Current Value 

Temperature Maximum Bound Attachments 
Name  Current Value 

Temperature Maximum Data Movement Rules 
Name  Type  Rule Text/Value 

Temperature Maximum Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Temperature Maximum 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
TEMP_MAX 		 NO     

Temperature Maximum Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Maximum Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Maximum Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Maximum Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Temperature Unit of Measure 
ColumnName  TEMP_UOM 
RoleName  TEMP_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Temperature Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Temperature Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Temperature Unit of Measure Security Types 
Name  Current Value 

Temperature Unit of Measure Bound Attachments 
Name  Current Value 

Temperature Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Temperature Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
TEMP_UOM 		 NO     

Temperature Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Temperature Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Minimum 
Base Entity  Experiment Resource 
Attribute Name  Pressure Minimum 
Logical Rolename   
ColumnName  PRESS_MIN 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Pressure Minimum Logical Attribute Properties 
Logical Attribute Name  Pressure Minimum 
Datatype  VARCHAR(5) 
Nullable  YES 

Pressure Minimum Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Pressure Minimum Security Types 
Name  Current Value 

Pressure Minimum Bound Attachments 
Name  Current Value 

Pressure Minimum Data Movement Rules 
Name  Type  Rule Text/Value 

Pressure Minimum Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Pressure Minimum 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
PRESS_MIN 		 NO     

Pressure Minimum Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Minimum Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Minimum Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Minimum Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Maximum 
Base Entity  Experiment Resource 
Attribute Name  Pressure Maximum 
Logical Rolename   
ColumnName  PRESS_MAX 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Pressure Maximum Logical Attribute Properties 
Logical Attribute Name  Pressure Maximum 
Datatype  VARCHAR(5) 
Nullable  YES 

Pressure Maximum Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Pressure Maximum Security Types 
Name  Current Value 

Pressure Maximum Bound Attachments 
Name  Current Value 

Pressure Maximum Data Movement Rules 
Name  Type  Rule Text/Value 

Pressure Maximum Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Pressure Maximum 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
PRESS_MAX 		 NO     

Pressure Maximum Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Maximum Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Maximum Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Maximum Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Pressure Unit of Measure 
ColumnName  PRESS_UOM 
RoleName  PRESS_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Pressure Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Pressure Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Pressure Unit of Measure Security Types 
Name  Current Value 

Pressure Unit of Measure Bound Attachments 
Name  Current Value 

Pressure Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Pressure Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
PRESS_UOM 		 NO     

Pressure Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Pressure Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Height 
Base Entity  Experiment Resource 
Attribute Name  Cell Size Height 
Logical Rolename   
ColumnName  CELL_SIZE_HT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Cell Size Height Logical Attribute Properties 
Logical Attribute Name  Cell Size Height 
Datatype  VARCHAR(10) 
Nullable  YES 

Cell Size Height Domain Restrictions 

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

Cell Size Height Bound Attachments 
Name  Current Value 

Cell Size Height Data Movement Rules 
Name  Type  Rule Text/Value 

Cell Size Height Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Cell Size Height 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
CELL_SIZE_HT 		 NO     

Cell Size Height Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Height Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Height Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Height Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Diameter 
Base Entity  Experiment Resource 
Attribute Name  Cell Size Diameter 
Logical Rolename   
ColumnName  CELL_SIZE_DIA 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Cell Size Diameter Logical Attribute Properties 
Logical Attribute Name  Cell Size Diameter 
Datatype  VARCHAR(50) 
Nullable  YES 

Cell Size Diameter Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Cell Size Diameter Security Types 
Name  Current Value 

Cell Size Diameter Bound Attachments 
Name  Current Value 

Cell Size Diameter Data Movement Rules 
Name  Type  Rule Text/Value 

Cell Size Diameter Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Cell Size Diameter 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
CELL_SIZE_DIA 		 NO     

Cell Size Diameter Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Diameter Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Diameter Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Diameter Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Cell Size Unit of Measure 
ColumnName  CELL_SIZE_UOM 
RoleName  CELL_SIZE_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Cell Size Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Cell Size Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Cell Size Unit of Measure Security Types 
Name  Current Value 

Cell Size Unit of Measure Bound Attachments 
Name  Current Value 

Cell Size Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Cell Size Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
CELL_SIZE_UOM 		 NO     

Cell Size Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cell Size Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Height 
Base Entity  Experiment Resource 
Attribute Name  Sample Space Height 
Logical Rolename   
ColumnName  SMPL_SPACE_HT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

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

Sample Space Height Domain Restrictions 

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

Sample Space Height Bound Attachments 
Name  Current Value 

Sample Space Height Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Space Height Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Sample Space Height 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
SMPL_SPACE_HT 		 NO     

Sample Space Height Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Height Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Height Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Height Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Diameter 
Base Entity  Experiment Resource 
Attribute Name  Sample Space Diameter 
Logical Rolename   
ColumnName  SMPL_SPACE_DIA 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Sample Space Diameter Logical Attribute Properties 
Logical Attribute Name  Sample Space Diameter 
Datatype  VARCHAR(20) 
Nullable  YES 

Sample Space Diameter Domain Restrictions 

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

Sample Space Diameter Bound Attachments 
Name  Current Value 

Sample Space Diameter Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Space Diameter Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Sample Space Diameter 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
SMPL_SPACE_DIA 		 NO     

Sample Space Diameter Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Diameter Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Diameter Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Diameter Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Sample Space Unit of Measure 
ColumnName  SMPL_SPACE_UOM 
RoleName  SMPL_SPACE_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Sample Space Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Sample Space Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Sample Space Unit of Measure Security Types 
Name  Current Value 

Sample Space Unit of Measure Bound Attachments 
Name  Current Value 

Sample Space Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Sample Space Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
SMPL_SPACE_UOM 		 NO     

Sample Space Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Sample Space Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Height 
Base Entity  Experiment Resource 
Attribute Name  Bore Size Height 
Logical Rolename   
ColumnName  BORE_SIZE_HT 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Bore Size Height Logical Attribute Properties 
Logical Attribute Name  Bore Size Height 
Datatype  VARCHAR(50) 
Nullable  YES 

Bore Size Height Domain Restrictions 

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

Bore Size Height Bound Attachments 
Name  Current Value 

Bore Size Height Data Movement Rules 
Name  Type  Rule Text/Value 

Bore Size Height Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Bore Size Height 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BORE_SIZE_HT 		 NO     

Bore Size Height Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Height Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Height Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Height Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Diameter 
Base Entity  Experiment Resource 
Attribute Name  Bore Size Diameter 
Logical Rolename   
ColumnName  BORE_SIZE_DIA 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Bore Size Diameter Logical Attribute Properties 
Logical Attribute Name  Bore Size Diameter 
Datatype  VARCHAR(50) 
Nullable  YES 

Bore Size Diameter Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Bore Size Diameter Security Types 
Name  Current Value 

Bore Size Diameter Bound Attachments 
Name  Current Value 

Bore Size Diameter Data Movement Rules 
Name  Type  Rule Text/Value 

Bore Size Diameter Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Bore Size Diameter 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BORE_SIZE_DIA 		 NO     

Bore Size Diameter Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Diameter Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Diameter Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Diameter Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Bore Size Unit of Measure 
ColumnName  BORE_SIZE_UOM 
RoleName  BORE_SIZE_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Bore Size Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Bore Size Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Bore Size Unit of Measure Security Types 
Name  Current Value 

Bore Size Unit of Measure Bound Attachments 
Name  Current Value 

Bore Size Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Bore Size Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BORE_SIZE_UOM 		 NO     

Bore Size Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Bore Size Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Interface Connection 
Base Entity  Experiment Resource 
Attribute Name  Interface Connection 
Logical Rolename   
ColumnName  INTERFACE_CONN 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Interface Connection Logical Attribute Properties 
Logical Attribute Name  Interface Connection 
Datatype  VARCHAR(255) 
Nullable  YES 

Interface Connection Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Interface Connection Security Types 
Name  Current Value 

Interface Connection Bound Attachments 
Name  Current Value 

Interface Connection Data Movement Rules 
Name  Type  Rule Text/Value 

Interface Connection Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Interface Connection 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
INTERFACE_CONN 		 NO     

Interface Connection Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Interface Connection Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Interface Connection Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Interface Connection Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center 
Base Entity  Experiment Resource 
Attribute Name  Distance Interface Beam Center 
Logical Rolename   
ColumnName  DIST_INT_BEAM_CENTER 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Distance Interface Beam Center Logical Attribute Properties 
Logical Attribute Name  Distance Interface Beam Center 
Datatype  VARCHAR(255) 
Nullable  YES 

Distance Interface Beam Center Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Distance Interface Beam Center Security Types 
Name  Current Value 

Distance Interface Beam Center Bound Attachments 
Name  Current Value 

Distance Interface Beam Center Data Movement Rules 
Name  Type  Rule Text/Value 

Distance Interface Beam Center Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Distance Interface Beam Center 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DIST_INT_BEAM_CENTER 		 NO     

Distance Interface Beam Center Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Adjustment 
Base Entity  Experiment Resource 
Attribute Name  Distance Interface Beam Center Adjustment 
Logical Rolename   
ColumnName  DIST_INT_BEAM_CENTER_ADJ 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Distance Interface Beam Center Adjustment Logical Attribute Properties 
Logical Attribute Name  Distance Interface Beam Center Adjustment 
Datatype  VARCHAR(25) 
Nullable  YES 

Distance Interface Beam Center Adjustment Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Distance Interface Beam Center Adjustment Security Types 
Name  Current Value 

Distance Interface Beam Center Adjustment Bound Attachments 
Name  Current Value 

Distance Interface Beam Center Adjustment Data Movement Rules 
Name  Type  Rule Text/Value 

Distance Interface Beam Center Adjustment Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Distance Interface Beam Center Adjustment 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DIST_INT_BEAM_CENTER_ADJ 		 NO     

Distance Interface Beam Center Adjustment Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Adjustment Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Adjustment Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Adjustment Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Distance Interface Beam Center Unit of Measure 
ColumnName  DIST_INT_BEAM_CENTER_UOM 
RoleName  DIST_INT_BEAM_CENTER_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Distance Interface Beam Center Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Distance Interface Beam Center Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Distance Interface Beam Center Unit of Measure Security Types 
Name  Current Value 

Distance Interface Beam Center Unit of Measure Bound Attachments 
Name  Current Value 

Distance Interface Beam Center Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Distance Interface Beam Center Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DIST_INT_BEAM_CENTER_UOM 		 NO     

Distance Interface Beam Center Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Interface Beam Center Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center 
Base Entity  Experiment Resource 
Attribute Name  Distance Stick Beam Center 
Logical Rolename   
ColumnName  DIST_STICK_BEAM_CENTER 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Description: Often used in validation tables accompanying an abbreviated identifer.
 
Note 
 

Distance Stick Beam Center Logical Attribute Properties 
Logical Attribute Name  Distance Stick Beam Center 
Datatype  VARCHAR(255) 
Nullable  YES 

Distance Stick Beam Center Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Distance Stick Beam Center Security Types 
Name  Current Value 

Distance Stick Beam Center Bound Attachments 
Name  Current Value 

Distance Stick Beam Center Data Movement Rules 
Name  Type  Rule Text/Value 

Distance Stick Beam Center Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Distance Stick Beam Center 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DIST_STICK_BEAM_CENTER 		 NO     

Distance Stick Beam Center Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Distance Stick Beam Center Unit of Measure 
ColumnName  DIST_STICK_BEAM_CENTER_UOM 
RoleName  DIST_STICK_BEAM_CENTER_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Distance Stick Beam Center Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Distance Stick Beam Center Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Distance Stick Beam Center Unit of Measure Security Types 
Name  Current Value 

Distance Stick Beam Center Unit of Measure Bound Attachments 
Name  Current Value 

Distance Stick Beam Center Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Distance Stick Beam Center Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DIST_STICK_BEAM_CENTER_UOM 		 NO     

Distance Stick Beam Center Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Distance Stick Beam Center Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Beam Center 
Base Entity  Experiment Resource 
Attribute Name  Tail Distance Beam Center 
Logical Rolename   
ColumnName  TAIL_DIST_BEAM_CENTER 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Tail Distance Beam Center Logical Attribute Properties 
Logical Attribute Name  Tail Distance Beam Center 
Datatype  VARCHAR(50) 
Nullable  YES 

Tail Distance Beam Center Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Tail Distance Beam Center Security Types 
Name  Current Value 

Tail Distance Beam Center Bound Attachments 
Name  Current Value 

Tail Distance Beam Center Data Movement Rules 
Name  Type  Rule Text/Value 

Tail Distance Beam Center Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Tail Distance Beam Center 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
TAIL_DIST_BEAM_CENTER 		 NO     

Tail Distance Beam Center Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Beam Center Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Beam Center Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Beam Center Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Center Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Tail Distance Center Unit of Measure 
ColumnName  TAIL_DIST_CENTER_UOM 
RoleName  TAIL_DIST_CENTER_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Tail Distance Center Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Tail Distance Center Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Tail Distance Center Unit of Measure Security Types 
Name  Current Value 

Tail Distance Center Unit of Measure Bound Attachments 
Name  Current Value 

Tail Distance Center Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Tail Distance Center Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
TAIL_DIST_CENTER_UOM 		 NO     

Tail Distance Center Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Center Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Center Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Tail Distance Center Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center to Sample Space Bottom 
Base Entity  Experiment Resource 
Attribute Name  Beam Center to Sample Space Bottom 
Logical Rolename   
ColumnName  BEAM_CENTER_SMPL_SP_BTM 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Beam Center to Sample Space Bottom Logical Attribute Properties 
Logical Attribute Name  Beam Center to Sample Space Bottom 
Datatype  VARCHAR(10) 
Nullable  YES 

Beam Center to Sample Space Bottom Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Beam Center to Sample Space Bottom Security Types 
Name  Current Value 

Beam Center to Sample Space Bottom Bound Attachments 
Name  Current Value 

Beam Center to Sample Space Bottom Data Movement Rules 
Name  Type  Rule Text/Value 

Beam Center to Sample Space Bottom Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Beam Center to Sample Space Bottom 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BEAM_CENTER_SMPL_SP_BTM 		 NO     

Beam Center to Sample Space Bottom Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center to Sample Space Bottom Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center to Sample Space Bottom Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center to Sample Space Bottom Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center Bottom Unit of Measure 
Base Entity  Experiment Resource 
Attribute Name  Unit Identifier 
Logical Rolename  Beam Center Bottom Unit of Measure 
ColumnName  BEAM_CENTER_BTM_UOM 
RoleName  BEAM_CENTER_BTM_UOM 
Domain   
Logical Only  NO 
Definition  
Length Unit Identifier: Abbreviated unit of length.
 
Note 
 

Beam Center Bottom Unit of Measure Logical Attribute Properties 
Logical Attribute Name  Unit Identifier 
Datatype  VARCHAR(3) 
Nullable  YES 

Beam Center Bottom Unit of Measure Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Beam Center Bottom Unit of Measure Security Types 
Name  Current Value 

Beam Center Bottom Unit of Measure Bound Attachments 
Name  Current Value 

Beam Center Bottom Unit of Measure Data Movement Rules 
Name  Type  Rule Text/Value 

Beam Center Bottom Unit of Measure Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Unit Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
BEAM_CENTER_BTM_UOM 		 NO     

Beam Center Bottom Unit of Measure Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center Bottom Unit of Measure Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center Bottom Unit of Measure Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Beam Center Bottom Unit of Measure Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Comment 
Base Entity  Experiment Resource 
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
Experiment Resource
Comment 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
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 

Manufacturer Identifier 
Base Entity  Experiment Resource 
Attribute Name  Manufacturer Identifier 
Logical Rolename   
ColumnName  MANUF_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Manufacturer Identifier Logical Attribute Properties 
Logical Attribute Name  Manufacturer Identifier 
Datatype  VARCHAR(30) 
Nullable  YES 

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

Manufacturer Identifier Security Types 
Name  Current Value 

Manufacturer Identifier Bound Attachments 
Name  Current Value 

Manufacturer Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Manufacturer Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Manufacturer Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
MANUF_ID 		 NO     

Manufacturer Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Model 
Base Entity  Experiment Resource 
Attribute Name  Model 
Logical Rolename   
ColumnName  Model 
RoleName   
Domain  Machine Mode Ind 
Logical Only  NO 
Definition 
 
Note 
 

Model Logical Attribute Properties 
Logical Attribute Name  Model 
Datatype  BINARY(1) 
Nullable  YES 

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

Model Security Types 
Name  Current Value 

Model Bound Attachments 
Name  Current Value 

Model Data Movement Rules 
Name  Type  Rule Text/Value 

Model Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Model 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
Model 		 NO     

Model Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Model Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Model Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Model Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Serial Number 
Base Entity  Experiment Resource 
Attribute Name  Manufacturer Serial Number 
Logical Rolename   
ColumnName  MANFU_SERIAL_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Manufacturer Serial Number Logical Attribute Properties 
Logical Attribute Name  Manufacturer Serial Number 
Datatype  VARCHAR(50) 
Nullable  YES 

Manufacturer Serial Number Domain Restrictions 

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

Manufacturer Serial Number Bound Attachments 
Name  Current Value 

Manufacturer Serial Number Data Movement Rules 
Name  Type  Rule Text/Value 

Manufacturer Serial Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Manufacturer Serial Number 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
MANFU_SERIAL_NBR 		 NO     

Manufacturer Serial Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Serial Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Serial Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Manufacturer Serial Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cost 
Base Entity  Experiment Resource 
Attribute Name  Cost 
Logical Rolename   
ColumnName  COST 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Cost Logical Attribute Properties 
Logical Attribute Name  Cost 
Datatype  NUMERIC(12, 2) 
Nullable  YES 

Cost Domain Restrictions 

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

Cost Bound Attachments 
Name  Current Value 

Cost Data Movement Rules 
Name  Type  Rule Text/Value 

Cost Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Cost 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
COST 		 NO     

Cost Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cost Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cost Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cost Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Commission Date 
Base Entity  Experiment Resource 
Attribute Name  Commission Date 
Logical Rolename   
ColumnName  COMM_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

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

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

Commission Date Security Types 
Name  Current Value 

Commission Date Bound Attachments 
Name  Current Value 

Commission Date Data Movement Rules 
Name  Type  Rule Text/Value 

Commission Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Commission Date 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
COMM_DTE 		 NO     

Commission Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Commission Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Commission Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Commission Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Date 
Base Entity  Experiment Resource 
Attribute Name  Revision Date 
Logical Rolename   
ColumnName  REV_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition  
Date: Date and time to seconds.
 
Note 
 

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

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

Revision Date Security Types 
Name  Current Value 

Revision Date Bound Attachments 
Name  Current Value 

Revision Date Data Movement Rules 
Name  Type  Rule Text/Value 

Revision Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Revision Date 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
REV_DTE 		 NO     

Revision Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Revision Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

View Code 
Base Entity  Experiment Resource 
Attribute Name  View Code 
Logical Rolename   
ColumnName  VIEW_CD 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

View Code Logical Attribute Properties 
Logical Attribute Name  View Code 
Datatype  CHAR(1) 
Nullable  NO 

View Code Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  'N' 
Bound Default   
View Code Security Types 
Name  Current Value 

View Code Bound Attachments 
Name  Current Value 

View Code Data Movement Rules 
Name  Type  Rule Text/Value 

View Code Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
View Code 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
VIEW_CD 		 NO     

View Code Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

View Code Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

View Code Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

View Code Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Assest Identifier 
Base Entity  Experiment Resource 
Attribute Name  DataStream Assest Identifier 
Logical Rolename   
ColumnName  DS_ASSET_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

DataStream Assest Identifier Logical Attribute Properties 
Logical Attribute Name  DataStream Assest Identifier 
Datatype  VARCHAR(30) 
Nullable  YES 

DataStream Assest Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

DataStream Assest Identifier Security Types 
Name  Current Value 

DataStream Assest Identifier Bound Attachments 
Name  Current Value 

DataStream Assest Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

DataStream Assest Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
DataStream Assest Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DS_ASSET_ID 		 NO     

DataStream Assest Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Assest Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Assest Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

DataStream Assest Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Master Equipment List Identifier 
Base Entity  Experiment Resource 
Attribute Name  Master Equipment List Identifier 
Logical Rolename   
ColumnName  MEL_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition  
Master Equipment List Identifier: The id assigned to the resource in HFIR's Master Equipment List system.
 
Note 
 

Master Equipment List Identifier Logical Attribute Properties 
Logical Attribute Name  Master Equipment List Identifier 
Datatype  VARCHAR(75) 
Nullable  YES 

Master Equipment List Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Master Equipment List Identifier Security Types 
Name  Current Value 

Master Equipment List Identifier Bound Attachments 
Name  Current Value 

Master Equipment List Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Master Equipment List Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Master Equipment List Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
MEL_ID 		 NO     

Master Equipment List Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Master Equipment List Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Master Equipment List Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Master Equipment List Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number 
Base Entity  Experiment Resource 
Attribute Name  ORNL Property Number 
Logical Rolename   
ColumnName  ORNL_PROP_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

ORNL Property Number Logical Attribute Properties 
Logical Attribute Name  ORNL Property Number 
Datatype  VARCHAR(10) 
Nullable  YES 

ORNL Property Number Domain Restrictions 

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

ORNL Property Number Bound Attachments 
Name  Current Value 

ORNL Property Number Data Movement Rules 
Name  Type  Rule Text/Value 

ORNL Property Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
ORNL Property Number 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
ORNL_PROP_NBR 		 NO     

ORNL Property Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

ORNL Property Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier 
Base Entity  Experiment Resource 
Attribute Name  Facility Identifier 
Logical Rolename   
ColumnName  FACIL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition  
Facility Identifer: A unique abbreviated identifier for the facilty in which the proposed experiment is to take place.
 
Note 
 

Facility Identifier Logical Attribute Properties 
Logical Attribute Name  Facility Identifier 
Datatype  VARCHAR(10) 
Nullable  NO 

Facility Identifier Domain Restrictions 

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

Facility Identifier Bound Attachments 
Name  Current Value 

Facility Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Facility Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Facility Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
FACIL_ID 		 NO     

Facility Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Facility Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Location Identifier 
Base Entity  Experiment Resource 
Attribute Name  Location Identifier 
Logical Rolename   
ColumnName  LOC_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

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

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

Location Identifier Security Types 
Name  Current Value 

Location Identifier Bound Attachments 
Name  Current Value 

Location Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Location Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Location Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
LOC_ID 		 NO     

Location Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Location Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Location Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Location Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity 
Base Entity  Experiment Resource 
Attribute Name  Quantity 
Logical Rolename   
ColumnName  QTY 
RoleName   
Domain  Quantity 
Logical Only  NO 
Definition 
 
Note 
 

Quantity Logical Attribute Properties 
Logical Attribute Name  Quantity 
Datatype  INTEGER 
Nullable  YES 

Quantity Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  1 
Bound Default   

Quantity Security Types 
Name  Current Value 

Quantity Bound Attachments 
Name  Current Value 

Quantity Data Movement Rules 
Name  Type  Rule Text/Value 

Quantity Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Quantity 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
QTY 		 NO     

Quantity Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Quantity Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Approval Indicator 
Base Entity  Experiment Resource 
Attribute Name  Approval Indicator 
Logical Rolename   
ColumnName  APPRV_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition  
Approval Indicator: Indicates if the resource needs approval to be scheduled.
 
Note 
 

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

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

Approval 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 
Y  Yes 
N  No 

Approval Indicator Security Types 
Name  Current Value 

Approval Indicator Bound Attachments 
Name  Current Value 

Approval Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Approval Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Approval Indicator 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
APPRV_IND 		 NO     

Approval Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Approval Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Approval Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Approval Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Drawing Number 
Base Entity  Experiment Resource 
Attribute Name  Drawing Number 
Logical Rolename   
ColumnName  DRAW_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition  
Drawing Number: NScD drawing number.
 
Note 
 

Drawing Number Logical Attribute Properties 
Logical Attribute Name  Drawing Number 
Datatype  VARCHAR(50) 
Nullable  YES 

Drawing Number Domain Restrictions 

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

Drawing Number Bound Attachments 
Name  Current Value 

Drawing Number Data Movement Rules 
Name  Type  Rule Text/Value 

Drawing Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Drawing Number 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
DRAW_NBR 		 NO     

Drawing Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Drawing Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Drawing Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Drawing Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Catalog Indicator 
Base Entity  Experiment Resource 
Attribute Name  Catalog Indicator 
Logical Rolename   
ColumnName  CAT_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition  
Catalog Indicator: Indicates the resource should be treated as a catalog item. Catalog items are low support required, generally available and easily replenishable.
 
Note 
 

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

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

Catalog 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 
Y  Yes 
N  No 

Catalog Indicator Security Types 
Name  Current Value 

Catalog Indicator Bound Attachments 
Name  Current Value 

Catalog Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Catalog Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Catalog Indicator 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
CAT_IND 		 NO     

Catalog Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Catalog Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Catalog Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Catalog Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Electrical Certification Identifier 
Base Entity  Experiment Resource 
Attribute Name  Electrical Certification Identifier 
Logical Rolename   
ColumnName  ELEC_CERT_ID 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Electrical Certification Identifier Logical Attribute Properties 
Logical Attribute Name  Electrical Certification Identifier 
Datatype  VARCHAR(25) 
Nullable  YES 

Electrical Certification Identifier Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Electrical Certification Identifier Security Types 
Name  Current Value 

Electrical Certification Identifier Bound Attachments 
Name  Current Value 

Electrical Certification Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Electrical Certification Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Electrical Certification Identifier 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
ELEC_CERT_ID 		 NO     

Electrical Certification Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Electrical Certification Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Electrical Certification Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Electrical Certification Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 

Website Description 
Base Entity  Experiment Resource 
Attribute Name  Website Description 
Logical Rolename   
ColumnName  WEB_DESC 
RoleName   
Domain  Description 
Logical Only  NO 
Definition  
Website Description: Text describing the experiment resource which will display on the public website.
 
Note 
 

Website Description Logical Attribute Properties 
Logical Attribute Name  Website Description 
Datatype  VARCHAR(2000) 
Nullable  YES 

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

Website Description Security Types 
Name  Current Value 

Website Description Bound Attachments 
Name  Current Value 

Website Description Data Movement Rules 
Name  Type  Rule Text/Value 

Website Description Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Resource
Website Description 		 NO     
EXPRESS (Oracle)
EXPT_RSRC
WEB_DESC 		 NO     

Website Description Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Website Description Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Website Description Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Website Description Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description