Share this page

# WP_TASK_COSTS

This table stores cost information about a task.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
KNTA_USERS | USER_ID | CREATED_BY
KNTA_USERS | USER_ID | LAST_UPDATED_BY

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TASK_COST_ID | NOT NULL | NUMBER | System-generated identifier
VERSION | NOT NULL | NUMBER | System-generated version for the entity. This column must not be updated manually
ACT_CAP_LABOR_BSE | NULLABLE | NUMBER | Actual labor capitalized cost in base currency
ACT_CAP_LABOR_LCL | NULLABLE | NUMBER | Actual labor capitalized cost in local currency
ACT_CAP_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the actual labor capitalized cost
ACT_CAP_NON_LABOR_BSE | NULLABLE | NUMBER | Actual non-labor capitalized cost in base currency
ACT_CAP_NON_LABOR_LCL | NULLABLE | NUMBER | Actual non-labor capitalized cost in local currency
ACT_CAP_NON_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the actual non-labor capitalized cost
ACT_OP_LABOR_BSE | NULLABLE | NUMBER | Actual labor operational cost in base currency
ACT_OP_LABOR_LCL | NULLABLE | NUMBER | Actual labor operational cost in local currency
ACT_OP_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the actual labor operational cost
ACT_OP_NON_LABOR_BSE | NULLABLE | NUMBER | Actual non-labor operational cost in base currency
ACT_OP_NON_LABOR_LCL | NULLABLE | NUMBER | Actual non-labor operational cost in local currency
ACT_OP_NON_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the actual non-labor operational cost
PLAN_CAP_LABOR_BSE | NULLABLE | NUMBER | Plan labor capitalized cost in base currency
PLAN_CAP_LABOR_LCL | NULLABLE | NUMBER | Plan labor capitalized cost in local currency
PLAN_CAP_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the plan labor capitalized cost
PLAN_CAP_NON_LABOR_BSE | NULLABLE | NUMBER | Plan non-labor capitalized cost in base currency
PLAN_CAP_NON_LABOR_LCL | NULLABLE | NUMBER | Plan non-labor capitalized cost in local currency
PLAN_CAP_NON_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the plan non-labor capitalized cost
PLAN_OP_LABOR_BSE | NULLABLE | NUMBER | Plan labor operational cost in base currency
PLAN_OP_LABOR_LCL | NULLABLE | NUMBER | Plan labor operational cost in local currency
PLAN_OP_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the plan labor operational cost
PLAN_OP_NON_LABOR_BSE | NULLABLE | NUMBER | Plan non-labor operational cost in base currency
PLAN_OP_NON_LABOR_LCL | NULLABLE | NUMBER | Plan non-labor operational cost in local currency
PLAN_OP_NON_LABOR_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the plan non-labor operational cost
CPI | NULLABLE | FLOAT | Cost Performance Index
EARNED_VALUE_BSE | NULLABLE | NUMBER | Earned value in base currency
EARNED_VALUE_LCL | NULLABLE | NUMBER | Earned value in local currency
EARNED_VALUE_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the earned value
PLANNED_VALUE_BSE | NULLABLE | NUMBER | Planned value in base currency
PLANNED_VALUE_LCL | NULLABLE | NUMBER | Planned value in local currency
PLANNED_VALUE_CUR_LCL | NULLABLE | VARCHAR2(255) | Local currency used for the planned value
HEALTH | NULLABLE | VARCHAR2(255) | Cost health
SPI | NULLABLE | FLOAT | Schedule Performance Index
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
NON_LABOR_CATEGORY_CODE | NULLABLE | VARCHAR2(40) | Stores the non labor cost category
OWNER_TASK_ID | NULLABLE | NUMBER | ID of the task in WP_TASKS table

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
SYS_C005201612 | UNIQUE | 1 | TASK_COST_ID

## Sequences

Sequence Name | Sequence Type
--- | ---
WP_TASK_COSTS_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: