Professional Services Automation Data Dictionary

pse__Utilization_Detail__c

Label: Utilization Detail

Contains utilization details for a single region, practice, group, or resource. PSA calculates utilization as a percentage: the number of hours resources have billed, divided into the number of billable hours in a given time period. If configured, utilization also calculates the number of hours resources are assigned in the future (held against resource requests), or aggregates requested and assigned hours by role. Utilization calculations have a master-detail relationship with utilization details. Run utilization reports on the information stored in this object to understand how utilized your resources are in comparison with their work calendar hours.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
pse__Group__c Group Pre-Spring 2018 Looks up to: pse__Grp__c
 Lookup false
pse__Hist_Sch_Billable_Hours__c Historical Scheduled Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Hist_Sch_Credited_Hours__c Historical Scheduled Credited Hours Pre-Spring 2018 Number(18,2) false
pse__Hist_Sch_Excluded_Hours__c Historical Scheduled Excluded Hours Pre-Spring 2018 Number(18,2) false
pse__Hist_Sch_Held_Hours__c Historical Scheduled Held Hours Pre-Spring 2018 Number(18,2) false
pse__Hist_Sch_Non_Billable_Hours__c Historical Scheduled Non-Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Historical_Billable_Hours__c Historical Billable Hours Pre-Spring 2018 Number(18,2) true 0
pse__Historical_Calendar_Hours__c Historical Calendar Hours Pre-Spring 2018 Number(18,2) true 0
pse__Historical_Credited_Hours__c Historical Credited Hours Pre-Spring 2018 Number(18,2) true 0
pse__Historical_End_Date__c Historical End Date Pre-Spring 2018 Date false
pse__Historical_Excluded_Hours__c Historical Excluded Hours Pre-Spring 2018 Number(18,2) true 0
pse__Historical_Non_Billable_Hours__c Historical Non-Billable Hours Pre-Spring 2018 Number(18,2) false
pse__Historical_Start_Date__c Historical Start Date Pre-Spring 2018 Date false
pse__Historical_Utilization_Billable_Only__c Historical Utilization (Billable Only) Pre-Spring 2018 Formula:
IF ( AND( (pse__Historical_Calendar_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Historical_Billable_Hours__c > 0) ), 1, IF ( AND( (pse__Historical_Calendar_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Historical_Billable_Hours__c= 0) ), 0, ((pse__Historical_Billable_Hours__c) / (pse__Historical_Calendar_Hours__c - pse__Historical_Excluded_Hours__c)) ) )
 Percent(18,2) false
pse__Historical_Utilization_Target_Attainment__c Historical Utilization Target Attainment Pre-Spring 2018 Formula:
IF(pse__Historical_Utilization_Target__c = 0, IF(pse__Historical_Utilization__c <= 0,0,1), pse__Historical_Utilization__c / pse__Historical_Utilization_Target__c )
 Percent(18,2) false
pse__Historical_Utilization_Target_Hours__c Historical Utilization Target Hours Pre-Spring 2018 Number(18,2) false 0
pse__Historical_Utilization_Target__c Historical Utilization Target Pre-Spring 2018 Formula:
IF(pse__Historical_Calendar_Hours__c = 0, 0, pse__Historical_Utilization_Target_Hours__c / pse__Historical_Calendar_Hours__c )
Percent(18,2) false
pse__Historical_Utilization__c Historical Utilization Pre-Spring 2018 Formula:
IF ( AND( (pse__Historical_Calendar_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Historical_Billable_Hours__c + pse__Historical_Credited_Hours__c > 0) ), 1, IF ( AND( (pse__Historical_Calendar_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Historical_Billable_Hours__c + pse__Historical_Credited_Hours__c = 0) ), 0, ((pse__Historical_Billable_Hours__c + pse__Historical_Credited_Hours__c) / (pse__Historical_Calendar_Hours__c - pse__Historical_Excluded_Hours__c)) ) )
 Percent(18,2) false
pse__Is_Report_Master__c Is Report Master Pre-Spring 2018 Formula:
IF (pse__Utilization_Calculation__r.pse__Is_Report_Master__c, 'true', 'false')
 Text 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__Resource__c Resource Pre-Spring 2018 Looks up to: Contact

 Lookup false
pse__Scheduled_Billable_Hours__c Scheduled Billable Hours Pre-Spring 2018 Number(18,2) true 0
pse__Scheduled_Calendar_Hours__c Scheduled Calendar Hours Pre-Spring 2018 Number(18,2) true 0
pse__Scheduled_Credited_Hours__c Scheduled Credited Hours Pre-Spring 2018 Number(18,2) true 0
pse__Scheduled_End_Date__c Scheduled End Date Pre-Spring 2018 Date false
pse__Scheduled_Excluded_Hours__c Scheduled Excluded Hours Pre-Spring 2018 Number(18,2) true 0
pse__Scheduled_Held_Hours__c Scheduled Held Hours Pre-Spring 2018 Number(18,2) false
pse__Scheduled_Non_Billable_Hours__c Scheduled Non-Billable Hours Pre-Spring 2018 Non-billable hours from assignments that are not credited or excluded

 Number(18,2) true 0
pse__Scheduled_Start_Date__c Scheduled Start Date Pre-Spring 2018 Date false
pse__Scheduled_Utilization_Billable_Only__c Scheduled Utilization (Billable Only) Pre-Spring 2018 Formula:
IF ( AND( (pse__Scheduled_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c > 0) ), 1, IF ( AND( (pse__Scheduled_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c= 0) ), 0, ((pse__Scheduled_Billable_Hours__c) / (pse__Scheduled_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c)) ) )
 Percent(18,2) false
pse__Scheduled_Utilization_Target_Attainment__c Scheduled Utilization Target Attainment Pre-Spring 2018 Formula:
IF(pse__Scheduled_Utilization_Target__c = 0, IF(pse__Scheduled_Utilization__c <= 0,0,1), pse__Scheduled_Utilization__c / pse__Scheduled_Utilization_Target__c )
 Percent(18,2) false
pse__Scheduled_Utilization_Target_Hours__c Scheduled Utilization Target Hours Pre-Spring 2018 Number(18,2) false 0
pse__Scheduled_Utilization_Target__c Scheduled Utilization Target Pre-Spring 2018 Formula:
IF(pse__Scheduled_Calendar_Hours__c = 0, 0, pse__Scheduled_Utilization_Target_Hours__c / pse__Scheduled_Calendar_Hours__c )
Percent(18,2) false
pse__Scheduled_Utilization__c Scheduled Utilization Pre-Spring 2018 Formula:
IF ( AND( (pse__Scheduled_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c + pse__Scheduled_Credited_Hours__c > 0) ), 1, IF ( AND( (pse__Scheduled_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c + pse__Scheduled_Credited_Hours__c = 0) ), 0, ((pse__Scheduled_Billable_Hours__c + pse__Scheduled_Credited_Hours__c) / (pse__Scheduled_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c)) ) )
 Percent(18,2) false
pse__Template_Key__c Template Key Pre-Spring 2018 PSE internal field. Not intended for display.

 Number(8,0) false
pse__Time_Period_Type__c Time Period Type Pre-Spring 2018 Picklist:
Month
Quarter
Week
Year		 false
pse__Time_Period__c Time Period Pre-Spring 2018 Looks up to: pse__Time_Period__c
 Lookup false
pse__Total_Utilization_Billable_Only__c Total Utilization (Billable Only) Pre-Spring 2018 Formula:
IF ( AND( (pse__Scheduled_Calendar_Hours__c + pse__Historical_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c + pse__Historical_Billable_Hours__c > 0) ), 1, IF ( AND( (pse__Scheduled_Calendar_Hours__c + pse__Historical_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c + pse__Historical_Billable_Hours__c = 0) ), 0, ((pse__Scheduled_Billable_Hours__c + pse__Historical_Billable_Hours__c) / (pse__Scheduled_Calendar_Hours__c + pse__Historical_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c - pse__Historical_Excluded_Hours__c)) ) )
 Percent(18,2) false
pse__Total_Utilization__c Total Utilization Pre-Spring 2018 Formula:
IF ( AND( (pse__Scheduled_Calendar_Hours__c + pse__Historical_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c + pse__Historical_Billable_Hours__c + pse__Scheduled_Credited_Hours__c + pse__Historical_Credited_Hours__c > 0) ), 1, IF ( AND( (pse__Scheduled_Calendar_Hours__c + pse__Historical_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c - pse__Historical_Excluded_Hours__c) = 0, (pse__Scheduled_Billable_Hours__c + pse__Historical_Billable_Hours__c + pse__Scheduled_Credited_Hours__c + pse__Historical_Credited_Hours__c = 0) ), 0, ((pse__Scheduled_Billable_Hours__c + pse__Historical_Billable_Hours__c + pse__Scheduled_Credited_Hours__c + pse__Historical_Credited_Hours__c) / (pse__Scheduled_Calendar_Hours__c + pse__Historical_Calendar_Hours__c - pse__Scheduled_Excluded_Hours__c - pse__Historical_Excluded_Hours__c)) ) )
 Percent(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
Resource		 false
pse__Utilization_Calculation__c Utilization Calculation Pre-Spring 2018 Looks up to: pse__Utilization_Calculation__c
 MasterDetail
pse__Utilization_Target_Attainment__c Utilization Target Attainment Pre-Spring 2018 Formula:
IF(pse__Utilization_Target__c = 0, IF(pse__Total_Utilization__c <= 0,0,1), pse__Total_Utilization__c / pse__Utilization_Target__c )
 Percent(18,2) false
pse__Utilization_Target_Hours__c Utilization Target Hours Pre-Spring 2018 Number(18,2) true 0
pse__Utilization_Target__c Utilization Target Pre-Spring 2018 Formula:
IF(pse__Historical_Calendar_Hours__c + pse__Scheduled_Calendar_Hours__c = 0, 0, pse__Utilization_Target_Hours__c / ( pse__Historical_Calendar_Hours__c + pse__Scheduled_Calendar_Hours__c) )
Percent(18,2) false


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