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