Utilization Dataset PS Cloud Analytics Output Fields

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

Key: H - Hidden field

Utilization Fields

Field Type	Field		Description
Measures	Actual Hours		A calculated field. This field is calculated by the sum of the Utilization Detail object Historical Billable Hours plus Historical Credited Hours plus Historical Excluded Hours plus Historical Non-Billable Hours.
	Billable Hours		A calculated field. This field is calculated by the sum of the Utilization Detail object Historical Billable Hours plus Historical Scheduled Billable Hours plus Scheduled Billable Hours.
	Credited Hours		A calculated field. This field is calculated by the sum of the Utilization Detail object Historical Credited Hours plus Scheduled Credited Hours.
	Calendar Hours		A calculated field. This field is calculated by the sum of the Utilization Detail object Historical Calendar Hours plus Scheduled Calendar Hours.
	Excluded Hours		A calculated field. This field is calculated by the sum of the Utilization Detail object Historical Excluded Hours plus Scheduled Excluded Hours.
	Target Hours		This is the value of the Utilization Detail object Utilization Target Hours.
	Scheduled Hours		A calculated field. This field is calculated by the sum of the Utilization Detail object Scheduled Billable Hours plus Scheduled Credited Hours plus Scheduled Excluded Hours plus Scheduled Held Hours plus Scheduled Non-Billable Hours.
Date	Scheduled Utilization Start Date		The scheduled utilization start date. See Utilization Detail object in the PSA Help.
	Scheduled Utilization End Date		The scheduled utilization end date. See Utilization Detail object in the PSA Help.
	Historical Utilization Start Date		The historical utilization start date. See Utilization Detail object in the PSA Help.
	Historical Utilization End Date		The historical utilization end date. See Utilization Detail object in the PSA Help.
	Time Period Start Date		The start date of the associated time period.
	Time Period End Date		The end date of the associated time period.
	Resource Start Date		The start date of the associated resource.
	Resource Last Date		The last date of the associated resource.
	Utilization Start Date		A calculated field. This is the Historical Start Date if this field is not null. Else, this is the Scheduled Start Date.
	Utilization End Date		A calculated field. This is the Scheduled End Date if this field is not null. Else, this is the Historical End Date.
Dimensions	Time Period Type		This is the time period for the Utilization Detail object. By default the values of this field are: Week, Month, Quarter, and Year.
	Time Period Name		The name of the time period.
	Utilization Calculation Name		The name of the utilization calculation associated with the record.
	Is Report Master		Indicates whether the utilization calculation is the master calculation.
	Resource ID		The identification number of the resource related to the utilization.
	Resource Name		The name related to the contact. See Resource fields in the PSA Help.
	Resource Role		The role related to the contact. See Resource fields in the PSA Help.
	Is Resource		Indicates whether this contact is a PSA resource. See Resource fields in the PSA Help.
	Is Resource Active		Indicates whether this is an active resource that can be assigned to projects. See Resource fields in the PSA Help.
	Resource External		Indicates whether this is a PSA external resource. See Resource fields in the PSA Help.
	Has Resource		A calculated field. Identifies if a record has a resource associated.
	Resource Mailing City		The mailing city associated with the resource. See Resource fields in the PSA Help.
	Resource Mailing Country		The mailing city country associated with the resource. See Resource fields in the PSA Help.
	Resource Mailing State/Province		The mailing city state or province associated with the resource. See Resource fields in the PSA Help.
	Resource Work Calendar		The work calendar associated with the resource. See Resource fields in the PSA Help.
	Salesforce Resource User ID		The identification number of the Salesforce User contact.
	Salesforce Resource User Name		The name of the Salesforce User contact.
	Salesforce Resource User Photo URL		The URL of the Salesforce User contact photo. This is used by the target attainment rate chart to display profile pictures.
	Region/Practice/Group Type		A calculated field. Identifies whether the record is associated with a region, practice, or group.
	Region/Practice/Group Hierarchy Depth		A calculated field. The hierarchy depth value of the RPG.
	RHierarchyDepth	H	Depending on the calculation this value can be the RPG hierarchy level of the region related to the calculation.
	PHierarchyDepth	H	Depending on the calculation this value can be the RPG hierarchy level of the practice related to the calculation.
	GHierarchyDepth	H	Depending on the calculation this value can be the RPG hierarchy level of the group related to the calculation.
	Group ID		The identification number of the group related to the contact.
	Group ID Chain		The concatenation between the RPG IDs of the group related to the contact.
	Group Name		The concatenation between the RPG levels of the group related to the contact.
	Group Level XX		The RPG level of the group related to the contact, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the group related to the contact.
	Practice ID		The identification number of the practice related to the contact.
	Practice ID Chain		The concatenation between the RPG IDs of the practice related to the contact.
	Practice Name		The concatenation between the RPG levels of the practice related to the contact.
	Practice Level XX		The RPG level of the practice related to the contact, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the practice related to the contact.
	Region ID		The identification number of the region related to the contact.
	Region ID Chain		The concatenation between the RPG IDs of the region related to the contact.
	Region Name		The concatenation between the RPG levels of the region related to the contact.
	Region Level XX		The RPG level of the region related to the contact, where XX is a number between 00 and 12. Level 00 represents the highest RPG level of the region related to the contact.