Finding Identifier |
Base Entity | Science Review Committee Finding |
Attribute Name | Finding Identifier |
Logical Rolename | |
ColumnName | FINDING_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Finding Identifier Logical Attribute Properties |
Logical Attribute Name | Finding Identifier |
Datatype | NUMERIC(38, 0) |
Nullable | NO |
Finding Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Finding Identifier Security Types |
Name | Current Value |
Finding Identifier Bound Attachments |
Name | Current Value |
Finding Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Finding Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Committee Finding Finding Identifier |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING FINDING_ID |
NO | ||
PRPSL (Oracle) SRCM_FINDING FINDING_ID |
NO |
Finding Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Finding Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Finding Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Finding Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Operational Cycle Identifier |
Base Entity | Science Review Committee Finding |
Attribute Name | Operational Cycle Identifier |
Logical Rolename | |
ColumnName | OPER_CYCLE_ID |
RoleName | |
Domain | Identifier |
Logical Only | NO |
Definition | |
Note |
Operational Cycle Identifier Logical Attribute Properties |
Logical Attribute Name | Operational Cycle Identifier |
Datatype | VARCHAR(25) |
Nullable | YES |
Operational Cycle Identifier Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Operational Cycle Identifier Security Types |
Name | Current Value |
Operational Cycle Identifier Bound Attachments |
Name | Current Value |
Operational Cycle Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Operational Cycle Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Committee Finding Operational Cycle Identifier |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING OPER_CYCLE_ID |
NO | ||
PRPSL (Oracle) SRCM_FINDING OPER_CYCLE_ID |
NO |
Operational Cycle Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operational Cycle Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Operational Cycle Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Operational Cycle Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date |
Base Entity | Science Review Committee Finding |
Attribute Name | Current Date |
Logical Rolename | |
ColumnName | CUR_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | |
Note |
Current Date Logical Attribute Properties |
Logical Attribute Name | Current Date |
Datatype | DATE |
Nullable | YES |
Current Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Current Date Security Types |
Name | Current Value |
Current Date Bound Attachments |
Name | Current Value |
Current Date Data Movement Rules |
Name | Type | Rule Text/Value |
Current Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Committee Finding Current Date |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING CUR_DTE |
NO | ||
PRPSL (Oracle) SRCM_FINDING CUR_DTE |
NO |
Current Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Current Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Description |
Base Entity | Science Review Committee Finding |
Attribute Name | Description |
Logical Rolename | |
ColumnName | DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | |
Note |
Description Logical Attribute Properties |
Logical Attribute Name | Description |
Datatype | VARCHAR(255) |
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 Committee Finding Description |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING DESCR |
NO | ||
PRPSL (Oracle) SRCM_FINDING 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 |
File Name |
Base Entity | Science Review Committee Finding |
Attribute Name | File Name |
Logical Rolename | |
ColumnName | FILE_NM |
RoleName | |
Domain | File Name |
Logical Only | NO |
Definition | |
Note |
File Name Logical Attribute Properties |
Logical Attribute Name | File Name |
Datatype | VARCHAR(255) |
Nullable | YES |
File Name Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
File Name Security Types |
Name | Current Value |
File Name Bound Attachments |
Name | Current Value |
File Name Data Movement Rules |
Name | Type | Rule Text/Value |
File Name Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Committee Finding File Name |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING FILE_NM |
NO | ||
PRPSL (Oracle) SRCM_FINDING FILE_NM |
NO |
File Name Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
File Name Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
File Name Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
File Name Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIME Type |
Base Entity | Science Review Committee Finding |
Attribute Name | MIME Type |
Logical Rolename | |
ColumnName | MIME_TYPE |
RoleName | |
Domain | MIME Type |
Logical Only | NO |
Definition | |
Note |
MIME Type Logical Attribute Properties |
Logical Attribute Name | MIME Type |
Datatype | VARCHAR(255) |
Nullable | YES |
MIME Type Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
MIME Type Security Types |
Name | Current Value |
MIME Type Bound Attachments |
Name | Current Value |
MIME Type Data Movement Rules |
Name | Type | Rule Text/Value |
MIME Type Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Committee Finding MIME Type |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING MIME_TYPE |
NO | ||
PRPSL (Oracle) SRCM_FINDING MIME_TYPE |
NO |
MIME Type Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIME Type Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
MIME Type Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIME Type Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
File Content |
Base Entity | Science Review Committee Finding |
Attribute Name | File Content |
Logical Rolename | |
ColumnName | FILE_CONTENT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
File Content Logical Attribute Properties |
Logical Attribute Name | File Content |
Datatype | VARBINARY/BLOB(18) |
Nullable | YES |
File Content Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
File Content Security Types |
Name | Current Value |
File Content Bound Attachments |
Name | Current Value |
File Content Data Movement Rules |
Name | Type | Rule Text/Value |
File Content Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Science Review Committee Finding File Content |
NO | ||
IPTSv5 (Oracle) SRCM_FINDING FILE_CONTENT |
NO | ||
PRPSL (Oracle) SRCM_FINDING FILE_CONTENT |
NO |
File Content Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
File Content Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
File Content Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
File Content Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |