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 |