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 |
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 |