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 |