P6 - Activity History / Primavera - Activity History
Description: Use this subject area to analyze daily, weekly, or monthly activity 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 |
|---|---|---|---|---|---|
Project | Budget - (Project) | Current Budget | Dimension | The Current Budget is the sum of the Original Budget and all approved budget changes in the Budget Change Log. | Value Derived From : Dim_W_PROJECT_HD_Project.CURRENT_BUDGET |
Project | Budget - (Project) | Current Variance | Dimension | Computed as the Current Budget minus the Total Spending Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.CURRENT_VARIANCE |
Project | Budget - (Project) | Distributed Current Budget | Dimension | Computed as sum of the Current Budget values from one level lower. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.DISTRIBUTED_CURRENT_BUDGET |
Project | Budget - (Project) | Original Budget | Dimension | Original budget for the project. | Value Derived From : Dim_W_PROJECT_HD_Project.ORIGINAL_BUDGET |
Project | Budget - (Project) | Proposed Budget | Dimension | The Proposed Budget is the sum of the Original Budget plus the Approved and Pending budgets from the budget change log. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.PROPOSED_BUDGET |
Project | Budget - (Project) | Total Benefit Plan | Dimension | Sum of the Monthly Benefit Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.TOTAL_BENEFIT_PLAN |
Project | Budget - (Project) | Total Benefit Plan Tally | Dimension | Sum of the Monthly Benefit Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.TOTAL_BENEFIT_PLAN_TALLY |
Project | Budget - (Project) | Total Funding | Dimension | The total amount of funding contributed to the project by your funding sources. | Value Derived From : Dim_W_PROJECT_HD_Project.TOTAL_FUNDING |
Project | Budget - (Project) | Total Spending Plan | Dimension | Sum of the Monthly Spending Plan. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.TOTAL_SPENDING_PLAN |
Project | Budget - (Project) | Total Spending Plan Tally | Dimension | Sum of the Monthly Spending Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.TOTAL_SPENDING_PLAN_TALLY |
Project | Budget - (Project) | Unallocated Budget | Dimension | Calculated as Total Current Budget - Distributed Current Budget. | Value Derived From : Dim_W_PROJECT_HD_Project.UNALLOCATED_BUDGET |
Project | Budget - (Project) | Undistributed Current Variance | Dimension | Computed as the Total Spending Plan minus the Total Spending Plan Tally. Not rolled up. | Value Derived From : Dim_W_PROJECT_HD_Project.UNDISTRIBUTED_CURRENT_VARIANCE |
Activity | Codes - (Activity) | Current Flag | Dimension | Indicates if a record is current (1,0) | Value Derived From : Dim_W_CODES_ACTIVITY_HD_Activity_Codes_HD.CURRENT_FLAG |
Activity | Codes - (Activity) | Effective End Date | Dimension | The end date this version of the record is effective | Value Derived From : Dim_W_CODES_ACTIVITY_HD_Activity_Codes_HD.EFFECTIVE_END_DATE |
Activity | Codes - (Activity) | Effective Start Date | Dimension | The start date this version of the record is effective | Value Derived From : Dim_W_CODES_ACTIVITY_HD_Activity_Codes_HD.EFFECTIVE_START_DATE |
Project | Codes - (Project) | Current Flag | Dimension | Indicates if a record is current (1,0) | Value Derived From : Dim_W_CODES_PROJECT_HD_ProjectCodes.CURRENT_FLAG |
Project | Codes - (Project) | Effective End Date | Dimension | The end date this version of the record is effective | Value Derived From : Dim_W_CODES_PROJECT_HD_ProjectCodes.EFFECTIVE_END_DATE |
Project | Codes - (Project) | Effective Start Date | Dimension | The start date this version of the record is effective | Value Derived From : Dim_W_CODES_PROJECT_HD_ProjectCodes.EFFECTIVE_START_DATE |
Project | Dates - (Project) | Actual Finish Date | Dimension | Actual Finish Date | Value Derived From : Dim_W_PROJECT_HD_Project.ACTUAL_FINISH_DATE |
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_Project.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_Project.ANTICIPATED_START_DATE |
Project | Dates - (Project) | Baseline Finish Date | Dimension | Baseline Finish Date | Value Derived From : Dim_W_PROJECT_HD_Project.BASELINE_FINISH_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_Project.DATA_DATE |
Project | Dates - (Project) | Date Added | Dimension | The date this activity was inserted. | Value Derived From : Dim_W_PROJECT_HD_Project.ADD_DATE |
Project | Dates - (Project) | Effective End Date | Dimension | The end date this version of the record is effective | Value Derived From : Dim_W_PROJECT_HD_Project.EFFECTIVE_END_DATE |
Project | Dates - (Project) | Effective Start Date | Dimension | The start date this version of the record is effective | Value Derived From : Dim_W_PROJECT_HD_Project.EFFECTIVE_START_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_Project.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_Project.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_Project.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_Project.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_Project.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_Project.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_Project.PROJECT_START_DATE |
Project | Durations - (Project) | Actual Duration | Dimension | Actual duration is the total time from the project actual start date to the actual finish date (for completed projects), or to the current data date (for in-progress projects). | Value Derived From : Dim_W_PROJECT_HD_Project.ACTUAL_DURATION |
Project | Durations - (Project) | At Completion Duration | Dimension | The duration at completion is the total time from the project current start date to the current finish date. | Value Derived From : Dim_W_PROJECT_HD_Project.AT_COMPLETION_DURATION |
Project | Durations - (Project) | Baseline Project Duration | Dimension | The duration of the baseline project. | Value Derived From : Dim_W_PROJECT_HD_Project.BASELINE_DURATION |
Project | Durations - (Project) | Planned Duration | Dimension | Planned duration is the total time from the project planned start date to the planned finish date. | Value Derived From : Dim_W_PROJECT_HD_Project.PLANNED_DURATION |
Project | Durations - (Project) | Remaining Duration | Dimension | Remaining duration is the total time from the current data date date to the current finish date. | Value Derived From : Dim_W_PROJECT_HD_Project.REMAINING_DURATION |
Project | Durations - (Project) | Variance - Baseline Project Duration | Dimension | The duration between the baseline project duration and the current project duration. Calculated as Planned Duration minus At Completion Duration. | Value Derived From : Dim_W_PROJECT_HD_Project.DURATION_VARIANCE |
Project | Durations - (Project) | Variance - Baseline Project Finish Date | Dimension | Variance - Baseline Project Finish Date | Value Derived From : Dim_W_PROJECT_HD_Project.FINISH_DATE_VARIANCE |
Project | General - (Project) | Added By | Dimension | The name of the user who added the project | Value Derived From : Dim_W_PROJECT_HD_Project.ADDED_BY_NAME |
Project | General - (Project) | Current Flag | Dimension | Indicates if a record is current (1,0) | Value Derived From : Dim_W_PROJECT_HD_Project.CURRENT_FLAG |
Project | General - (Project) | Datasource Id | Dimension | A unique source Id created for the Primavera data source being used. Used to identify data sources when using multiple Primavera data sources. | Value Derived From : Dim_W_PROJECT_HD_Project.DATASOURCE_ID |
Project | General - (Project) | Project Leveling Priority | Dimension | Priority for leveling | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_PRIORITY |
Project | General - (Project) | Project Score | Dimension | The Project score | Value Derived From : Dim_W_PROJECT_HD_Project.OVERALL_PROJECT_SCORE |
Project | General - (Project) | Project Description | Dimension | The project description | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_DESCRIPTION |
Project | General - (Project) | Project Id | Dimension | The Project Id of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_ID |
Project | General - (Project) | Project Name | Dimension | The project name | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_NAME |
Project | General - (Project) | Unique Project ID | Dimension | The Unique ID of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_ID |
Project | General - (Project) | Project Owner | Dimension | Resource designated as owner of the project | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_OWNER |
Project | General - (Project) | Project Risk Exposure | Dimension | The calculated exposure value for the risk | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_RISK_EXPOSURE |
Project | General - (Project) | Project Risk Level | Dimension | Project risk level (1 - Very Low, 2 - Low, 3 - Medium, 4 - High, 5 - Very High) | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_RISK_LEVEL |
Project | General - (Project) | Project Risk Score | Dimension | The calculated score value of the impact values assigned to the risk | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_RISK_SCORE |
Project | General - (Project) | WBS | Dimension | The Unique ID of the project's root level WBS | Value Derived From : Dim_W_PROJECT_HD_Project.WBS_OBJECT_ID |
Project | General - (Project) | Project Status | Dimension | The status of the project as active, inactive, planned or what-if | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_STATUS |
Project | General - (Project) | Strategic Priority | Dimension | Range 1 to 10,000 | Value Derived From : Dim_W_PROJECT_HD_Project.PROJECT_STRATEGIC_PRIORITY |
Project | Location - (Project) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_PROJECT_HD_Project.ADDRESS_LINE1 |
Project | Location - (Project) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_PROJECT_HD_Project.ADDRESS_LINE2 |
Project | Location - (Project) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.CITY_NAME |
Project | Location - (Project) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.COUNTRY_CODE |
Project | Location - (Project) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.COUNTRY_NAME |
Project | Location - (Project) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.LATITUDE |
Project | Location - (Project) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_PROJECT_HD_Project.LOCATION_NAME |
Project | Location - (Project) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_PROJECT_HD_Project.LOCATION_TYPE |
Project | Location - (Project) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.LONGITUDE |
Project | Location - (Project) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.MUNICIPALITY_NAME |
Project | Location - (Project) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.POSTAL_CODE |
Project | Location - (Project) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.STATE_CODE |
Project | Location - (Project) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_PROJECT_HD_Project.STATE_NAME |
|
|
|
|
|
|
Fact - Primavera -Activity History Folder |
|
|
|
|
|
Fact - Primavera -Activity History | Period Cost | Next This Period Expense Cost | Fact | The Expense Cost planned in the next period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.NEXT_PER_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Next This Period Labor Cost | Fact | The Labor Cost planned for the next period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.NEXT_PER_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Next This Period Material Cost | Fact | The Material Cost planned in the next period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.NEXT_PER_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Next This Period Nonlabor Cost | Fact | The Nonlabor Cost planned in the next period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.NEXT_PER_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Actual Cost | Fact | The Actual Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Actual Expense Cost | Fact | The Actual Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Actual Labor Cost | Fact | The Actual Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Actual Material Cost | Fact | The Actual Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Actual Nonlabor Cost | Fact | The Actual Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Actual Total Cost | Fact | The Actual Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period At Completion Expense Cost | Fact | The At Completion Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period At Completion Labor Cost | Fact | The At Completion Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period At Completion Material Cost | Fact | The At Completion Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period At Completion Nonlabor Cost | Fact | The At Completion Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period At Completion Total Cost | Fact | The At Completion Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Actual Expense Cost | Fact | The Baseline Actual Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Actual Labor Cost | Fact | The Baseline Actual Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Actual Material Cost | Fact | The Baseline Actual Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Actual Nonlabor Cost | Fact | The Baseline Actual Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Actual Total Cost | Fact | The Baseline Actual Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Project Expense Cost | Fact | The Baseline Project Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Project Labor Cost | Fact | The Baseline Project Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Project Material Cost | Fact | The Baseline Project Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Project Nonlabor Cost | Fact | The Baseline Project Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Baseline Project Total Cost | Fact | The Baseline Project Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Earned Value Cost | Fact | The Earned Value Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.EARNED_VALUE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Estimate At Completion Cost | Fact | The Estimate at Completion Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_AT_COMPLETION_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Estimate To Completion Cost | Fact | The Estimate To Completion Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_TO_COMPLETE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Planned Expense Cost | Fact | The Planned Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Planned Labor Cost | Fact | The Planned Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Planned Material Cost | Fact | The Planned Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Planned Nonlabor Cost | Fact | The Planned Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Planned Total Cost | Fact | The Planned Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Planned Value Cost | Fact | The Planned Value Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_VALUE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Expense Cost | Fact | The Remaining Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Labor Cost | Fact | The Remaining Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Late Expense Cost | Fact | The Remaining Late Expense Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_EXPENSE_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Late Labor Cost | Fact | The Remaining Late Labor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_LABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Late Material Cost | Fact | The Remaining Late Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Late Nonlabor Cost | Fact | The Remaining Late Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Late Total Cost | Fact | The Remaining Late Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Material Cost | Fact | The Remaining Material Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_MATERIAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Nonlabor Cost | Fact | The Remaining Nonlabor Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_NONLABOR_COST_P |
Fact - Primavera -Activity History | Period Cost | Period Remaining Total Cost | Fact | The Remaining Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_TOTAL_COST_P |
Fact - Primavera -Activity History | Period Cost | Previous This Period Expense Cost | Fact | The Expense Cost planned in the previous period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PREV_THIS_PER_EXPENSE_COST |
Fact - Primavera -Activity History | Period Cost | Previous This Period Labor Cost | Fact | The Period Labor Cost planned in the previous period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PREV_THIS_PER_LABOR_COST |
Fact - Primavera -Activity History | Period Cost | Previous This Period Material Cost | Fact | The Material Cost planned in the previous period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PREV_THIS_PER_MATERIAL_COST |
Fact - Primavera -Activity History | Period Cost | Previous This Period Nonlabor Cost | Fact | The Nonlabor Cost planned in the previous period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PREV_THIS_PER_NONLABOR_COST |
Fact - Primavera -Activity History | Costs | Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_EXPENSE_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_LABOR_COST |
Fact - Primavera -Activity History | Costs | Actual Material Cost | Fact | The actual cost for all material resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_MATERIAL_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_NONLABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_TOTAL_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_EXPENSE_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_LABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_MATERIAL_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_NONLABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_TOTAL_COST |
Fact - Primavera -Activity History | Costs | Baseline Actual Expense Cost | Fact | The actual cost for all project expenses associated with the activity in the primary baseline | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_EXPENSE_COST |
Fact - Primavera -Activity History | Costs | Baseline Actual Labor Cost | Fact | The actual cost for all labor resources assigned to the activity in the project baseline. If no resources are assigned, computed as the activity Baseline Project Actual Labor Units * Project Default Price / Time. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_LABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_MATERIAL_COST |
Fact - Primavera -Activity History | Costs | Baseline Actual Nonlabor Cost | Fact | The actual cost for all nonlabor resources assigned to the activity in the project baseline. If no resources are assigned, computed as the activity Baseline Project Actual Nonlabor Units * Project Default Price / Time | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_NONLABOR_COST |
Fact - Primavera -Activity History | Costs | Baseline Actual Total Cost | Fact | The actual total cost for the activity in the project baseline, including labor resources, nonlabor resources, material resources and project expenses. Baseline Project Actual Total Cost = Baseline Project Actual Labor Cost + Baseline Project Actual Nonlabor Cost + Baseline Project Actual Material Cost + Baseline Project Actual Expense Cost | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_TOTAL_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_EXPENSE_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_LABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_MATERIAL_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_NONLABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_TOTAL_COST |
Fact - Primavera -Activity History | Costs | Planned Expense Cost | Fact | The budgeted cost for all project expenses associated with the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_EXPENSE_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.PLANNED_LABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.PLANNED_MATERIAL_COST |
Fact - Primavera -Activity History | Costs | Planned Nonlabor Cost | Fact | The budgeted costs for all nonlabor resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_NONLABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.PLANNED_TOTAL_COST |
Fact - Primavera -Activity History | Costs | Remaining Expense Cost | Fact | The remaining cost for all project expenses associated with the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_EXPENSE_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LABOR_COST |
Fact - Primavera -Activity History | Costs | Remaining Late Expense Cost | Fact | Remaining Late Expense Cost | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_EXPENSE_COST |
Fact - Primavera -Activity History | Costs | Remaining Late Labor Cost | Fact | Remaining Late Labor Cost | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_LABOR_COST |
Fact - Primavera -Activity History | Costs | Remaining Late Material Cost | Fact | Remaining Late Material Cost | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_MATERIAL_COST |
Fact - Primavera -Activity History | Costs | Remaining Late Nonlabor Cost | Fact | Remaining Late Nonlabor Cost | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_NONLABOR_COST |
Fact - Primavera -Activity History | Costs | Period Remaining Late Total Cost | Fact | The Remaining Late Total Cost for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_TOTAL_COST |
Fact - Primavera -Activity History | Costs | Remaining Material Cost | Fact | The remaining cost for all material resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_MATERIAL_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.REMAINING_NONLABOR_COST |
Fact - Primavera -Activity 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_ACTIVITY_HISTORY_F_Activity_History.REMAINING_TOTAL_COST |
Fact - Primavera -Activity History | Dates | Actual Finish | Fact | The date on which the activity actually finished | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_FINISH_DATE |
Fact - Primavera -Activity History | Dates | Actual Start | Fact | The date on which the activity actually started | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_START_DATE |
Fact - Primavera -Activity History | Dates | Baseline Project Finish | Fact | The Project Baseline Planned Finish Date. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BASELINE_FINISH_DATE |
Fact - Primavera -Activity History | Dates | Baseline Project Start | Fact | The Project Baseline Planned Start Date. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BASELINE_START_DATE |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.FINISH_DATE |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_FINISH_DATE |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_START_DATE |
Fact - Primavera -Activity History | Dates | Remaining Finish | Fact | Remaining Finish | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_FINISH_DATE |
Fact - Primavera -Activity History | Dates | Remaining Start | Fact | Remaining Start | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_START_DATE |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.START_DATE |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_DURATION |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_DURATION |
Fact - Primavera -Activity History | Durations | Baseline Project Duration | Fact | The duration for the activity in the primary baseline. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BASELINE_DURATION |
Fact - Primavera -Activity History | Durations | Variance - Baseline Project Duration | Fact | Variance duration is the duration between the activity' Baseline project duration and the At Completion duration. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.DURATION_VARIANCE |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_DURATION |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_DURATION |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.TOTAL_FLOAT |
Fact - Primavera -Activity 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 | "P6Core"."Fact - Activity Spread H"."Planned Value Cost" - "P6Core"."Fact - Activity Spread H"."Actual Cost" |
Fact - Primavera -Activity History | Earned Value (Cost) | Budget At Completion (Cost) | Fact | Budget at Completion is the baseline Labor Cost + baseline Nonlabor Cost + baseline Expense Cost + baseline Material Cost. Same as the baseline Total Cost. | Value Derived From: "P6Core"."Fact - Activity Spread H"."Baseline Project Total Cost" |
Fact - Primavera -Activity 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. | Value Derived From: "P6Core"."Fact - Activity Spread H"."Earned Value Cost" / "P6Core"."Fact - Activity Spread H"."Actual Cost" |
Fact - Primavera -Activity History | Earned Value (Cost) | Cost Schedule Index (Cost) | Fact | Cost Schedule Index By Cost | Value Derived From: "P6Core"."Fact - Activity Spread H"."Cost Performance Index - (CPI)" * "P6Core"."Fact - Activity Spread H"."Schedule Performance Index (SPI) - Cost" |
Fact - Primavera -Activity 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. | Valued Derived From: "P6Core"."Fact - Activity Spread H"."Earned Value Cost" - "P6Core"."Fact - Activity Spread H"."Actual Cost" |
Fact - Primavera -Activity History | Earned Value (Cost) | Cost Variance Index (Cost) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | Value Derived From: "P6Core"."Fact - Activity Spread H"."Cost Variance" / "P6Core"."Fact - Activity Spread H"."Earned Value Cost" |
Fact - Primavera -Activity History | Earned Value (Cost) | Earned Value (Cost) | Fact | Earned value cost for the project | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EARNED_VALUE_COST) |
Fact - Primavera -Activity 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. | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_AT_COMPLETION_COST) |
Fact - Primavera -Activity History | Earned Value (Cost) | Estimate to Complete (Cost) | Fact | Calculated Estimate To Complete using specified technique | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_TO_COMPLETE_COST) |
Fact - Primavera -Activity History | Earned Value (Cost) | Planned Value (Cost) | Fact | Planned cost of work scheduled for the project | Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_VALUE_COST) |
Fact - Primavera -Activity 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. | Derived From: "P6Core"."Fact - Activity Spread H"."Earned Value Cost" / "P6Core"."Fact - Activity Spread H"."Planned Value Cost" |
Fact - Primavera -Activity 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. | Derived From: "P6Core"."Fact - Activity Spread H"."Earned Value Cost" - "P6Core"."Fact - Activity Spread H"."Planned Value Cost" |
Fact - Primavera -Activity History | Earned Value (Cost) | Schedule Variance Index (Cost) | Fact | Schedule Variance Index is the Schedule Variance divided by Planned Value. | Derived From: "P6Core"."Fact - Activity Spread H"."Schedule Variance - Cost" / "P6Core"."Fact - Activity Spread H"."Planned Value Cost" |
Fact - Primavera -Activity History | Earned Value (Cost) | To Complete Performance Index - BAC (Cost) | Fact | The To Complete Performance Index is (Budget at Completion - Earned Value) / (Budget at Completion (BAC)- Actual Cost). | ("P6Core"."Fact - Activity Spread H"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread H"."Earned Value Cost") / ("P6Core"."Fact - Activity Spread H"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread H"."Actual Cost") |
Fact - Primavera -Activity History | Earned Value (Cost) | To Complete Performance Index - EAC (Cost) | Fact | The To Complete Performance Index is (Budget at Completion - Earned Value) / (Estimate at Completion - Actual Cost). | Derived From: ("P6Core"."Fact - Activity Spread H"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread H"."Earned Value Cost") / ("P6Core"."Fact - Activity Spread H"."Estimate At Completion Cost" - "P6Core"."Fact - Activity Spread H"."Actual Cost") |
Fact - Primavera -Activity History | Earned Value (Cost) | Variance At Completion (Cost) | Fact | Variance At Completion is the Budget At Completion (baseline total cost) minus Estimate At Completion. | Derived From: "P6Core"."Fact - Activity Spread H"."Baseline Project Total Cost" - "P6Core"."Fact - Activity Spread H"."Estimate At Completion Cost" |
Fact - Primavera -Activity 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. | Derived From: "P6Core"."Fact - Activity Spread H"."Planned Value Labor Units" - "P6Core"."Fact - Activity Spread H"."Actual Labor Units" |
Fact - Primavera -Activity 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. | Derived From: "P6Core"."Fact - Activity Spread H"."Baseline Project Labor Units" |
Fact - Primavera -Activity History | Earned Value (Units) | Cost Performance Index (Units) | Fact | Cost Performance Index Labor Units is the Earned Value Labor Units / Actual Labor Units. | Derived From: "P6Core"."Fact - Activity Spread H"."Earned Value Labor Units" / "P6Core"."Fact - Activity Spread H"."Actual Labor Units" |
Fact - Primavera -Activity History | Earned Value (Units) | Cost Schedule Index (Units) | Fact | Cost Schedule Index By Units | Derived From: "P6Core"."Fact - Activity Spread H"."Cost Performance Index (CPI) - Labor Units" * "P6Core"."Fact - Activity Spread H"."Schedule Performance Index (SPI) - Labor Units" |
Fact - Primavera -Activity History | Earned Value (Units) | Cost Variance (Units) | Fact | Cost Variance Labor Units is Earned Value Labor Units minus Actual Labor Units. | Derived From: "P6Core"."Fact - Activity Spread H"."Earned Value Labor Units" - "P6Core"."Fact - Activity Spread H"."Actual Labor Units" |
Fact - Primavera -Activity History | Earned Value (Units) | Cost Variance Index (Units) | Fact | Cost Variance Index is the Cost Variance divided by Earned Value. | Derived From: "P6Core"."Fact - Activity Spread H"."Cost Variance - Labor Units" / "P6Core"."Fact - Activity Spread H"."Earned Value Labor Units" |
Fact - Primavera -Activity 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. | Derives From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EARNED_VALUE_LABOR_UNITS) |
Fact - Primavera -Activity 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.) | Derives From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_AT_COMPLETION_LABOR_UNITS) |
Fact - Primavera -Activity 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. | Derives From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_TO_COMPLETE_LABOR_UNITS) |
Fact - Primavera -Activity 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. | Derives From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_VALUE_LABOR_UNITS) |
Fact - Primavera -Activity 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. | Derives From: "P6Core"."Fact - Activity Spread H"."Earned Value Cost" / "P6Core"."Fact - Activity Spread H"."Planned Value Cost" |
Fact - Primavera -Activity History | Earned Value (Units) | Schedule Variance (Units) | Fact | Schedule Variance Labor Units is the Earned Value Labor Units minus Planned Value Labor Units. | Derives From: "P6Core"."Fact - Activity Spread H"."Earned Value Labor Units" - "P6Core"."Fact - Activity Spread H"."Planned Value Labor Units" |
Fact - Primavera -Activity 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. | Derives From: "P6Core"."Fact - Activity Spread H"."Schedule Variance - Labor Units" / "P6Core"."Fact - Activity Spread H"."Planned Value Labor Units" |
Fact - Primavera -Activity 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). | Derives From: ("P6Core"."Fact - Activity Spread H"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Activity Spread H"."Earned Value Labor Units") / ("P6Core"."Fact - Activity Spread H"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Activity Spread H"."Actual Labor Units") |
Fact - Primavera -Activity 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). | Derives From: ("P6Core"."Fact - Activity Spread H"."Budget At Completion (BAC) - Labor Units" - "P6Core"."Fact - Activity Spread H"."Earned Value Labor Units") / ("P6Core"."Fact - Activity Spread H"."Estimate At Completion - Labor Units" - "P6Core"."Fact - Activity Spread H"."Actual Labor Units") |
Fact - Primavera -Activity History | Earned Value (Units) | Variance At Completion (Units) | Fact | Variance At Completion is the Planned Labor Units minus Estimate At Completion Labor Units. | Derives From: "P6Core"."Fact - Activity Spread H"."Baseline Project Labor Units" - "P6Core"."Fact - Activity Spread H"."Estimate At Completion - Labor Units" |
Fact - Primavera -Activity History | Units | Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_LABOR_UNITS |
Fact - Primavera -Activity History | Units | Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_NONLABOR_UNITS |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_LABOR_UNITS |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_NONLABOR_UNITS |
Fact - Primavera -Activity History | Units | Baseline Actual Labor Units | Fact | The actual units for all labor resources assigned to the activity in the project baseline | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_LABOR_UNITS |
Fact - Primavera -Activity History | Units | Baseline Actual Nonlabor Units | Fact | The actual units for all nonlabor resources assigned to the activity in the project baseline | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_NONLABOR_UNITS |
Fact - Primavera -Activity History | Units | Baseline Project Labor Units | Fact | The sum of the Budgeted (or At Completion) units for all labor resources assigned to the activity in the project baseline. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_LABOR_UNITS |
Fact - Primavera -Activity History | Period Units | Baseline Project Nonlabor Units | Fact | The sum of the Budgeted (or At Completion) units for all nonlabor resources assigned to the activity in the project baseline | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_NONLABOR_UNITS |
Fact - Primavera -Activity History | Period Units | Next This Period Labor Units | Fact | This Period Labor Units for the period after the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.NEXT_PER_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Next This Period Nonlabor Units | Fact | This Period Nonlabor Units for the period after the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.NEXT_PER_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Actual Labor Units | Fact | Period Actual Labor Units | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Actual Nonlabor Units | Fact | The Actual Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period At Completion Labor Units | Fact | The At Completion Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Baseline Actual Labor Units | Fact | The Baseline Actual Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Baseline Actual Nonlabor Units | Fact | The Baseline Actual Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_ACTUAL_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Baseline Project Labor Units | Fact | The Baseline Project Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Baseline Project Nonlabor Units | Fact | The Baseline Project Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.BL_PLANNED_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Earned Value Labor Units | Fact | The Earned Value Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.EARNED_VALUE_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Estimate At Completion Labor Units | Fact | The Estimate At Completion Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_AT_COMPL_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Estimate To Completion Labor Units | Fact | The Estimate to Completion Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.EST_TO_COMPLETE_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Planned Labor Units | Fact | Period Planned Labor Units | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Planned Nonlabor Units | Fact | The Planned Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Planned Value Labor Units | Fact | The Planned Value Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_VALUE_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Remaining Labor Units | Fact | The Remaining Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Remaining Late Labor Units | Fact | The Remaining Late Labor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_LABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Remaining Late Nonlabor Units | Fact | The Remaining Late Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REM_LATE_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period Remaining Nonlabor Units | Fact | The Remaining Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Period Units | Period At Completion Nonlabor Units | Fact | The At Completion Nonlabor Units for the period specified | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_NONLABOR_UNITS_P |
Fact - Primavera -Activity History | Units | Planned Labor Units | Fact | The budgeted units for all labor resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_LABOR_UNITS |
Fact - Primavera -Activity History | Units | Planned Nonlabor Units | Fact | The budgeted units for all nonlabor resources assigned to the activity. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PLANNED_NONLABOR_UNITS |
Fact - Primavera -Activity History | Period Units | Previous This Period Labor Units | Fact | Previous This Period Labor Units | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PREV_THIS_PER_LABOR_UNITS |
Fact - Primavera -Activity History | Period Units | Previous This Period Nonlabor Units | Fact | The Nonlabor Units planned for the previous period | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.PREV_THIS_PER_NONLABOR_UNITS |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LABOR_UNITS |
Fact - Primavera -Activity History | Units | Remaining Late Labor Units | Fact | Remaining Late Labor Units | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_LABOR_UNITS |
Fact - Primavera -Activity History | Units | Remaining Late Nonlabor Units | Fact | Remaining Late Nonlabor Units | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_LATE_NONLABOR_UNITS |
Fact - Primavera -Activity 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. | Value Derived From : Fact_W_ACTIVITY_HISTORY_F_Activity_History.REMAINING_NONLABOR_UNITS |
Fact - Primavera -Activity History | Metrics | # Of Activities | Fact | # Of Activities | Value Derived From: count(distinct Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTIVITY_WID) |
Fact - Primavera -Activity History | Metrics | # Of Projects | Fact | # Of Projects | Value Derived From: count(distinct Fact_W_ACTIVITY_HISTORY_F_Activity_History.PROJECT_WID) |
Fact - Primavera -Activity History | Metrics | Completed Last Period | Fact | Activities with Completed status at the time of the previous ETL run | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.COMPLETED_LAST_PERIOD) |
Fact - Primavera -Activity History | Metrics | Completed This Period | Fact | Activities whose actual finish date fell between the period start and period end for this ETL run | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.COMPLETED_THIS_PERIOD) |
Fact - Primavera -Activity History | Metrics | Delayed This Period | Fact | Activities planned to start between the period start and period end with no actual start date | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.DELAYED_THIS_PERIOD) |
Fact - Primavera -Activity History | Metrics | Emergent Count | Fact | Activities added before the period start date of this ETL run | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.EMERGENT_WORK) |
Fact - Primavera -Activity History | Metrics | In Progress Last Period | Fact | Activities with In Progress status at the time of the previous ETL run | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.IN_PROGRESS_LAST_PERIOD) |
Fact - Primavera -Activity History | Metrics | In Progress This Period | Fact | Activities whose actual start date fell between the period start and period end for this ETL run | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.IN_PROGRESS_THIS_PERIOD) |
Fact - Primavera -Activity History | Metrics | Not Started Last Period | Fact | Activities with Not Started status at the time of the previous ETL run | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.NOT_STARTED_LAST_PERIOD) |
Fact - Primavera -Activity History | Metrics | Not Started This Period | Fact | The number of activities that are Not Started during the specific Project History Interval. | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.NOT_STARTED_ACTIVITY_COUNT) |
Fact - Primavera -Activity History | Metrics | Risk Exposure | Fact | The calculated exposure value for the risk | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.PROJECT_RISK_EXPOSURE) |
Fact - Primavera -Activity History | Metrics | Risk Score | Fact | The calculated score value of the impact values assigned to the risk | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.PROJECT_RISK_SCORE) |
Fact - Primavera -Activity 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. | Value Derived From: sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_TOTAL_COST) / nullif( sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_TOTAL_COST) , 0) * 100 |
Fact - Primavera -Activity History | Percent Completes | Cost % of Planned | Fact | The proportion of the cost budget that has been spent. Computed as actual total cost / baseline total cost. | Value Derived From: "P6Core"."Fact - Activity Spread H"."Actual Cost" / "P6Core"."Fact - Activity Spread H"."Budget at Completion" * 100 |
Fact - Primavera -Activity History | Percent Completes | Expense Cost % Complete | Fact | The percent complete of cost for all expenses associated with the wbs. Computed as Actual Expense Cost / At Complete Expense Cost * 100. Always in the range 0 to 100. | Value Derived From: "P6Core"."Fact - Activity Spread H"."Actual Expense Cost" / "P6Core"."Fact - Activity Spread H"."At Completion Expense Cost" * 100 |
Fact - Primavera -Activity History | Percent Completes | Labor Cost % Complete | Fact | The percent complete of cost for all labor resources assigned to the wbs. Computed as Actual Labor Cost / At Complete Labor Cost * 100. Always in the range 0 to 100. | sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_LABOR_COST) / nullif( sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_LABOR_COST) , 0) * 100 |
Fact - Primavera -Activity 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. | sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_LABOR_UNITS) / nullif( sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_LABOR_UNITS) , 0) * 100 |
Fact - Primavera -Activity History | Percent Completes | Material Cost % Complete | Fact | The percent complete of cost for all material resources assigned to the wbs. Computed as Actual Material Cost / At Complete Material Cost * 100. Always in the range 0 to 100. | sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_MATERIAL_COST) / nullif( sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_MATERIAL_COST) , 0) * 100 |
Fact - Primavera -Activity History | Percent Completes | Nonlabor Cost % Complete | Fact | The percent complete of cost for all nonlabor resources assigned to the wbs. Computed as Actual Nonlabor Cost / At Complete Nonlabor Cost * 100. Always in the range 0 to 100. | sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_NONLABOR_COST) / nullif( sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_NONLABOR_COST) , 0) * 100 |
Fact - Primavera -Activity 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. | sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.ACTUAL_NONLABOR_UNITS) / nullif( sum(Fact_W_ACTIVITY_HISTORY_F_Activity_History.AT_COMPLETION_NONLABOR_UNITS) , 0) * 100 |
Fact - Primavera -Activity 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 - Activity Spread H"."Earned Value Cost" / P6Core."Fact - Activity Spread H"."Budget at Completion" * 100 |
Fact - Primavera -Activity History | Percent Completes | Perfomance % Complete (Units) | Fact | Perfomance % Complete (Units) | IFNULL(P6Core."Fact - Activity Spread H"."Earned Value Labor Units", 0) / IFNULL(P6Core."Fact - Activity Spread H"."Budget At Completion (BAC) - Labor Units", 0) * 100 |
Fact - Primavera -Activity History | Percent Completes | Schedule % Complete | Fact | Schedule % Complete | P6Core."Fact - Activity Spread H"."Planned Value Cost" / P6Core."Fact - Activity Spread H"."Budget at Completion" * 100 |
Fact - Primavera -Activity History | Percent Completes | Schedule % Complete (Units) | Fact | Schedule % Complete (Units) | IFNULL(P6Core."Fact - Activity Spread H"."Earned Value Labor Units", 0) / IFNULL(P6Core."Fact - Activity Spread H"."Budget At Completion (BAC) - Labor Units", 0) * 100 |
Fact - Primavera -Activity 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. | ( IFNULL(P6Core."Fact - Activity Spread H"."Actual Labor Units", 0) + IFNULL(P6Core."Fact - Activity Spread H"."Actual Nonlabor Units", 0)) / ( IFNULL(P6Core."Fact - Activity Spread H"."At Completion Labor Units", 0) + IFNULL(P6Core."Fact - Activity Spread H"."At Completion Nonlabor Units", 0)) * 100 |
|
|
|
|
|
|
Activity Folder |
|
|
|
|
|
Activity | Dates - (Activity) | Actual Finish | Dimension | The date on which the activity actually finished | Dim_W_ACTIVITY_HD_Activity.ACTUAL_FINISH_DATE" |
Activity | Dates - (Activity) | Actual Start | Dimension | The date on which the activity actually started | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTUAL_START_DATE |
Activity | Dates - (Activity) | Baseline Project Finish | Dimension | The Project Baseline Planned Finish Date. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.BASELINE_FINISH_DATE |
Activity | Dates - (Activity) | Baseline Project Start | Dimension | The Project Baseline Planned Start Date. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.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_Activity.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_Activity.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_Activity.EARLY_START_DATE |
Activity | Dates - (Activity) | Effective End Date | Dimension | The end date this version of the record is effective | Value Derived From : Dim_W_ACTIVITY_HD_Activity.EFFECTIVE_END_DATE |
Activity | Dates - (Activity) | Effective Start Date | Dimension | The start date this version of the record is effective | Value Derived From : Dim_W_ACTIVITY_HD_Activity.EFFECTIVE_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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.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_Activity.RESUME_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_Activity.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_Activity.START_DATE |
Activity | Dates - (Activity) | Suspend Date | Dimension | The date progress is suspended on an activity. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.SUSPEND_DATE |
Activity | Durations - (Activity) | Actual Duration | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTUAL_DURATION |
Activity | Durations - (Activity) | At Completion Duration | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.AT_COMPLETION_DURATION |
Activity | Durations - (Activity) | Baseline Project Duration | Dimension | The duration for the activity in the primary baseline. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.BASELINE_DURATION |
Activity | Durations - (Activity) | Baseline Planned Duration | Dimension | Baseline Planned Duration is the total working time from the baseline activity planned start date to the baseline planned finish date. The baseline planned working time is computed using the activity's calendar. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.BASELINE_PLANNED_DURATION |
Activity | Durations - (Activity) | Free Float | Dimension | The amount of time the activity can be delayed before delaying the start date of any successor activity. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.FREE_FLOAT |
Activity | Durations - (Activity) | Original Duration | Dimension | Original Duration is the total working time from the activity planned start date to the planned finish date. The planned working time is computed using the activity's calendar. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.PLANNED_DURATION |
Activity | Durations - (Activity) | Remaining Duration | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.REMAINING_DURATION |
Activity | Durations - (Activity) | Remaining Float | Dimension | The amount of time remaining by which the activity can be delayed before delaying the project finish date. Computed as Late Finish - Remaining Finish. If the remaining finish is the same as the early finish ( in general, when the activity is not started), then the remaining float is the same as the total float. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.REMAINING_FLOAT |
Activity | Durations - (Activity) | Total Float | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.TOTAL_FLOAT |
Activity | Durations - (Activity) | Variance - Baseline Project Duration | Dimension | Variance duration is the duration between the activity' Baseline project duration and the At Completion duration. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.DURATION_VARIANCE |
Activity | Durations - (Activity) | Variance - Baseline Project Finish Date | Dimension | Variance Finish Date is the duration between the Baseline project finish date and the finish date in the current project. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.FINISH_DATE_VARIANCE |
Activity | Durations - (Activity) | Variance - Baseline Project Start Date | Dimension | Variance Start Date is the duration between the Baseline project start date and the start date in the current project. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.START_DATE_VARIANCE |
Activity | General - (Activity) | Activity ID | Dimension | A short ID which uniquely identifies the activity within the project. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTIVITY_ID |
Activity | General - (Activity) | Activity Name | Dimension | The name of the activity. The activity name does not have to be unique. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTIVITY_NAME |
Activity | General - (Activity) | Owner | Dimension | User who owns the activity. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTIVITY_OWNER |
Activity | General - (Activity) | Activity Status | Dimension | The current status of the activity, either Not Started, In Progress, or Completed. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTIVITY_STATUS |
Activity | General - (Activity) | Activity Type | Dimension | The type of activity, either 'Task Dependent', 'Resource Dependent', 'Level of Effort', 'Start Milestone' or 'Finish Milestone'. A Task Dependent activity is scheduled using the activity's calendar rather than the calendars of the assigned resources. A Resource Dependent activity is scheduled using the calendars of the assigned resources. This type is used when several resources are assigned to the activity, but they may work separately. A Start/Finish Milestone is a zero-duration activity, marking a significant start/end of project event. A Level of Effort activity has a duration which is determined by its dependent activities. Administration-type activities are typically level of effort. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ACTIVITY_TYPE |
Activity | General - (Activity) | Auto Compute Actuals | Dimension | Identifies whether the actual and remaining units, start date, finish date, and percent complete for the activity are computed automatically using the planned dates, budgeted units and the activity's schedule percent complete. If this option is selected, the actual/remaining units and actual dates are automatically updated when project actuals are applied. This assumes that all work for the activity proceeds according to plan. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.AUTO_COMPUTE_ACTUALS_FLAG |
Activity | General - (Activity) | Calendar Name | Dimension | The calendar assigned to the activity. Activity calendars can be assigned from the global calendar pool or the project calendar pool. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.CALENDAR_NAME |
Activity | General - (Activity) | Criticality Index | Dimension | Criticality Index | Value Derived From : Dim_W_ACTIVITY_HD_Activity.CRITICALITY_INDEX |
Activity | General - (Activity) | Current Flag | Dimension | Indicates if a record is current (1,0) | Value Derived From : Dim_W_ACTIVITY_HD_Activity.CURRENT_FLAG |
Activity | General - (Activity) | Duration Type | Dimension | The duration type of the activity. One of Fixed Units per Time, Fixed Duration, or Fixed Units. For Fixed Units per Time activities, the resource units per time are constant when the activity duration or units are changed. This type is used when an activity has fixed resources with fixed productivity output per time period. For Fixed Duration activities, the activity duration is constant as the units or resource units per time are changed. This type is used when the activity is to be completed within a fixed time period regardless of the resources assigned. For Fixed Units activities, the activity units are constant when the duration or resource units per time are changed. This type is used when the total amount of work is fixed, and increasing the resources can decrease the activity duration. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.DURATION_TYPE |
Activity | General - (Activity) | Critical | Dimension | Indicates whether the activity is critical. An activity is critical when its Total Float is below the critical duration specified for the project. Delaying critical activities will delay the finish date of the project. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.CRITICALITY_INDEX |
Activity | General - (Activity) | Longest Path | Dimension | Indicates whether an activity is on the longest path. The longest path is defined as activities that are on the critical path and determine the end date of the project. Defining critical activities based on the longest path in the project provides an alternative to viewing critical activities based on float. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.IS_LONGEST_PATH |
Activity | General - (Activity) | Activity Leveling Priority | Dimension | The activity priority can be used to prioritize activities in a project when performing resource leveling. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.LEVELING_PRIORITY |
Activity | General - (Activity) | Percent Complete Type | Dimension | The activity percent complete type is one of Duration, Units, or Physical. The percent complete type controls whether the Activity % Complete is tied to the Duration % Complete, the Units % Complete, or the Physical % Complete for the activity. Set the percent complete type to Duration for activities which are duration driven, for example, administration tasks and training classes. Set the percent complete type to Physical for activities which are work-product driven, for example, creating a document or a product. Set the percent complete type to Units for activities which are work effort driven, for example, providing a consulting service. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.COMPLETE_PCT_TYPE |
Activity | General - (Activity) | Primary Constraint | Dimension | The type of constraint applied to the activity start or finish date. Activity constraints are used by the project scheduler. Start date constraints are 'Start On', 'Start On or Before', 'Start On or After' and 'Mandatory Start'. Finish date constraints are 'Finish On', 'Finish On or Before', 'Finish On or After' and 'Mandatory Finish'. Another type of constraint, 'As Late as Possible', schedules the activity as late as possible based on the available free float. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.PRIMARY_CONSTRAINT_TYPE |
Activity | General - (Activity) | Primary Resource | Dimension | The primary resource for the activity. The primary resource is responsible for the overall work on the activity and updates the activity status using Progress Reporter. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.PRIMARY_RESOURCE_NAME |
Activity | General - (Activity) | Secondary Constraint | Dimension | The second type of constraint applied to the activity start or finish date. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.SECONDARY_CONSTRAINT_TYPE |
Activity | General - (Activity) | WBS Code | Dimension | The WBS for the activity. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.WBS_CODE |
Activity | General - (Activity) | WBS Name | Dimension | The Work Breakdown Structure Name. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.WBS_NAME |
Activity | Location - (Activity) | Address Line 1 | Dimension | The first line of the address | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ADDRESS_LINE1 |
Activity | Location - (Activity) | Address Line 2 | Dimension | The second line of the address | Value Derived From : Dim_W_ACTIVITY_HD_Activity.ADDRESS_LINE2 |
Activity | Location - (Activity) | City Name | Dimension | The city name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.CITY_NAME |
Activity | Location - (Activity) | Country Code | Dimension | The country code for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.COUNTRY_CODE |
Activity | Location - (Activity) | Country Name | Dimension | The country name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.COUNTRY_NAME |
Activity | Location - (Activity) | Latitude | Dimension | The latitude for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.LATITUDE |
Activity | Location - (Activity) | Location Name | Dimension | The name of the location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.LOCATION_NAME |
Activity | Location - (Activity) | Location Type | Dimension | Location Type | Value Derived From : Dim_W_ACTIVITY_HD_Activity.LOCATION_TYPE |
Activity | Location - (Activity) | Longitude | Dimension | The longitude for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.LONGITUDE |
Activity | Location - (Activity) | Municipality Name | Dimension | The municipality name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.MUNICIPALITY_NAME |
Activity | Location - (Activity) | Postal Code | Dimension | The postal code for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.POSTAL_CODE |
Activity | Location - (Activity) | State/Province Code | Dimension | The state abbreviation for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.STATE_CODE |
Activity | Location - (Activity) | State/Province Name | Dimension | The state name for this Location | Value Derived From : Dim_W_ACTIVITY_HD_Activity.STATE_NAME |
Activity | Percent Completes - (Activity) | Duration % Of Planned | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.DURATION_PCT_OF_PLANNED |
Activity | Percent Completes - (Activity) | Duration % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.DURATION_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Expense Cost % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.EXPENSE_COST_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Labor Units % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.LABOR_UNITS_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Nonlabor Cost % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.NONLABOR_COST_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Nonlabor Units % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.NONLABOR_UNITS_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Percent Complete | Dimension | The activity percent complete. This value is tied to the activity Duration % Complete, Units % Complete, or Physical % Complete, depending on the setting for the activity's Percent Complete Type, which is one of Duration, Units, or Physical. Always in the range 0 to 100. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.PERCENT_COMPLETE |
Activity | Percent Completes - (Activity) | Performance % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.PERFORMANCE_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Physical % Complete | Dimension | The physical percent complete can either be user entered or calculated from the activity's weighted steps. There is a project setting specifying this. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.PHYSICAL_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Schedule % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.SCHEDULE_PCT_COMPLETE |
Activity | Percent Completes - (Activity) | Units % Complete | Dimension | 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. | Value Derived From : Dim_W_ACTIVITY_HD_Activity.UNITS_PCT_COMPLETE |
|
|
|
|
|
|
WBS Folder |
|
|
|
|
|
WBS |
| Current Flag | Dimension | Indicates if a record is current (1,0) | Value Derived From : Dim_W_WBS_HD_Wbs.CURRENT_FLAG |
WBS |
| Effective End Date | Dimension | The end date this version of the record is effective | Value Derived From : Dim_W_WBS_HD_Wbs.EFFECTIVE_END_DATE |
WBS |
| Effective Start Date | Dimension | The start date this version of the record is effective | Value Derived From : Dim_W_WBS_HD_Wbs.EFFECTIVE_START_DATE |
WBS |
| Unique Project ID | Dimension | The Unique ID of the project | Value Derived From : Dim_W_WBS_HD_Wbs.PROJECT_OBJECT_ID |
WBS |
| WBS Name | Dimension | The Work Breakdown Structure Name. | Value Derived From : Dim_W_WBS_HD_Wbs.WBS_NAME |
WBS |
| WBS Unique Id | Dimension | The Unique ID of the WBS | Value Derived From : Dim_W_WBS_HD_Wbs.WBS_OBJECT_ID |
WBS | WBS Hierarchy - (WBS) | Full Path Name | Dimension | Full path for wbs hierarchy | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.FULL_PATH_NAME |
WBS | WBS Hierarchy - (WBS) | WBS Code (Project Level) | Dimension | A short code assigned to each WBS element for identification. Each WBS element is uniquely identified by concatenating its own code together with its parents codes | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.PROJ_LEVEL_SHORT_NAME |
WBS | WBS Hierarchy - (WBS) | WBS Name (Project Level) | Dimension | The name of the WBS element | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.PROJ_LEVEL_NAME |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 1 | Dimension | WBS ID Level 1 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV1 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 10 | Dimension | WBS ID Level 10 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV10 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 11 | Dimension | WBS ID Level 11 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV11 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 12 | Dimension | WBS ID Level 12 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV12 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 13 | Dimension | WBS ID Level 13 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV13 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 14 | Dimension | WBS ID Level 14 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV14 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 15 | Dimension | WBS ID Level 15 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV15 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 16 | Dimension | WBS ID Level 16 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV16 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 17 | Dimension | WBS ID Level 17 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV17 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 2 | Dimension | WBS ID Level 2 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV2 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 3 | Dimension | WBS ID Level 3 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV3 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 4 | Dimension | WBS ID Level 4 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV4 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 5 | Dimension | WBS ID Level 5 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV5 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 6 | Dimension | WBS ID Level 6 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV6 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 7 | Dimension | WBS ID Level 7 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV7 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 8 | Dimension | WBS ID Level 8 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV8 |
WBS | WBS Hierarchy - (WBS) | WBS ID Level 9 | Dimension | WBS ID Level 9 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_ID_LV9 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 1 | Dimension | WBS Name Level 1 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV1 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 10 | Dimension | WBS Name Level 10 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV10 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 11 | Dimension | WBS Name Level 11 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV11 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 12 | Dimension | WBS Name Level 12 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV12 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 13 | Dimension | WBS Name Level 13 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV13 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 14 | Dimension | WBS Name Level 14 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV14 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 15 | Dimension | WBS Name Level 15 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV15 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 16 | Dimension | WBS Name Level 16 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV16 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 17 | Dimension | WBS Name Level 17 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV17 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 2 | Dimension | WBS Name Level 2 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV2 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 3 | Dimension | WBS Name Level 3 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV3 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 4 | Dimension | WBS Name Level 4 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV4 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 5 | Dimension | WBS Name Level 5 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV5 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 6 | Dimension | WBS Name Level 6 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV6 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 7 | Dimension | WBS Name Level 7 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV7 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 8 | Dimension | WBS Name Level 8 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV8 |
WBS | WBS Hierarchy - (WBS) | WBS Name Level 9 | Dimension | WBS Name Level9 | Value Derived From : Dim_W_WBS_HIERARCHY_D_WbsHier_ID.WBS_NAME_LV9 |
Related Topics
P6 - Activity / Primavera Activity
P6 - Activity Period Actuals / Primavera - Activity Period Actuals
P6 - Burn Down / Primavera - Burn Down
P6 - Project History / Primavera - Project History
P6 - Resource Assignment / Primavera - Resource Assignment
P6 - Resource Assignment History / Primavera - Resource Assignment History
P6 - Resource Period Actuals / Primavera - Resource Period Actuals
P6 - Resource Utilization / Primavera - Resource Utilization
P6 - Role Utilization / Primavera - Role Utilization
P6 - Spread Snapshot History / Primavera - Spread Snapshot History
P6 - Work Planning / Primavera - Work Planning
Last Published Friday, December 8, 2023