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