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