WP_TASK_ACTUALS

This table stores information about the actuals logged against a particular task.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

ACTUALS_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

ACT_DURATION

NULLABLE

FLOAT

Actual duration for this task

ACT_EFFORT

NULLABLE

FLOAT

Actual effort entered against this task

ACT_FINISH_DATE

NULLABLE

DATE

Actual finish date for this task

ACT_START_DATE

NULLABLE

DATE

Actual start date for this task

EST_FINISH_DATE

NULLABLE

DATE

Estimated finish date for this task

EST_REM_EFFORT

NULLABLE

FLOAT

Estimated remaining effort in hours for this task

TOT_SCHED_DURATION

NULLABLE

FLOAT

Stores, for summary tasks, the sum of the duration of its children

PERC_COMPLETE

NULLABLE

FLOAT

Percent complete for this task

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

CREATION_DATE

NOT NULL

DATE

Date record was created

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

OWNER_TASK_ID

NULLABLE

NUMBER

ID of the task in WP_TASKS table

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C00109356204

UNIQUE

1

ACTUALS_ID

Sequences

Sequence Name

Sequence Type

WP_TASK_ACTUALS_S

ACTUALS_ID