P6 - Project History / Primavera - Project History
Description: Use this subject area to analyze project and WBS-level history, including changes to both facts and dimensions, to better understand changes over time. This subject area requires project-specific configuration in P6.
| Folder | Subfolder | Field Name | Dimension/ Fact / Lookup | Description | Values Derived From / Calculated By |
|---|---|---|---|---|---|
| Fact - Primavera - Project History | Period Cost | Next This Period Expense Cost | Fact | The Expense Cost planned in the next period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.NEXT_PER_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Next This Period Labor Cost | Fact | The Labor Cost planned for the next period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.NEXT_PER_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Next This Period Material Cost | Fact | The Material Cost planned in the next period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.NEXT_PER_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Next This Period Nonlabor Cost | Fact | The Nonlabor Cost planned in the next period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.NEXT_PER_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Actual Cost | Fact | The Actual Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Actual Expense Cost | Fact | The Actual Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Actual Labor Cost | Fact | The Actual Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Actual Material Cost | Fact | The Actual Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Actual Nonlabor Cost | Fact | The Actual Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Actual Total Cost | Fact | The Actual Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period At Completion Expense Cost | Fact | The At Completion Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period At Completion Labor Cost | Fact | The At Completion Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period At Completion Material Cost | Fact | The At Completion Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period At Completion Nonlabor Cost | Fact | The At Completion Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period At Completion Total Cost | Fact | The At Completion Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Actual Expense Cost | Fact | The Baseline Actual Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Actual Labor Cost | Fact | The Baseline Actual Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Actual Material Cost | Fact | The Baseline Actual Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Actual Nonlabor Cost | Fact | The Baseline Actual Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Actual Total Cost | Fact | The Baseline Actual Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Project Expense Cost | Fact | The Baseline Project Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Project Labor Cost | Fact | The Baseline Project Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Project Material Cost | Fact | The Baseline Project Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Project Nonlabor Cost | Fact | The Baseline Project Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Baseline Project Total Cost | Fact | The Baseline Project Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Earned Value Cost | Fact | The Earned Value Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.EARNED_VALUE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Estimate At Completion Cost | Fact | The Estimate at Completion Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.EST_AT_COMPLETION_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Estimate To Completion Cost | Fact | The Estimate To Completion Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.EST_TO_COMPLETE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Planned Expense Cost | Fact | The Planned Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Planned Labor Cost | Fact | The Planned Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Planned Material Cost | Fact | The Planned Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Planned Nonlabor Cost | Fact | The Planned Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Planned Total Cost | Fact | The Planned Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Planned Value Cost | Fact | The Planned Value Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_VALUE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Expense Cost | Fact | The Remaining Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Labor Cost | Fact | The Remaining Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Late Expense Cost | Fact | The Remaining Late Expense Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_EXPENSE_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Late Labor Cost | Fact | The Remaining Late Labor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_LABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Late Material Cost | Fact | The Remaining Late Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Late Nonlabor Cost | Fact | The Remaining Late Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Late Total Cost | Fact | The Remaining Late Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Material Cost | Fact | The Remaining Material Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_MATERIAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Nonlabor Cost | Fact | The Remaining Nonlabor Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_NONLABOR_COST_P |
| Fact - Primavera - Project History | Period Cost | Period Remaining Total Cost | Fact | The Remaining Total Cost for the period specified | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_TOTAL_COST_P |
| Fact - Primavera - Project History | Period Cost | Previous This Period Expense Cost | Fact | The Expense Cost planned in the previous period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PREV_THIS_PER_EXPENSE_COST |
| Fact - Primavera - Project History | Period Cost | Previous This Period Labor Cost | Fact | The Period Labor Cost planned in the previous period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PREV_THIS_PER_LABOR_COST |
| Fact - Primavera - Project History | Period Cost | Previous This Period Material Cost | Fact | The Material Cost planned in the previous period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PREV_THIS_PER_MATERIAL_COST |
| Fact - Primavera - Project History | Period Cost | Previous This Period Nonlabor Cost | Fact | The Nonlabor Cost planned in the previous period | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PREV_THIS_PER_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | Actual Labor Cost | Fact | The actual cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Labor Units * Project Default Price / Time. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_LABOR_COST |
| Fact - Primavera - Project History | Costs | Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | Actual NonLabor Cost | Fact | The actual cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Actual Nonlabor Units * Project Default Price / Time. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Actual Total Cost | Fact | The Actual Total Cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Actual Total Cost = Actual Labor Cost + Actual Nonlabor Cost + Actual Material Cost + Actual Expense Cost. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.ACTUAL_TOTAL_COST |
| Fact - Primavera - Project History | Costs | At Completion Expense Cost | Fact | The expense cost at completion is the sum of the actual plus remaining cost for all expenses associated with the activity. Computed as Actual Expense Cost + Remaining Expense Cost. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | At Completion Labor Cost | Fact | The labor cost at completion is the sum of the actual plus remaining cost for all labor resources assigned to the activity. Computed as Actual Labor Cost + Remaining Labor Cost. Same as the budgeted labor cost if the activity is not started and the actual labor cost once the activity is completed. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_LABOR_COST |
| Fact - Primavera - Project History | Costs | At Completion Material Cost | Fact | The material cost at completion is the sum of the actual plus remaining cost for all material resources assigned to the activity. Computed as Actual Material Cost + Remaining Material Cost. Same as the budgeted material cost if the activity is not started and the actual material cost once the activity is completed. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | At Completion Nonlabor Cost | Fact | The nonlabor cost at completion is the sum of the actual plus remaining cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost + Remaining Nonlabor Cost. Same as the budgeted nonlabor cost if the activity is not started and the actual nonlabor cost once the activity is completed. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | At Completion Total Cost | Fact | The total cost at completion for the activity, including labor resources, nonlabor resources, material resources, and project expenses. At Completion Total Cost = At Completion Labor Cost + At Completion Nonlabor Cost + At Completion Material Cost + At Completion Expense Cost. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.AT_COMPLETION_TOTAL_COST |
| Fact - Primavera - Project History | Costs | Baseline Actual Nonlabor Cost | Fact | The actual cost for all the Nonlabor resources assigned to an activity in the project baseline | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Baseline Actual Expense Cost | Fact | The actual cost for all the actual expenses associated with the activity in the project baseline. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | Baseline Actual Labor Cost | Fact | The actual cost for all the labor resources assigned to an activity in the project baseline. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_LABOR_COST |
| Fact - Primavera - Project History | Costs | Baseline Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity in the project baseline. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | Baseline Actual Total Cost | Fact | The actual total cost of the activity in the project baseline, including labor resources, non-labor resources, material resources, and project expenses. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_ACTUAL_TOTAL_COST |
| Fact - Primavera - Project History | Costs | Baseline Project Expense Cost | Fact | The cost for all the project expenses associated with the activity in the project baseline. | Value Derived From : Fact_W_WBS_HISTORY_F_Wbs_History.BL_PLANNED_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | Baseline Project Labor Cost | Fact | The cost for all the labor resources assigned to an activity in the project baseline. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_LABOR_COST |
| Fact - Primavera - Project History | Costs | Baseline Project Material Cost | Fact | Budgeted or (At Completion)cost for all material resources assigned to the activity in the project baseline. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | Baseline Project Nonlabor Cost | Fact | The cost for all the Nonlabor resources assigned to an activity in the project baseline | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Baseline Project Total Cost | Fact | The total cost of the activity in the project baseline, including labor resources, non-labor resources, material resources, and project expenses. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.BL_PLANNED_TOTAL_COST |
| Fact - Primavera - Project History | Costs | Planned Expense Cost | Fact | Planned Expense Cost | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | Planned Labor Cost | Fact | The budgeted costs for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Budgeted Labor Units * Project Default Price / Time. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_LABOR_COST |
| Fact - Primavera - Project History | Costs | Planned Material Cost | Fact | The budgeted costs for all material resources assigned to the activity. If no resources are assigned, computed as the activity Budgeted Labor Units * Project Default Price / Time. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | Planned Nonlabor Cost | Fact | The budgeted costs for all nonlabor resources assigned to the activity. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Planned Total Cost | Fact | The budgeted total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Budgeted Total Cost = Budgeted Labor Cost + Budgeted Nonlabor Cost + Budgeted Material Cost + Budgeted Expense Cost. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.PLANNED_TOTAL_COST |
| Fact - Primavera - Project History | Costs | Remaining Expense Cost | Fact | The remaining cost for all project expenses associated with the activity. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | Remaining Labor Cost | Fact | The remaining cost for all labor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Labor Units * Project Default Price / Time. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LABOR_COST |
| Fact - Primavera - Project History | Costs | Remaining Late Expense Cost | Fact | Remaining Late Expense Cost | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_EXPENSE_COST |
| Fact - Primavera - Project History | Costs | Remaining Late Labor Cost | Fact | Remaining Late Labor Cost | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_LABOR_COST |
| Fact - Primavera - Project History | Costs | Remaining Late Material Cost | Fact | Remaining Late Material Cost | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | Remaining Late Nonlabor Cost | Fact | Remaining Late Nonlabor Cost | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Remaining Late Total Cost | Fact | Remaining Late Total Cost | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_LATE_TOTAL_COST |
| Fact - Primavera - Project History | Costs | Remaining Material Cost | Fact | The remaining cost for all material resources assigned to the activity. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_MATERIAL_COST |
| Fact - Primavera - Project History | Costs | Remaining Nonlabor Cost | Fact | The remaining cost for all nonlabor resources assigned to the activity. If no resources are assigned, computed as the activity Remaining Nonlabor Units * Project Default Price / Time. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_NONLABOR_COST |
| Fact - Primavera - Project History | Costs | Remaining Total Cost | Fact | The remaining total cost for the activity, including labor resources, nonlabor resources, material resources, and project expenses. Remaining Total Cost = Remaining Labor Cost + Remaining Nonlabor Cost + Remaining Material Cost + Remaining Expense Cost. | Value Derived From : Fact_W_PROJECT_HISTORY_F_Project_History.REMAINING_TOTAL_COST |
| Fact - Primavera - Project History | Dates | Dates | |||
| Fact - Primavera - Project History | Dates | Actual Finish | Fact | The date on which the activity actually finished | last(max(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_FINISH_DATE)) |
| Fact - Primavera - Project History | Dates | Actual Start | Fact | The date on which the activity actually started | last(min(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_START_DATE)) |
| Fact - Primavera - Project History | Dates | Baseline Project Finish | Fact | The Project Baseline Planned Finish Date. | last(max(Fact_W_WBS_HISTORY_F_Wbs_History.BASELINE_FINISH_DATE)) |
| Fact - Primavera - Project History | Dates | Baseline Project Start | Fact | The Project Baseline Planned Start Date. | last(min(Fact_W_WBS_HISTORY_F_Wbs_History.BASELINE_START_DATE)) |
| Fact - Primavera - Project History | Dates | Finish | Fact | 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. | last(max(Fact_W_WBS_HISTORY_F_Wbs_History.FINISH_DATE)) |
| Fact - Primavera - Project History | Dates | Planned Finish | Fact | 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. | last(min(Fact_W_WBS_HISTORY_F_Wbs_History.START_DATE)) |
| Fact - Primavera - Project History | Dates | Planned Start | Fact | 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. | last(min(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_START_DATE)) |
| Fact - Primavera - Project History | Dates | Remaining Finish | Fact | Remaining Finish | last(max(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_FINISH_DATE)) |
| Fact - Primavera - Project History | Dates | Remaining Start | Fact | Remaining Start | last(min(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_START_DATE)) |
| Fact - Primavera - Project History | Dates | Start | Fact | 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. | last(min(Fact_W_WBS_HISTORY_F_Wbs_History.START_DATE)) |
| Fact - Primavera - Project History | Durations | Durations | |||
| Fact - Primavera - Project History | Durations | Actual Duration | Fact | Actual duration is the total working time from the activity actual start date to the actual finish date (for completed activities), or to the current data date (for in-progress activities). The actual working time is computed using the activity's calendar. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_DURATION)) |
| Fact - Primavera - Project History | Durations | At Completion Duration | Fact | The duration at completion is the total working time from the activity's current start date to the current finish date. The current start date is the planned start date until the activity is started, then it is the actual start date. The current finish date is the activity planned finish date while the activity is not started, the remaining finish date while the activity is in progress, and the actual finish date once the activity is completed. The total working time is computed using the activity's calendar. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.AT_COMPLETION_DURATION)) |
| Fact - Primavera - Project History | Durations | Baseline Project Duration | Fact | The duration for the activity in the primary baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BASELINE_DURATION)) |
| Fact - Primavera - Project History | Durations | Variance - Baseline Project Duration | Fact | Variance duration is the duration between the activity' Baseline project duration and the At Completion duration. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.DURATION_VARIANCE)) |
| Fact - Primavera - Project History | Durations | Planned Duration | Fact | Planned Duration is the planned working time for the resource assignment on the activity, from the resource's planned start date to the planned finish date. The planned working time is computed using the calendar determined by the Activity Type. Resource Dependent activities use the resource's calendar; other activity types use the activity's calendar. This is the duration that Progress Reporter users follow and the schedule variance is measured against. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_DURATION)) |
| Fact - Primavera - Project History | Durations | Remaining Duration | Fact | Remaining duration is the total working time from the activity remaining start date to the remaining finish date. The remaining working time is computed using the activity's calendar. Before the activity is started, the remaining duration is the same as the Original Duration. After the activity is completed the remaining duration is zero. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_DURATION)) |
| Fact - Primavera - Project History | Durations | Total Float | Fact | The amount of time the activity can be delayed before delaying the project finish date. Total float can be computed as Late Start - Early Start or as Late Finish - Early Finish; this option can be set when running the project scheduler. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.TOTAL_FLOAT)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Earned Value (Cost) | |||
| Fact - Primavera - Project History | Earned Value - (Cost) | Accounting Variance (Cost) | Fact | Accounting Variance is the Planned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EARNED_VALUE_COST)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Cost Performance Index (Cost) | Fact | Cost Performance Index is the Earned Value divided by the Actual Cost. A value less than 1 indicates that Actual Cost have exceeded the Planned Value. | P6Core."Fact - Project History"."Earned Value Cost" / ( IFNULL("P6Core"."Fact - Project History"."Actual Cost", 0)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Cost Schedule Index (Cost) | Fact | Cost Schedule Index By Cost | P6Core."Fact - Project History"."Earned Value Cost" / ( IFNULL("P6Core"."Fact - Project History"."Actual Cost", 0)) * ( IFNULL("P6Core"."Fact - Project History"."Earned Value Cost", 0)) / ( IFNULL("P6Core"."Fact - Project History"."Planned Value Cost", 0)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Cost Variance (Cost) | Fact | Cost Variance is the Earned Value minus the Actual Cost. A negative value indicates that Actual Cost have exceeded the Planned Value. | P6Core."Fact - Project History"."Earned Value Cost" - "P6Core"."Fact - Project History"."Actual Cost" |
| Fact - Primavera - Project History | Earned Value - (Cost) | Cost Variance Index (Cost) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | P6Core."Fact - Project History"."Cost Variance" / "P6Core"."Fact - Project History"."Earned Value Cost" |
| Fact - Primavera - Project History | Earned Value - (Cost) | Earned Value (Cost) | Fact | Earned value cost for the project | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EARNED_VALUE_COST)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Estimate At Completion (Cost) | Fact | Estimate Cost at Completion is the Actual Cost plus the Estimate to Complete Cost. The method for computing Estimate to Complete depends on the Earned Value technique selected for the activity's WBS. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EST_AT_COMPLETION_COST)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Estimate to Complete (Cost) | Fact | Calculated Estimate To Complete using specified technique | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EST_TO_COMPLETE_COST)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Planned Value (Cost) | Fact | Planned cost of work scheduled for the project | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_VALUE_COST)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Schedule Performance Index (Cost) | Fact | Schedule Performance Index is the Earned Value divided by Planned Value. A value less than 1 indicates that less work was actually performed than was scheduled. | P6Core."Fact - Project History"."Earned Value Cost" / "P6Core"."Fact - Project History"."Planned Value Cost" |
| Fact - Primavera - Project History | Earned Value - (Cost) | Schedule Variance (Cost) | Fact | Schedule Variance is the Earned Value minus the Planned Value. A negative value indicates that less work was actually performed than was scheduled. | P6Core."Fact - Project History"."Earned Value Cost" - "P6Core"."Fact - Project History"."Planned Value Cost" |
| Fact - Primavera - Project History | Earned Value - (Cost) | Schedule Variance Index (Cost) | Fact | Schedule Variance Index is the Schedule Variance divided by Planned Value. | P6Core."Fact - Project History"."Schedule Variance Cost" / "P6Core"."Fact - Project History"."Planned Value Cost" |
| Fact - Primavera - Project History | Earned Value - (Cost) | To Complete Performance Index - BAC (Cost) | Fact | To Complete Performance Index - BAC (Cost) | ("P6Core"."Fact - Project History"."Bl Planned Total Cost" - "P6Core"."Fact - Project History"."Earned Value Cost") / (IFNULL("P6Core"."Fact - Project History"."Bl Planned Total Cost" - "P6Core"."Fact - Project History"."Actual Cost", 0)) |
| Fact - Primavera - Project History | Earned Value - (Cost) | To Complete Performance Index - EAC (Cost) | Fact | To Complete Performance Index - EAC (Cost) | ("P6Core"."Fact - Project History"."Bl Planned Total Cost" - "P6Core"."Fact - Project History"."Earned Value Cost") / ((IFNULL("P6Core"."Fact - Project History"."Est At Completion Cost",0)) - (IFNULL("P6Core"."Fact - Project History"."Actual Cost",0))) |
| Fact - Primavera - Project History | Earned Value - (Cost) | Variance At Completion (Cost) | Fact | Variance At Completion is the Budget At Completion (baseline total cost) minus Estimate At Completion. | P6Core."Fact - Project History"."Bl Planned Total Cost" - "P6Core"."Fact - Project History"."Est At Completion Cost" |
| Fact - Primavera - Project History | Earned Value - (Units) | Earned Value (Units) | |||
| Fact - Primavera - Project History | Earned Value - (Units) | Accounting Variance (Units) | Fact | Accounting Variance Labor Units is the Planned Value Labor Units minus the Actual Units. Negative value indicates that Actual Units have exceeded the Planned Value Labor Units. | P6Core."Fact - Project History"."Planned Value Labor Units" - "P6Core"."Fact - Project History"."Actual Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Budget At Completion (Units) | Fact | Budget at Completion Labor Units is the baseline Labor Units + baseline Nonlabor Labor Units + baseline Expense Labor Units + baseline Material Labor Units. Same as the baseline Total Labor Units. | P6Core."Fact - Project History"."Baseline Project Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Cost Performance Index (Units) | Fact | Cost Performance Index Labor Units is the Earned Value Labor Units / Actual Labor Units. | P6Core."Fact - Project History"."Earned Value Labor Units" / "P6Core"."Fact - Project History"."Actual Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Cost Schedule Index (Units) | Fact | Cost Schedule Index By Units | P6Core."Fact - Project History"."Cost Performance Index (CPI) - Labor Units" * "P6Core"."Fact - Project History"."Schedule Performance Index (SPI) Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Cost Variance (Units) | Fact | Cost Variance Labor Units is Earned Value Labor Units minus Actual Labor Units. | P6Core."Fact - Project History"."Earned Value Labor Units" - "P6Core"."Fact - Project History"."Actual Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Cost Variance Index (Units) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | ("P6Core"."Fact - Project History"."Earned Value Labor Units" - "P6Core"."Fact - Project History"."Actual Labor Units") / "P6Core"."Fact - Project History"."Earned Value Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Earned Value (Units) | Fact | Earned Value Labor Units Performed is the portion of the baseline Labor Units that is actually completed as of the project data date. Computed as baseline Labor Units * Performance % Complete. The Earned Value Labor Units is essentially the labor units earned value for the activity. The method for computing the Performance % Complete depends on the earned value technique selected for the activity's WBS. The baseline Labor Units is taken from the baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EARNED_VALUE_LABOR_UNITS)) |
| Fact - Primavera - Project History | Earned Value - (Units) | Estimate At Completion (Units) | Fact | Estimate At Completion Labor Units is calculated as Actual Labor Units + Estimate To Complete Labor Units. (Estimate To Complete Labor Units is calculated based off of the Earned Value setting on the WBS.) | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EST_AT_COMPLETION_LABOR_UNITS)) |
| Fact - Primavera - Project History | Earned Value - (Units) | Estimate To Complete (Units) | Fact | The estimated quantity to complete of the activity. Computed as either the remaining total units for the activity, or as Performance Factor * (Baseline Budgeted Labor Units - Budgeted Quantity of Work Performed), depending on the Earned Value Technique selected for the activity's WBS. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EST_TO_COMPLETE_LABOR_UNITS)) |
| Fact - Primavera - Project History | Earned Value - (Units) | Variance - Baseline Project Finish Date | Fact | Variance Finish Date is the duration between the Baseline project finish date and the finish date in the current project. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.FINISH_DATE_VARIANCE)) |
| Fact - Primavera - Project History | Earned Value - (Units) | Planned Value (Units) | Fact | Planned Value Labor Units Scheduled is the portion of the baseline Labor Units that is scheduled to be completed as of the project data date. For activities without resource assignments, and for activity resource assignments that do not have resource curves, computed as baseline Labor Units * Schedule % Complete. For activity resource assignments that do have resource curves, the curve distribution is additionally factored into the calculation. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. The baseline Labor Units is taken from the baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_VALUE_LABOR_UNITS)) |
| Fact - Primavera - Project History | Earned Value - (Units) | Planned Value Nonlabor (Units) | Fact | Planned Value Nonlabor (Units) | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_PLANNED_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Earned Value - (Units) | Schedule Performance Index (Units) | Fact | Schedule Performance Index Labor Units is the Earned Value Labor Units divided by Planned Value Labor Units. | P6Core."Fact - Project History"."Earned Value Labor Units" / "P6Core"."Fact - Project History"."Planned Value Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Schedule Variance (Units) | Fact | Schedule Variance Labor Units is the Earned Value Labor Units minus Planned Value Labor Units. | P6Core."Fact - Project History"."Earned Value Labor Units" - "P6Core"."Fact - Project History"."Planned Value Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Schedule Variance Index (Units) | Fact | Schedule Variance Index is the Schedule Variance Labor Units divided by the Planned Value Labor Units. | P6Core."Fact - Project History"."Schedule Variance Labor Units" / "P6Core"."Fact - Project History"."Planned Value Labor Units" |
| Fact - Primavera - Project History | Earned Value - (Units) | Variance - Baseline Project Start Date | Fact | Variance Start Date is the duration between the Baseline project start date and the start date in the current project. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.START_DATE_VARIANCE)) |
| Fact - Primavera - Project History | Earned Value - (Units) | To Complete Performance Index - BAC (Units) | Fact | The To Complete Performance Index is (Budget at Completion (BAC) - Earned Value Labor Units) / (Budget at Completion (BAC) - Actual Labor Units). | ("P6Core"."Fact - Project History"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Project History"."Earned Value Labor Units") / ("P6Core"."Fact - Project History"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Project History"."Actual Labor Units") |
| Fact - Primavera - Project History | Earned Value - (Units) | To Complete Performance Index - EAC (Units) | Fact | The To Complete Performance Index is (Budget at Completion (EAC) - Earned Value Labor Units) / (Estimated at Completion - Actual Labor Units). | ("P6Core"."Fact - Project History"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Project History"."Earned Value Labor Units") / ("P6Core"."Fact - Project History"."Estimate At Completion Labor Units" - "P6Core"."Fact - Project History"."Actual Labor Units") |
| Fact - Primavera - Project History | Metrics | Metrics | |||
| Fact - Primavera - Project History | Metrics | # Of Activities | Fact | # Of Activities | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.TOTAL_ACTIVITY_COUNT)) |
| Fact - Primavera - Project History | Metrics | # Of Completed Activities | Fact | The number of activities that were Completed during the specific Project History Interval. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.COMPLETED_ACTIVITY_COUNT)) |
| Fact - Primavera - Project History | Metrics | # Of In Progress Activities | Fact | The number of activities that are InProgress during the specific Project History Interval. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.IN_PROGRESS_ACTIVITY_COUNT)) |
| Fact - Primavera - Project History | Metrics | # Of Not Started Activities | Fact | The number of activities that are Not Started during the specific Project History Interval. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.NOT_STARTED_ACTIVITY_COUNT)) |
| Fact - Primavera - Project History | Metrics | # Of Projects | Fact | # Of Projects | last(count(distinct Fact_W_WBS_HISTORY_F_Wbs_History.PROJECT_WID)) |
| Fact - Primavera - Project History | Metrics | Completed Last Period | Fact | Activities with Completed status at the time of the previous ETL run | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.COMPLETED_THIS_PERIOD)) |
| Fact - Primavera - Project History | Metrics | Completed This Period | Fact | Activities whose actual finish date fell between the period start and period end for this ETL run | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.COMPLETED_LAST_PERIOD)) |
| Fact - Primavera - Project History | Metrics | Delayed This Period | Fact | Activities planned to start between the period start and period end with no actual start date | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.DELAYED_THIS_PERIOD)) |
| Fact - Primavera - Project History | Metrics | Emergent Count | Fact | Activities added before the period start date of this ETL run | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EMERGENT_WORK)) |
| Fact - Primavera - Project History | Metrics | In Progress Last Period | Fact | Activities with In Progress status at the time of the previous ETL run | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.IN_PROGRESS_LAST_PERIOD)) |
| Fact - Primavera - Project History | Metrics | In Progress This Period | Fact | Activities whose actual start date fell between the period start and period end for this ETL run | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.IN_PROGRESS_THIS_PERIOD)) |
| Fact - Primavera - Project History | Metrics | Not Started Last Period | Fact | Activities with Not Started status at the time of the previous ETL run | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.NOT_STARTED_LAST_PERIOD)) |
| Fact - Primavera - Project History | Metrics | Risk Exposure | Fact | The calculated exposure value for the risk | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PROJECT_RISK_EXPOSURE)) |
| Fact - Primavera - Project History | Metrics | Risk Score | Fact | The calculated score value of the impact values assigned to the risk | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PROJECT_RISK_SCORE)) |
| Fact - Primavera - Project History | Percent Completes | Percent Completes | |||
| Fact - Primavera - Project History | Percent Completes | Cost % Complete | Fact | The percent complete of cost for all labor resources, nonlabor resources, material resources, and expenses for the activity. Computed as Actual Total Cost / At Completion Total Cost * 100. Always in the range 0 to 100. | P6Core."Fact - Project History"."Actual Total Cost" / P6Core."Fact - Project History"."At Completion Total Cost" * 100 |
| Fact - Primavera - Project History | Percent Completes | Duration % Complete | Fact | The percent complete of the activity duration. Computed as (Original Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Original Duration is taken from the current plan, not from the baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.DURATION_PCT_COMPLETE)) |
| Fact - Primavera - Project History | Percent Completes | Duration % Of Planned | Fact | The percent complete of the activity duration. Computed as (Planned Duration - Remaining Duration)/Original Duration * 100. Always in the range 0 to 100. The Planned Duration is taken from the current plan, not from the baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.DURATION_PCT_OF_PLANNED)) |
| Fact - Primavera - Project History | Percent Completes | Expense Cost % Complete | Fact | Percent complete of cost for all expenses associated with an activity. Computed as Actual Expense Cost / At Completion Expense Cost* 100. Always in the range 0 to 100. | P6Core."Fact - Project History"."Actual Expense Cost" / P6Core."Fact - Project History"."At Completion Expense Cost" * 100 |
| Fact - Primavera - Project History | Percent Completes | Labor Cost % Complete | Fact | The percent complete of cost for all labor resources assigned to the activity. Computed as Actual Labor Cost / At Completion Labor Cost * 100. Always in the range 0 to 100. | P6Core."Fact - Project History"."Actual Labor Cost" / P6Core."Fact - Project History"."At Completion Labor Cost" * 100 |
| Fact - Primavera - Project History | Percent Completes | Labor Units % Complete | Fact | The percent complete of units for all labor resources for the activity. Computed as Actual Labor Units / At Completion Labor Units * 100. Always in the range 0 to 100. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.LABOR_UNITS_PCT_COMPLETE)) |
| Fact - Primavera - Project History | Percent Completes | Material Cost % Complete | Fact | The percent complete of cost for all material resources assigned to the activity. Computed as Actual Material Cost / At Completion Material Cost * 100. Always in the range 0 to 100. | P6Core."Fact - Project History"."Actual Material Cost" / P6Core."Fact - Project History"."At Completion Material Cost" * 100 |
| Fact - Primavera - Project History | Percent Completes | Nonlabor Cost % Complete | Fact | The percent complete of cost for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Cost / At Completion Nonlabor Cost * 100. Always in the range 0 to 100. | P6Core."Fact - Project History"."Actual Nonlabor Cost" / P6Core."Fact - Project History"."At Completion Nonlabor Cost" * 100 |
| Fact - Primavera - Project History | Percent Completes | Nonlabor Units % Complete | Fact | The percent complete of units for all nonlabor resources for the activity. Computed as Actual Nonlabor Units / At Completion Nonlabor Units * 100. Always in the range 0 to 100. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.NONLABOR_UNITS_PCT_COMPLETE)) |
| Fact - Primavera - Project History | Percent Completes | Performance % Complete | Fact | The activity performance percent complete. The performance percent complete is used to compute earned value and may be based on the Activity % Complete, on the 0/100 rule, on the 50/50 rule, etc., depending on the technique for computing earned-value percent complete for the activity's WBS. The Performance % Complete specifies what percentage of the activity's planned worth has been earned so far. | P6Core."Fact - Project History"."Earned Value Cost" / P6Core."Fact - Project History"."Budget at Completion" * 100 |
| Fact - Primavera - Project History | Percent Completes | Schedule % Complete | Fact | The activity schedule percent complete. The Schedule % Complete specifies how much of the activity's baseline duration has been completed so far. Computed based on where the current data date falls between the activity's baseline start and finish dates. If the data date is earlier than the baseline Start, the Schedule % Complete is 0. If the data date is later than the baseline Finish, the Schedule % Complete is 100. The Schedule % Complete indicates how much of the activity duration should be currently completed, relative to the selected baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.SCHEDULE_PCT_COMPLETE)) |
| Fact - Primavera - Project History | Percent Completes | Units % Complete | Fact | The percent complete of units for all labor and nonlabor resources assigned to the activity. Computed as Actual Units / At Completion Units * 100. Always in the range 0 to 100. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.UNITS_PCT_COMPLETE)) |
| Fact - Primavera - Project History | Units | Units | |||
| Fact - Primavera - Project History | Units | Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Units | At Completion Labor Units | Fact | The labor units at completion is the sum of the actual plus remaining units for all labor resources assigned to the activity. Computed as Actual Labor Units + Remaining Labor Units. Same as the budgeted labor units if the activity is not started and the actual labor units once the activity is completed. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.AT_COMPLETION_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | At Completion Nonlabor Units | Fact | The nonlabor units at completion is the sum of the actual plus remaining units for all nonlabor resources assigned to the activity. Computed as Actual Nonlabor Units + Remaining Nonlabor Units. Same as the budgeted nonlabor units if the activity is not started and the actual nonlabor units once the activity is completed. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.AT_COMPLETION_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Baseline Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity in the project baseline | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_ACTUAL_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Baseline Actual Nonlabor Units | Fact | The actual units for all the Nonlabor resources assigned to an activity in the project baseline | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_ACTUAL_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Baseline Project Labor Units | Fact | The units for all the labor resources assigned to an activity in the project baseline. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_PLANNED_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Baseline Project Nonlabor Units | Fact | The units for all the Nonlabor resources assigned to an activity in the project baseline | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_PLANNED_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Period Units | Next This Period Labor Units | Fact | This Period Labor Units for the period after the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.NEXT_PER_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Next This Period Nonlabor Units | Fact | This Period Nonlabor Units for the period after the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.NEXT_PER_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Actual Labor Units | Fact | Period Actual Labor Units | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Actual Nonlabor Units | Fact | The Actual Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.ACTUAL_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period At Completion Labor Units | Fact | The At Completion Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.AT_COMPLETION_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Baseline Actual Labor Units | Fact | The Baseline Actual Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_ACTUAL_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Baseline Actual Nonlabor Units | Fact | The Baseline Actual Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_ACTUAL_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Baseline Project Labor Units | Fact | The Baseline Project Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_PLANNED_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Baseline Project Nonlabor Units | Fact | The Baseline Project Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.BL_PLANNED_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Earned Value Labor Units | Fact | The Earned Value Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EARNED_VALUE_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Estimate At Completion Labor Units | Fact | The Estimate At Completion Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EST_AT_COMPL_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Estimate To Completion Labor Units | Fact | The Estimate to Completion Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.EST_TO_COMPLETE_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Planned Labor Units | Fact | Period Planned Labor Units | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Planned Nonlabor Units | Fact | The Planned Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Planned Value Labor Units | Fact | The Planned Value Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_VALUE_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Remaining Labor Units | Fact | The Remaining Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Remaining Late Labor Units | Fact | The Remaining Late Labor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_LATE_LABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Remaining Late Nonlabor Units | Fact | The Remaining Late Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REM_LATE_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period Remaining Nonlabor Units | Fact | The Remaining Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Period Units | Period At Completion Nonlabor Units | Fact | The At Completion Nonlabor Units for the period specified | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.AT_COMPLETION_NONLABOR_UNITS_P)) |
| Fact - Primavera - Project History | Units | Planned Labor Units | Fact | The budgeted units for all labor resources assigned to the activity. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Planned Nonlabor Units | Fact | The budgeted units for all nonlabor resources assigned to the activity. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PLANNED_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Period Units | Previous This Period Labor Units | Fact | Previous This Period Labor Units | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PREV_THIS_PER_LABOR_UNITS)) |
| Fact - Primavera - Project History | Period Units | Previous This Period Nonlabor Units | Fact | The Nonlabor Units planned for the previous period | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.PREV_THIS_PER_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Remaining Labor Units | Fact | The remaining units for all labor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the budgeted units. After the activity is completed, the remaining units are zero. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Remaining Late Labor Units | Fact | Remaining Late Labor Units | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_LATE_LABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Remaining Late Nonlabor Units | Fact | Remaining Late Nonlabor Units | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_LATE_NONLABOR_UNITS)) |
| Fact - Primavera - Project History | Units | Remaining Nonlabor Units | Fact | The remaining units for all nonlabor resources assigned to the activity. The remaining units reflects the work remaining to be done for the activity. Before the activity is started, the remaining units are the same as the budgeted units. After the activity is completed, the remaining units are zero. | last(sum(Fact_W_WBS_HISTORY_F_Wbs_History.REMAINING_NONLABOR_UNITS)) |