KRSC_PENDING_WORK_ITEM_UPDATES

This table stores references to updates that need to be made to the
KDRV_PROJECTS table or the KCRT_FG_WORK_ITEMS table that could not be immediately updated. A task (KDRV_PROJECTS) or request (KCRT_FB_WORK_ITEMS) can be updated by a Time Management timesheet, a task can be updated by a request, and a request can be updated by a task. If any of these updates cannot take place because there is a lock on the entity being updated, a row is added to the KRSC_PENDING_WORK_ITEM_UPDATES table. A process in the Server queries this table and makes the appropriate updates when the entities are unlocked.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_ENTITIES_NLS

ENTITY_ID

WORK_ITEM_ENTITY_ID

PM_PROJECTS

PROJECT_ID

WORK_ITEM_ID

KCRT_FG_WORK_ITEMS

REQUEST_ID

WORK_ITEM_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

PENDING_WORK_ITEM_UPDATE_ID

NOT NULL

NUMBER

System-generated identifier

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

WORK_ITEM_ENTITY_ID

NOT NULL

NUMBER

Type of work item - either a Task or a request

WORK_ITEM_ID

NOT NULL

NUMBER

Foreign key to the KDRV_PROJECTS table or the KCRT_FB_WORK_ITEMS table.

UPDATE_VALUE

NULLABLE

VARCHAR2(200)

New value of the column to be updated if update is from Time Management.

UPDATE_TYPE

NOT NULL

VARCHAR2(50)

One of 'TM_ACTUAL_EFFORT_UPDATE', 'TM_ACTUAL_COST_UPDATE', 'REQ_UPDATES_TASK_ACTUAL_EFFORT', or 'TASK_UPDATES_REQ_SCHEDULE'

ATTEMPTS

NOT NULL

NUMBER

Number of times the process has tried to make the update.

ERROR_MESSAGE

NULLABLE

VARCHAR2(200)

Error message received as to why the update could not immediately be made.

RESOURCE_ID

NULLABLE

NUMBER

For the token evaluation engine. Contains the primary key of a table (see KNTA_TOKEN). The reference to this table is used to resolve all the tokens from this context after update

Indexes

Index Name

Index Type

Sequence

Column Name

KRSC_PEND_WORK_ITEM_UPDATES_U1

UNIQUE

1

PENDING_WORK_ITEM_UPDATE_ID

Sequences

This table uses no sequences.