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