Proposal Identifier |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | Proposal Identifier |
Logical Rolename | |
ColumnName | PRPSL_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Proposal Identifier Logical Attribute Properties |
Logical Attribute Name | Proposal Identifier |
Datatype | NUMERIC(10, 0) |
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 Instrument Group Chair Review Proposal Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV PRPSL_ID |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_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 |
Submission Number |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | Submission Number |
Logical Rolename | |
ColumnName | SUBMISS_NBR |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Submission Number Logical Attribute Properties |
Logical Attribute Name | Submission Number |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Submission Number Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Submission Number Security Types |
Name | Current Value |
Submission Number Bound Attachments |
Name | Current Value |
Submission Number Data Movement Rules |
Name | Type | Rule Text/Value |
Submission Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review Submission Number |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV SUBMISS_NBR |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV SUBMISS_NBR |
NO |
Submission Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Submission Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | FACIL_ID |
Logical Rolename | |
ColumnName | FACIL_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
FACIL_ID Logical Attribute Properties |
Logical Attribute Name | FACIL_ID |
Datatype | VARCHAR(10) |
Nullable | NO |
FACIL_ID Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
FACIL_ID Security Types |
Name | Current Value |
FACIL_ID Bound Attachments |
Name | Current Value |
FACIL_ID Data Movement Rules |
Name | Type | Rule Text/Value |
FACIL_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review FACIL_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV FACIL_ID |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV FACIL_ID |
NO |
FACIL_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FACIL_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
GRP_ID |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | GRP_ID |
Logical Rolename | |
ColumnName | GRP_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
GRP_ID Logical Attribute Properties |
Logical Attribute Name | GRP_ID |
Datatype | VARCHAR(20) |
Nullable | NO |
GRP_ID Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
GRP_ID Security Types |
Name | Current Value |
GRP_ID Bound Attachments |
Name | Current Value |
GRP_ID Data Movement Rules |
Name | Type | Rule Text/Value |
GRP_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review GRP_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV GRP_ID |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV GRP_ID |
NO |
GRP_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
GRP_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
GRP_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
GRP_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERSON_ID |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | PERSON_ID |
Logical Rolename | |
ColumnName | PERSON_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
PERSON_ID Logical Attribute Properties |
Logical Attribute Name | PERSON_ID |
Datatype | VARCHAR(10) |
Nullable | NO |
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 Instrument Group Chair Review PERSON_ID |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV PERSON_ID |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV 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 |
Rank Number |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | Rank Number |
Logical Rolename | |
ColumnName | RANK_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Rank Number Logical Attribute Properties |
Logical Attribute Name | Rank Number |
Datatype | NUMERIC(4, 0) |
Nullable | YES |
Rank Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Rank Number Security Types |
Name | Current Value |
Rank Number Bound Attachments |
Name | Current Value |
Rank Number Data Movement Rules |
Name | Type | Rule Text/Value |
Rank Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review Rank Number |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV RANK_NBR |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV RANK_NBR |
NO |
Rank Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Rank Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Rank Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Rank Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Recomended Day Number |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | Recomended Day Number |
Logical Rolename | |
ColumnName | RECM_DAYS_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Recomended Day Number Logical Attribute Properties |
Logical Attribute Name | Recomended Day Number |
Datatype | NUMERIC(2, 0) |
Nullable | YES |
Recomended Day Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Recomended Day Number Security Types |
Name | Current Value |
Recomended Day Number Bound Attachments |
Name | Current Value |
Recomended Day Number Data Movement Rules |
Name | Type | Rule Text/Value |
Recomended Day Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review Recomended Day Number |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV RECM_DAYS_NBR |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV RECM_DAYS_NBR |
NO |
Recomended Day Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Recomended Day Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Recomended Day Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Recomended Day Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BAC Comment |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | BAC Comment |
Logical Rolename | |
ColumnName | BAC_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
BAC Comment Logical Attribute Properties |
Logical Attribute Name | BAC Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
BAC Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BAC Comment Security Types |
Name | Current Value |
BAC Comment Bound Attachments |
Name | Current Value |
BAC Comment Data Movement Rules |
Name | Type | Rule Text/Value |
BAC Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review BAC Comment |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV BAC_CMNT |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV BAC_CMNT |
NO |
BAC Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BAC Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BAC Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BAC Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SRCM PI Comment |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | SRCM PI Comment |
Logical Rolename | |
ColumnName | SRCM_PI_CMNT |
RoleName | |
Domain | Comment |
Logical Only | NO |
Definition | Comment: General comments. |
Note |
SRCM PI Comment Logical Attribute Properties |
Logical Attribute Name | SRCM PI Comment |
Datatype | VARCHAR(2000) |
Nullable | YES |
SRCM PI Comment Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
SRCM PI Comment Security Types |
Name | Current Value |
SRCM PI Comment Bound Attachments |
Name | Current Value |
SRCM PI Comment Data Movement Rules |
Name | Type | Rule Text/Value |
SRCM PI Comment Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review SRCM PI Comment |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV SRCM_PI_CMNT |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV SRCM_PI_CMNT |
NO |
SRCM PI Comment Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SRCM PI Comment Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SRCM PI Comment Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SRCM PI Comment Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Number |
Base Entity | Proposal Instrument Group Chair Review |
Attribute Name | Rating Number |
Logical Rolename | |
ColumnName | RATING_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Rating Number Logical Attribute Properties |
Logical Attribute Name | Rating Number |
Datatype | NUMERIC(6, 2) |
Nullable | YES |
Rating Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Rating Number Security Types |
Name | Current Value |
Rating Number Bound Attachments |
Name | Current Value |
Rating Number Data Movement Rules |
Name | Type | Rule Text/Value |
Rating Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Instrument Group Chair Review Rating Number |
NO | ||
IPTSv5 (Oracle) PRPSL_INSTR_GRP_CHAIR_REV RATING_NBR |
NO | ||
PRPSL (Oracle) PRPSL_INSTR_GRP_CHAIR_REV RATING_NBR |
NO |
Rating Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |