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