KREL_DIST_RUN_GROUP_LOCKS

This table stores the same information as the KREL_DIST_RUN_GROUP_STATUS table. For internal use only.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KREL_DIST_RUN_GROUPS

DIST_RUN_GROUP_ID

DIST_RUN_GROUP_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

DIST_RUN_GROUP_LOCK_ID

NOT NULL

NUMBER

System-generated identifier

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

DIST_RUN_GROUP_ID

NOT NULL

NUMBER

Identifier for Run Group. Please refer to KREL_DIST_RUN_GROUPS

STATUS_CODE

NULLABLE

VARCHAR2(30)

Status code for the entire run group

STATUS_MEANING

NULLABLE

VARCHAR2(80)

Status meaning for the entire run group

WORKFLOW_STEP_ID_PATH

NOT NULL

VARCHAR2(200)

System generated ID path for the workflow step

Indexes

Index Name

Index Type

Sequence

Column Name

KREL_DIST_RUN_GROUP_LOCKS_U1

UNIQUE

1

DIST_RUN_GROUP_LOCK_ID

KREL_DIST_RUN_GROUP_LOCKS_U2

NONUNIQUE

1

DIST_RUN_GROUP_ID

KREL_DIST_RUN_GROUP_LOCKS_U2

NONUNIQUE

2

WORKFLOW_STEP_ID_PATH

Sequences

Sequence Name

Sequence Type

KREL_DIST_RUN_GROUP_LOCKS_S

DIST_RUN_GROUP_LOCK_ID