Share this page

# DIM_TASKS

This table stores all task information.

## Foreign Keys

Primary Key Table | Primary Key Column | Foreign Key Column
--- | --- | ---
DIM_TASKS | PARENT_TASK_ID | PK_TASKS_ID
DIM_PROJECTS | PROJECT_ID | PK_ PROJECTS_ID

## Column Descriptions

Column Name | Null? | Data Type | Description | SCD2
--- | --- | --- | --- | ---
PK_TASKS_ID | Nullable | INT | System-generated identifier | No
MD_BUSINESS_KEY | Nullable | VARCHAR (1000) | Primary key that is mapped to one or more source columns | No
MD_ENTERPRISE_KEY | Nullable | INT | Unique identifier for entity | No
TASK_COST_ID | Nullable | INT | Unique identifier for task cost ID that stores information about that task costs task costs | No
ACT_CAP_LABOR_BSE | Nullable | NUMERIC | Actual labor capitalized cost in base currency | No
ACT_CAP_LABOR_LCL | Nullable | NUMERIC | Actual labor capitalized cost in local currency | No
ACT_CAP_LABOR_CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the actual labor capitalized cost | No
ACT_CAP_NON_LABOR_ BSE | Nullable | NUMERIC | Actual non-labor capitalized cost in base currency | No
ACT_CAP_NON_LABOR_LCL | Nullable | NUMERIC | Actual non-labor capitalized cost in local currency | No
ACT_CAP_NON_LABOR_ CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the actual non-labor capitalized cost | No
ACT_OP_LABOR_BSE | Nullable | NUMERIC | Actual labor operational cost in base currency | No
ACT_OP_LABOR_LCL | Nullable | NUMERIC | Actual labor operational cost in local currency | No
ACT_OP_LABOR_CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the actual labor operational cost | No
ACT_OP_NON_LABOR_BSE | Nullable | NUMERIC | Actual non-labor operational cost in base currency | No
ACT_OP_NON_LABOR_LCL | Nullable | NUMERIC | Actual non-labor operational cost in local currency | No
ACT_OP_NON_LABOR_ CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the actual non-labor operational cost | No
PLAN_CAP_LABOR_BSE | Nullable | NUMERIC | Plan labor capitalized cost in base currency | No
PLAN_CAP_LABOR_LCL | Nullable | NUMERIC | Plan labor capitalized cost in local currency | No
PLAN_CAP_LABOR_CUR_ LCL | Nullable | VARCHAR (255) | Local currency used for the plan labo capitalized cost | No
PLAN_CAP_NON_LABOR_ BSE | Nullable | NUMERIC | Plan non-labor capitalized cost in base currency | No
PLAN_CAP_NON_LABOR_ LCL | Nullable | NUMERIC | Plan non-labor capitalized cost in local currency | No
PLAN_CAP_NON_LABOR_ CUR_LCL | Nullable | VARCAHR (255) | Local currency used for the plan non-labor capitalized cost | No
PLAN_OP_LABOR_BSE | Nullable | NUMERIC | Plan labor operational cost in base currency | No
PLAN_OP_LABOR_LCL | Nullable | NUMERIC | Plan labor operational cost in local currency | No
PLAN_OP_LABOR_CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the plan labor operational cost | No
PLAN_OP_NON_LABOR_BSE | Nullable | NUMERIC | Plan non-labor operational cost in base currency | No
PLAN_OP_NON_LABOR_LCL | Nullable | NUMERIC | Plan non-labor operational cost in local currency | No
PLAN_OP_NON_LABOR_ CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the plan non-labor operational cost | No
CPI | Nullable | FLOAT | Cost Performance Index | No
EARNED_VALUE_BSE | Nullable | NUMERIC | Earned value in base currency | No
EARNED_VALUE_LCL | Nullable | NUMERIC | Earned value in local currency | No
EARNED_VALUE_CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the earned value | No
PLANNED_VALUE_BSE | Nullable | NUMERIC | Planned value in base currency | No
PLANNED_VALUE_LCL | Nullable | NUMERIC | Planned value in local currency | No
PLANNED_VALUE_CUR_LCL | Nullable | VARCHAR (255) | Local currency used for the planned value | No
COST_HEALTH | Nullable | VARCHAR (255) | Cost health | No
SPI | Nullable | FLOAT | Schedule performance index | No
OUTLINE_LEVEL | Nullable | INT | Indicate the level of indentation in the work plan tree | No
PARENT_TASK_ID | Nullable | INT | Identifies this task's parent task | Yes
PARENT_TASK_BUSINESS_ KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to DIM_TASKS | Yes
PARENT_TASK_ ENTERPRISE_KEY | Nullable | INT | Unique identifier for foreign key | Yes
PATH_ID_LIST | Nullable | VARCHAR (600) | Provides a list of task IDs representing the path from the work plan root node to this task | No
SEQUENCE_NUMBER | Nullable | INT | Indicates this task's sequence number within the work plan | No
TASK_INFO_ID | Nullable | INT | Identifies which stores general information about that task | No
ACTIVITY_ID | Nullable | INT | indicates the task's activity | Yes
ACTIVITY_NAME | Nullable | VARCHAR (255) | Defines the name given to this activity | No
ACTIVITY_DESCRIPTION | Nullable | VARCHAR (650) | Describes the activity | No
CRITICAL_PATH_TASK | Nullable | INT | Indicates whether a given task is on the work plan critical path | No
AUTO_EFFORT_MODE | Nullable | VARCHAR(1) | Indicates whether effort is entered automatically (computed based on the resource calendar and the task duration) or manually | No
TASK_NAME | Nullable | VARCHAR (300) | Indicates the name of the task | No
TASK_DESC | Nullable | VARCHAR (300) | Indicates the description of the task | No
PRIORITY | Nullable | INT | Indicates the priority for the task | No
TASK_TYPE_CODE | Nullable | VARCHAR(1) | Indicates whether the task is a leaf task (L), a summary task (S), or a milestone (M) | Yes
ROLE_ID | Nullable | INT | Identifier which stores the role associated with the task | Yes
ROLE_NAME | Nullable | VARCHAR (260) | Indicates the role name associated with the task. | Yes
SCHEDULE_HEALTH | Nullable | VARCHAR (255) | Indicates the schedule health of the task | No
SLACK | Nullable | INT | Indicates the task's slack | No
TASK_STATUS | Nullable | INT | Indicates the status of the task . Lookup code `PM - Task Statuses`. | No
TASK_STATUS_NAME | Nullable | VARCHAR (150) | Indicates the status name of the task | No
REQUIRED | Nullable | VARCHAR(1) | Indicates whether this task is required on the work plan and cannot be deleted | No
SERVICE_ID | Nullable | VARCHAR (40) | The service ID | No
SERVICE_NAME | Nullable | VARCHAR (255) | The service name | No
OVERRIDE_SERVICE | Nullable | VARCHAR(1) | Indicates whether this service can b overridden by parent node, the default flag `N` represents the overridden. | No
TASK_USERDATA_ID | Nullable | INT | Identifier to which stores use customizable data | Y
DATUM1-20_VISIBLE | Nullable | VARCHAR (255) | User data visible value | No
DATUM1-20_CODE | Nullable | VARCHAR (255) | User data hidden value | No
WORK_PLAN_ID | Nullable | INT | Identifies the work plan this task belongs to | No
WORK_PLAN_ENTITY_TYPE | Nullable | VARCHAR (255) | Stores the entity type for the entity. For example, it may put WORK_PLAN for work plan entity and BASE_LINE for baseline entity. | No
WORK_PLAN_NAME | Nullable | VARCHAR (300) | Name of the work plan | No
WORK_PLAN_DESCRIPTION | Nullable | VARCHAR (650) | Description of the work plan | No
PROJECT_ID | Nullable | INT | Project ID to which the entity belongs to | Y
PROJECT_BUSINESS_KEY | Nullable | VARCHAR (1000) | Foreign key that is mapped to dim_person | Y
PROJECT_ENTERPRISE_ KEY | Nullable | INT | Unique identifier for foreign key | Y
PROJECT_NAME | Nullable | VARCHAR (300) | Indicates the project name associated with this task | No
MSP_UID | Nullable | INT | Stores the identifier for this task in Microsoft Project | No
BUSINESS_UID | Nullable | INT | Identifies the original task this task is a baseline of (if applicable) | No
MD_BATCH_ID | Nullable | INT | ID of data batch | No
MD_PROCESS_ID | Nullable | INT | ID of ETL process running on a specific task | No
MD_SOURCE_INSTANCE_ID | Nullable | INT | Content pack ID of source instance | No
MD_CREATEDDATE | Nullable | DATETIME | Date of the record being inserted | No
MD_DELETEDDATE | Nullable | DATETIME | Date of the record being deleted | No
MD_LASTMODDATE | Nullable | DATETIME | Date of the record being updated | No
MD_TRANSLASTIND | Nullable | VARCHAR(1) | Flags whether it is the latest record after updated by SCD2 | No
MD_TRANSENDDATE | Nullable | DATETIME | End date of the record being effective | No
MD_ACTIVESTATUSIND | Nullable | VARCHAR(1) | Flags whether or not the old record is deleted | No
MD_HASH_CODE_SCD1 | Nullable | VARCHAR (40) | (Only for dimension table) Hash code that is generated by SCD1 columns | No
MD_HASH_CODE_SCD2 | Nullable | VARCHAR (40) | (Only for dimension table) Hash code that is generated by SCD2 columns | No

## Projections

This table uses no projections.

## Sequences

Sequence Name | Sequence Type
--- | ---
TASKS_ENTERPRISE_XREF_SEQ | MD_ENTERPRISE_KEY
TASKS_KEY_LOOKUP_SEQ | PK_ TASKS_ID
PROJECTS_ENTERPRISE_XREF_SEQ | PROJECT_ENTERPRISE_KEY
PROJECTS_KEY_LOOKUP_SEQ | PROJECT_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: