PJS_SYSTEM_PRC_STATUS
This table contains a non-persistent list of state, a list of steps being executed and whether they are complete, used by all methods of summarization. Each summarization run has a unique PROCESS_NAME.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Comments | Status |
|---|---|---|---|---|
| PROCESS_NAME | VARCHAR2 | 30 | Process name representing internal summarization state. | Active |
| STEP_SEQ | NUMBER | Step sequence of internal summarization state. | Active | |
| STEP_STATUS | VARCHAR2 | 10 | Status of a step in internal summarization state. | Active |
| STEP_NAME | VARCHAR2 | 80 | Step name of internal summarization state. | Active |
| START_DATE | DATE | Start date of the step in a specific process. | Active | |
| END_DATE | DATE | End date of the step in a specific process. | Active |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_SYSTEM_PRC_STATUS_N1 | Non Unique | Default | PROCESS_NAME, STEP_SEQ |