Utilization Results Dataset PS Cloud Analytics Output Fields

The Utilization Analytics (Embedded) dataset stores fields associated with the Utilization Results object in PSA and its related records as well as other associated objects. The fields are:

Utilization Analytics (Embedded) Fields

Field Type

Field Label

Field API Name

Description

Measures Billable Assignment Hours ValueBillableAssignmentHours This is the value of the Billable Assignment Hours field on the Utilization Result object.
Billable Timecard Hours ValueBillableTimecardHours This is the value of the Billable Timecard Hours field on the Utilization Result object.
Calendar Hours ValueCalendarHours This is the value of the Calendar Hours field on the Utilization Result object.
Credited Assignment Hours ValueCreditedAssignmentHours This is the value of the Credited Assignment Hours field on the Utilization Result object.
Credited Timecard Hours ValueCreditedTimecardHours This is the value of the Credited Timecard Hours field on the Utilization Result object.
Held Resource Request Hours ValueHeldResourceRequestHours This is the value of the Held Resource Request Hours field on the Utilization Result object.

Hours at Threshold Value 1

pse__Hours_At_Threshold_Value_1__c

The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 1.

Hours at Threshold Value 2

pse__Hours_At_Threshold_Value_2__c

The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 2.

Hours at Threshold Value 3

pse__Hours_At_Threshold_Value_3__c

The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 3.

Hours at Threshold Value 4

pse__Hours_At_Threshold_Value_4__c

The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 4.

Hours at Threshold Value 5

pse__Hours_At_Threshold_Value_5__c

The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 5.

Hours at Threshold Value 6

pse__Hours_At_Threshold_Value_6__c

The sum of hours calculated from the unheld resource requests of the role that is associated with this utilization result at threshold value 6.

Non-Billable Assignment Hours ValueNonBillableAssignmentHours This is the value of the Non-Billable Assignment Hours field on the Utilization Result object.
Non-Billable Timecard Hours ValueNonBillableTimecardHours This is the value of the Non-Billable Timecard Hours field on the Utilization Result object.
Resource Change New Utilization Target (%) ValueResourceChangeNewUtilizationTarget The value of the new utilization target assigned to the resource associated with this resource change.
Resource Change Old Utilization Target (%) ValueResourceChangeOldUtilizationTarget The value of the old utilization target assigned to the resource associated with this resource change.
Standard Work Calendar Hours ValueStandardWorkCalendarHours This is the value of the Standard Work Calendar Hours for the Utilization Result object's region.
Time Excluded Assignment Hours ValueTimeExcludedAssignmentHours This is the value of the Time Excluded Assignment Hours field on the Utilization Result object.
Time Excluded Timecard Hours ValueTimeExcludedTimecardHours This is the value of the Time Excluded Timecard Hours field on the Utilization Result object.
Unheld Resource Request Hours ValueUnheldResourceRequestHours This is the value of the Unheld Resource Request Hours field on the Utilization Result object.
Unheld Resource Request Weighted Hours pse__Unheld_Resource_Request_Weighted_Hours__c The sum of weighted hours calculated from the unheld resource requests of the role that is associated with this utilization result.
Utilization Excluded Assignment Hours ValueUtilizationExcludedAssignmentHours This is the value of the Utilization Excluded Assignment Hours field on the Utilization Result object.
Utilization Excluded Held RR Hours ValueUtilizationExcludedHeldRRHours This is the value of the Utilization Excluded Held RR Hours field on the Utilization Result object.
Utilization Excluded Timecard Hours ValueUtilizationExcludedTimecardHours This is the value of the Utilization Excluded Timecard Hours field on the Utilization Result object.
Utilization Excluded Unheld RR Hours ValueUtilizationExcludedUnheldRRHours This is the value of the Utilization Excluded Unheld RR Hours field on the Utilization Result object.
Utilization Target Hours ValueUtilizationTargetHours This is the value of the Utilization Target Hours field on the Utilization Result object.
Utilization Target (%) ValueUtilizationTargetPercent This is the value of the Utilization Target field on the Utilization Result object.

Weighted Hours at Threshold Value 1

pse__Weighted_Hours_At_Threshold_Value_1__c

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.

Weighted Hours at Threshold Value 2

pse__Weighted_Hours_At_Threshold_Value_2__c

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.

Weighted Hours at Threshold Value 3

pse__Weighted_Hours_At_Threshold_Value_3__c

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.

Weighted Hours at Threshold Value 4

pse__Weighted_Hours_At_Threshold_Value_4__c

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.

Weighted Hours at Threshold Value 5

pse__Weighted_Hours_At_Threshold_Value_5__c

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.

Weighted Hours at Threshold Value 6

pse__Weighted_Hours_At_Threshold_Value_6__c

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.

Date Date Date The calendar date associated with this utilization result.
Resource Change Date ResourceChangeChangeDate The date there was a change made to the Resource Change's associated resource object.
Time Period Month TimePeriodMonth The time period defined as type month. This is derived from the Time Period object.
Time Period Quarter TimePeriodQuarter The time period defined as type quarter. This is derived from the Time Period object.
Time Period Week TimePeriodWeek The time period defined as type week. This is derived from the Time Period object.
Time Period Week End Date TimePeriodWeekEndDate The end date of time period defined as type week. This is derived from the Time Period object.
Time Period Week Start Date TimePeriodWeekStartDate The start date of the time period defined as type week. This is derived from the Time Period object.
Time Period Year TimePeriodYear The time period defined as type year. This is derived from the Time Period object.
Dimensions Group ID GroupId The group that is associated with this utilization result on the specified date. See Resource fields in the PSA Help.
Group Level XX GroupNameXX The RPG level of the group associated with this utilization result, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the group associated with this utilization result.

Last Updated Run

pse__Last_Updated_Run__c

Lookup to the utilization run this utilization result relates to.

Practice ID PracticeId The practice that is associated with this utilization result on the specified date. See Resource fields in the PSA Help.
Practice Level XX PracticeNameXX The RPG level of the practice associated with this utilization result, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the practice associated with this utilization result.
Region ID RegionId The region that is associated with this utilization result on the specified date. See Resource fields in the PSA Help.
Region Level XX RegionNameXX

The RPG level of the region associated with this utilization result, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the region associated with this utilization result.

Resource Change New Group ResourceChange.NewGroup.Name

The name of the new group assigned to the resource associated with this resource change.

Resource Change New Is Resource ResourceChange.pse__New_Is_Resource__c

The new boolean value of the resource associated with this resource change being assigned as a resource.

Resource Change New Is Resource Active ResourceChange.pse__New_Is_Resource_Active__c

The new boolean value of the resource associated with this resource change being assigned as being currently active.

Resource Change New Practice ResourceChange.NewPractice.Name

The name of the new practice assigned to the resource associated with this resource change.

Resource Change New Region ResourceChange.NewRegion.Name

The name of the new region assigned to the resource associated with this resource change.

Resource Change New Resource RoleResourceChange.pse__New_Resource_Role__c

The name of the new role assigned to the resource associated with this resource change.

Resource Change New Work Calendar ResourceChange.NewWorkCalendar.Name

The name of the new work calendar assigned to the resource associated with this resource change.

Resource Change Old Group ResourceChange.OldGroup.Name

The name of the old group assigned to the resource associated with this resource change.

Resource Change Old Is Resource ResourceChange.pse__Old_Is_Resource__c

The old boolean value of the resource associated with this resource change being assigned as a resource

Resource Change Old Is Resource Active ResourceChange.pse__Old_Is_Resource_Active__c

The old boolean value of the resource associated with this resource change being assigned as being currently active.

Resource Change Old Practice ResourceChange.OldPractice.Name

The name of the old practice assigned to the resource associated with this resource change.

Resource Change Old Region ResourceChange.OldRegion.Name

The name of the old region assigned to the resource associated with this resource change.

Resource Change Old Resource Role ResourceChange.pse__Old_Resource_Role__c

The name of the old role assigned to the resource associated with this resource change.

Resource Change Old Work Calendar ResourceChangeResourceChange.OldWorkCalendar.Name

The name of the old work calendar assigned to the resource associated with this resource change.

Resource External ResourceExternal Indicates whether this is a PSA external resource. See Resource fields in the PSA Help.
Resource ID ResourceId The ID of the contact record associated with this utilization result.
Resource Name ResourceName The name related to the contact. See Resource fields in the PSA Help.
Resource Role ResourceRole This is the value of the Resource Role field on the Utilization Result object.
Resource Salesforce User Resource.pse__Salesforce_User__c This is added when the Utilization Results Security Mode field on the PS Cloud AnalyticsSetup record is set to “Individual” or “Hierarchy”.
Resource Skills / Certifications Resource.Skill.SkillName The skills or certifications associated with the resource.
Note: Duplicate hours might be displayed for skill or certification records if you use this field in a lens. For example, if you group using this field in a lens, in conjunction with Resource Name, and Resource Skills groupings, then hours displayed under your Sum of Calendar Hours column are duplicated for each skill or certification row.
Salesforce Resource User Photo URL ResourceSalesforceUserPhotoUrl The URL of the Salesforce User contact photo.