P6 - Work Planning / Primavera - Work Planning

Description: Use this subject area to analyze weekly work planning process by comparing project scope and schedule freeze dates each week. In this way, potential risks such as activity planned start date changes can quickly be identified. This subject area requires project specific UDF configuration in P6.

Folder	Subfolder	Field Name	Dimension/ Fact / Lookup	Description	Values Derived From / Calculated By
Fact - Primavera - Spread Snapshot History	Metrics			Metrics
Fact - Primavera - Spread Snapshot History	Metrics	Actual Finish	Fact	The date on which the activity actually finished	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.CS_FINISHED
Fact - Primavera - Spread Snapshot History	Metrics	Actual Start	Fact	The date on which the activity actually started	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.CS_STARTED
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot Finished	Fact	Activities that were Scheduled to Finish since the previous week's Snapshot and Actually finished during their Scheduled week	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_FINISHED
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot Lost Record	Fact	Lost Activities since the previous week's Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_LOST_RECORD
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot New Record	Fact	New Activities since the previous week's Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_NEW_RECORD
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot Planned Date Change	Fact	Planned Date Changes to Activities since the previous week's Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_PLANNED_DATE_CHANGE
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot Scheduled Finish	Fact	Activities Scheduled to Finish since the previous week's Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_SCHEDULED_FINISH
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot Scheduled Start	Fact	Activities Scheduled to Start since the previous week's Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_SCHEDULED_START
Fact - Primavera - Spread Snapshot History	Metrics	Previous Snapshot Started	Fact	Activities that were Scheduled to Start since the previous week's Snapshot and Actually started during their Scheduled week	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.PS_STARTED
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze Finished	Fact	Activities that were Scheduled to Finish as of Schedule Freeze and Actually finished during their Scheduled week	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_FINISHED
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze Lost Record	Fact	Lost Activities since the Schedule Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_LOST_RECORD
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze New Record	Fact	New Activities added since the Schedule Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_NEW_RECORD
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze Planned Date Change	Fact	Planned Date Changes to Activities since the Schedule Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_PLANNED_DATE_CHANGE
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze Scheduled Finished	Fact	Activities Scheduled to Finish as of Schedule Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_SCHEDULED_FINISH
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze Scheduled Start	Fact	Activities Scheduled to Start as of Schedule Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_SCHEDULED_START
Fact - Primavera - Spread Snapshot History	Metrics	Schedule Freeze Started	Fact	Activities that were Scheduled to Start as of Schedule Freeze and Actually started during their Scheduled week	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.TF_STARTED
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze Scheduled Finish	Fact	Activities Scheduled to Finish as of Scope Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_SCHEDULED_FINISH
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze Finished	Fact	Activities that were Scheduled to Finish as of Scope Freeze and Actually finished during their Scheduled week	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_FINISHED
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze Lost Record	Fact	Lost Activities since the Scope Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_LOST_RECORD
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze New Record	Fact	New Activities since the Scope Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_NEW_RECORD
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze Planned Date Change	Fact	Planned Date Changes to Activities since the Scope Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_PLANNED_DATE_CHANGE
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze Scheduled Start	Fact	Activities Scheduled to Start as of Scope Freeze Snapshot	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_SCHEDULED_START
Fact - Primavera - Spread Snapshot History	Metrics	Scope Freeze Started	Fact	Activities that were Scheduled to Start as of Scope Freeze and Actually started during their Scheduled week	Value Derived From : Fact_W_WORK_PROCESS_HF_WorkProcess.SF_STARTED

Activity Folder
Activity	Dates - (Activity)			Activity Dates
Activity	Dates - (Activity)	Actual Finish	Dimension	The date on which the activity actually finished	Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTUAL_FINISH_DATE
Activity	Dates - (Activity)	Actual Start	Dimension	The date on which the activity actually started	Value Derived From : Dim_W_ACTIVITY_HD_ID.ACTUAL_START_DATE
Activity	Dates - (Activity)	Baseline Project Finish	Dimension	The Project Baseline Planned Finish Date.	Value Derived From : Dim_W_ACTIVITY_HD_ID.BASELINE_FINISH_DATE
Activity	Dates - (Activity)	Baseline Project Start	Dimension	The Project Baseline Planned Start Date.	Value Derived From : Dim_W_ACTIVITY_HD_ID.BASELINE_START_DATE
Activity	Dates - (Activity)	Data Date	Dimension	The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied.	Value Derived From : Dim_W_ACTIVITY_HD_ID.DATA_DATE
Activity	Dates - (Activity)	Early Finish	Dimension	The earliest possible date the activity can finish. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability.	Value Derived From : Dim_W_ACTIVITY_HD_ID.EARLY_FINISH_DATE
Activity	Dates - (Activity)	Early Start	Dimension	The earliest possible date the remaining work for the activity can begin. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability.	Value Derived From : Dim_W_ACTIVITY_HD_ID.EARLY_START_DATE
Activity	Dates - (Activity)	Expected Finish	Dimension	The date the activity is expected to finish. Typically, this date is entered in the Timesheets module by the primary resource.	Value Derived From : Dim_W_ACTIVITY_HD_ID.EXPECT_FINISH_DATE
Activity	Dates - (Activity)	External Early Start	Dimension	The External Early Start date is the earliest finish date of all lost external relationships. This field is populated only during import when a relationship is lost because it does not exist in the current database. This date may be used to calculate the start date of the current activity in place of the true relationship when scheduling.	Value Derived From : Dim_W_ACTIVITY_HD_ID.EXTERNAL_EARLY_START_DATE
Activity	Dates - (Activity)	External Late Finish	Dimension	The External Late Finish date is the latest start date of all lost external relationships. This field is populated only during import when a relationship is lost because it does not exist in the current database. This date may be used to calculate the finish date of the current activity in place of the true relationship when scheduling.	Value Derived From : Dim_W_ACTIVITY_HD_ID.EXTERNAL_LATE_FINISH_DATE
Activity	Dates - (Activity)	Finish	Dimension	The current finish date of the activity. Set to the activity remaining early finish date while the activity is not started or in progress, and the actual finish date once the activity is completed.	Value Derived From : Dim_W_ACTIVITY_HD_ID.FINISH_DATE
Activity	Dates - (Activity)	Late Finish	Dimension	The latest possible date the activity must finish without delaying the project finish date. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability.	Value Derived From : Dim_W_ACTIVITY_HD_ID.LATE_FINISH_DATE
Activity	Dates - (Activity)	Late Start	Dimension	The latest possible date the remaining work for the activity must begin without delaying the project finish date. This date is calculated by the project scheduler based on activity relationships, schedule constraints, and resource availability.	Value Derived From : Dim_W_ACTIVITY_HD_ID.LATE_START_DATE
Activity	Dates - (Activity)	Planned Finish	Dimension	The date the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started.	Value Derived From : Dim_W_ACTIVITY_HD_ID.PLANNED_FINISH_DATE
Activity	Dates - (Activity)	Planned Start	Dimension	The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started.	Value Derived From : Dim_W_ACTIVITY_HD_ID.PLANNED_START_DATE
Activity	Dates - (Activity)	Primary Constraint Date	Dimension	The constraint date for the activity, if the activity has a constraint. The activity's constraint type determines whether this is a start date or finish date. Activity constraints are used by the project scheduler.	Value Derived From : Dim_W_ACTIVITY_HD_ID.PRIMARY_CONSTRAINT_DATE
Activity	Dates - (Activity)	Remaining Early Finish	Dimension	The date the remaining work for the activity is scheduled to finish. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining finish date is the same as the planned finish date. This is the finish date that Progress Reporter users follow.	Value Derived From : Dim_W_ACTIVITY_HD_ID.REMAINING_FINISH_DATE
Activity	Dates - (Activity)	Remaining Early Start	Dimension	The date the remaining work for the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. Before the activity is started, the remaining start date is the same as the planned start date. This is the start date that Progress Reporter users follow.	Value Derived From : Dim_W_ACTIVITY_HD_ID.REMAINING_START_DATE
Activity	Dates - (Activity)	Remaining Late Finish	Dimension	Remaining late end date is calculated by the scheduler.	Value Derived From : Dim_W_ACTIVITY_HD_ID.REMAINING_LATE_FINISH_DATE
Activity	Dates - (Activity)	Remaining Late Start	Dimension	Remaining late start date is calculated by the scheduler.	Value Derived From : Dim_W_ACTIVITY_HD_ID.REMAINING_LATE_START_DATE
Activity	Dates - (Activity)	Resume Date	Dimension	The date progress is resumed on an activity.	Value Derived From : Dim_W_ACTIVITY_HD_ID.RESUME_DATE
Activity	Dates - (Activity)	Schedule Freeze Date	Dimension	The activity schedule freeze date	Value Derived From : Dim_W_ACTIVITY_HD_ID.SCHEDULE_FREEZE_DATE
Activity	Dates - (Activity)	Scope Freeze Date	Dimension	The activity scope freeze date	Value Derived From : Dim_W_ACTIVITY_HD_ID.SCOPE_FREEZE_DATE
Activity	Dates - (Activity)	Secondary Constraint Date	Dimension	The second constraint date for the activity, if the activity has a constraint.	Value Derived From : Dim_W_ACTIVITY_HD_ID.SECONDARY_CONSTRAINT_DATE
Activity	Dates - (Activity)	Start	Dimension	The current start date of the activity. Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started.	Value Derived From : Dim_W_ACTIVITY_HD_ID.START_DATE
Activity	Dates - (Activity)	Suspend Date	Dimension	The date progress is suspended on an activity.	Value Derived From : Dim_W_ACTIVITY_HD_ID.SUSPEND_DATE

Project Folder
Project	Dates - (Project)			Project Dates
Project	Dates - (Project)	Anticipated Finish	Dimension	Anticipated finish date of WBS, Project and EPS elements. User-entered - not dependent upon any other fields. If there are no children, the anticipated finish date will be the Finish date displayed in the columns.	Value Derived From : Dim_W_PROJECT_HD_ID.ANTICIPATED_FINISH_DATE
Project	Dates - (Project)	Anticipated Start	Dimension	Anticipated start date of WBS, Project and EPS elements. User-entered - not dependent upon any other fields. If there are no children, the anticipated start date will be the Start date displayed in the columns.	Value Derived From : Dim_W_PROJECT_HD_ID.ANTICIPATED_START_DATE
Project	Dates - (Project)	Data Date	Dimension	The current data date for the project. The project status is up to date as of the data date. The data date is modified when project actuals are applied.	Value Derived From : Dim_W_PROJECT_HD_ID.DATA_DATE
Project	Dates - (Project)	Date Added	Dimension	The date this activity was inserted.	Value Derived From : Dim_W_PROJECT_HD_ID.ADD_DATE
Project	Dates - (Project)	Finish	Dimension	The current finish date of the activity. Set to the activity remaining early finish date while the activity is not started or in progress, and the actual finish date once the activity is completed.	Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_FINISH_DATE
Project	Dates - (Project)	Forecast Finish Date	Dimension	An alternate end date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in a resource analysis layout, tracking or PA). In User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates.	Value Derived From : Dim_W_PROJECT_HD_ID.FORECAST_FINISH_DATE
Project	Dates - (Project)	Forecast Start Date	Dimension	An alternate start date to be optionally used by the scheduler (see Schedule dialog), which is set by the user by dragging the project bar in the Gantt Chart around while manually leveling the resource profile (in a resource analysis layout, tracking or PA). In the User Preferences dialog, the user can choose to view remaining units for a resource based on the forecast dates or the remaining dates.	Value Derived From : Dim_W_PROJECT_HD_ID.FORECAST_START_DATE
Project	Dates - (Project)	Must Finish By	Dimension	The date by which all project activities must finish. If entered, it is used as the project late finish date by the project scheduler.	Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_PLANNED_FINISH_DATE
Project	Dates - (Project)	Planned Start	Dimension	The date the activity is scheduled to begin. This date is computed by the project scheduler but can be updated manually by the project manager. This date is not changed by the project scheduler after the activity has been started.	Value Derived From : Dim_W_PROJECT_HD_ID.PLANNED_START_DATE
Project	Dates - (Project)	Scheduled Finish	Dimension	The early finish date of the latest activity in the project, as computed by the project scheduler.	Value Derived From : Dim_W_PROJECT_HD_ID.SCHEDULED_FINISH_DATE
Project	Dates - (Project)	Start	Dimension	The current start date of the activity. Set to the activity remaining early start date while the activity is not started, and the actual start date once the activity is started.	Value Derived From : Dim_W_PROJECT_HD_ID.PROJECT_START_DATE

Related Topics