Share this page

# KCRT_FG_WORK_ITEMS

If the Work Items field group is linked to a request's request header type, a row will exist in this table for the request. Defines columns so that a request can be scheduled and can be viewed in Workload visualizations..

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
RSC_ROLES_NLS | ROLE_ID | ROLE_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | REQUEST_TYPE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
REQUEST_ID | NOT NULL | NUMBER | Request identifier
REQUEST_TYPE_ID | NOT NULL | NUMBER | Request type used by the request
WORKLOAD_FLAG | NULLABLE | VARCHAR2(1) | Determines whether this request is to be considered workload in visualizations (Y/N).
WORKLOAD_FLAG_MEANING | NULLABLE | VARCHAR2(200) | Meaning of workload_flag
WORKLOAD_CATEGORY_CODE | NULLABLE | VARCHAR2(30) | Lookup code of 'RSC - Workload Category Code'
WORKLOAD_CATEGORY_MEANING | NULLABLE | VARCHAR2(200) | Lookup meaning of 'RSC - Workload Category Code'
ALLOW_EXTERNAL_UPDATE_FLAG | NULLABLE | VARCHAR2(1) | Determines whether this request can be updated by Time Management (Y/N).
USR_SCHEDULED_START_DATE | NULLABLE | DATE | Scheduled Start Date formatted for viewing
USR_SCHEDULED_FINISH_DATE | NULLABLE | DATE | Scheduled Finish Date formatted for viewing
SCHEDULED_START_DATE | NULLABLE | DATE | Date on which work on the request is scheduled to start
SCHEDULED_FINISH_DATE | NULLABLE | DATE | Date on which work on the request is scheduled to end.
SCHEDULED_EFFORT | NULLABLE | NUMBER | Number of hours estimated to be worked on the request
SCHEDULED_DURATION | NULLABLE | NUMBER | Number of days over which work on this request will take place not including non-working days
SCHED_EFF_OVER_DUR | NULLABLE | NUMBER | Ratio of Scheduled Effort/Duration. Used for defaulting logic
USR_ACTUAL_START_DATE | NULLABLE | DATE | Actual Start Date formatted for viewing
USR_ACTUAL_FINISH_DATE | NULLABLE | DATE | Actual Finish Date formatted for viewing
ACTUAL_START_DATE | NULLABLE | DATE | Date on which work on the request started
ACTUAL_FINISH_DATE | NULLABLE | DATE | Date on which work on the request ended
ACTUAL_EFFORT | NULLABLE | NUMBER | Number of hours worked on the request
ACTUAL_DURATION | NULLABLE | NUMBER | Number of days over which work on this request took place not including non-working days
ACTUAL_EFF_OVER_DUR | NULLABLE | NUMBER | Ratio of Actual Effort to Duration. Used for defaulting logic.
ROLE_ID | NULLABLE | NUMBER | Role of the resource that is assigned to the item
ROLE_NAME | NULLABLE | VARCHAR2(200) | Name of the role represented by ROLE_ID

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KCRT_FG_WORK_ITEMS_N1 | NONUNIQUE | 1 | ROLE_ID
KCRT_FG_WORK_ITEMS_N2 | NONUNIQUE | 1 | WORKLOAD_FLAG
KCRT_FG_WORK_ITEMS_N2 | NONUNIQUE | 2 | WORKLOAD_CATEGORY_CODE
KCRT_FG_WORK_ITEMS_U1 | UNIQUE | 1 | REQUEST_ID

## Sequences

This table uses no sequences.

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: