| Proposal Identifier |
| Base Entity | Proposal |
| Attribute Name | Proposal Identifier |
| Logical Rolename | |
| ColumnName | PRPSL_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Proposal Identifier: Unique identifer assigned to the proposal. |
| Note |
| Proposal Identifier Logical Attribute Properties |
| Logical Attribute Name | Proposal Identifier |
| Datatype | VARCHAR(10) |
| 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 Proposal Proposal Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL PRPSL_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL PRPSL_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL PRPSL_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL PRPSL_ID |
NO | ||
| PUBL (Oracle) PROPOSAL PRPSL_ID |
NO | ||
| SMPL (Oracle) PROPOSAL 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 |
| User Access Identifer |
| Base Entity | Proposal |
| Attribute Name | User Access Identifer |
| Logical Rolename | |
| ColumnName | USER_ACCESS_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Proposal Type Idenitifer: Abbreviated identifer for the type of proposal. (General user. Partner user). Mandatory but enforced through the UI. |
| Note |
| User Access Identifer Logical Attribute Properties |
| Logical Attribute Name | User Access Identifer |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| User Access Identifer Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| User Access Identifer Security Types |
| Name | Current Value |
| User Access Identifer Bound Attachments |
| Name | Current Value |
| User Access Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| User Access Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal User Access Identifer |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL USER_ACCESS_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL USER_ACCESS_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL USER_ACCESS_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL USER_ACCESS_ID |
NO | ||
| PUBL (Oracle) PROPOSAL USER_ACCESS_ID |
NO | ||
| SMPL (Oracle) PROPOSAL USER_ACCESS_ID |
NO |
| User Access Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Access Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Access Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| User Access Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Acess Indicator |
| Base Entity | Proposal |
| Attribute Name | Rapid Acess Indicator |
| Logical Rolename | |
| ColumnName | RAPID_ACC_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Rapid Acess Indicator Logical Attribute Properties |
| Logical Attribute Name | Rapid Acess Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Rapid Acess Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Rapid Acess 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 |
| Rapid Acess Indicator Security Types |
| Name | Current Value |
| Rapid Acess Indicator Bound Attachments |
| Name | Current Value |
| Rapid Acess Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Rapid Acess Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Rapid Acess Indicator |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL RAPID_ACC_IND |
NO | ||
| EXPRESS (Oracle) PROPOSAL RAPID_ACC_IND |
NO | ||
| IPTSv5 (Oracle) PROPOSAL RAPID_ACC_IND |
NO | ||
| PRPSL (Oracle) PROPOSAL RAPID_ACC_IND |
NO | ||
| PUBL (Oracle) PROPOSAL RAPID_ACC_IND |
NO | ||
| SMPL (Oracle) PROPOSAL RAPID_ACC_IND |
NO |
| Rapid Acess Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Acess Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Acess Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Acess Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Access Justification |
| Base Entity | Proposal |
| Attribute Name | Rapid Access Justification |
| Logical Rolename | |
| ColumnName | RA_JUST |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Rapid Access Justification Logical Attribute Properties |
| Logical Attribute Name | Rapid Access Justification |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Rapid Access Justification Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Rapid Access Justification Security Types |
| Name | Current Value |
| Rapid Access Justification Bound Attachments |
| Name | Current Value |
| Rapid Access Justification Data Movement Rules |
| Name | Type | Rule Text/Value |
| Rapid Access Justification Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Rapid Access Justification |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL RA_JUST |
NO | ||
| EXPRESS (Oracle) PROPOSAL RA_JUST |
NO | ||
| IPTSv5 (Oracle) PROPOSAL RA_JUST |
NO | ||
| PRPSL (Oracle) PROPOSAL RA_JUST |
NO | ||
| PUBL (Oracle) PROPOSAL RA_JUST |
NO | ||
| SMPL (Oracle) PROPOSAL RA_JUST |
NO |
| Rapid Access Justification Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Access Justification Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Access Justification Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rapid Access Justification Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier |
| Base Entity | Proposal |
| Attribute Name | Status Identifier |
| Logical Rolename | |
| ColumnName | STAT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Status Identifer: Abbreviated idenfifer for the given status. |
| Note |
| Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Status Identifier |
| Datatype | VARCHAR(20) |
| Nullable | NO |
| Status Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Status Identifier Security Types |
| Name | Current Value |
| Status Identifier Bound Attachments |
| Name | Current Value |
| Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Status Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL STAT_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL STAT_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL STAT_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL STAT_ID |
NO | ||
| PUBL (Oracle) PROPOSAL STAT_ID |
NO | ||
| SMPL (Oracle) PROPOSAL STAT_ID |
NO |
| Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Review Status Identifier |
| Base Entity | Proposal |
| Attribute Name | Review Status Identifier |
| Logical Rolename | |
| ColumnName | REVIEW_STAT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Status Identifer: Abbreviated idenfifer for the given status. |
| Note |
| Review Status Identifier Logical Attribute Properties |
| Logical Attribute Name | Review Status Identifier |
| Datatype | VARCHAR(20) |
| Nullable | YES |
| Review Status Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Review Status Identifier Security Types |
| Name | Current Value |
| Review Status Identifier Bound Attachments |
| Name | Current Value |
| Review Status Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Review Status Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Review Status Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL REVIEW_STAT_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL REVIEW_STAT_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL REVIEW_STAT_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL REVIEW_STAT_ID |
NO | ||
| PUBL (Oracle) PROPOSAL REVIEW_STAT_ID |
NO | ||
| SMPL (Oracle) PROPOSAL REVIEW_STAT_ID |
NO |
| Review Status Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Review Status Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Review Status Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Review Status Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TItle |
| Base Entity | Proposal |
| Attribute Name | TItle |
| Logical Rolename | |
| ColumnName | TITLE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Title: The title for the proposed experiment. |
| Note |
| TItle Logical Attribute Properties |
| Logical Attribute Name | TItle |
| Datatype | VARCHAR(128) |
| Nullable | NO |
| TItle Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| TItle Security Types |
| Name | Current Value |
| TItle Bound Attachments |
| Name | Current Value |
| TItle Data Movement Rules |
| Name | Type | Rule Text/Value |
| TItle Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal TItle |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL TITLE |
NO | ||
| EXPRESS (Oracle) PROPOSAL TITLE |
NO | ||
| IPTSv5 (Oracle) PROPOSAL TITLE |
NO | ||
| PRPSL (Oracle) PROPOSAL TITLE |
NO | ||
| PUBL (Oracle) PROPOSAL TITLE |
NO | ||
| SMPL (Oracle) PROPOSAL TITLE |
NO |
| TItle Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TItle Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| TItle Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| TItle Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Reason for Facility Use |
| Base Entity | Proposal |
| Attribute Name | Reason for Facility Use |
| Logical Rolename | |
| ColumnName | REASON_USE |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Abstract: Abstract for the proposed experiment. Mandatory but enforced through the UI. |
| Note |
| Reason for Facility Use Logical Attribute Properties |
| Logical Attribute Name | Reason for Facility Use |
| Datatype | VARCHAR(500) |
| Nullable | YES |
| Reason for Facility Use Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Reason for Facility Use Security Types |
| Name | Current Value |
| Reason for Facility Use Bound Attachments |
| Name | Current Value |
| Reason for Facility Use Data Movement Rules |
| Name | Type | Rule Text/Value |
| Reason for Facility Use Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Reason for Facility Use |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL REASON_USE |
NO | ||
| EXPRESS (Oracle) PROPOSAL REASON_USE |
NO | ||
| IPTSv5 (Oracle) PROPOSAL REASON_USE |
NO | ||
| PRPSL (Oracle) PROPOSAL REASON_USE |
NO | ||
| PUBL (Oracle) PROPOSAL REASON_USE |
NO | ||
| SMPL (Oracle) PROPOSAL REASON_USE |
NO |
| Reason for Facility Use Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Reason for Facility Use Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Reason for Facility Use Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Reason for Facility Use Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cycle Identifier |
| Base Entity | Proposal |
| Attribute Name | Cycle Identifier |
| Logical Rolename | |
| ColumnName | CY_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Run Cycle Identifier: Identifer for the run cycle period. Mandatory but enforced through the UI. |
| Note |
| Cycle Identifier Logical Attribute Properties |
| Logical Attribute Name | Cycle Identifier |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| 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 Proposal Cycle Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL CY_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL CY_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL CY_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL CY_ID |
NO | ||
| PUBL (Oracle) PROPOSAL CY_ID |
NO | ||
| SMPL (Oracle) PROPOSAL 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 |
| Staff Contacted Indicator |
| Base Entity | Proposal |
| Attribute Name | Staff Contacted Indicator |
| Logical Rolename | |
| ColumnName | STAFF_CONT_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Instrument Scientist Contacted Indicator: Indicates if the PI contacted an facilityt scientist for a given instrument. Mandatory but enforced through the UI. |
| Note |
| Staff Contacted Indicator Logical Attribute Properties |
| Logical Attribute Name | Staff Contacted Indicator |
| Datatype | CHAR(1) |
| Nullable | YES |
| Staff Contacted Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Staff Contacted 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 |
| Staff Contacted Indicator Security Types |
| Name | Current Value |
| Staff Contacted Indicator Bound Attachments |
| Name | Current Value |
| Staff Contacted Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Staff Contacted Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Staff Contacted Indicator |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL STAFF_CONT_IND |
NO | ||
| EXPRESS (Oracle) PROPOSAL STAFF_CONT_IND |
NO | ||
| IPTSv5 (Oracle) PROPOSAL STAFF_CONT_IND |
NO | ||
| PRPSL (Oracle) PROPOSAL STAFF_CONT_IND |
NO | ||
| PUBL (Oracle) PROPOSAL STAFF_CONT_IND |
NO | ||
| SMPL (Oracle) PROPOSAL STAFF_CONT_IND |
NO |
| Staff Contacted Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Staff Contacted Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Staff Contacted Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Staff Contacted Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier |
| Base Entity | Proposal |
| Attribute Name | Institute Identifier |
| Logical Rolename | |
| ColumnName | INST_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Institute Identifer: Abbreviated identifier for a institute. |
| Note |
| Institute Identifier Logical Attribute Properties |
| Logical Attribute Name | Institute Identifier |
| Datatype | INTEGER |
| Nullable | NO |
| Institute Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Institute Identifier Security Types |
| Name | Current Value |
| Institute Identifier Bound Attachments |
| Name | Current Value |
| Institute Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Institute Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL INST_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL INST_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL INST_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL INST_ID |
NO | ||
| PUBL (Oracle) PROPOSAL INST_ID |
NO | ||
| SMPL (Oracle) PROPOSAL INST_ID |
NO |
| Institute Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier |
| Base Entity | Proposal |
| Attribute Name | Person Identifier |
| Logical Rolename | |
| ColumnName | PERSON_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Person Identifier: Unique identifier for a person derived from XCAMS. |
| Note |
| Person Identifier Logical Attribute Properties |
| Logical Attribute Name | Person Identifier |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Person Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Person Identifier Security Types |
| Name | Current Value |
| Person Identifier Bound Attachments |
| Name | Current Value |
| Person Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Person Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Person Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL PERSON_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL PERSON_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL PERSON_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL PERSON_ID |
NO | ||
| PUBL (Oracle) PROPOSAL PERSON_ID |
NO | ||
| SMPL (Oracle) PROPOSAL PERSON_ID |
NO |
| Person Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Person Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Begin Work Date |
| Base Entity | Proposal |
| Attribute Name | Requested Begin Work Date |
| Logical Rolename | |
| ColumnName | REQ_BEGIN_WORK_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Requested Begin Work Date Logical Attribute Properties |
| Logical Attribute Name | Requested Begin Work Date |
| Datatype | DATE |
| Nullable | NO |
| Requested Begin Work Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Requested Begin Work Date Security Types |
| Name | Current Value |
| Requested Begin Work Date Bound Attachments |
| Name | Current Value |
| Requested Begin Work Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Requested Begin Work Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Requested Begin Work Date |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL REQ_BEGIN_WORK_DTE |
NO | ||
| EXPRESS (Oracle) PROPOSAL REQ_BEGIN_WORK_DTE |
NO | ||
| IPTSv5 (Oracle) PROPOSAL REQ_BEGIN_WORK_DTE |
NO | ||
| PRPSL (Oracle) PROPOSAL REQ_BEGIN_WORK_DTE |
NO | ||
| PUBL (Oracle) PROPOSAL REQ_BEGIN_WORK_DTE |
NO | ||
| SMPL (Oracle) PROPOSAL REQ_BEGIN_WORK_DTE |
NO |
| Requested Begin Work Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Begin Work Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Begin Work Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Begin Work Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Day Number |
| Base Entity | Proposal |
| Attribute Name | Requested Day Number |
| Logical Rolename | |
| ColumnName | REQ_DAY_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Requested Day Number: The number of days at CNMS requested by the PI. Mandatory but enforced through the UI. |
| Note |
| Requested Day Number Logical Attribute Properties |
| Logical Attribute Name | Requested Day Number |
| Datatype | NUMERIC(3, 0) |
| Nullable | YES |
| Requested Day Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Requested Day Number Security Types |
| Name | Current Value |
| Requested Day Number Bound Attachments |
| Name | Current Value |
| Requested Day Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Requested Day Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Requested Day Number |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL REQ_DAY_NBR |
NO | ||
| EXPRESS (Oracle) PROPOSAL REQ_DAY_NBR |
NO | ||
| IPTSv5 (Oracle) PROPOSAL REQ_DAY_NBR |
NO | ||
| PRPSL (Oracle) PROPOSAL REQ_DAY_NBR |
NO | ||
| PUBL (Oracle) PROPOSAL REQ_DAY_NBR |
NO | ||
| SMPL (Oracle) PROPOSAL REQ_DAY_NBR |
NO |
| Requested Day Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Day Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Day Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Requested Day Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Actual Day Number |
| Base Entity | Proposal |
| Attribute Name | Actual Day Number |
| Logical Rolename | |
| ColumnName | ACT_DAY_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Actual Day Number: The number of days at CNMS granted to the experiment. |
| Note |
| Actual Day Number Logical Attribute Properties |
| Logical Attribute Name | Actual Day Number |
| Datatype | NUMERIC(3, 0) |
| Nullable | YES |
| Actual Day Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Actual Day Number Security Types |
| Name | Current Value |
| Actual Day Number Bound Attachments |
| Name | Current Value |
| Actual Day Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Actual Day Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Actual Day Number |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL ACT_DAY_NBR |
NO | ||
| EXPRESS (Oracle) PROPOSAL ACT_DAY_NBR |
NO | ||
| IPTSv5 (Oracle) PROPOSAL ACT_DAY_NBR |
NO | ||
| PRPSL (Oracle) PROPOSAL ACT_DAY_NBR |
NO | ||
| PUBL (Oracle) PROPOSAL ACT_DAY_NBR |
NO | ||
| SMPL (Oracle) PROPOSAL ACT_DAY_NBR |
NO |
| Actual Day Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Actual Day Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Actual Day Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Actual Day Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Category Identifier |
| Base Entity | Proposal |
| Attribute Name | Proposal Category Identifier |
| Logical Rolename | |
| ColumnName | PRPSL_CAT_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Proposal Category Identifier Logical Attribute Properties |
| Logical Attribute Name | Proposal Category Identifier |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Proposal Category Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Proposal Category Identifier Security Types |
| Name | Current Value |
| Proposal Category Identifier Bound Attachments |
| Name | Current Value |
| Proposal Category Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Category Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Proposal Category Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL PRPSL_CAT_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL PRPSL_CAT_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL PRPSL_CAT_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL PRPSL_CAT_ID |
NO | ||
| PUBL (Oracle) PROPOSAL PRPSL_CAT_ID |
NO | ||
| SMPL (Oracle) PROPOSAL PRPSL_CAT_ID |
NO |
| Proposal Category Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Category Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Category Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Category Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Date |
| Base Entity | Proposal |
| Attribute Name | Proposal Date |
| Logical Rolename | |
| ColumnName | PRPSL_DTE |
| RoleName | |
| Domain | Date |
| Logical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| Proposal Date Logical Attribute Properties |
| Logical Attribute Name | Proposal Date |
| Datatype | DATE |
| Nullable | NO |
| Proposal Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| Proposal Date Security Types |
| Name | Current Value |
| Proposal Date Bound Attachments |
| Name | Current Value |
| Proposal Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Proposal Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Proposal Date |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL PRPSL_DTE |
NO | ||
| EXPRESS (Oracle) PROPOSAL PRPSL_DTE |
NO | ||
| IPTSv5 (Oracle) PROPOSAL PRPSL_DTE |
NO | ||
| PRPSL (Oracle) PROPOSAL PRPSL_DTE |
NO | ||
| PUBL (Oracle) PROPOSAL PRPSL_DTE |
NO | ||
| SMPL (Oracle) PROPOSAL PRPSL_DTE |
NO |
| Proposal Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Proposal Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date |
| Base Entity | Proposal |
| Attribute Name | Modify Date |
| Logical Rolename | |
| ColumnName | MOD_DATE |
| RoleName | |
| Domain | Modify Date |
| Logical Only | NO |
| Definition | Modify Date: The date the entity values were were created or modified. |
| Note |
| Modify Date Logical Attribute Properties |
| Logical Attribute Name | Modify Date |
| Datatype | DATE |
| Nullable | NO |
| Modify Date Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Modify Date Security Types |
| Name | Current Value |
| Modify Date Bound Attachments |
| Name | Current Value |
| Modify Date Data Movement Rules |
| Name | Type | Rule Text/Value |
| Modify Date Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Modify Date |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL MOD_DATE |
NO | ||
| EXPRESS (Oracle) PROPOSAL MOD_DATE |
NO | ||
| IPTSv5 (Oracle) PROPOSAL MOD_DATE |
NO | ||
| PRPSL (Oracle) PROPOSAL MOD_DATE |
NO | ||
| PUBL (Oracle) PROPOSAL MOD_DATE |
NO | ||
| SMPL (Oracle) PROPOSAL MOD_DATE |
NO |
| Modify Date Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Modify Date Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Apex Page Number |
| Base Entity | Proposal |
| Attribute Name | Apex Page Number |
| Logical Rolename | |
| ColumnName | APEX_PAGE_NBR |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Apex Page Number Logical Attribute Properties |
| Logical Attribute Name | Apex Page Number |
| Datatype | NUMERIC(4, 0) |
| Nullable | YES |
| Apex Page Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Apex Page Number Security Types |
| Name | Current Value |
| Apex Page Number Bound Attachments |
| Name | Current Value |
| Apex Page Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Apex Page Number Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Apex Page Number |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL APEX_PAGE_NBR |
NO | ||
| EXPRESS (Oracle) PROPOSAL APEX_PAGE_NBR |
NO | ||
| IPTSv5 (Oracle) PROPOSAL APEX_PAGE_NBR |
NO | ||
| PRPSL (Oracle) PROPOSAL APEX_PAGE_NBR |
NO | ||
| PUBL (Oracle) PROPOSAL APEX_PAGE_NBR |
NO | ||
| SMPL (Oracle) PROPOSAL APEX_PAGE_NBR |
NO |
| Apex Page Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Apex Page Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Apex Page Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Apex Page Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Condition |
| Base Entity | Proposal |
| Attribute Name | Special Condition |
| Logical Rolename | |
| ColumnName | SPEC_COND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Special Condition Logical Attribute Properties |
| Logical Attribute Name | Special Condition |
| Datatype | VARCHAR(4000) |
| Nullable | YES |
| Special Condition Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Special Condition Security Types |
| Name | Current Value |
| Special Condition Bound Attachments |
| Name | Current Value |
| Special Condition Data Movement Rules |
| Name | Type | Rule Text/Value |
| Special Condition Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Special Condition |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL SPEC_COND |
NO | ||
| EXPRESS (Oracle) PROPOSAL SPEC_COND |
NO | ||
| IPTSv5 (Oracle) PROPOSAL SPEC_COND |
NO | ||
| PRPSL (Oracle) PROPOSAL SPEC_COND |
NO | ||
| PUBL (Oracle) PROPOSAL SPEC_COND |
NO | ||
| SMPL (Oracle) PROPOSAL SPEC_COND |
NO |
| Special Condition Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Condition Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Condition Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Special Condition Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Partner User Description |
| Base Entity | Proposal |
| Attribute Name | Partner User Description |
| Logical Rolename | |
| ColumnName | PART_USER_DESCR |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
| Note |
| Partner User Description Logical Attribute Properties |
| Logical Attribute Name | Partner User Description |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| Partner User Description Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Partner User Description Security Types |
| Name | Current Value |
| Partner User Description Bound Attachments |
| Name | Current Value |
| Partner User Description Data Movement Rules |
| Name | Type | Rule Text/Value |
| Partner User Description Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Partner User Description |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL PART_USER_DESCR |
NO | ||
| EXPRESS (Oracle) PROPOSAL PART_USER_DESCR |
NO | ||
| IPTSv5 (Oracle) PROPOSAL PART_USER_DESCR |
NO | ||
| PRPSL (Oracle) PROPOSAL PART_USER_DESCR |
NO | ||
| PUBL (Oracle) PROPOSAL PART_USER_DESCR |
NO | ||
| SMPL (Oracle) PROPOSAL PART_USER_DESCR |
NO |
| Partner User Description Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Partner User Description Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Partner User Description Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Partner User Description Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Identifier |
| Base Entity | Proposal |
| Attribute Name | Research Safety Sheet Identifier |
| Logical Rolename | |
| ColumnName | RSS_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Research Safety Sheet Identifier Logical Attribute Properties |
| Logical Attribute Name | Research Safety Sheet Identifier |
| Datatype | NUMERIC(38, 0) |
| Nullable | YES |
| Research Safety Sheet Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Research Safety Sheet Identifier Security Types |
| Name | Current Value |
| Research Safety Sheet Identifier Bound Attachments |
| Name | Current Value |
| Research Safety Sheet Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Research Safety Sheet Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Research Safety Sheet Identifier |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL RSS_ID |
NO | ||
| EXPRESS (Oracle) PROPOSAL RSS_ID |
NO | ||
| IPTSv5 (Oracle) PROPOSAL RSS_ID |
NO | ||
| PRPSL (Oracle) PROPOSAL RSS_ID |
NO | ||
| PUBL (Oracle) PROPOSAL RSS_ID |
NO | ||
| SMPL (Oracle) PROPOSAL RSS_ID |
NO |
| Research Safety Sheet Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Comment |
| Base Entity | Proposal |
| Attribute Name | Research Safety Sheet Comment |
| Logical Rolename | |
| ColumnName | RSS_CMNT |
| RoleName | |
| Domain | Comment |
| Logical Only | NO |
| Definition | Comment: General comments. |
| Note |
| Research Safety Sheet Comment Logical Attribute Properties |
| Logical Attribute Name | Research Safety Sheet Comment |
| Datatype | VARCHAR(2000) |
| Nullable | YES |
| Research Safety Sheet Comment Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Research Safety Sheet Comment Security Types |
| Name | Current Value |
| Research Safety Sheet Comment Bound Attachments |
| Name | Current Value |
| Research Safety Sheet Comment Data Movement Rules |
| Name | Type | Rule Text/Value |
| Research Safety Sheet Comment Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Research Safety Sheet Comment |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL RSS_CMNT |
NO | ||
| EXPRESS (Oracle) PROPOSAL RSS_CMNT |
NO | ||
| IPTSv5 (Oracle) PROPOSAL RSS_CMNT |
NO | ||
| PRPSL (Oracle) PROPOSAL RSS_CMNT |
NO | ||
| PUBL (Oracle) PROPOSAL RSS_CMNT |
NO | ||
| SMPL (Oracle) PROPOSAL RSS_CMNT |
NO |
| Research Safety Sheet Comment Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Comment Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Comment Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Research Safety Sheet Comment Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Group Leader Approve Indicator |
| Base Entity | Proposal |
| Attribute Name | Group Leader Approve Indicator |
| Logical Rolename | |
| ColumnName | GRP_LEAD_APRV_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Group Leader Approve Indicator Logical Attribute Properties |
| Logical Attribute Name | Group Leader Approve Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Group Leader Approve Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Group Leader Approve 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 |
| Group Leader Approve Indicator Security Types |
| Name | Current Value |
| Group Leader Approve Indicator Bound Attachments |
| Name | Current Value |
| Group Leader Approve Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Group Leader Approve Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Proposal Group Leader Approve Indicator |
NO | ||
| CNMS_PRPSL (Oracle) PROPOSAL GRP_LEAD_APRV_IND |
NO | ||
| EXPRESS (Oracle) PROPOSAL GRP_LEAD_APRV_IND |
NO | ||
| IPTSv5 (Oracle) PROPOSAL GRP_LEAD_APRV_IND |
NO | ||
| PRPSL (Oracle) PROPOSAL GRP_LEAD_APRV_IND |
NO | ||
| PUBL (Oracle) PROPOSAL GRP_LEAD_APRV_IND |
NO | ||
| SMPL (Oracle) PROPOSAL GRP_LEAD_APRV_IND |
NO |
| Group Leader Approve Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Group Leader Approve Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Group Leader Approve Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Group Leader Approve Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |