PM_PROJECT_ROLLUP

This table stores project health information which are normally obtained from rollup calculation for the whole project or work plan.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

ROLLUP_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually

SCHEDULE_HEALTH_INDICATOR

NULLABLE

VARCHAR2(255)

Stores project schedule health information

OVERRIDE_DATE

NULLABLE

DATE

Stores date the project health was overridden.

OVERRIDE_DESCRIPTION

NULLABLE

VARCHAR2(750)

Stores the description for overriding the project health

OVERALL_HEALTH_INDICATOR

NULLABLE

VARCHAR2(255)

Stores the overall health information for the project

COST_HEALTH_INDICATOR

NULLABLE

VARCHAR2(255)

Stores the cost health information for the project

BUDGET_OVERRUN

NULLABLE

FLOAT

Stores the project budget overrun information

ISSUE_HEALTH_INDICATOR

NULLABLE

VARCHAR2(255)

Stores the project health information

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

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201557

UNIQUE

1

ROLLUP_ID

Sequences

Sequence Name

Sequence Type

PM_PROJECT_ROLLUP_S

ROLLUP_ID