WP_WORK_UNITS

This table stores information about assignments of resources to tasks

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

RESOURCE_ID

WP_TASKS

TASK_ID

TASK_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WORK_UNIT_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_START_DATE

NULLABLE

DATE

Actual start date of a resource on a task

RESOURCE_ID

NULLABLE

NUMBER

Identifies the resource assigned

SCHED_EFFORT

NULLABLE

FLOAT

Scheduled effort of a resource on a task

ACT_DURATION

NULLABLE

FLOAT

Actual duration of the assignment of a resource on a task

ACT_EFFORT

NULLABLE

FLOAT

Actual effort spent by a resource on a task

ACT_FINISH_DATE

NULLABLE

DATE

Actual finish date of a resource on a task

EST_EFFORT

NULLABLE

FLOAT

Estimated remaining effort of a resource on a task

EST_FINISH_DATE

NULLABLE

DATE

Estimated finish date of a resource on a task

PERC_COMPLETE

NULLABLE

FLOAT

Percent complete of a resource on a task

TASK_ID

NULLABLE

NUMBER

Identifies the task a resource is assigned to

TM_ORIGIN

NULLABLE

VARCHAR2(1)

Indicates whether actuals need to be entered by the resource on this task through timesheets or directly on the task

MSP_UID

NULLABLE

NUMBER

Identifies the assignment in Microsoft Project
RESOURCE_FROM_POSITION      

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

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005200663

UNIQUE

1

RESOURCE_ID

SYS_C005200663

UNIQUE

2

TASK_ID

SYS_C005201618

UNIQUE

1

WORK_UNIT_ID

WP_WORK_UNITS_TASK_ID_N2

NONUNIQUE

1

TASK_ID

Sequences

Sequence Name

Sequence Type

WP_WORK_UNITS_S

WORK_UNIT_ID