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 |