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	Description
Error Details	These fields are imported directly from your PSA environment. For more information about these fields, see Backlog Calculation Detail Fields.
Status

Backlog Details Converted

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

Fields Retrieved from the Backlog Details Converted Object

Field	Description
Backlog Detail Converted ID	These fields are imported directly from your PSA environment. For more information about these fields, see the Backlog Detail Converted Fields in the PSA Help.
Billings
Bookings
External Time Cost
Held Resource Request Hours
Held Resource Request External Cost
Held Resource Request Internal Cost
Held Resource Request Revenue
Internal Time Cost
Scheduled Days
Scheduled Hours
Unheld Resource Request Cost
Unheld Resource Request Hours
Unheld Resource Request Revenue
Backlog Detail ID	We use this field to look up the corresponding PSA object for the following fields Backlog Detail
Time Period ID	We use this field to look up the corresponding PSA object for the following fields Time Period
Project ID	We use this field to look up the corresponding PSA object for the following fields Project

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