P6 - Resource Assignment History / Primavera - Resource Assignment History
Enter topic description here.
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 |