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 entitytype 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

Contnet 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