Share this page

# 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

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: