Utilization Dataset PS Cloud Analytics Input Fields

The input fields are the foundation of every dataset in PS Cloud Analytics. These fields are imported from your org environment by the dataflow when you create the Analytics app, the data is then processed to populate your apps' datasets.

Base Object

This flow uses Utilization Detail as the central object to retrieve PS Cloud Analytics field information. It also uses lookups to other PS Cloud Analytics objects to complement the data necessary to generate the Utilization Dataset.

Utilization Calculation Detail

The main fields retrieved from the Utilization Calculation Detail object in PSA are as follows.

Fields Retrieved from the Utilization Calculation Detail Object

Field

Description

Historical Billable Hours These fields are imported directly from your PSA environment. For more information about these fields, see the Utilization Detail fields in the PSA Help.
Historical Calendar Hours
Historical Credited Hours
Historical End Date
Historical Excluded Hours
Historical Non-Billable Hours
Historical Scheduled Billable Hours
Historical Scheduled Credited Hours
Historical Scheduled Excluded Hours
Historical Scheduled Held Hours
Historical Scheduled Non-Billable Hours
Historical Start Date
Historical Utilization Target Hours
Is Report Master
Scheduled Billable Hours
Scheduled Calendar Hours
Scheduled Credited Hours
Scheduled End Date
Scheduled Excluded Hours
Scheduled Held Hours
Scheduled Non-Billable Hours
Scheduled Start Date
Scheduled Utilization Target Hours
Utilization Target Hours
Utilization Calculation ID We use this field to look up the corresponding PSA object for the following fields Utilization Calculation
Time Period ID We use this field to look up the corresponding PSA object for the following fields Time Period
Region ID We use this field to look up the corresponding PSA object for the following fields Region
Practice ID

We use this field to look up the corresponding PSA object for the following fields Practice

Group ID

We use this field to look up the corresponding PSA object for the following fields Group 

Resource ID We use this field to look up the corresponding PSA object for the following fields Resource (Contact)

Augmented Fields

Augmented fields complement the data imported from the base objects, giving you a better view of your data.

Note: These fields are imported directly from your PSA environment. For more information about these fields, see the PSA field reference guide for their corresponding PSA object.

Key: → — Lookup path between objects

For more information about the calculated fields, see Utilization Flow Intermediate Processing.

Augmented Fields
PSA Object

Lookup Path

Fields

 

Utilization Calculation N/A Name  
Time Period N/A End Date  
Start Date  
Time Period Name  
Type  
Region N/A IdChain *
NameXX *
NameChain *
HierarchyDepth  
RPG Type *
Practice N/A IdChain *
NameXX *
NameChain *
HierarchyDepth  
RPG Type *
Group

 

N/A IdChain *
NameXX *
NameChain *
HierarchyDepth  
RPG Type *
Resource (Contact) N/A External Resource  
Full Name  
Is Resource  
Is Resource Active  
Last Date  
Mailing City  
Mailing Country  
Mailing State/Province  
Resource Role  
Salesforce User ID  
Start Date  
Work Calendar  
Department  
→ Resource → Salesforce User Name  
Full Photo URL