PM_WORKPLAN_TEMPLATES

This table stores work plan template entity information.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

ITG_SECURABLE_ENTITIES

SECURABLE_ENTITY_ID

TEMPLATE_ACCESS_SECURABLE_ID

ITG_SECURABLE_ENTITIES

SECURABLE_ENTITY_ID

TEMPLATE_USAGE_SECURABLE_ID

PM_WORK_PLANS

WORK_PLAN_ID

WORK_PLAN_ID

Column Descriptions

Column Name

Null?

Data Type

Description

WORKPLAN_TEMPLATE_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

WORKPLAN_TEMPLATE_NAME

NULLABLE

VARCHAR2(255)

Name of the work plan template

IS_ENABLED_FLAG

NULLABLE

VARCHAR2(1)

Flag to indicate whether the work plan template is enabled

DESCRIPTION

NULLABLE

VARCHAR2(255)

Description of work plan template

WORK_PLAN_ID

NULLABLE

NUMBER

Work plan ID for this template. This is a foreign key reference to work_plan_id of pm_work_plans table.

TEMPLATE_ACCESS_SECURABLE_ID

NULLABLE

NUMBER

Stores template access information. It references securable_entity_id of the itg_securable_entities table.

TEMPLATE_USAGE_SECURABLE_ID

NULLABLE

NUMBER

Stores template usage information. It references securable_entity_id of the itg_securable_entities table.

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

Indexes

Index Name

Index Type

Sequence

Column Name

FK4272B4761EC4DBD6_I

NONUNIQUE

1

TEMPLATE_ACCESS_SECURABLE_ID

FK4272B476DDE96832_I

NONUNIQUE

1

TEMPLATE_USAGE_SECURABLE_ID

SYS_C005200345

UNIQUE

1

WORKPLAN_TEMPLATE_NAME

SYS_C005200346

UNIQUE

1

WORK_PLAN_ID

SYS_C005201571

UNIQUE

1

WORKPLAN_TEMPLATE_ID

Sequences

Sequence Name

Sequence Type

PM_WORKPLAN_TEMPLATES_S

WORKPLAN_TEMPLATE_ID