Professional Services Automation Data Dictionary

pse__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 VersionDescriptionTypeRequiredDefault Value
pse__Actual_Billable_Hours__c Actual Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Actual_Credited_Hours__c Actual Credited Hours Pre-Spring 2018 Number(18,2) false
pse__Actual_Excluded_Hours__c Actual Excluded Hours Pre-Spring 2018 Number(18,2) false
pse__Actual_Non_Billable_Hours__c Actual Non-Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Assigned_Billable_Hours__c Assigned Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Assigned_Credited_Hours__c Assigned Credited Hours Pre-Spring 2018 Number(18,2) false
pse__Assigned_Excluded_Hours__c Assigned Excluded Hours Pre-Spring 2018 Number(18,2) false
pse__Assigned_Non_Billable_Hours__c Assigned Non-Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Calendar_Hours__c Calendar Hours Pre-Spring 2018 Number(18,2) false
pse__Group__c Group Pre-Spring 2018 Looks up to: pse__Grp__c
Lookup false
pse__Held_Hours_Opp_Pct_Weighted__c Held Hours Opp Pct Weighted Pre-Spring 2018 Number(18,2) false
pse__Held_Hours__c Held Hours Pre-Spring 2018 Number(18,2) false
pse__Practice__c Practice Pre-Spring 2018 Looks up to: pse__Practice__c
Lookup false
pse__Region__c Region Pre-Spring 2018 Looks up to: pse__Region__c
Lookup false
pse__Remaining_Capacity__c Remaining Capacity Pre-Spring 2018 Formula:
IF(pse__Calendar_Hours__c=0, 0, (pse__Calendar_Hours__c - pse__Assigned_Billable_Hours__c - pse__Assigned_Excluded_Hours__c - pse__Assigned_Credited_Hours__c - pse__Assigned_Non_Billable_Hours__c - pse__Held_Hours__c - pse__Unheld_Hours__c) / pse__Calendar_Hours__c )
Percent(18,2) false
pse__Resource_Role__c Resource Role Pre-Spring 2018 Picklist:
Architect
Business Analyst
Client Manager
Consultant
Contractor
Executive
Project Manager
Senior Consultant
Trainer
false
pse__Target_Hours__c Target Hours Pre-Spring 2018 Number(18,2) false
pse__Template_Key__c Template Key Pre-Spring 2018 Number(8,0) false
pse__Time_Period__c Time Period Pre-Spring 2018 Looks up to: pse__Time_Period__c
Lookup false
pse__Total_Hours_Opp_Pct_Weighted__c Total Hours Opp Pct Weighted Pre-Spring 2018 Formula:
pse__Assigned_Billable_Hours__c + pse__Assigned_Excluded_Hours__c + pse__Assigned_Credited_Hours__c + pse__Assigned_Non_Billable_Hours__c + pse__Held_Hours_Opp_Pct_Weighted__c + pse__Unheld_Hours_Opp_Pct_Weighted__c
Number(18,2) false
pse__Total_Hours__c Total Hours Pre-Spring 2018 Formula:
pse__Assigned_Billable_Hours__c + pse__Assigned_Excluded_Hours__c + pse__Assigned_Credited_Hours__c + pse__Assigned_Non_Billable_Hours__c + pse__Held_Hours__c + pse__Unheld_Hours__c
Number(18,2) false
pse__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
false
pse__Unheld_Hours_Opp_Pct_Weighted__c Unheld Hours Opp Pct Weighted Pre-Spring 2018 Number(18,2) false
pse__Unheld_Hours__c Unheld Hours Pre-Spring 2018 Number(18,2) false
pse__Utilization_Calculation__c Utilization Calculation Pre-Spring 2018 Looks up to: pse__Utilization_Calculation__c
MasterDetail


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