Share this page

# WP_TASKS

This is the base table for task entities.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
WP_TASKS | TASK_ID | BUSINESS_UID
WP_CALENDAR_CONSTRAINTS | CALENDARCONSTRAINT_ID | CALENDAR_CONSTRAINT_ID
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
WP_MILESTONES | MILESTONE_ID | MILESTONE_ID
WP_TASKS | TASK_ID | PARENT_TASK_ID
WP_TASK_ACTUALS | ACTUALS_ID | TASK_ACTUALS_ID
WP_TASK_COSTS | TASK_COST_ID | TASK_COST_ID
WP_TASK_INFO | TASK_INFO_ID | TASK_INFO_ID
PM_TASK_NOTIFICATION_SETUPS | TASK_NOTIFICATION_SETUP_ID | TASK_NOTIFICATION_ID
WP_TASK_SCHEDULE | TASK_SCHEDULE_ID | TASK_SCHEDULE_ID
WP_USER_DATA | USER_DATA_ID | TASK_USERDATA_ID
PM_WORK_PLANS | WORK_PLAN_ID | WORK_PLAN_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TASK_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
TASK_ACTUALS_ID | NULLABLE | NUMBER | Foreign key to the WP_TASK_ACTUALS table which stores information about that task actuals
CALENDAR_CONSTRAINT_ID | NULLABLE | NUMBER | Foreign key to the WP_CALENDAR_CONSTRAINTS identifying the constraint applied to this task
TASK_COST_ID | NULLABLE | NUMBER | Foreign key to the WP_TASK_COSTS table which stores information about that task costs
MILESTONE_ID | NULLABLE | NUMBER | Foreign key to the WP_MILESTONES table which stores information related to milestone tasks
TASK_NOTIFICATION_ID | NULLABLE | NUMBER | Foreign key to the pm_task_notification_setups storing the notification configuration for this task
OUTLINE_LEVEL | NULLABLE | NUMBER | Indicate the level of indentation in the work plan tree
PARENT_TASK_ID | NULLABLE | NUMBER | Identifies this task's parent task
PATH_ID_LIST | NULLABLE | VARCHAR2(600) | Provides a list of task IDs representing the path from the work plan root node to this task
TASK_SCHEDULE_ID | NULLABLE | NUMBER | Foreign key to the WP_TASK_SCHEDULE table which stores information related to this task's schedule
SEQUENCE_NUMBER | NULLABLE | NUMBER | Indicates this task's sequence number within the work plan
TASK_INFO_ID | NULLABLE | NUMBER | Foreign key to the WP_TASK_INFO table which stores general information about that task
TASK_USERDATA_ID | NULLABLE | NUMBER | Foreign key to the WP_USER_DATA table which stores user customizable data
WORK_PLAN_ID | NULLABLE | NUMBER | Identifies the work plan this task belongs to
MSP_UID | NULLABLE | NUMBER | Stores the identifier for this task in Microsoft Project
BUSINESS_UID | NULLABLE | VARCHAR2(255) | Identifies the original task this task is a baseline of (if applicable)
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
CHILD_TASK_SEQ | NULLABLE | NUMBER | Indicates the sequence of this task relative to its siblings (tasks having the same parent task).
MAPPING_TYPE | NULLABLE | VARCHAR2(1) | "L" if it is a linked task."E" if it is an external task. Null if it is a normal PPM task.
EXTERNAL_UID | NULLABLE | VARCHAR2(100) | Unique identifier of external task

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK1712A6A8D0309419_I | NONUNIQUE | 1 | WORK_PLAN_ID
SYS_C005200613 | UNIQUE | 1 | TASK_USERDATA_ID
SYS_C005200614 | UNIQUE | 1 | TASK_SCHEDULE_ID
SYS_C005200615 | UNIQUE | 1 | TASK_INFO_ID
SYS_C005200616 | UNIQUE | 1 | TASK_ACTUALS_ID
SYS_C005200617 | UNIQUE | 1 | TASK_NOTIFICATION_ID
SYS_C005200618 | UNIQUE | 1 | MILESTONE_ID
SYS_C005200619 | UNIQUE | 1 | TASK_COST_ID
SYS_C005200620 | UNIQUE | 1 | CALENDAR_CONSTRAINT_ID
SYS_C005201610 | UNIQUE | 1 | TASK_ID
WP_TASKS_N2 | NONUNIQUE | 1 | PARENT_TASK_ID
WP_TASKS_N3 | NONUNIQUE | 1 | BUSINESS_UID
WP_TASKS_N4 | NONUNIQUE | 1 | MSP_UID

## Sequences

Sequence Name | Sequence Type
--- | ---
WP_TASKS_S | TASK_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: