KDRV_COST_METRICS_BY_PERIOD

This table stores the cost information for a project by periods.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KCST_CURRENCIES_NLS

CURRENCY_ID

LOCAL_CURRENCY_ID

PPM_FISCAL_PERIODS_NLS

FISCAL_PERIOD_ID

PERIOD_ID

PM_PROJECTS

PROJECT_ID

PROJECT_ID

Column Descriptions

Column Name

Null?

Data Type

Description

COST_METRICS_BY_PERIOD_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

PROJECT_ID

NOT NULL

NUMBER

Identifier for the Project

PERIOD_ID

NOT NULL

NUMBER

Identifier for the Period

LOCAL_CURRENCY_ID

NOT NULL

NUMBER

Identifier for the local currency

PLANNED_VALUE_LCL

NULLABLE

NUMBER

Planned cost value in local currency

PLANNED_VALUE_BSE

NULLABLE

NUMBER

Planned cost value in base currency

EARNED_VALUE_LCL

NULLABLE

NUMBER

Earned value in local currency

EARNED_VALUE_BSE

NULLABLE

NUMBER

Earned value in base currency

Indexes

Index Name

Index Type

Sequence

Column Name

KDRV_COST_METRICS_BY_PERIOD_U1

UNIQUE

1

COST_METRICS_BY_PERIOD_ID

KDRV_COST_METRICS_BY_PERIOD_U2

UNIQUE

1

PROJECT_ID

KDRV_COST_METRICS_BY_PERIOD_U2

UNIQUE

2

FISCAL_PERIOD_ID

Sequences

Sequence Name

Sequence Type

KDRV_COST_METRICS_BY_PERIOD_S

COST_METRICS_BY_PERIOD_ID