P6 - Spread Snapshot History / Primavera - Spread Snapshot History

Description: Use this subject area to analyze how your data will appear at different points in time by creating a snapshot at different time intervals, for comparison purposes.

Folder	Subfolder	Field Name	Dimension/ Fact / Lookup	Description	Values Derived From / Calculated By
Fact - Primavera - Spread Snapshot History	Costs
Fact - Primavera - Spread Snapshot History	Costs	Actual Cost	Fact	The actual non-overtime plus overtime cost for the resource assignment on the activity. Calculated as Actual Regular Cost plus Actual Overtime Cost.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_COST
Fact - Primavera - Spread Snapshot History	Costs	Actual Overtime Cost	Fact	The actual overtime cost for the resource assignment on the activity. Calculated as Actual Overtime Units multiplied by Cost per Time multiplied by Overtime Factor.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_OVERTIME_COST
Fact - Primavera - Spread Snapshot History	Costs	Actual Regular Cost	Fact	The actual non-overtime cost for the resource assignment on the activity. Calculated as Actual Regular Units multiplied by Cost per Time.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_REGULAR_COST
Fact - Primavera - Spread Snapshot History	Costs	At Completion Cost	Fact	The sum of the actual costs plus remaining costs for the resource assignment on the activity. Calculated as Actual Costs plus Remaining Costs.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.AT_COMPLETION_COST
Fact - Primavera - Spread Snapshot History	Costs	Planned Cost	Fact	The planned cost of work required for the assignment to be completed. Calculated as Planned Units multiplied by Price per Time.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.PLANNED_COST
Fact - Primavera - Spread Snapshot History	Costs	Remaining Cost	Fact	The remaining cost for the resource assignment on the activity. Calculated as Remaining Units multiplied by Cost/Time.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_COST
Fact - Primavera - Spread Snapshot History	Costs	Remaining Late Cost	Fact	Remaining Late Cost	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_LATE_COST
Fact - Primavera - Spread Snapshot History	Costs	Staffed Remaining Cost	Fact	The remaining cost for resource assignments that have a filled role.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_COST
Fact - Primavera - Spread Snapshot History	Costs	Staffed Remaining Late Cost	Fact	Staffed Remaining Late Cost	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_COST
Fact - Primavera - Spread Snapshot History	Costs	Unstaffed Remaining Cost	Fact	The remaining cost for resource assignments that do not have a filled role.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_COST
Fact - Primavera - Spread Snapshot History	Costs	Unstaffed Remaining Late Cost	Fact	Unstaffed Remaining Late Cost	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_COST
Fact - Primavera - Spread Snapshot History	Metrics			Metrics
Fact - Primavera - Spread Snapshot History	Metrics	# Of Activities	Fact	# Of Activities	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTIVITY_WID
Fact - Primavera - Spread Snapshot History	Metrics	# Of Projects	Fact	# Of Projects	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.PROJECT_WID
Fact - Primavera - Spread Snapshot History	Metrics	# Of Resources	Fact	# Of Resources	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.RESOURCE_WID
Fact - Primavera - Spread Snapshot History	Units			Units
Fact - Primavera - Spread Snapshot History	Units	Actual Overtime Units	Fact	The actual overtime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_OVERTIME_UNITS
Fact - Primavera - Spread Snapshot History	Units	Actual Regular Units	Fact	The actual nonovertime units worked by the resource on this activity. This value is computed from timesheets when project actuals are applied or may be entered directly by the project manager.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_REGULAR_UNITS
Fact - Primavera - Spread Snapshot History	Units	Actual Units	Fact	The sum of the actual non-overtime and the overtime units worked by the resource on the activity.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.ACTUAL_UNITS
Fact - Primavera - Spread Snapshot History	Units	At Completion Units	Fact	The sum of the actual units and remaining units for the resource assignment on the activity. Calculated as Actual Units plus Remaining Units.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.AT_COMPLETION_UNITS
Fact - Primavera - Spread Snapshot History	Units	Planned Units	Fact	The planned units of work for the resource assignment on the activity.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.PLANNED_UNITS
Fact - Primavera - Spread Snapshot History	Units	Remaining Late Units	Fact	Remaining Late Units	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_LATE_UNITS
Fact - Primavera - Spread Snapshot History	Units	Remaining Units	Fact	The remaining units of work to be performed by the resource on the activity. Calculated as Planned Units minus Actual Units.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.REMAINING_UNITS
Fact - Primavera - Spread Snapshot History	Units	Staffed Remaining Late Units	Fact	Staffed Remaining Late Units	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_UNITS
Fact - Primavera - Spread Snapshot History	Units	Staffed Remaining Units	Fact	The remaining units for resource assignments that have filled a role.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.STAFFED_REMAINING_UNITS
Fact - Primavera - Spread Snapshot History	Units	Unstaffed Remaining Late Units	Fact	Unstaffed Remaining Late Units	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_UNITS
Fact - Primavera - Spread Snapshot History	Units	Unstaffed Remaining Units	Fact	The remaining units for resource assignments that have not filled a role.	Value Derived From : Fact_W_SPREAD_SNAP_HISTORY_F_Spread_Snapshot_History.UNSTAFFED_REMAINING_UNITS

Related Topics