Rating Identifier |
Base Entity | Science Review Merit |
Attribute Name | Rating Identifier |
Logical Rolename | |
ColumnName | RATING_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Rating Identifier: Identifier for the science review ratings from 1 - 5. |
Note |
Rating Identifier Logical Attribute Properties |
Logical Attribute Name | Rating Identifier |
Datatype | NUMERIC(2, 1) |
Nullable | NO |
Rating Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Rating Identifier Security Types |
Name | Current Value |
Rating Identifier Bound Attachments |
Name | Current Value |
Rating Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Rating Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Merit Rating Identifier |
NO | ||
CNMS_PRPSL (Oracle) SCI_REVIEW_MERIT RATING_ID |
NO | ||
IPTSv5 (Oracle) SCI_REVIEW_MERIT RATING_ID |
NO | ||
PRPSL (Oracle) SCI_REVIEW_MERIT RATING_ID |
NO |
Rating Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Rating Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Name |
Base Entity | Science Review Merit |
Attribute Name | Name |
Logical Rolename | |
ColumnName | NM |
RoleName | |
Domain | Name |
Logical Only | NO |
Definition | Name: A long description name usually accompanied by an abbreviated code. |
Note |
Name Logical Attribute Properties |
Logical Attribute Name | Name |
Datatype | VARCHAR(120) |
Nullable | NO |
Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Name Security Types |
Name | Current Value |
Name Bound Attachments |
Name | Current Value |
Name Data Movement Rules |
Name | Type | Rule Text/Value |
Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Merit Name |
NO | ||
CNMS_PRPSL (Oracle) SCI_REVIEW_MERIT NM |
NO | ||
IPTSv5 (Oracle) SCI_REVIEW_MERIT NM |
NO | ||
PRPSL (Oracle) SCI_REVIEW_MERIT NM |
NO |
Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description |
Base Entity | Science Review Merit |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(1000) |
Nullable | YES |
Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Description Security Types |
Name | Current Value |
Description Bound Attachments |
Name | Current Value |
Description Data Movement Rules |
Name | Type | Rule Text/Value |
Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Merit Description |
NO | ||
CNMS_PRPSL (Oracle) SCI_REVIEW_MERIT DESCR |
NO | ||
IPTSv5 (Oracle) SCI_REVIEW_MERIT DESCR |
NO | ||
PRPSL (Oracle) SCI_REVIEW_MERIT DESCR |
NO |
Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |