Share this page

# PM_PROJECTS

This table stores the PPM project 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
KCRT_REQUESTS | REQUEST_ID | PFM_REQUEST_ID
ITG_SECURABLE_ENTITIES | SECURABLE_ENTITY_ID | PROJECT_ACCESS_ID
ITG_SECURABLE_ENTITIES | SECURABLE_ENTITY_ID | PROJECT_COST_ACCESS_ID
PM_PROJECT_TYPES | PROJECT_TYPE_ID | PROJECT_TYPE_ID
KNTA_REGIONS_NLS | REGION_ID | REGION_ID
PM_PROJECT_ROLLUP | ROLLUP_ID | ROLLUP_ID

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
PROJECT_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
ROLLUP_ID | NULLABLE | NUMBER | Provides foreign key reference to pm_project_rollup table
PROJECT_NAME | NULLABLE | VARCHAR2(300) | Stores the name of the project record
DESCRIPTION | NULLABLE | VARCHAR2(650) | Stores the description of the project record.
ASSOCIATED_MSP_PROJECT | NULLABLE | VARCHAR2(255) | Stores the file name and path of the microsoft project if the project is integrated with any MSP file.
PROJECT_MANAGER | NULLABLE | NUMBER | This column is never used
START_DATE_PERIOD | NULLABLE | NUMBER | Provides start period of the project. It is a foreign key reference to fiscal_period_id of PPM_FISCAL_PERIODS table
FINISH_DATE_PERIOD | NULLABLE | NUMBER | Provides end period of the project. It is a foreign key reference to fiscal_period_id of PPM_FISCAL_PERIODS table
REGION_ID | NULLABLE | NUMBER | Provides region information for this project. It is a foreign key reference to region_id of knta_regions table
PROJECT_TYPE_ID | NULLABLE | NUMBER | Provides project type information for the project. It is a foreign key reference to project_type_id of pm_project_types table.
PFM_REQUEST_ID | NULLABLE | NUMBER | Stores the request information associated with each project entity. It is a foreign key reference to request_id of knta_requests table.
DISPLAY_STATUS | NULLABLE | VARCHAR2(255) | This is the status end user sees from the application. Which can be different from the internal status which is stored in the STATUS column.
STATUS | NULLABLE | NUMBER | Provides the project internal status, which must not be visible to the end user and is used internally to keep in sync with the associated request's internal status.
PROJECT_ACCESS_ID | NULLABLE | NUMBER | Provides project access control information. It references security_entity_id of itg_securable_entities table.
PROJECT_COST_ACCESS_ID | NULLABLE | NUMBER | Provides project cost access control information. It references security_entity_id of itg_securable_entities table.
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
Progress | NULLABLE | FLOAT | The progress of the project

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
FKF131A87C24F76528_I | NONUNIQUE | 1 | PROJECT_COST_ACCESS_ID
FKF131A87C304FDB17_I | NONUNIQUE | 1 | PROJECT_ACCESS_ID
FKF131A87C505BB933_I | NONUNIQUE | 1 | REGION_ID
FKF131A87C71368172_I | NONUNIQUE | 1 | PROJECT_MANAGER
FKF131A87C802E73E_I | NONUNIQUE | 1 | FINISH_DATE_PERIOD
FKF131A87C88B8FB3A_I | NONUNIQUE | 1 | PROJECT_TYPE_ID
FKF131A87CA35BE08D_I | NONUNIQUE | 1 | START_DATE_PERIOD
PM_PROJECTS_FI1 | NONUNIQUE | 1 | SYS_NC00021$
PM_PROJECTS_N1 | NONUNIQUE | 1 | PFM_REQUEST_ID
PM_PROJECTS_N2 | NONUNIQUE | 1 | ASSOCIATED_MSP_PROJECT
PPM_PROJ_SEARCH_IDX | NONUNIQUE | 1 | DESCRIPTION
SYS_C005200282 | UNIQUE | 1 | ROLLUP_ID
SYS_C005200283 | UNIQUE | 1 | PROJECT_NAME
SYS_C005201555 | UNIQUE | 1 | PROJECT_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
PM_PROJECTS_S | PROJECT_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: