KDLV_PENDING_JOBS
This table stores records of executions that submit mainframe jobs.
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KWFL_PENDING_EXEC_OBJECTS |
BATCH_ID |
BATCH_ID |
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KDLV_PACKAGES |
PACKAGE_ID |
PACKAGE_ID |
KWFL_STEP_TRANSACTIONS |
STEP_TRANSACTION_ID |
STEP_TRANSACTION_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
PACKAGE_ID |
NOT NULL |
NUMBER |
Package ID. Refers to KDLV_PACKAGES. |
BATCH_ID |
NOT NULL |
NUMBER |
Execution batch ID used to launch the mainframe job. Refers to KWFL_PENDING_EXEC_OBJECTS |
STEP_TRANSACTION_ID |
NOT NULL |
NUMBER |
Identifies the step transaction in KWFL_STEP_TRANSACTIONS that resulted in the mainframe job submission. STEP_TRANSACTION_ID is required to write back status results to the KWFL_STEP_TRANSACTIONS table. |
STATUS |
NOT NULL |
VARCHAR2(30) |
Result of the job's execution upon completion of the job. |
VISIBLE_USER_STATUS_VALUE |
NULLABLE |
VARCHAR2(200) |
Visible result of the status that is shown to the user. |
RESULT_VALUE |
NULLABLE |
VARCHAR2(200) |
Holds the hidden result value from a successfully completed workflow step. Valid values in this field are determined by the validation associated with the given workflow step. |
FILE_PATH |
NOT NULL |
VARCHAR2(200) |
Absolute path (on the app server) to the JCL file that was submitted. |
FILENAME |
NOT NULL |
VARCHAR2(200) |
Name of the JCL file that was submitted. |
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
Indexes
This table uses no indexes.
Sequences
This table uses no sequences.