KCST_PENDING_EV_UPDATES

This table temporally stores the EV values that needs to be updated by the EV services

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_ENTITIES_NLS

ENTITY_ID

SOURCE_ENTITY_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

PENDING_EV_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

SOURCE_ENTITY_ID

NOT NULL

NUMBER

Foreign key to KNTA_ENTITIES_NLS. The type of Entity that was modified that would affect EV (Project Setup, Project, Task)

SOURCE_ID

NOT NULL

NUMBER

Foreign key to Project Setup, Project, Task

Indexes

Index Name

Index Type

Sequence

Column Name

KCST_PENDING_EV_UPDATES_N1

NONUNIQUE

1

SOURCE_ID

KCST_PENDING_EV_UPDATES_N1

NONUNIQUE

2

SOURCE_ENTITY_ID

KCST_PENDING_EV_UPDATES_U1

UNIQUE

1

PENDING_EV_UPDATE_ID

Sequences

Sequence Name

Sequence Type

KCST_PENDING_EV_UPDATES_S

PENDING_EV_UPDATE_ID