P6 - Resource Assignment History / Primavera - Resource Assignment History

Description: Use this subject area to analyze daily resource assignment-level history, including changes to both facts and dimensions to help you 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
Resource	Cost Account - (Resource)			Resource Cost Accounts
Resource	Cost Account - (Resource)	Cost Account ID	Dimension	A short ID assigned to each cost account for identification. Each cost account is uniquely identified by concatenating its own ID together with its parents' IDs.	Value Derived From : Dim_W_COST_ACCOUNT_HD_CostAcct.ACCT_SHORT_NAME
Resource	Cost Account - (Resource)	Cost Account Name	Dimension	The name of a cost account.	Value Derived From : Dim_W_COST_ACCOUNT_HD_CostAcct.ACCT_NAME
Resource	Cost Account - (Resource)	Current Flag	Dimension	Indicates if a record is current (1,0)	Value Derived From : Dim_W_COST_ACCOUNT_HD_CostAcct.CURRENT_FLAG
Resource	Cost Account - (Resource)	Effective End Date	Dimension	The end date this version of the record is effective	Value Derived From : Dim_W_COST_ACCOUNT_HD_CostAcct.EFFECTIVE_END_DATE
Resource	Cost Account - (Resource)	Effective Start Date	Dimension	The start date this version of the record is effective	Value Derived From : Dim_W_COST_ACCOUNT_HD_CostAcct.EFFECTIVE_START_DATE
Resource	General - (Resource)			General Resource Information
Resource	General - (Resource)	Active	Dimension	Indicates whether the resource is currently active. Nonactive resources may have left the organization but are not deleted from the system since they may have actual hours.	Value Derived From : Dim_W_RESOURCE_HD_Resource.ACTIVE_FLAG
Resource	General - (Resource)	Current Flag	Dimension	Indicates if a record is current (1,0)	Value Derived From : Dim_W_RESOURCE_HD_Resource.CURRENT_FLAG
Resource	General - (Resource)	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_RESOURCE_HD_Resource.DATASOURCE_ID
Resource	General - (Resource)	Effective End Date	Dimension	The end date this version of the record is effective	Value Derived From : Dim_W_RESOURCE_HD_Resource.EFFECTIVE_END_DATE
Resource	General - (Resource)	Effective Start Date	Dimension	The start date this version of the record is effective	Value Derived From : Dim_W_RESOURCE_HD_Resource.EFFECTIVE_START_DATE
Resource	General - (Resource)	Primary Role Name	Dimension	The name of the role that is assigned as the resource's primary role.	Value Derived From : Dim_W_RESOURCE_HD_Resource.PRIMARY_ROLE_NAME
Resource	General - (Resource)	Unique Primary Role Id	Dimension	The unique Id of the role that is assigned as the resource's primary role.	Value Derived From : Dim_W_RESOURCE_HD_Resource.PRIMARY_ROLE_OBJECT_ID
Resource	General - (Resource)	Resource ID	Dimension	A short code which uniquely identifies the resource.	Value Derived From : Dim_W_RESOURCE_HD_Resource.RESOURCE_ID
Resource	General - (Resource)	Resource Name	Dimension	The name of the resource	Value Derived From : Dim_W_RESOURCE_HD_Resource.RESOURCE_NAME
Resource	General - (Resource)	Title	Dimension	The title of the resource	Value Derived From : Dim_W_RESOURCE_HD_Resource.RESOURCE_TITLE
Resource	General - (Resource)	Resource Type	Dimension	Indicates whether the resource is labor, nonlabor, or material.	Value Derived From : Dim_W_RESOURCE_HD_Resource.RESOURCE_TYPE
Resource	Location - (Resource)			Resource Location
Resource	Location - (Resource)	Address Line 1	Dimension	The first line of the address	Value Derived From : Dim_W_RESOURCE_HD_Resource.ADDRESS_LINE1
Resource	Location - (Resource)	Address Line 2	Dimension	The second line of the address	Value Derived From : Dim_W_RESOURCE_HD_Resource.ADDRESS_LINE2
Resource	Location - (Resource)	City Name	Dimension	The city name for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.CITY_NAME
Resource	Location - (Resource)	Country Code	Dimension	The country code for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.COUNTRY_CODE
Resource	Location - (Resource)	Country Name	Dimension	The country name for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.COUNTRY_NAME
Resource	Location - (Resource)	Latitude	Dimension	The latitude for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.LATITUDE
Resource	Location - (Resource)	Location Name	Dimension	The name of the location	Value Derived From : Dim_W_RESOURCE_HD_Resource.LOCATION_NAME
Resource	Location - (Resource)	Location Type	Dimension	Location Type	Value Derived From : Dim_W_RESOURCE_HD_Resource.LOCATION_TYPE
Resource	Location - (Resource)	Longitude	Dimension	The longitude for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.LONGITUDE
Resource	Location - (Resource)	Municipality Name	Dimension	The municipality name for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.MUNICIPALITY_NAME
Resource	Location - (Resource)	Postal Code	Dimension	The postal code for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.POSTAL_CODE
Resource	Location - (Resource)	State/Province Code	Dimension	The state abbreviation for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.STATE_CODE
Resource	Location - (Resource)	State/Province Name	Dimension	The state name for this Location	Value Derived From : Dim_W_RESOURCE_HD_Resource.STATE_NAME

Fact - Primavera - Resource Assignment History Folder
Fact - Primavera - Resource Assignment History	Costs			Costs
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTUAL_COST)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTUAL_OVERTIME_COST)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTUAL_REGULAR_COST)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.AT_COMPLETION_COST)
Fact - Primavera - Resource Assignment History	Costs	Period Actual Cost	Fact	Period Actual Cost	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.PERIOD_ACTUAL_COST)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.PLANNED_COST)
Fact - Primavera - Resource Assignment History	Costs	Remaining Cost	Fact	The remaining cost for the resource assignment on the activity. Calculated as Remaining Units multiplied by Cost/Time.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.REMAINING_COST)
Fact - Primavera - Resource Assignment History	Costs	Remaining Late Cost	Fact	Remaining Late Cost	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.REMAINING_LATE_COST)
Fact - Primavera - Resource Assignment History	Costs	Staffed Remaining Cost	Fact	The remaining cost for resource assignments that have a filled role.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.STAFFED_REMAINING_COST)
Fact - Primavera - Resource Assignment History	Costs	Staffed Remaining Late Cost	Fact	Staffed Remaining Late Cost	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.STAFFED_REMAINING_LATE_COST)
Fact - Primavera - Resource Assignment History	Costs	Unstaffed Remaining Cost	Fact	The remaining cost for resource assignments that do not have a filled role.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.UNSTAFFED_REMAINING_COST)
Fact - Primavera - Resource Assignment History	Costs	Unstaffed Remaining Late Cost	Fact	Unstaffed Remaining Late Cost	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.UNSTAFFED_REMAINING_LATE_COST)
Fact - Primavera - Resource Assignment History	Metrics			Metrics
Fact - Primavera - Resource Assignment History	Metrics	# Of Activities	Fact	# Of Activities	count(distinct Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTIVITY_WID)
Fact - Primavera - Resource Assignment History	Metrics	# Of Projects	Fact	# Of Projects	count(distinct Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.PROJECT_WID)
Fact - Primavera - Resource Assignment History	Metrics	# Of Resources	Fact	# Of Resources	count(distinct Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.RESOURCE_WID)
Fact - Primavera - Resource Assignment History	Units			Units
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTUAL_OVERTIME_UNITS)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTUAL_REGULAR_UNITS)
Fact - Primavera - Resource Assignment History	Units	Actual Units	Fact	The sum of the actual non-overtime and the overtime units worked by the resource on the activity.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.ACTUAL_UNITS)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.AT_COMPLETION_UNITS)
Fact - Primavera - Resource Assignment History	Units	Period Actual Units	Fact	Period Actual Units	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.PERIOD_ACTUAL_UNITS)
Fact - Primavera - Resource Assignment History	Units	Planned Units	Fact	The planned units of work for the resource assignment on the activity.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.PLANNED_UNITS)
Fact - Primavera - Resource Assignment History	Units	Remaining Late Units	Fact	Remaining Late Units	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.REMAINING_LATE_UNITS)
Fact - Primavera - Resource Assignment 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.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.REMAINING_UNITS)
Fact - Primavera - Resource Assignment History	Units	Staffed Remaining Late Units	Fact	Staffed Remaining Late Units	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.STAFFED_REMAINING_LATE_UNITS)
Fact - Primavera - Resource Assignment History	Units	Staffed Remaining Units	Fact	The remaining units for resource assignments that have filled a role.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.STAFFED_REMAINING_UNITS)
Fact - Primavera - Resource Assignment History	Units	Unstaffed Remaining Late Units	Fact	Unstaffed Remaining Late Units	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.UNSTAFFED_REMAINING_LATE_UNITS)
Fact - Primavera - Resource Assignment History	Units	Unstaffed Remaining Units	Fact	The remaining units for resource assignments that have not filled a role.	sum(Fact_W_ASSIGNMENT_SPREAD_HF_Assignment_Spread.UNSTAFFED_REMAINING_UNITS)

Resource Assignment Folder
Resource Assignment	Dates - (Resource Assignment)
Resource Assignment	Dates - (Resource Assignment)	Actual Finish	Dimension	The date on which the assignment actually finished	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.ACTUAL_FINISH_DATE
Resource Assignment	Dates - (Resource Assignment)	Actual Start	Dimension	The date on which the assignment actually started	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.ACTUAL_START_DATE
Resource Assignment	Dates - (Resource Assignment)	Effective End Date	Dimension	The end date this version of the record is effective	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.EFFECTIVE_END_DATE
Resource Assignment	Dates - (Resource Assignment)	Effective Start Date	Dimension	The start date this version of the record is effective	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.EFFECTIVE_START_DATE
Resource Assignment	Dates - (Resource Assignment)	Planned Finish	Dimension	The date the assignment is scheduled to be finished.	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.PLANNED_FINISH_DATE
Resource Assignment	Dates - (Resource Assignment)	Planned Start	Dimension	The date work on the assignment is scheduled to begin.	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.PLANNED_START_DATE
Resource Assignment	Dates - (Resource Assignment)	Remaining Finish	Dimension	The date the assignment is scheduled to be finished. This date can be updated manually by the user. Before the activity is started, this date is the same as the Planned Finish date.	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.REMAINING_FINISH_DATE
Resource Assignment	Dates - (Resource Assignment)	Remaining Start	Dimension	The date the assignment is scheduled to begin. This date can be updated manually by the user. Before the activity is started, this date is the same as the Planned Start date.	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.REMAINING_START_DATE
Resource Assignment	General - (Resource Assignment)			General Resource Assignment Information
Resource Assignment	General - (Resource Assignment)	Current Flag	Dimension	Indicates if a record is current (1,0)	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.CURRENT_FLAG
Resource Assignment	General - (Resource Assignment)	Role Name	Dimension	The name of the resource for this assignment	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.ROLE_NAME
Resource Assignment	General - (Resource Assignment)	Resource Name	Dimension	The name of the role for this assignment	Value Derived From : Dim_W_ASSIGNMENT_HD_Assignment.RESOURCE_NAME

Related Topics