PJB_PARALLEL_WORKERS
PJB_PARALLEL_WORKERS table stores contract-worker information used for parallelizing processes.
Details
-
Schema: FUSION
-
Object owner: PJB
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CALLING_PROCESS | VARCHAR2 | 20 | Yes | Process which is using this table. For example: 'INVGEN', 'REVGEN' | |
| PARENT_REQUEST_ID | NUMBER | 18 | Yes | Identifier of the ESS parent request. | |
| CONTRACT_ID | NUMBER | 18 | Yes | Identifier of the contract. | |
| PROCESS_STATUS | VARCHAR2 | 1 | Yes | Processing status of the contract. Possible values are 'U' - Unprocessed, 'P' - Processing, 'S' - Success, 'F' - Failed. | |
| SUBPROCESS_REQUEST_ID | NUMBER | 18 | Identifier of the ESS child request. | ||
| PROCSD_TRNS_COUNT | NUMBER | 20 | Number of transactions processed. | ||
| START_TIME | DATE | Start time of processing of the contract. | |||
| END_TIME | DATE | End time of processing of the contract. | |||
| ERROR_CODE | VARCHAR2 | 30 | Error code for the contract. | ||
| ERROR_TEXT | VARCHAR2 | 240 | Error text for the contract. | ||
| PROCESSING_ORDER | NUMBER | 20 | Order in which contract is processed. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| FEATURE_VAR1 | NUMBER | Value of Feature variable 1. | |||
| FEATURE_VAR2 | NUMBER | Value of Feature variable 2. | |||
| FEATURE_VAR3 | NUMBER | Value of Feature variable 3. | |||
| FEATURE_VAR4 | NUMBER | Value of Feature variable 4. | |||
| FEATURE_VAR5 | NUMBER | Value of Feature variable 5. | |||
| FEATURE_VAR6 | NUMBER | Value of Feature variable 6. | |||
| FEATURE_VAR7 | NUMBER | Value of Feature variable 7. | |||
| FEATURE_VAR8 | NUMBER | Value of Feature variable 8. | |||
| FEATURE_VAR9 | NUMBER | Value of Feature variable 9. | |||
| FEATURE_VAR10 | NUMBER | Value of Feature variable 10. | |||
| FEATURE_VAR11 | VARCHAR2 | 32 | Value of Feature variable 11. | ||
| FEATURE_VAR12 | VARCHAR2 | 32 | Value of Feature variable 12. | ||
| FEATURE_VAR13 | VARCHAR2 | 32 | Value of Feature variable 13. | ||
| FEATURE_VAR14 | VARCHAR2 | 32 | Value of Feature variable 14. | ||
| ESTIMATED_TIME | TIMESTAMP | Estimated processing time of the contract. | |||
| ACTUAL_TIME | TIMESTAMP | Actual processing time of the contract. | |||
| PARENT_STATISTIC_GROUP_ID | NUMBER | 18 | Identifier for Statistic Group Id for Parent Invoice request |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJB_PARALLEL_WORKERS_U1 | Unique | Default | CALLING_PROCESS, PARENT_REQUEST_ID, CONTRACT_ID |