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