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 |