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 |
