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.