Share this page
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.
