| Cycle Identifier |
| Base Entity | Experiment Cycle |
| Attribute Name | Cycle Identifier |
| Logical Rolename | |
| ColumnName | CY_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Run Cycle Identifier: Identifer for the run cycle period. |
| Note |
| Cycle Identifier Logical Attribute Properties |
| Logical Attribute Name | Cycle Identifier |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| Cycle Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Cycle Identifier Security Types |
| Name | Current Value |
| Cycle Identifier Bound Attachments |
| Name | Current Value |
| Cycle Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Cycle Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Cycle Cycle Identifier |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE CY_ID |
NO |
| Cycle Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Sequence Start Number |
| Base Entity | Experiment Cycle |
| Attribute Name | Cycle Sequence Start Number |
| Logical Rolename | |
| ColumnName | CY_SEQ_STRT_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Cycle Sequence Start Number Logical Attribute Properties |
| Logical Attribute Name | Cycle Sequence Start Number |
| Datatype | NUMERIC(3, 0) |
| Nullable | NO |
| Cycle Sequence Start Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Cycle Sequence Start Number Security Types |
| Name | Current Value |
| Cycle Sequence Start Number Bound Attachments |
| Name | Current Value |
| Cycle Sequence Start Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Cycle Sequence Start Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Cycle Cycle Sequence Start Number |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE CY_SEQ_STRT_NBR |
NO |
| Cycle Sequence Start Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Sequence Start Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Sequence Start Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Sequence Start Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Begin Date |
| Base Entity | Experiment Cycle |
| Attribute Name | Cycle Begin Date |
| Logical Rolename | |
| ColumnName | CY_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 Experiment Cycle Cycle Begin Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE CY_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 | Experiment Cycle |
| Attribute Name | Cycle End Date |
| Logical Rolename | |
| ColumnName | CY_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 Experiment Cycle Cycle End Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE CY_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 Start Date |
| Base Entity | Experiment Cycle |
| Attribute Name | Proposal Start Date |
| Logical Rolename | |
| ColumnName | PRPSL_START_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Proposal Start Date Logical Attribute Properties |
| Logical Attribute Name | Proposal Start Date |
| Datatype | DATE |
| Nullable | NO |
| Proposal Start Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Proposal Start Date Security Types |
| Name | Current Value |
| Proposal Start Date Bound Attachments |
| Name | Current Value |
| Proposal Start Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Start Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Cycle Proposal Start Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE PRPSL_START_DTE |
NO |
| Proposal Start Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Start Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Start Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Start Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal End Date |
| Base Entity | Experiment 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 Experiment Cycle Proposal End Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_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 | Experiment 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 Experiment Cycle Feasibility Review Start Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_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 |
| Feasibiity Review End Date |
| Base Entity | Experiment Cycle |
| Attribute Name | Feasibiity Review End Date |
| Logical Rolename | |
| ColumnName | FEAS_REV_END_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Feasibiity Review End Date Logical Attribute Properties |
| Logical Attribute Name | Feasibiity Review End Date |
| Datatype | DATE |
| Nullable | NO |
| Feasibiity Review End Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Feasibiity Review End Date Security Types |
| Name | Current Value |
| Feasibiity Review End Date Bound Attachments |
| Name | Current Value |
| Feasibiity Review End Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Feasibiity Review End Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Cycle Feasibiity Review End Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE FEAS_REV_END_DTE |
NO |
| Feasibiity Review End Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Feasibiity Review End Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Feasibiity Review End Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Feasibiity Review End Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Review Final Date |
| Base Entity | Experiment 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 Experiment Cycle Review Final Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_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 |
| Instrument Scientist End Date |
| Base Entity | Experiment Cycle |
| Attribute Name | Instrument Scientist End Date |
| Logical Rolename | |
| ColumnName | INSTR_SCI_END_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Instrument Scientist End Date Logical Attribute Properties |
| Logical Attribute Name | Instrument Scientist End Date |
| Datatype | DATE |
| Nullable | NO |
| Instrument Scientist End Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Instrument Scientist End Date Security Types |
| Name | Current Value |
| Instrument Scientist End Date Bound Attachments |
| Name | Current Value |
| Instrument Scientist End Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Instrument Scientist End Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Experiment Cycle Instrument Scientist End Date |
NO | ||
| CNMS_PRPSL (Oracle) EXPT_CYCLE INSTR_SCI_END_DTE |
NO |
| Instrument Scientist End Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Scientist End Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Scientist End Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Instrument Scientist End Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |