SECTIONSUtilization Flow Intermediate Processing
After importing the input fields and augmenting them with the data from their lookup objects, the PS Cloud Analytics dataflow filters out non-relevant or repeated records.
You can use the dataflow editor in Analytics Studio to visualize the PS Cloud Analytics dataflow and its nodes. Alternatively, you can download the dataflow definition file which is a JSON file representing the dataflow and its logic. For more information on the dataflow editor and the dataflow definition file, see Configure the Dataflow in the Salesforce Help.
Dataflow Nodes
These are the main dataflow nodes in the Utilization flow.
|
Dataflow Node |
Description |
|---|---|
| utilization_details__FILTER | This filter matches records with an associated time period. |
Calculated Fields
These are the fields calculated by the Utilization flow.
|
Field API Name |
Description |
|---|---|
| HasResource | Identifies if a record has a resource associated. |
| ValueActualHours | 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. |
| ValueBillableHours | Calculated by the sum of the Utilization Detail object Historical Billable Hours plus Historical Scheduled Billable Hours plus Scheduled Billable Hours. |
| ValueScheduledHours | 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. |
| ValueHistoricalScheduledHours | Calculated by the sum of the Utilization Detail object Historical Scheduled Billable Hours plus Historical Scheduled Credited Hours plus Historical Scheduled Excluded Hours plus Historical Scheduled Held Hours plus Historical Scheduled Non-Billable Hours. |
| UtilizationStartDate | This is the Historical Start Date if this field is not null. Else, this is the Scheduled Start Date. |
| UtilizationEndDate | This is the Scheduled End Date if this field is not null. Else, this is the Historical End Date. |
| ValueCreditedHours | Calculated by the sum of the Utilization Detail object Historical Credited Hours plus Scheduled Credited Hours. |
| ValueCalendarHours | Calculated by the sum of the Utilization Detail object Historical Calendar Hours plus Scheduled Calendar Hours. |
| ValueExcludedHours | calculated by the sum of the Utilization Detail object Historical Excluded Hours plus Scheduled Excluded Hours. |
| RPGType | Identifies whether the record is associated with a region, practice, or group. |
| RPGHierarchyDepth | The hierarchy depth value of the RPG. |