CST_PREP_RUNNING_STATUS_T
The status of the job for Quantity PreProcessor instance which hold the lock and is running the global level sqls. This status column only has value of RUNNING and there should be only one row in the table. Once the global level sqls are over, the lock needs to be released and other QPP instances need to continue, that row is deleted.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_PREP_RUNNING_STATUS_T_PK |
REQUEST_ID, STATUS |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REQUEST_ID | NUMBER | 18 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| STATUS | VARCHAR2 | 20 | Yes | The status of the job for Quantity PreProcessor instance which hold the lock and is running the global level sqls. This column only has value of RUNNING and there should be only one row in the table. | |
| 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. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_PREP_RUNNING_STATUS_T_U1 | Unique | FUSION_TS_TX_DATA | REQUEST_ID, STATUS |