Share this page

# PM_PROJECT_TYPES

This table stores project type and project setting information.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | ISSUE_REQUEST_TYPE_ID
KNTA_USERS | USER_ID | LAST_UPDATED_BY
PM_PROJECTS | PROJECT_ID | PROJECT_ID
KCRT_REQUEST_TYPES_NLS | REQUEST_TYPE_ID | PROJECT_REQUEST_TYPE_ID
ITG_SECURABLE_ENTITIES | SECURABLE_ENTITY_ID | PROJECT_TYPE_EDIT_ACCESS_ID
ITG_SECURABLE_ENTITIES | SECURABLE_ENTITY_ID | PROJECT_TYPE_USAGE_ID
RSC_RESOURCE_POOLS | RESOURCE_POOL_ID | RESOURCE_POOL_ID
KNTA_PENDING_EXCEPTIONS | SOURCE_ID | SOURCE_ID
PM_WORKPLAN_TEMPLATES | WORKPLAN_TEMPLATE_ID | WORKPLAN_TEMPLATE_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PROJECT_TYPE_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
SOURCE_ID | NULLABLE | NUMBER | Indicate the ID of the original Project type instance that this instance was copied from.If this is the original, the source_id should be the same as its own ID
PROJECT_TYPE_NAME | NULLABLE | VARCHAR2(255) | Name of the project type
DESCRIPTION | NULLABLE | VARCHAR2(650) | Description of the project type
ENABLED_FLAG | NULLABLE | VARCHAR2(1) | Indicates whether this project type is enabled
WORKPLAN_TEMPLATE_ID | NULLABLE | NUMBER | Stores Workplan template ID used by this project type. It references the Workplan_template_id of pm_workplan_templates table.
RESOURCE_POOL_ID | NULLABLE | NUMBER | Stores resource pool ID It references the resource_pool_id of rsc_resource_pools table
PROJECT_REQUEST_TYPE_ID | NULLABLE | NUMBER | Stores request type ID It references the request_type_id of KCRT_REQUEST_TYPES
PROJECT_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2(255) | Stores request type name. It references the request_type_name of KCRT_REQUEST_TYPES
ISSUE_REQUEST_TYPE_ID | NULLABLE | NUMBER | Stores the issue request type ID It references the request_type_id of KCRT_REQUEST_TYPES
ISSUE_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2(255) | Stores the issue request type name. It references the request_type_name of KCRT_REQUEST_TYPES
RISK_REQUEST_TYPE_ID | NULLABLE | NUMBER | Stores the risk request type ID It references the request_type_id of KCRT_REQUEST_TYPES
RISK_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2(255) | Stores the risk request type name. It references the request_type_name of KCRT_REQUEST_TYPES
SCOPE_CHANGE_REQUEST_TYPE_ID | NULLABLE | NUMBER | Stores the scope change request type ID It references the request_type_id of KCRT_REQUEST_TYPES
SCOPE_CHANGE_REQUEST_TYPE_NAME | NULLABLE | VARCHAR2(255) | Stores the scope change request type name. It references the request_type_name of KCRT_REQUEST_TYPES.
PROJECT_TYPE_EDIT_ACCESS_ID | NULLABLE | NUMBER | Stores edit access information for the project type entity. It references securable_entity_id of the itg_securable_entities table.
PROJECT_TYPE_USAGE_ID | NULLABLE | NUMBER | Stores usage access information for the project type. It references securable_entity_id of the itg_securable_entities table.
PROJECT_ID | NULLABLE | NUMBER | Project ID associated with the project type setting
INDICATOR_OVERRIDABLE_FLAG | NULLABLE | VARCHAR2(1) | Not currently used
PT_SETTINGS_KEY | NULLABLE | NUMBER | Stores the foreign key to ITG_SETTINGS_CONTAINERS table
CONTEXT_PATH | NULLABLE | VARCHAR2(255) | Stores unique name of itg containers
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
PROJECT_CONTAINER_ID | NULLABLE | NUMBER | Currently not used
ALLOWED_PROJECT_TYPES_SEQ | NULLABLE | NUMBER | Currently not used
WORK_LOAD_CATEGORY_CODE | NULLABLE | VARCHAR2(255) | Represents the work load category. This is the same value from the project settings but allocated a dedicated column for performance reasons.
EN_CHANGE_TO_DEMAND_APPROVAL | NOT NULL | VARCHAR2(1) | Flag to indicate if Change To Demand feature is enabled for this project type. This column is not used in PPM and can be safely ignored.

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FK8BAAB111198C5CC9_I | NONUNIQUE | 1 | PT_SETTINGS_KEY
FK8BAAB1117138459F_I | NONUNIQUE | 1 | PROJECT_TYPE_USAGE_ID
FK8BAAB11186DA93FA_I | NONUNIQUE | 1 | PROJECT_TYPE_EDIT_ACCESS_ID
FK8BAAB11195D2EB1E_I | NONUNIQUE | 1 | PROJECT_ID
FK8BAAB111A578EEB_I | NONUNIQUE | 1 | WORKPLAN_TEMPLATE_ID
FK8BAAB111A85CA660_I | NONUNIQUE | 1 | RESOURCE_POOL_ID
FK8BAAB111C009AE93_I | NONUNIQUE | 1 | PROJECT_CONTAINER_ID
PM_PROJECT_TYPES_N1 | NONUNIQUE | 1 | SOURCE_ID
PM_PROJECT_TYPES_N2 | NONUNIQUE | 1 | PROJECT_TYPE_NAME
SYS_C005201558 | UNIQUE | 1 | PROJECT_TYPE_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PM_PROJECT_TYPES_S | PROJECT_TYPE_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: