TM_WORK_UNITS

This table stores information about assignments of resources to Request, Tasks and Projects - as viewed on time sheets.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

RSC_RESOURCES

RESOURCE_ID

RESOURCE_ID

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

TM_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

WORK_ITEM_ID

NOT NULL

VARCHAR2(255)

Identifies the item that this work unit represents. Valid values represent Request IDs, Project IDs, Task IDs.

WORK_ITEM_TYPE

NOT NULL

VARCHAR2(255)

Indicates the type of item that this work unit represents. Valid values are REQUEST, TASK, and PROJECT

RESOURCE_ID

NOT NULL

NUMBER

ID of the resource associated with this item in this work unit

ACT_START_DATE

NULLABLE

DATE

Actual start date of the resource on this work item

ACT_FINISH_DATE

NULLABLE

DATE

Actual finish date of the resource on this work item

ACT_EFFORT

NULLABLE

NUMBER

Actual effort, in days, of the resource on this work item

PERC_COMPLETE

NULLABLE

NUMBER

Actual percent complete of the resource on this work item

EST_EFFORT

NULLABLE

NUMBER

Estimated remaining effort of the resource on this work item

EST_FINISH_DATE

NULLABLE

DATE

Estimated finish date of the resource on this work item

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

NEEDS_SYNC

NOT NULL

VARCHAR2(1)

Flag (Y/N) whether this TM work unit was changed in TM and needs to be synchronized to PjM, in the next run of the TM-PM Sync Service

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005200557

UNIQUE

1

WORK_ITEM_ID

SYS_C005200557

UNIQUE

2

WORK_ITEM_TYPE

SYS_C005200557

UNIQUE

3

RESOURCE_ID

SYS_C005201601

UNIQUE

1

TM_WORK_UNIT_ID

Sequences

Sequence Name

Sequence Type

TM_WORK_UNITS_S

TM_WORK_UNIT_ID