Proposal Identifier |
Base Entity | Proposal Attachment |
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 Attachment Proposal Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH PRPSL_ID |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH 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 Attachment |
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 Attachment Submission Number |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH SUBMISS_NBR |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH 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 |
Activity Identifier |
Base Entity | Proposal Attachment |
Attribute Name | Activity Identifier |
Logical Rolename | |
ColumnName | ACT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Activity Identifier: Abbreviated identifer of the activity that can be taken against a proposal. |
Note |
Activity Identifier Logical Attribute Properties |
Logical Attribute Name | Activity Identifier |
Datatype | VARCHAR(10) |
Nullable | NO |
Activity Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Activity Identifier Security Types |
Name | Current Value |
Activity Identifier Bound Attachments |
Name | Current Value |
Activity Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Activity Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Attachment Activity Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH ACT_ID |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH ACT_ID |
NO |
Activity Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Activity Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Attachment Sequence |
Base Entity | Proposal Attachment |
Attribute Name | Attachment Sequence |
Logical Rolename | |
ColumnName | ATTACH_SEQ |
RoleName | |
Domain | Sequence |
Logical Only | NO |
Definition | Sequence: A numerical primary key value derived from a Sequence. |
Note |
Attachment Sequence Logical Attribute Properties |
Logical Attribute Name | Attachment Sequence |
Datatype | INTEGER |
Nullable | NO |
Attachment Sequence Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Attachment Sequence Security Types |
Name | Current Value |
Attachment Sequence Bound Attachments |
Name | Current Value |
Attachment Sequence Data Movement Rules |
Name | Type | Rule Text/Value |
Attachment Sequence Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Attachment Attachment Sequence |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH ATTACH_SEQ |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH ATTACH_SEQ |
NO |
Attachment Sequence Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Attachment Sequence Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Attachment Sequence Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Attachment Sequence Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date |
Base Entity | Proposal Attachment |
Attribute Name | Modify Date |
Logical Rolename | |
ColumnName | MOD_DTE |
RoleName | |
Domain | Date |
Logical Only | NO |
Definition | Date: Date and time to seconds. |
Note |
Modify Date Logical Attribute Properties |
Logical Attribute Name | Modify Date |
Datatype | DATE |
Nullable | NO |
Modify Date Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
Modify Date Security Types |
Name | Current Value |
Modify Date Bound Attachments |
Name | Current Value |
Modify Date Data Movement Rules |
Name | Type | Rule Text/Value |
Modify Date Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Attachment Modify Date |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH MOD_DTE |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH MOD_DTE |
NO |
Modify Date Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Modify Date Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
MIME Type |
Base Entity | Proposal Attachment |
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(30) |
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 Proposal Attachment MIME Type |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH MIME_TYPE |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH 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 |
Content |
Base Entity | Proposal Attachment |
Attribute Name | Content |
Logical Rolename | |
ColumnName | CONTENT |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Content Logical Attribute Properties |
Logical Attribute Name | Content |
Datatype | VARBINARY/BLOB(50) |
Nullable | NO |
Content Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Content Security Types |
Name | Current Value |
Content Bound Attachments |
Name | Current Value |
Content Data Movement Rules |
Name | Type | Rule Text/Value |
Content Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Attachment Content |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH CONTENT |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH CONTENT |
NO |
Content Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Content Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Content Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Content Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
FILE_NM |
Base Entity | Proposal Attachment |
Attribute Name | FILE_NM |
Logical Rolename | |
ColumnName | FILE_NM |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
FILE_NM Logical Attribute Properties |
Logical Attribute Name | FILE_NM |
Datatype | VARCHAR(255) |
Nullable | YES |
FILE_NM Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
FILE_NM Security Types |
Name | Current Value |
FILE_NM Bound Attachments |
Name | Current Value |
FILE_NM Data Movement Rules |
Name | Type | Rule Text/Value |
FILE_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Attachment FILE_NM |
NO | ||
IPTSv5 (Oracle) PRPSL_ATTACH FILE_NM |
NO | ||
PRPSL (Oracle) PRPSL_ATTACH FILE_NM |
NO |
FILE_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
FILE_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
FILE_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
FILE_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |