Experiment Resource Type Identifier 
Base Entity  Can Substrate Cell Experiment Schedule Association 
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
Can Substrate Cell Experiment Schedule Association
Experiment Resource Type Identifier 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
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 


Facility Identifier 
Base Entity  Can Substrate Cell Experiment Schedule Association 
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
Can Substrate Cell Experiment Schedule Association
Facility Identifier 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
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 


Proposal Identifier 
Base Entity  Can Substrate Cell Experiment Schedule Association 
Attribute Name  Proposal Identifier 
Logical Rolename   
ColumnName  PRPSL_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Proposal Identifier Logical Attribute Properties 
Logical Attribute Name  Proposal Identifier 
Datatype  NUMERIC(10, 0) 
Nullable  NO 

Proposal Identifier Domain Restrictions 

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

Proposal Identifier Bound Attachments 
Name  Current Value 

Proposal Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Can Substrate Cell Experiment Schedule Association
Proposal Identifier 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
PRPSL_ID 
NO     

Proposal Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Submission Number 
Base Entity  Can Substrate Cell Experiment Schedule Association 
Attribute Name  Submission Number 
Logical Rolename   
ColumnName  SUBMISS_NBR 
RoleName   
Domain  Identifier 
Logical Only  NO 
Definition 
 
Note 
 

Submission Number Logical Attribute Properties 
Logical Attribute Name  Submission Number 
Datatype  NUMERIC(38, 0) 
Nullable  NO 

Submission Number Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Submission Number Security Types 
Name  Current Value 

Submission Number Bound Attachments 
Name  Current Value 

Submission Number Data Movement Rules 
Name  Type  Rule Text/Value 

Submission Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Can Substrate Cell Experiment Schedule Association
Submission Number 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
SUBMISS_NBR 
NO     

Submission Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Submission Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Instrument Identifier 
Base Entity  Can Substrate Cell Experiment Schedule Association 
Attribute Name  Instrument Identifier 
Logical Rolename   
ColumnName  INSTR_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Instrument Identifier: Abbreviated identier for the instrument.
 
Note 
 

Instrument Identifier Logical Attribute Properties 
Logical Attribute Name  Instrument Identifier 
Datatype  VARCHAR(20) 
Nullable  NO 

Instrument Identifier Domain Restrictions 

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

Instrument Identifier Bound Attachments 
Name  Current Value 

Instrument Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Instrument Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Can Substrate Cell Experiment Schedule Association
Instrument Identifier 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
INSTR_ID 
NO     

Instrument Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Run Number 
Base Entity  Can Substrate Cell Experiment Schedule Association 
Attribute Name  Run Number 
Logical Rolename   
ColumnName  RUN_NBR 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Run Number Logical Attribute Properties 
Logical Attribute Name  Run Number 
Datatype  NUMERIC(5, 0) 
Nullable  NO 

Run Number Domain Restrictions 

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

Run Number Bound Attachments 
Name  Current Value 

Run Number Data Movement Rules 
Name  Type  Rule Text/Value 

Run Number Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Can Substrate Cell Experiment Schedule Association
Run Number 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
RUN_NBR 
NO     

Run Number Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Run Number Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Run Number Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Run Number Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Quantity 
Base Entity  Can Substrate Cell Experiment Schedule Association 
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 
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
Can Substrate Cell Experiment Schedule Association
Quantity 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
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 


Current Date 
Base Entity  Can Substrate Cell Experiment Schedule Association 
Attribute Name  Current Date 
Logical Rolename   
ColumnName  CUR_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

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

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

Current Date Security Types 
Name  Current Value 

Current Date Bound Attachments 
Name  Current Value 

Current Date Data Movement Rules 
Name  Type  Rule Text/Value 

Current Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Can Substrate Cell Experiment Schedule Association
Current Date 
NO     
EXPRESS (Oracle)
CASC_EXPT_SCHED_ASSC
CUR_DTE 
NO     

Current Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description