| Subcommittee Identifier |
| Base Entity | Review Subcommittee |
| Attribute Name | Subcommittee Identifier |
| Logical Rolename | |
| ColumnName | SUBCOMM_ID |
| RoleName | |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Subcommittee Identifier Logical Attribute Properties |
| Logical Attribute Name | Subcommittee Identifier |
| Datatype | VARCHAR(25) |
| Nullable | NO |
| Subcommittee Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Subcommittee Identifier Security Types |
| Name | Current Value |
| Subcommittee Identifier Bound Attachments |
| Name | Current Value |
| Subcommittee Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Subcommittee Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Subcommittee Identifier |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM SUBCOMM_ID |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM SUBCOMM_ID |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM SUBCOMM_ID |
NO |
| Subcommittee Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommittee Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommittee Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommittee Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Subcommittee Identifier |
| Base Entity | Review Subcommittee |
| Attribute Name | Subcommittee Identifier |
| Logical Rolename | Parent Subcommittee Identifier |
| ColumnName | PARENT_SUBCOMMID |
| RoleName | PARENT_SUBCOMMID |
| Domain | Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Parent Subcommittee Identifier Logical Attribute Properties |
| Logical Attribute Name | Subcommittee Identifier |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Parent Subcommittee Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Parent Subcommittee Identifier Security Types |
| Name | Current Value |
| Parent Subcommittee Identifier Bound Attachments |
| Name | Current Value |
| Parent Subcommittee Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Parent Subcommittee Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Subcommittee Identifier |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM PARENT_SUBCOMMID |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM PARENT_SUBCOMMID |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM PARENT_SUBCOMMID |
NO |
| Parent Subcommittee Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Subcommittee Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Subcommittee Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Parent Subcommittee Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Name |
| Base Entity | Review Subcommittee |
| Attribute Name | Subcommitte Name |
| Logical Rolename | |
| ColumnName | SUBCOMM_NM |
| RoleName | |
| Domain | Name |
| Logical Only | NO |
| Definition | Name: A long description name usually accompanied by an abbreviated code. |
| Note |
| Subcommitte Name Logical Attribute Properties |
| Logical Attribute Name | Subcommitte Name |
| Datatype | VARCHAR(120) |
| Nullable | YES |
| Subcommitte Name Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Subcommitte Name Security Types |
| Name | Current Value |
| Subcommitte Name Bound Attachments |
| Name | Current Value |
| Subcommitte Name Data Movement Rules |
| Name | Type | Rule Text/Value |
| Subcommitte Name Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Subcommitte Name |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM SUBCOMM_NM |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM SUBCOMM_NM |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM SUBCOMM_NM |
NO |
| Subcommitte Name Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Name Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Name Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Name Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Proposal PDF |
| Base Entity | Review Subcommittee |
| Attribute Name | Subcommitte Proposal PDF |
| Logical Rolename | |
| ColumnName | SUBCOMM_PRPSL_PDF |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Subcommitte Proposal PDF Logical Attribute Properties |
| Logical Attribute Name | Subcommitte Proposal PDF |
| Datatype | VARBINARY/BLOB(50) |
| Nullable | YES |
| Subcommitte Proposal PDF Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Subcommitte Proposal PDF Security Types |
| Name | Current Value |
| Subcommitte Proposal PDF Bound Attachments |
| Name | Current Value |
| Subcommitte Proposal PDF Data Movement Rules |
| Name | Type | Rule Text/Value |
| Subcommitte Proposal PDF Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Subcommitte Proposal PDF |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM SUBCOMM_PRPSL_PDF |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM SUBCOMM_PRPSL_PDF |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM SUBCOMM_PRPSL_PDF |
NO |
| Subcommitte Proposal PDF Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Proposal PDF Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Proposal PDF Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subcommitte Proposal PDF Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Supplemental Proposal Call Indicator |
| Base Entity | Review Subcommittee |
| Attribute Name | Supplemental Proposal Call Indicator |
| Logical Rolename | |
| ColumnName | SUP_PRPSL_CALL_IND |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | |
| Note |
| Supplemental Proposal Call Indicator Logical Attribute Properties |
| Logical Attribute Name | Supplemental Proposal Call Indicator |
| Datatype | CHAR(1) |
| Nullable | NO |
| Supplemental Proposal Call Indicator Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Supplemental Proposal Call 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 |
| Supplemental Proposal Call Indicator Security Types |
| Name | Current Value |
| Supplemental Proposal Call Indicator Bound Attachments |
| Name | Current Value |
| Supplemental Proposal Call Indicator Data Movement Rules |
| Name | Type | Rule Text/Value |
| Supplemental Proposal Call Indicator Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Supplemental Proposal Call Indicator |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM SUP_PRPSL_CALL_IND |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM SUP_PRPSL_CALL_IND |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM SUP_PRPSL_CALL_IND |
NO |
| Supplemental Proposal Call Indicator Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Supplemental Proposal Call Indicator Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Supplemental Proposal Call Indicator Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Supplemental Proposal Call Indicator Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minimum Reviewer |
| Base Entity | Review Subcommittee |
| Attribute Name | Minimum Reviewer |
| Logical Rolename | |
| ColumnName | MIN_REV |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Minimum Reviewer Logical Attribute Properties |
| Logical Attribute Name | Minimum Reviewer |
| Datatype | INTEGER |
| Nullable | YES |
| Minimum Reviewer Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Minimum Reviewer Security Types |
| Name | Current Value |
| Minimum Reviewer Bound Attachments |
| Name | Current Value |
| Minimum Reviewer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Minimum Reviewer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Minimum Reviewer |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM MIN_REV |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM MIN_REV |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM MIN_REV |
NO |
| Minimum Reviewer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minimum Reviewer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minimum Reviewer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Minimum Reviewer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Maximum Reviewer |
| Base Entity | Review Subcommittee |
| Attribute Name | Maximum Reviewer |
| Logical Rolename | |
| ColumnName | MAX_REV |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Maximum Reviewer Logical Attribute Properties |
| Logical Attribute Name | Maximum Reviewer |
| Datatype | INTEGER |
| Nullable | YES |
| Maximum Reviewer Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Maximum Reviewer Security Types |
| Name | Current Value |
| Maximum Reviewer Bound Attachments |
| Name | Current Value |
| Maximum Reviewer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Maximum Reviewer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Review Subcommittee Maximum Reviewer |
NO | ||
| IPTSv5 (Oracle) REV_SUBCOMM MAX_REV |
NO | ||
| PRPSL (Oracle) REV_SUBCOMM MAX_REV |
NO | ||
| XF_ADMIN (Oracle) REV_SUBCOMM MAX_REV |
NO |
| Maximum Reviewer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Maximum Reviewer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Maximum Reviewer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Maximum Reviewer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |