Share this page

# PM_WORK_PLANS

This table stores PPM work plan entities.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY
PM_WORK_PLANS | WORK_PLAN_ID | MASTER_WORK_PLAN_ID
KNTA_USERS | USER_ID | OWNER_USER_ID
PM_PROJECTS | PROJECT_ID | PROJECT_ID
WP_TASKS | TASK_ID | ROOT_TASK_ID
PM_WORKPLAN_TEMPLATES | WORKPLAN_TEMPLATE_ID | WORK_PLAN_TEMPLATE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
WORK_PLAN_ID | NOT NULL | NUMBER | System-generated identifier
ENTITY_TYPE | NOT NULL | VARCHAR2(255) | Stores the entity type for the entity. For example, it may put "WORK_PLAN" for work plan entity and "BASE_LINE" for baseline entity.
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
MASTER_WORK_PLAN_ID | NULLABLE | NUMBER | Stores the current baseline ID if the entity is a baseline.
WORK_PLAN_TEMPLATE_ID | NULLABLE | NUMBER | Stores work plan template ID used to create this work plan. It will be null if it is not created from the work plan template.
WORK_PLAN_NAME | NULLABLE | VARCHAR2(300) | Name of the work plan
OWNER_USER_ID | NULLABLE | NUMBER | Currently not used
DESCRIPTION | NULLABLE | VARCHAR2(650) | Description of the work plan
IS_ACTIVE_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether the current work plan is active or not
OBSOLETE_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether the current work plan is obsolete or not
PROJECT_ID | NULLABLE | NUMBER | Project ID to which the entity belongs to. It references the Project_id of table pm_projects.
WORK_PLAN_SEQ | NULLABLE | NUMBER | Stores the sequence of the work plan entity.
IS_COPY_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether this entity is a copy of another work plan entity
ROOT_TASK_ID | NULLABLE | NUMBER | Root task of the current work plan. It references task_id of wp_tasks table
COST_CONTOUR_ID | NULLABLE | NUMBER | Stores cost calendar information. It is a foreign key reference to the calendar_id of itg_calendar table
LOCK_REASON | NULLABLE | VARCHAR2(255) | Indicates why the current entity is locked
LOCK_TIMEOUT | NULLABLE | DATE | Indicates the time out period the current lock is effective on the entity.
UNLOCK_TIME | NULLABLE | DATE | Currently not used
SOURCE | NULLABLE | VARCHAR2(255) | Currently not used
SOURCE_TYPE_CODE | NULLABLE | VARCHAR2(255) | Currently not used
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
BASELINE_TYPE | NULLABLE | NUMBER | Used by baseline only. Indicates the baseline type.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKBF9E4B3EB1FFCD6E_I | NONUNIQUE | 1 | OWNER_USER_ID
FKBF9E4B3EF978A454_I | NONUNIQUE | 1 | COST_CONTOUR_ID
PM_WORK_PLANS_N1 | NONUNIQUE | 1 | ROOT_TASK_ID
PM_WORK_PLANS_N2 | NONUNIQUE | 1 | PROJECT_ID
PM_WORK_PLANS_N3 | NONUNIQUE | 1 | MASTER_WORK_PLAN_ID
PM_WORK_PLANS_N4 | NONUNIQUE | 1 | WORK_PLAN_NAME
SYS_C005201572 | UNIQUE | 1 | WORK_PLAN_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PM_WORK_PLANS_S | WORK_PLAN_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: