Professional Services Automation Data Dictionary

Utilization_Summary__c

Label: Utilization Summary

If Calculate Summary By Role, in the Utilization custom setting, is set to True, PSA creates Utilization Summary records when calculating scheduled utilization. In contrast to Utilization Detail, this object summarizes utilization by role rather than resource; it can therefore summarize hours from unheld resource requests (these are never linked to a resource). Therefore, utilization summaries give a fuller picture of capacity because these hours are summarized alongside those from held resource requests, assignments, and calendars. You can use this information to plan for future capacity by role. Optionally, total unheld hours can be weighted by the percentage probability of closing an opportunity linked to the resource request. Utilization calculations have a master-detail relationship with utilization summaries.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Actual_Billable_Hours__c Actual Billable Hours Pre-Spring 2018 Number(18,2)
Actual_Credited_Hours__c Actual Credited Hours Pre-Spring 2018 Number(18,2)
Actual_Excluded_Hours__c Actual Excluded Hours Pre-Spring 2018 Number(18,2)
Actual_Non_Billable_Hours__c Actual Non-Billable Hours Pre-Spring 2018 Number(18,2)
Assigned_Billable_Hours__c Assigned Billable Hours Pre-Spring 2018 Number(18,2)
Assigned_Credited_Hours__c Assigned Credited Hours Pre-Spring 2018 Number(18,2)
Assigned_Excluded_Hours__c Assigned Excluded Hours Pre-Spring 2018 Number(18,2)
Assigned_Non_Billable_Hours__c Assigned Non-Billable Hours Pre-Spring 2018 Number(18,2)
Calendar_Hours__c Calendar Hours Pre-Spring 2018 Number(18,2)
Group__c Group Pre-Spring 2018 Looks up to: Grp__c
Lookup
Held_Hours_Opp_Pct_Weighted__c Held Hours Opp Pct Weighted Pre-Spring 2018 Number(18,2)
Held_Hours__c Held Hours Pre-Spring 2018 Number(18,2)
Practice__c Practice Pre-Spring 2018 Looks up to: Practice__c
Lookup
Region__c Region Pre-Spring 2018 Looks up to: Region__c
Lookup
Remaining_Capacity__c Remaining Capacity Pre-Spring 2018 Formula:
IF(Calendar_Hours__c=0, 0, (Calendar_Hours__c - Assigned_Billable_Hours__c - Assigned_Excluded_Hours__c - Assigned_Credited_Hours__c - Assigned_Non_Billable_Hours__c - Held_Hours__c - Unheld_Hours__c) / Calendar_Hours__c )
Percent(18,2)
Resource_Role__c Resource Role Pre-Spring 2018 Picklist:
Architect
Business Analyst
Client Manager
Consultant
Contractor
Executive
Project Manager
Senior Consultant
Trainer
Target_Hours__c Target Hours Pre-Spring 2018 Number(18,2)
Template_Key__c Template Key Pre-Spring 2018 Number(8,0)
Time_Period__c Time Period Pre-Spring 2018 Looks up to: Time_Period__c
Lookup
Total_Hours_Opp_Pct_Weighted__c Total Hours Opp Pct Weighted Pre-Spring 2018 Formula:
Assigned_Billable_Hours__c + Assigned_Excluded_Hours__c + Assigned_Credited_Hours__c + Assigned_Non_Billable_Hours__c + Held_Hours_Opp_Pct_Weighted__c + Unheld_Hours_Opp_Pct_Weighted__c
Number(18,2)
Total_Hours__c Total Hours Pre-Spring 2018 Formula:
Assigned_Billable_Hours__c + Assigned_Excluded_Hours__c + Assigned_Credited_Hours__c + Assigned_Non_Billable_Hours__c + Held_Hours__c + Unheld_Hours__c
Number(18,2)
Type__c Type Pre-Spring 2018 Picklist:
Group
Group by Practice
Group by Region
Practice
Practice by Group
Practice by Region
Region
Region by Group
Region by Practice
Unheld_Hours_Opp_Pct_Weighted__c Unheld Hours Opp Pct Weighted Pre-Spring 2018 Number(18,2)
Unheld_Hours__c Unheld Hours Pre-Spring 2018 Number(18,2)
Utilization_Calculation__c Utilization Calculation Pre-Spring 2018 Looks up to: Utilization_Calculation__c
MasterDetail


© Copyright 2009–2023 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.