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