Professional Services Automation Data Dictionary

Utilization_Result__c

Label: Utilization Result

Stores the utilization calculation records created for a resource.

Field NameField LabelCreated in VersionDescriptionTypeDefault Value
Billable_Assignment_Hours__c Billable Assignment Hours Fall 2021 The sum of billable hours calculated from the assignments of the resource that is associated with this utilization calculation result.

Number(18,2)
Billable_Timecard_Hours__c Billable Timecard Hours Fall 2021 The sum of billable hours calculated from the timecards of the resource that is associated with this utilization calculation result.

Number(18,2)
Calendar_Hours__c Calendar Hours Fall 2021 The number of hours from the resource's work calendar on the date of this utilization result.

Number(18,2)
Credited_Assignment_Hours__c Credited Assignment Hours Fall 2021 The sum of time credited hours calculated from the assignments of the resource that is associated with this utilization calculation result.

Number(18,2)
Credited_Timecard_Hours__c Credited Timecard Hours Fall 2021 The sum of time credited hours calculated from the timecards of the resource that is associated with this utilization calculation result.

Number(18,2)
Date__c Date Fall 2021 The calendar date that is associated with this utilization result.

Date
Group__c Group Fall 2021 The group that is associated with this utilization result on the specified date.

Looks up to: Grp__c
Lookup
Held_Resource_Request_Hours__c Held Resource Request Hours Fall 2021 The sum of hours calculated from the held resource requests of the resource that is associated with this utilization calculation result.

Number(18,2)
Hours_At_Threshold_Value_1__c Hours at Threshold Value 1 Summer 2023 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 1.

Number(18,2)
Hours_At_Threshold_Value_2__c Hours at Threshold Value 2 Summer 2023 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 2.

Number(18,2)
Hours_At_Threshold_Value_3__c Hours at Threshold Value 3 Summer 2023 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 3.

Number(18,2)
Hours_At_Threshold_Value_4__c Hours at Threshold Value 4 Summer 2023 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 4.

Number(18,2)
Hours_At_Threshold_Value_5__c Hours at Threshold Value 5 Summer 2023 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 5.

Number(18,2)
Hours_At_Threshold_Value_6__c Hours at Threshold Value 6 Summer 2023 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 6.

Number(18,2)
Last_Updated_Run__c Utilization Run Fall 2021 Lookup to the utilization run this utilization result relates to.

Looks up to: Utilization_Run__c
Lookup
Non_Billable_Assignment_Hours__c Non-Billable Assignment Hours Fall 2021 The sum of non-billable hours calculated from the assignments of the resource that is associated with this utilization calculation result.

Number(18,2)
Non_Billable_Timecard_Hours__c Non-Billable Timecard Hours Fall 2021 The sum of non-billable hours calculated from the timecards of the resource that is associated with this utilization calculation result.

Number(18,2)
Practice__c Practice Fall 2021 The practice that is associated with this utilization result on the specified date.

Looks up to: Practice__c
Lookup
Region__c Region Fall 2021 The region that is associated with this utilization result on the specified date.

Looks up to: Region__c
Lookup
Resource_Change__c Resource Change Summer 2023 The ID of the resource change associated with this utilization calculation result.

Looks up to: Resource_Change__c
Lookup
Resource_Role__c Resource Role Fall 2021 The role of the resource that is associated with this utilization calculation result.

Text(255)
Resource__c Resource Fall 2021 The name of the resource associated with this utilization calculation result.

Looks up to: Contact

Lookup
Time_Excluded_Assignment_Hours__c Time Excluded Assignment Hours Fall 2021 The sum of time excluded hours calculated from the assignments of the resource that is associated with this utilization calculation result.

Number(18,2)
Time_Excluded_Timecard_Hours__c Time Excluded Timecard Hours Fall 2021 The sum of time excluded hours calculated from the timecards of the resource that is associated with this utilization calculation result.

Number(18,2)
Unheld_Resource_Request_Hours__c Unheld Resource Request Hours Spring 2021 The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization calculation result.

Number(18,2)
Unheld_Resource_Request_Weighted_Hours__c Unheld Resource Request Weighted Hours Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result.

Number(18,2)
Unique_Identifier__c Unique Identifier Spring 2021 The unique identifier for this utilization result record in the format Date, Resource, Resource Role, Region, Practice and Group.

Text(255)
Utilization_Excluded_Assignment_Hours__c Utilization Excluded Assignment Hours Fall 2021 The sum of utilization excluded hours calculated from the assignments of the resource that is associated with this utilization calculation result.

Number(18,2)
Utilization_Excluded_Held_RR_Hours__c Utilization Excluded Held RR Hours Fall 2021 The sum of hours excluded from utilization calculated from the held resource requests of the resource that is associated with this utilization calculation result.

Number(18,2)
Utilization_Excluded_Timecard_Hours__c Utilization Excluded Timecard Hours Fall 2021 The sum of utilization excluded hours calculated from the timecards of the resource that is associated with this utilization calculation result.

Number(18,2)
Utilization_Excluded_Unheld_RR_Hours__c Utilization Excluded Unheld RR Hours Spring 2021 The sum of hours excluded from utilization calculated from the unheld resource requests of the role that is associated with this utilization calculation result.

Number(18,2)
Utilization_Target_Hours__c Utilization Target Hours Summer 2023 Target hours for the resource associated with this utilization result on the specified date.

Number(18,2)
Utilization_Target__c Utilization Target Summer 2023 Target percentage for the resource associated with this utilization result on the specified date.

Percent(5,2)
Weighted_Hours_At_Threshold_Value_1__c Weighted Hours at Threshold Value 1 Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 1.

Number(18,2)
Weighted_Hours_At_Threshold_Value_2__c Weighted Hours at Threshold Value 2 Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 2.

Number(18,2)
Weighted_Hours_At_Threshold_Value_3__c Weighted Hours at Threshold Value 3 Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 3.

Number(18,2)
Weighted_Hours_At_Threshold_Value_4__c Weighted Hours at Threshold Value 4 Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 4.

Number(18,2)
Weighted_Hours_At_Threshold_Value_5__c Weighted Hours at Threshold Value 5 Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 5.

Number(18,2)
Weighted_Hours_At_Threshold_Value_6__c Weighted Hours at Threshold Value 6 Summer 2023 The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 6.

Number(18,2)


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