| Proposal Identifier |
| Base Entity | Additional Reviewer |
| 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 Additional Reviewer Proposal Identifier |
NO | ||
| CNMS_PRPSL (Oracle) ADDNL_REV 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 |
| First Name |
| Base Entity | Additional Reviewer |
| Attribute Name | First Name |
| Logical Rolename | |
| ColumnName | FIRST_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | First Name: |
| Note |
| First Name Logical Attribute Properties |
| Logical Attribute Name | First Name |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| First Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| First Name Security Types |
| Name | Current Value |
| First Name Bound Attachments |
| Name | Current Value |
| First Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| First Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Additional Reviewer First Name |
NO | ||
| CNMS_PRPSL (Oracle) ADDNL_REV FIRST_NM |
NO |
| First Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| First Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name |
| Base Entity | Additional Reviewer |
| Attribute Name | Last Name |
| Logical Rolename | |
| ColumnName | LAST_NM |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Last Name: |
| Note |
| Last Name Logical Attribute Properties |
| Logical Attribute Name | Last Name |
| Datatype | VARCHAR(64) |
| Nullable | NO |
| Last Name Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Last Name Security Types |
| Name | Current Value |
| Last Name Bound Attachments |
| Name | Current Value |
| Last Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Last Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Additional Reviewer Last Name |
NO | ||
| CNMS_PRPSL (Oracle) ADDNL_REV LAST_NM |
NO |
| Last Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Last Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute |
| Base Entity | Additional Reviewer |
| Attribute Name | Institute |
| Logical Rolename | |
| ColumnName | INST |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Institute Logical Attribute Properties |
| Logical Attribute Name | Institute |
| Datatype | VARCHAR(255) |
| Nullable | NO |
| Institute Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Institute Security Types |
| Name | Current Value |
| Institute Bound Attachments |
| Name | Current Value |
| Institute Data Movement Rules |
| Name | Type | Rule Text/Value |
| Institute Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Additional Reviewer Institute |
NO | ||
| CNMS_PRPSL (Oracle) ADDNL_REV INST |
NO |
| Institute Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Institute Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |