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