Share this page

# KTMG_WI_ACTUALS_SUM

This table is added for performance. It stores the sum of the actuals of TM Work Items.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KCRT_REQUESTS | REQUEST_ID | WORK_ITEM_ID
KDLV_PACKAGES | PACKAGE_ID | WORK_ITEM_ID
WP_TASKS | TASK_ID | WORK_ITEM_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
WORK_ITEM_ID | NOT NULL | NUMBER | ID of the work item
WORK_ITEM_TYPE_CODE | NOT NULL | VARCHAR2(40) | Code of the type of the work item
ACTUAL_TO_DATE | NOT NULL | FLOAT | Total time logged for this work item at the time this record is logged
LAST_UPDATE_TIME | NOT NULL | DATE | Last time this record was updated

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
KTMG_WI_ACTUALS_SUM_U1 | UNIQUE | 1 | WORK_ITEM_ID
KTMG_WI_ACTUALS_SUM_U1 | UNIQUE | 2 | WORK_ITEM_TYPE_CODE

## 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: