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