Proposal Identifier 
Base Entity  Experiment Laboratory Schedule Log 
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
Experiment Laboratory Schedule Log
Proposal Identifier 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
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  Experiment Laboratory Schedule Log 
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
Experiment Laboratory Schedule Log
Submission Number 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
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  Experiment Laboratory Schedule Log 
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
Experiment Laboratory Schedule Log
Instrument Identifier 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
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  Experiment Laboratory Schedule Log 
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
Experiment Laboratory Schedule Log
Run Number 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
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 


Laboratory Identifier 
Base Entity  Experiment Laboratory Schedule Log 
Attribute Name  Laboratory Identifier 
Logical Rolename   
ColumnName  LAB_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Laboratory Identifier: Abbreviated identifier for the laboratory.
 
Note 
 

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

Laboratory Identifier Domain Restrictions 

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

Laboratory Identifier Bound Attachments 
Name  Current Value 

Laboratory Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Laboratory Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Laboratory Schedule Log
Laboratory Identifier 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
LAB_ID 
NO     

Laboratory Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Laboratory Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Laboratory Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Laboratory Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Activity Identifier 
Base Entity  Experiment Laboratory Schedule Log 
Attribute Name  Activity Identifier 
Logical Rolename   
ColumnName  ACT_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Activity Identifier: Abbreviated identifer of the activity that can be taken against a proposal.
 
Note 
 

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

Activity Identifier Domain Restrictions 

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

Activity Identifier Bound Attachments 
Name  Current Value 

Activity Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Activity Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Laboratory Schedule Log
Activity Identifier 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
ACT_ID 
NO     

Activity Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Activity Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Current TimeStamp 
Base Entity  Experiment Laboratory Schedule Log 
Attribute Name  Current TimeStamp 
Logical Rolename   
ColumnName  CUR_TIMESTAMP 
RoleName   
Domain  TimeStamp 
Logical Only  NO 
Definition 
 
Note 
 

Current TimeStamp Logical Attribute Properties 
Logical Attribute Name  Current TimeStamp 
Datatype  TIMESTAMP/DATE 
Nullable  NO 

Current TimeStamp Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   

Current TimeStamp Security Types 
Name  Current Value 

Current TimeStamp Bound Attachments 
Name  Current Value 

Current TimeStamp Data Movement Rules 
Name  Type  Rule Text/Value 

Current TimeStamp Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Laboratory Schedule Log
Current TimeStamp 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
CUR_TIMESTAMP 
NO     

Current TimeStamp Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current TimeStamp Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Current TimeStamp Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Current TimeStamp Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Entry 
Base Entity  Experiment Laboratory Schedule Log 
Attribute Name  Entry 
Logical Rolename   
ColumnName  ENTRY 
RoleName   
Domain   
Logical Only  NO 
Definition 
Comment:  General comments.
 
Note 
 

Entry Logical Attribute Properties 
Logical Attribute Name  Entry 
Datatype  VARCHAR(4000) 
Nullable  YES 

Entry Domain Restrictions 

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

Entry Bound Attachments 
Name  Current Value 

Entry Data Movement Rules 
Name  Type  Rule Text/Value 

Entry Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Experiment Laboratory Schedule Log
Entry 
NO     
EXPRESS (Oracle)
EXPT_LAB_SCHED_LOG
ENTRY 
NO     

Entry Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Entry Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Entry Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Entry Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description