KRSC_PENDING_ASSIGNMENTS

This table gets updated every time an Assignment is updated. An Assignment can be updated directly (such as the duration of a Task is increased) or indirectly (such as a Project Setup is changed that will change how Tasks in a project should be treated. A process in the server reads through the rows in this table updates the data in the KRSC_WORK_ITEM_ASSIGNMENTS table.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCRT_REQUEST_HEADER_TYPES_NLS

REQUEST_HEADER_TYPE_ID

SOURCE_ID

KCRT_FG_WORK_ITEMS

REQUEST_ID

SOURCE_ID

KNTA_ENTITIES_NLS

ENTITY_ID

SOURCE_ENTITY_ID

PM_PROJECTS

PROJECT_ID

SOURCE_ID

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

RSC_STAFFING_PROFILES

STAFFING_PROFILE_ID

SOURCE_ID

KCRT_REQUEST_TYPES_NLS

REQUEST_TYPE_ID

SOURCE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PENDING_ASSIGNMENT_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. The type of Entity that was modified that would affect an assignment (Project Setup, Project, Task, Request Type, Request Header Type, Request, Staffing Profile, Staffing Profile Line, or Staffing Profile Line Cell)

SOURCE_ID

NOT NULL

NUMBER

Foreign key to Project Setup, Project, Task, Request Type, Request Header Type, Request, Staffing Profile, Staffing Profile Line, or Staffing Profile Line Cell

Indexes

Index Name

Index Type

Sequence

Column Name

KRSC_PENDING_ASSIGNMENTS_N1

NONUNIQUE

1

SOURCE_ENTITY_ID

KRSC_PENDING_ASSIGNMENTS_N1

NONUNIQUE

2

SOURCE_ID

KRSC_PENDING_ASSIGNMENTS_U1

UNIQUE

1

PENDING_ASSIGNMENT_ID

Sequences

Sequence Name

Sequence Type

KRSC_PENDING_ASSIGNMENTS_S

PENDING_ASSIGNMENT_ID