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 |