KRSC_WORK_ITEM_ASSIGNMENTS
This table stores a copy of all the Assignment information from Projects, Requests, and Staffing Profiles. The relevant data is de-normalized (and pre-processed) into this table and kept up to date asynchronously by the server. This table serves as the data source for the Workload information in the Resource Management visualizations (available from the Resource Management menu)
Foreign Keys
Primary Key Table |
Primary Key Column |
Foreign Key Column |
---|---|---|
KNTA_USERS |
USER_ID |
CREATED_BY |
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
KNTA_USERS |
USER_ID |
USER_ID |
Column Descriptions
Column Name |
Null? |
Data Type |
Description |
---|---|---|---|
WORK_ITEM_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 |
WORK_ITEM_ENTITY_ID |
NOT NULL |
NUMBER |
Foreign key to KNTA_ENTITIES. The Entity type of the originating assignment information (Request, Task, or Staffing Profile Line Cell) |
WORK_ITEM_NAME |
NOT NULL |
VARCHAR2(300) |
Request Id, the Task Name, or the Staffing Profile Line Cell Id |
WORK_ITEM_ID |
NOT NULL |
NUMBER |
Foreign key to Requests, Tasks, or Staffing Profile Line Cells. |
USER_ID |
NOT NULL |
NUMBER |
Foreign key to KNTA_USERS. The User that is working on this assignment. Can be null. |
SKILL_ID |
NOT NULL |
NUMBER |
Foreign key to the KRSC_SKILLS table. The Skill used by the User working on this assignment. Cannot be null. Will point to the 'Unspecified' Skill if not specified. |
GROUP_ENTITY_ID |
NOT NULL |
NUMBER |
Foreign key to KNTA_ENTITIES. It is either the Request Type Entity ID, the Staffing Profile Entity ID, or the Project Entity ID (depending on if the Work Item Entity is a request, a task, or a staffing profile line cell) |
GROUP_NAME |
NOT NULL |
VARCHAR2(300) |
Request Type Name, Staffing Profile Name, or the Project name associated with the GROUP_ID. |
GROUP_ID |
NOT NULL |
NUMBER |
Foreign key to KCRT_REQUEST_TYPES, KRSC_STAFF_PROFS, or KDRV_PROJECTS. |
WORKLOAD_CATEGORY_CODE |
NULLABLE |
VARCHAR2(30) |
Lookup code for 'RSC - Workload Category Code' |
WORKLOAD_FLAG |
NOT NULL |
VARCHAR2(1) |
'Y' or 'N'. Determines whether this assignment should show up in workload visualizations. |
PLAN_CALENDAR |
NULLABLE |
VARCHAR2(4) |
Calendar used to determine the working days and the number of hours in a working day. Either 'BASE' or 'RSC'. 'BASE' by default and 'RSC' if the User's Calendar differs from the Base Calendar (for example, Vacation Days) |
PLAN_START_DATE |
NULLABLE |
DATE |
Scheduled Start Date (day and time) of the assignment |
PLAN_START_DAY |
NULLABLE |
DATE |
Scheduled Start Date at 00:00:00 hours |
PLAN_START_DAY_FRACTION |
NULLABLE |
NUMBER |
Fraction of first day that contributes to the scheduled duration |
PLAN_START_DAY_EFFORT |
NULLABLE |
NUMBER |
Number of hours scheduled on the first day of assignment |
PLAN_FINISH_DATE |
NULLABLE |
DATE |
Scheduled End Date (day and time) of the assignment |
PLAN_FINISH_DAY |
NULLABLE |
DATE |
Scheduled End Date at 00:00:00 hours |
PLAN_FINISH_DAY_FRACTION |
NULLABLE |
NUMBER |
Fraction of end day that contributes to the scheduled duration |
PLAN_FINISH_DAY_EFFORT |
NULLABLE |
NUMBER |
Number of hours scheduled on the last day of assignment |
PLAN_TOTAL_WORKDAYS |
NULLABLE |
NUMBER |
Scheduled duration |
PLAN_TOTAL_EFFORT |
NULLABLE |
NUMBER |
Scheduled Effort |
PLAN_WORKDAY_EFFORT |
NULLABLE |
NUMBER |
Number of hours scheduled to be worked on every day other than the first day or last day of the assignment. |
ACTUAL_CALENDAR |
NULLABLE |
VARCHAR2(4) |
Calendar used to determine the working days and the number of hours in a working day. Either 'BASE' or 'RSC'. 'BASE' by default and 'RSC' if the User's Calendar differs from the Base Calendar (for example, Vacation Days) |
ACTUAL_START_DATE |
NULLABLE |
DATE |
Actual Start Date (day and time) of the assignment |
ACTUAL_START_DAY |
NULLABLE |
DATE |
Actual Start Date at 00:00:00 hours |
ACTUAL_START_DAY_FRACTION |
NULLABLE |
NUMBER |
Fraction of first day that contributes to the Actual duration |
ACTUAL_START_DAY_EFFORT |
NULLABLE |
NUMBER |
Number of hours actually worked the first day of assignment |
ACTUAL_FINISH_DATE |
NULLABLE |
DATE |
Actual End Date (day and time) of the assignment |
ACTUAL_FINISH_DAY |
NULLABLE |
DATE |
Actual End Date at 00:00:00 hours |
ACTUAL_FINISH_DAY_FRACTION |
NULLABLE |
NUMBER |
Fraction of end day that contributes to the Actual duration |
ACTUAL_FINISH_DAY_EFFORT |
NULLABLE |
NUMBER |
Number of hours actually worked the last day of assignment |
ACTUAL_TOTAL_WORKDAYS |
NULLABLE |
NUMBER |
Actual duration |
ACTUAL_TOTAL_EFFORT |
NULLABLE |
NUMBER |
Actual effort |
ACTUAL_WORKDAY_EFFORT |
NULLABLE |
NUMBER |
Number of hours actually worked on every day other than the first day or last day of the assignment |
Indexes
Index Name |
Index Type |
Sequence |
Column Name |
---|---|---|---|
KRSC_WORK_ITEM_ASSIGNMENTS_N1 |
NONUNIQUE |
1 |
WORK_ITEM_ENTITY_ID |
KRSC_WORK_ITEM_ASSIGNMENTS_N1 |
NONUNIQUE |
2 |
WORK_ITEM_ID |
KRSC_WORK_ITEM_ASSIGNMENTS_N10 |
NONUNIQUE |
1 |
PLAN_FINISH_DATE |
KRSC_WORK_ITEM_ASSIGNMENTS_N11 |
NONUNIQUE |
1 |
ACTUAL_START_DATE |
KRSC_WORK_ITEM_ASSIGNMENTS_N12 |
NONUNIQUE |
1 |
ACTUAL_FINISH_DATE |
KRSC_WORK_ITEM_ASSIGNMENTS_N13 |
NONUNIQUE |
1 |
GROUP_ID |
KRSC_WORK_ITEM_ASSIGNMENTS_N2 |
NONUNIQUE |
1 |
USER_ID |
KRSC_WORK_ITEM_ASSIGNMENTS_N3 |
NONUNIQUE |
1 |
SKILL_ID |
KRSC_WORK_ITEM_ASSIGNMENTS_N4 |
NONUNIQUE |
1 |
WORKLOAD_CATEGORY_CODE |
KRSC_WORK_ITEM_ASSIGNMENTS_N5 |
NONUNIQUE |
1 |
PLAN_START_DAY |
KRSC_WORK_ITEM_ASSIGNMENTS_N6 |
NONUNIQUE |
1 |
PLAN_FINISH_DAY |
KRSC_WORK_ITEM_ASSIGNMENTS_N7 |
NONUNIQUE |
1 |
ACTUAL_START_DAY |
KRSC_WORK_ITEM_ASSIGNMENTS_N8 |
NONUNIQUE |
1 |
ACTUAL_FINISH_DAY |
KRSC_WORK_ITEM_ASSIGNMENTS_N9 |
NONUNIQUE |
1 |
PLAN_START_DATE |
KRSC_WORK_ITEM_ASSIGNMENTS_U1 |
UNIQUE |
1 |
WORK_ITEM_ASSIGNMENT_ID |
Sequences
Sequence Name |
Sequence Type |
---|---|
KRSC_WORK_ITEM_ASSIGNMENTS_S |
WORK_ITEM_ASSIGNMENT_ID |