Facility Identifier 
Base Entity  Run Cycle 
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
Run Cycle
Facility Identifier 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
FACIL_ID 
NO     
PRPSL (Oracle)
RUN_CYCLE
FACIL_ID 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
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 


Run Cycle Identifier 
Base Entity  Run Cycle 
Attribute Name  Run Cycle Identifier 
Logical Rolename   
ColumnName  RUN_CYCLE_ID 
RoleName   
Domain   
Logical Only  NO 
Definition 
Run Cycle Identifier: Identifer for the run cycle period.
 
Note 
 

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

Run Cycle Identifier Domain Restrictions 

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

Run Cycle Identifier Bound Attachments 
Name  Current Value 

Run Cycle Identifier Data Movement Rules 
Name  Type  Rule Text/Value 

Run Cycle Identifier Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Run Cycle Identifier 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
RUN_CYCLE_ID 
NO     
PRPSL (Oracle)
RUN_CYCLE
RUN_CYCLE_ID 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
RUN_CYCLE_ID 
NO     

Run Cycle Identifier Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Run Cycle Identifier Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Run Cycle Identifier Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Run Cycle Identifier Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Cycle Begin Date 
Base Entity  Run Cycle 
Attribute Name  Cycle Begin Date 
Logical Rolename   
ColumnName  CYC_BEGIN_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Cycle Begin Date Logical Attribute Properties 
Logical Attribute Name  Cycle Begin Date 
Datatype  DATE 
Nullable  NO 

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

Cycle Begin Date Security Types 
Name  Current Value 

Cycle Begin Date Bound Attachments 
Name  Current Value 

Cycle Begin Date Data Movement Rules 
Name  Type  Rule Text/Value 

Cycle Begin Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Cycle Begin Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
CYC_BEGIN_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
CYC_BEGIN_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
CYC_BEGIN_DTE 
NO     

Cycle Begin Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cycle Begin Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cycle Begin Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cycle Begin Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Cycle End Date 
Base Entity  Run Cycle 
Attribute Name  Cycle End Date 
Logical Rolename   
ColumnName  CYC_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Cycle End Date Logical Attribute Properties 
Logical Attribute Name  Cycle End Date 
Datatype  DATE 
Nullable  NO 

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

Cycle End Date Security Types 
Name  Current Value 

Cycle End Date Bound Attachments 
Name  Current Value 

Cycle End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Cycle End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Cycle End Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
CYC_END_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
CYC_END_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
CYC_END_DTE 
NO     

Cycle End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cycle End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Cycle End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Cycle End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Proposal End Date 
Base Entity  Run Cycle 
Attribute Name  Proposal End Date 
Logical Rolename   
ColumnName  PRPSL_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Proposal End Date Logical Attribute Properties 
Logical Attribute Name  Proposal End Date 
Datatype  DATE 
Nullable  NO 

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

Proposal End Date Security Types 
Name  Current Value 

Proposal End Date Bound Attachments 
Name  Current Value 

Proposal End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Proposal End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Proposal End Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
PRPSL_END_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
PRPSL_END_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
PRPSL_END_DTE 
NO     

Proposal End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Proposal End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Feasibility Review Start Date 
Base Entity  Run Cycle 
Attribute Name  Feasibility Review Start Date 
Logical Rolename   
ColumnName  FEAS_REV_STRT_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Feasibility Review Start Date Logical Attribute Properties 
Logical Attribute Name  Feasibility Review Start Date 
Datatype  DATE 
Nullable  NO 

Feasibility Review Start Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Feasibility Review Start Date Security Types 
Name  Current Value 

Feasibility Review Start Date Bound Attachments 
Name  Current Value 

Feasibility Review Start Date Data Movement Rules 
Name  Type  Rule Text/Value 

Feasibility Review Start Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Feasibility Review Start Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
FEAS_REV_STRT_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
FEAS_REV_STRT_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
FEAS_REV_STRT_DTE 
NO     

Feasibility Review Start Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Feasibility Review Start Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Feasibility Review Start Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Feasibility Review Start Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Review Final Date 
Base Entity  Run Cycle 
Attribute Name  Review Final Date 
Logical Rolename   
ColumnName  REV_FIN_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Review Final Date Logical Attribute Properties 
Logical Attribute Name  Review Final Date 
Datatype  DATE 
Nullable  NO 

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

Review Final Date Security Types 
Name  Current Value 

Review Final Date Bound Attachments 
Name  Current Value 

Review Final Date Data Movement Rules 
Name  Type  Rule Text/Value 

Review Final Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Review Final Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
REV_FIN_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
REV_FIN_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
REV_FIN_DTE 
NO     

Review Final Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Review Final Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Review Final Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Review Final Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Beamtime Allocation Committee Date 
Base Entity  Run Cycle 
Attribute Name  Beamtime Allocation Committee Date 
Logical Rolename   
ColumnName  BT_ALLOC_COM_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Beamtime Allocation Committee Date Logical Attribute Properties 
Logical Attribute Name  Beamtime Allocation Committee Date 
Datatype  DATE 
Nullable  NO 

Beamtime Allocation Committee Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Beamtime Allocation Committee Date Security Types 
Name  Current Value 

Beamtime Allocation Committee Date Bound Attachments 
Name  Current Value 

Beamtime Allocation Committee Date Data Movement Rules 
Name  Type  Rule Text/Value 

Beamtime Allocation Committee Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Beamtime Allocation Committee Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
BT_ALLOC_COM_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
BT_ALLOC_COM_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
BT_ALLOC_COM_DTE 
NO     

Beamtime Allocation Committee Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beamtime Allocation Committee Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Beamtime Allocation Committee Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Beamtime Allocation Committee Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Program Development Indicator 
Base Entity  Run Cycle 
Attribute Name  Program Development Indicator 
Logical Rolename   
ColumnName  PROG_DEV_IND 
RoleName   
Domain  Indicator 
Logical Only  NO 
Definition 
Program Development Indicator: Indicates that the Run Cycle is for internal Program Development activities.
 
Note 
 

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

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

Program Development Indicator Reference Value (Bound to Domain) 
Name  Standard Indicator 
Description  These are the standard values for the Indicator domain. 
Type  By List 
Value  Value Description 
Yes 
No 

Program Development Indicator Security Types 
Name  Current Value 

Program Development Indicator Bound Attachments 
Name  Current Value 

Program Development Indicator Data Movement Rules 
Name  Type  Rule Text/Value 

Program Development Indicator Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Program Development Indicator 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
PROG_DEV_IND 
NO     
PRPSL (Oracle)
RUN_CYCLE
PROG_DEV_IND 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
PROG_DEV_IND 
NO     

Program Development Indicator Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Program Development Indicator Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Program Development Indicator Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Program Development Indicator Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Program Development End Date 
Base Entity  Run Cycle 
Attribute Name  Program Development End Date 
Logical Rolename   
ColumnName  PROG_DEV_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Program Development End Date Logical Attribute Properties 
Logical Attribute Name  Program Development End Date 
Datatype  DATE 
Nullable  NO 

Program Development End Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Program Development End Date Security Types 
Name  Current Value 

Program Development End Date Bound Attachments 
Name  Current Value 

Program Development End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Program Development End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Program Development End Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
PROG_DEV_END_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
PROG_DEV_END_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
PROG_DEV_END_DTE 
NO     

Program Development End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Program Development End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Program Development End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Program Development End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Instrument Development Team End Date 
Base Entity  Run Cycle 
Attribute Name  Instrument Development Team End Date 
Logical Rolename   
ColumnName  IDT_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Instrument Development Team End Date Logical Attribute Properties 
Logical Attribute Name  Instrument Development Team End Date 
Datatype  DATE 
Nullable  NO 

Instrument Development Team End Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Instrument Development Team End Date Security Types 
Name  Current Value 

Instrument Development Team End Date Bound Attachments 
Name  Current Value 

Instrument Development Team End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Instrument Development Team End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Instrument Development Team End Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
IDT_END_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
IDT_END_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
IDT_END_DTE 
NO     

Instrument Development Team End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Development Team End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Development Team End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Instrument Development Team End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Operational Feasibiity Review Start Date 
Base Entity  Run Cycle 
Attribute Name  Operational Feasibiity Review Start Date 
Logical Rolename   
ColumnName  OPER_FEAS_REV_STRT_DTE 
RoleName   
Domain   
Logical Only  NO 
Definition 
 
Note 
 

Operational Feasibiity Review Start Date Logical Attribute Properties 
Logical Attribute Name  Operational Feasibiity Review Start Date 
Datatype  DATE 
Nullable  YES 

Operational Feasibiity Review Start Date Domain Restrictions 

CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default   
Bound Default   
Operational Feasibiity Review Start Date Security Types 
Name  Current Value 

Operational Feasibiity Review Start Date Bound Attachments 
Name  Current Value 

Operational Feasibiity Review Start Date Data Movement Rules 
Name  Type  Rule Text/Value 

Operational Feasibiity Review Start Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Operational Feasibiity Review Start Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
OPER_FEAS_REV_STRT_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
OPER_FEAS_REV_STRT_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
OPER_FEAS_REV_STRT_DTE 
NO     

Operational Feasibiity Review Start Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operational Feasibiity Review Start Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Operational Feasibiity Review Start Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Operational Feasibiity Review Start Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Supplemental Call End Date 
Base Entity  Run Cycle 
Attribute Name  Supplemental Call End Date 
Logical Rolename   
ColumnName  SUP_CALL_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Date: Date and time to seconds.
 
Note 
 

Supplemental Call End Date Logical Attribute Properties 
Logical Attribute Name  Supplemental Call End Date 
Datatype  DATE 
Nullable  NO 

Supplemental Call End Date Domain Restrictions 
CheckConstraint   
Check Constraint Name   
Bound Rule   
Declared Default  sysdate 
Bound Default   

Supplemental Call End Date Security Types 
Name  Current Value 

Supplemental Call End Date Bound Attachments 
Name  Current Value 

Supplemental Call End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Supplemental Call End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Supplemental Call End Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
SUP_CALL_END_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
SUP_CALL_END_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
SUP_CALL_END_DTE 
NO     

Supplemental Call End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Call End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Call End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Supplemental Call End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description 


Default End Date 
Base Entity  Run Cycle 
Attribute Name  Default End Date 
Logical Rolename   
ColumnName  DEF_END_DTE 
RoleName   
Domain  Date 
Logical Only  NO 
Definition 
Default End Date: Run Cycle cut off date for proposal types not explicitly defined in their own attribute.
 
Note 
 

Default End Date Logical Attribute Properties 
Logical Attribute Name  Default End Date 
Datatype  DATE 
Nullable  NO 

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

Default End Date Security Types 
Name  Current Value 

Default End Date Bound Attachments 
Name  Current Value 

Default End Date Data Movement Rules 
Name  Type  Rule Text/Value 

Default End Date Where Used 
Mapped Object  Is User Defined?  Description  Bound Attachments 
Logical
Run Cycle
Default End Date 
NO     
IPTSv5 (Oracle)
RUN_CYCLE
DEF_END_DTE 
NO     
PRPSL (Oracle)
RUN_CYCLE
DEF_END_DTE 
NO     
XF_ADMIN (Oracle)
RUN_CYCLE
DEF_END_DTE 
NO     

Default End Date Direct Source Mappings 
Columns  Transformation Logic  Transformation Description 

Default End Date Secondary Source Mappings 
Columns  Transformation Logic  Transformation Description 

Default End Date Direct Target Mappings 
Columns  Transformation Logic  Transformation Description 

Default End Date Secondary Target Mappings 
Columns  Transformation Logic  Transformation Description