Status Identifier |
Base Entity | Proposal Submission Status |
Attribute Name | Status Identifier |
Logical Rolename | |
ColumnName | STAT_ID |
RoleName | |
Domain | |
Logical Only | NO |
Definition | Status Identifer: Abbreviated idenfifer for the given status. |
Note |
Status Identifier Logical Attribute Properties |
Logical Attribute Name | Status Identifier |
Datatype | VARCHAR(20) |
Nullable | NO |
Status Identifier Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Status Identifier Security Types |
Name | Current Value |
Status Identifier Bound Attachments |
Name | Current Value |
Status Identifier Data Movement Rules |
Name | Type | Rule Text/Value |
Status Identifier Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Status Status Identifier |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS_STAT STAT_ID |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS_STAT STAT_ID |
NO |
Status Identifier Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Identifier Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Description |
Base Entity | Proposal Submission Status |
Attribute Name | Status Description |
Logical Rolename | |
ColumnName | STAT_DESCR |
RoleName | |
Domain | Description |
Logical Only | NO |
Definition | Description: Often used in validation tables accompanying an abbreviated identifer. |
Note |
Status Description Logical Attribute Properties |
Logical Attribute Name | Status Description |
Datatype | VARCHAR(255) |
Nullable | NO |
Status Description Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
Status Description Security Types |
Name | Current Value |
Status Description Bound Attachments |
Name | Current Value |
Status Description Data Movement Rules |
Name | Type | Rule Text/Value |
Status Description Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Status Status Description |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS_STAT STAT_DESCR |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS_STAT STAT_DESCR |
NO |
Status Description Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Description Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Status Description Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Status Description Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
Order Number |
Base Entity | Proposal Submission Status |
Attribute Name | Order Number |
Logical Rolename | |
ColumnName | ORD_NBR |
RoleName | |
Domain | |
Logical Only | NO |
Definition | |
Note |
Order Number Logical Attribute Properties |
Logical Attribute Name | Order Number |
Datatype | NUMERIC(4, 0) |
Nullable | YES |
Order Number Domain Restrictions |
CheckConstraint | |||
Check Constraint Name | |||
Bound Rule | |||
Declared Default | |||
Bound Default |
Order Number Security Types |
Name | Current Value |
Order Number Bound Attachments |
Name | Current Value |
Order Number Data Movement Rules |
Name | Type | Rule Text/Value |
Order Number Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Proposal Submission Status Order Number |
NO | ||
IPTSv5 (Oracle) PRPSL_SUBMISS_STAT ORD_NBR |
NO | ||
PRPSL (Oracle) PRPSL_SUBMISS_STAT ORD_NBR |
NO |
Order Number Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
Order Number Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
Order Number Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
Order Number Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |