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