Share this page

# RPT_DIM_PM_TASKS

This table holds the task information that is derived from PPM table. All the fields are derived from PPM task table.

## Foreign Keys

This table does not have any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
TASK_ID | NOT NULL | NUMBER | Unique ID of the TASK table
PROJECT_ID | NULLABLE | NUMBER | Identifier of the related project
WORK_PLAN_ID | NULLABLE | NUMBER | Identifier of the related work plan
TASK_NAME | NULLABLE | VARCHAR2(300) | Name of the task
TASK_DESCRIPTION | NULLABLE | VARCHAR2(300) | Description of the task
PRIORITY | NULLABLE | NUMBER | Priority of the task
STATUS | NULLABLE | VARCHAR2(150) | Status of the task
TASK_TYPE | NULLABLE | VARCHAR2(1) | Type of the task
MILESTONE | NULLABLE | VARCHAR2(1) | It indicates if task is milestone
MAJOR_MILESTONE | NULLABLE | VARCHAR2(1) | It indicates if task is major milestone
IN_CRITICAL_PATH | NULLABLE | VARCHAR2(1) | It indicates if task is in critical path
PARENT_TASK_ID | NULLABLE | NUMBER | ID of parent task
PARENT_TASK_NAME | NULLABLE | VARCHAR2(300) | Name of parent task
SCHED_START_DATE | NULLABLE | DATE | Schedule start date of the task
SCHED_FINISH_DATE | NULLABLE | DATE | Schedule finish date of the task
SCHED_DURATION | NULLABLE | FLOAT | Schedule duration of the task
PERC_COMPLETE | NULLABLE | FLOAT | Percent Complete of the task
ACTUAL_START_DATE | NULLABLE | DATE | Actual start date of the task
ACTUAL_FINISH_DATE | NULLABLE | DATE | Actual finish date of the task
ACTUAL_DURATION | NULLABLE | FLOAT | Actual duration of the task
ESTIMATED_FINISH_DATE | NULLABLE | DATE | Estimated finish date of the task
CREATED_BY_FIRSTNAME | NULLABLE | VARCHAR2(80) | First Name of user who creates the task
CREATED_BY_LASTNAME | NULLABLE | VARCHAR2(80) | Last Name of user who creates the task
CREATION_DATE | NULLABLE | DATE | Task creation date
SERVICE_ID | NULLABLE | VARCHAR2(40) | ID of the related service
SERVICE_NAME | NULLABLE | VARCHAR2(255) | Name of the related service
SCHEDULE_HEALTH | NULLABLE | VARCHAR2(255) | Schedule health of the task
EXCEPTION_TASK_COUNT | NULLABLE | NUMBER | Number of exception in task
TOTAL_EXCEPTION_COUNT | NULLABLE | NUMBER | Total exception count in the project
DATUM1_CODE | NULLABLE | VARCHAR2(255) | User data code 1
DATUM1_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 1
DATUM2_CODE | NULLABLE | VARCHAR2(255) | User data code 2
DATUM2_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 2
DATUM3_CODE | NULLABLE | VARCHAR2(255) | User data code 3
DATUM3_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 3
DATUM4_CODE | NULLABLE | VARCHAR2(255) | User data code 4
DATUM4_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 4
DATUM5_CODE | NULLABLE | VARCHAR2(255) | User data code 5
DATUM5_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 5
DATUM6_CODE | NULLABLE | VARCHAR2(255) | User data code 6
DATUM6_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 6
DATUM7_CODE | NULLABLE | VARCHAR2(255) | User data code 7
DATUM7_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 7
DATUM8_CODE | NULLABLE | VARCHAR2(255) | User data code 8
DATUM8_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 8
DATUM9_CODE | NULLABLE | VARCHAR2(255) | User data code 9
DATUM9_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 9
DATUM10_CODE | NULLABLE | VARCHAR2(255) | User data code 10
DATUM10_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 10
DATUM11_CODE | NULLABLE | VARCHAR2(255) | User data code 11
DATUM11_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 11
DATUM12_CODE | NULLABLE | VARCHAR2(255) | User data code 12
DATUM12_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 12
DATUM13_CODE | NULLABLE | VARCHAR2(255) | User data code 13
DATUM13_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 13
DATUM14_CODE | NULLABLE | VARCHAR2(255) | User data code 14
DATUM14_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 14
DATUM15_CODE | NULLABLE | VARCHAR2(255) | User data code 15
DATUM15_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 15
DATUM16_CODE | NULLABLE | VARCHAR2(255) | User data code 16
DATUM16_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 16
DATUM17_CODE | NULLABLE | VARCHAR2(255) | User data code 17
DATUM17_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 17
DATUM18_CODE | NULLABLE | VARCHAR2(255) | User data code 18
DATUM18_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 18
DATUM19_CODE | NULLABLE | VARCHAR2(255) | User data code 19
DATUM19_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 19
DATUM20_CODE | NULLABLE | VARCHAR2(255) | User data code 20
DATUM20_VISIBLE | NULLABLE | VARCHAR2(255) | Visible value of user data code 20

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
RPT_DIM_PM_TASKS_N1 | NONUNIQUE | 1 | TASK_ID
RPT_DIM_PM_TASKS_N2 | NONUNIQUE | 1 | PROJECT_ID
RPT_DIM_PM_TASKS_N3 | NONUNIQUE | 1 | PARENT_TASK_ID
RPT_DIM_PM_TASKS_N4 | NONUNIQUE | 1 | STATUS

## Sequences

This table uses no sequences.

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: