Share this page

# 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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: