Share this page

# RPT_FCT_PM_TASK_COST

This is a fact table which stores the project cost information.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
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.

## Indexes

This table uses no indexes.

## Sequences

Sequence Name | Sequence Type
--- | ---
RPT_FCT_PM_TASK_COST_S | TASK_COST_ID

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: