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