RPT_FCT_PM_TASK_COST

TASK_COST_ID

NOT NULL

NUMBER

System-generated identifier using RPT_FCT_PM_TASK_COST_S sequence

TASK_ID

NOT NULL

NUMBER

ID of a task of a project

WORK_PLAN_ID

NULLABLE

NUMBER

ID of work plan of a project

PROJECT_ID

NULLABLE

NUMBER

ID of a PPM project. It relates to the project_id of the pm_projects table.

REGION_ID

NULLABLE

NUMBER

ID of the region the cost is associated with. It is derived from project's region.

PLAN_CAP_LABOR_BSE

NULLABLE

NUMBER

Planned capital labor cost of a project, expressed in base currency.

PLAN_CAP_LABOR_LCL

NULLABLE

NUMBER

Planned capital labor cost of a project, expressed in local currency.

PLAN_CAP_NON_LABOR_BSE

NULLABLE

NUMBER

Planned capital non labor cost of a project, expressed in base currency.

PLAN_CAP_NON_LABOR_LCL

NULLABLE

NUMBER

Planned capital non labor cost of a project, expressed in local currency.

PLAN_OP_LABOR_BSE

NULLABLE

NUMBER

Planned operating labor cost of a project, expressed in base currency.

PLAN_OP_LABOR_LCL

NULLABLE

NUMBER

Planned operating labor cost of a project, expressed in local currency.

PLAN_OP_NON_LABOR_BSE

NULLABLE

NUMBER

Planned operating non labor cost of a project, expressed in base currency.

PLAN_OP_NON_LABOR_LCL

NULLABLE

NUMBER

Planned operating non labor cost of a project, expressed in local currency.

ACT_CAP_LABOR_BSE

NULLABLE

NUMBER

Actual capital labor cost of a project, expressed in base currency.

ACT_CAP_LABOR_LCL

NULLABLE

NUMBER

Actual capital labor cost of a project, expressed in local currency.

ACT_CAP_NON_LABOR_BSE

NULLABLE

NUMBER

Actual capital non labor cost of a project, expressed in base currency.

ACT_CAP_NON_LABOR_LCL

NULLABLE

NUMBER

Actual capital non labor cost of a project, expressed in local currency.

ACT_OP_LABOR_BSE

NULLABLE

NUMBER

Actual operating labor cost of a project, expressed in base currency.

ACT_OP_LABOR_LCL

NULLABLE

NUMBER

Actual operating labor cost of a project, expressed in local currency.

ACT_OP_NON_LABOR_BSE

NULLABLE

NUMBER

Actual operating non labor cost of a project, expressed in base currency.

ACT_OP_NON_LABOR_LCL

NULLABLE

NUMBER

Actual operating non labor cost of a project, expressed in local currency.

EARNED_VALUE_BSE

NULLABLE

NUMBER

Earned value of the completed project work, expressed in base currency.

EARNED_VALUE_LCL

NULLABLE

NUMBER

Earned value of the completed project work, expressed in local currency.

PLANNED_VALUE_BSE

NULLABLE

NUMBER

Planned value of work to be performed for a project, expressed in base currency.

PLANNED_VALUE_LCL

NULLABLE

NUMBER

Planned value of work to be performed for a project, expressed in local currency.

SPI

NULLABLE

FLOAT

Schedule Performance Index (ratio of earned value to planned value for a project), is a measure of project efficiency. An SPI equal to or greater than one indicates a favorable condition and value of less than one indicates an unfavorable condition.

CPI

NULLABLE

FLOAT

Schedule Performance Index (ratio of earned value to actual cost for a project), is a measure of cost efficiency of a project. A CPI equal to or greater than one indicates a favorable condition and value of less than one indicates an unfavorable condition.

BASE_CUR_CODE

NULLABLE

VARCHAR2(255)

Base currency code associated with the project. Example: USD for United States Dollar. (The base currency defaults to the PPM Center base currency.)

BASE_CUR_SYMBOL

NULLABLE

VARCHAR2(255)

Symbol for the base currency used for the project. Example: $ for USD.

LOCAL_CUR_CODE

NULLABLE

VARCHAR2(255)

Base currency code associated with the project. Example: USD for United States Dollar. (The local currency defaults to the PPM Center local currency.)

LOCAL_CUR_SYMBOL

NULLABLE

VARCHAR2(255)

Symbol for the local currency used for the project. Example: $ for USD.

RPT_FCT_PM_TASK_COST_S

TASK_COST_ID