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.