Billing Forecast Summaries Flow PSA Input Fields

The input fields are the foundation of every dataset in PSA 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 Objects

This flow uses Forecast Summary Category as the base object to extract PSA field information. It also uses this object to look up to other PSA objects to complement the data necessary to generate the Billing Forecast Summaries Dataset.

Forecast Summary Category

This are the main fields retrieved from the Forecast Summary Category object in PSA.

Field

Description

Adjusted Value

These fields are extracted directly from your PSA environment. For more information about these fields, see Forecast Summary Category Fields in the PSA Help.

Category Label
Forecast Total Value
Override Notes
Override Roll-Up Variance
Override Value
Billing Forecast Setup Category

We use this field to look up the corresponding PSA object for the following fields Billing Forecast Setup Category

Override Created By We use this field to look up the corresponding PSA object for the following fields User (Override Created By)
Billing Forecast Summary

We use this field to look up the corresponding PSA object for the following fields Billing Forecast Summary

Augmented Fields

The augment fields complement the data imported from the base objects allowing you to have a deeper visualization 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 Billing Forecast Summaries Flow Intermediate Processing.

PSA Object

Lookup Path

Fields

 

Billing Forecast Setup Category N/A Category Order  
User (Override Created By) N/A Name  
Billing Forecast Summary N/A Forecast Calculation ID  
Group ID  
Practice ID  
Region ID  
→ Billing Forecast Calculation Commited  
Created Date  
Current  
Forecast Calculation Name  
RPG ID *
Time Period ID  
→ Billing Forecast Calculation → Time Period End Date  
Start Date  
Time Period Name  
Type  
→ Region Name  
Hierarchy Depth  
→ Practice Name  
Hierarchy Depth  
→ Group Name  
Hierarchy Depth  
→ Region / Practice / Group NameXX *