Backlog 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 Backlog Details Converted and Backlog Calculation as the base objects to retrieve PSA field information. It also uses this object to look up to other PSA objects to complement the data necessary to generate the Backlog Dataset.

Backlog Calculation

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

Fields Retrieved from the Backlog Calculation Object

Field Label	Field API Name	Description
Error Details	pse__Error_Details__c	Populates the Backlog Calculation Error Details field in the resulting dataset.
Status	pse__Status__c	Populates the Backlog Calculation Status field in the resulting dataset.

Backlog Detail Converted

The main fields retrieved from the Backlog Detail Converted object in PSA are as follows.

Fields Retrieved from the Backlog Detail Converted Object

Field Label	Field API Name	Description
Backlog Detail Converted ID		Populates the Backlog Detail Converted ID field in the resulting dataset.
Backlog Detail ID	pse__Backlog_Detail__c	Populates the Backlog Detail ID field in the resulting dataset.
Billings	pse__Billings__c	Populates the Value Billings field in the resulting dataset.
Bookings	pse__Bookings__c	Populates the Value Bookings field in the resulting dataset.
External Time Cost	pse__External_Time_Cost__c	Populates the Value External Time Cost field in the resulting dataset.
Held Resource Request External Cost	pse__Held_Resource_Request_External_Cost__c	Populates the Value Held Resource Request External Cost field in the resulting dataset.
Held Resource Request Hours	pse__Held_Resource_Request_Hours__c	Populates the Value Held Resource Request Hours field in the resulting dataset.
Held Resource Request Internal Cost	pse__Held_Resource_Request_Internal_Cost__c	Populates the Value Held Resource Request Internal Cost field in the resulting dataset.
Held Resource Request Revenue	pse__Held_Resource_Request_Revenue__c	Populates the Value Held Resource Request Revenue field in the resulting dataset.
Internal Time Cost	pse__Internal_Time_Cost__c	Populates the Value Internal Time Cost field in the resulting dataset.
Project ID	pse__Project__c	Populates the Project ID field in the resulting dataset.
Scheduled Days	pse__Scheduled_Days__c	Populates the Value Scheduled Days field in the resulting dataset.
Scheduled Hours	pse__Scheduled_Hours__c	Populates the Value Scheduled Hours field in the resulting dataset.
Time Period ID	pse__Time_Period__c	Populates the Time Period ID field in the resulting dataset.
Unheld Resource Request Cost	pse__Unheld_Resource_Request_Cost__c	Populates the Value Unheld Resource Request Cost field in the resulting dataset.
Unheld Resource Request Hours	pse__Unheld_Resource_Request_Hours__c	Populates the Value Unheld Resource Request Hours field in the resulting dataset.
Unheld Resource Request Revenue	pse__Unheld_Resource_Request_Revenue__c	Populates the Value Unheld Resource Request Revenue field in the resulting dataset.

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 Backlog Flow Intermediate Processing.

Augmented Fields

PSA Object	Lookup Path	Fields
Time Period	N/A	Time Period Name
		Time Period Type
		Time Period Start Date
		Time Period End Date
Backlog Detail	N/A	Region ID
		Region ID Chain
		Region Name
		Region Name Level XX	*
		Practice ID
		Practice ID Chain
		Practice Name
		Practice Name Level XX	*
		Group ID
		Group ID Chain
		Group Name
		Group Name Level XX	*
		Backlog Calculation ID
	→ Backlog Calculation	Backlog Calculation Name
		Region ID
		Practice ID
		Group ID
		Include Sublevels
		Is Report Master
		Time Period Types
	→ Backlog Calculation → Region	Region ID Chain
		Region Name
		Region Name Level XX	*
	→ Backlog Calculation → Practice	Practice ID Chain
		Practice Name
		Practice Name Level XX	*
	→ Backlog Calculation → Group	Group ID Chain
		Group Name
		Group Name Level XX	*
Project	N/A	Time Period Start Date
		Time Period End Date
		Group ID Chain
		Practice ID Chain
		Region ID Chain
		Closed for Expense Entry
		Closed for Time Entry
		Allow Expenses Without Assignment
		Allow Timecards Without Assignment
		Allow Self-Staffing
		Financial Status
		Schedule Status
		Scope Status
		Location
		Pre-Bill Type
		Type
		Is Template
		Time Period Name
		Time Period Type
		Non-Billable Hours (External)
		Non-Billable Hours (Internal)
		Credited Hours
		Excluded Hours
		Billed
		Expense Budget
		Expense Costs
		External Costs
		Internal Costs
		Internal Time Cost
		Invoiced
		Margin
		Master Project
		Other Costs
		Parent Project
		Pass-through Billings
		Project Phase
		Revenue
		Tasks Total Percent Complete (Points)
		Tasks Total Points
		Tasks Total Points Complete
		Time Credited
		Time Excluded
		Total Assigned Hours
		Total Costs
		Total Number of Tasks
		Total Submitted Hours
		Unscheduled Backlog
		Percent Hours Complete
		Scheduled Hours Remaining
		Recognition Method
		Backlog: Last Update Date
	→ Project → Account	Name
		Account Type
		Billing Country
		Industry
		Annual Revenue
		Employees