Billings 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 Timecards, Milestones, Estimates Vs Actuals, Expense and Expense Report, Budgets, and Miscellaneous Adjustments as base objects to retrieve PSA field information. It also uses these objects to look up to other PSA objects to complement the data necessary to generate the Billings Dataset.

Timecard

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

Fields Retrieved from the Timecard Object

Field	Description
Bill Date	These fields are imported directly from your PSA environment. For more information about these fields, see Timecard Fields.
End Date
Name
Project Exchange Rate
Record ID
Status
Total Billable Amount
Total Days Worked
Total Hours
Currency ISO Code	We use this field to match and augment the Conversion Rate field with the Currency Type Salesforce object.
Project ID	We use this field to look up the corresponding PSA object for the following fields Project
Resource ID	We use this field to look up the corresponding PSA object for the following fields Resource (Contact)

Milestone

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

Fields Retrieved from the Milestone Object

Field	Description
Actual Date	These fields are imported directly from your PSA environment. For more information about these fields, see Milestone Fields.
Approved
Bill Date
Billable Days In Financials
Billable Hours In Financials
Default Bill Rate is Daily Rate
Description
Include In Financials
Milestone Amount
Name
Project Currency Exchange Rate
Record ID
Target Date
Currency ISO Code	We use this field to match and augment the Conversion Rate field with the Currency Type Salesforce object.
Transaction ID	We use this field to look up the corresponding PSA object for the following fields Transaction
Project ID	We use this field to look up the corresponding PSA object for the following fields Project

Estimates Vs Actuals

The main fields retrieved from the Estimates Vs Actuals object in PSA are as follows.

Fields Retrieved from the Estimates Vs Actuals Object

Field	Description
Assignment	These fields are imported directly from your PSA environment. For more information about these fields, see Estimates Versus Actuals Fields.
End Date
Estimated Days
Estimated Hours
Name
Project Currency Exchange Rate
Record ID
Scheduled Bill Rate
Scheduled Bill Rate is Daily Rate
Currency ISO Code	We use this field to match and augment the Conversion Rate field with the Currency Type Salesforce object.
Project ID	We use this field to look up the corresponding PSA object for the following fields Project
Resource ID	We use this field to look up the corresponding PSA object for the following fields Resource (Contact)
Time Period ID	We use this field to look up the corresponding PSA object for the following fields Time Period

Expense

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

Fields Retrieved from the Expense Object

Field	Description
Bill Date	These fields are imported directly from your PSA environment. For more information about these fields, see Expense Report Page Fields.
Billing Amount
Description
Expense Date
Include In Financials
Name
Record ID
Currency ISO Code	We use this field to match and augment the Conversion Rate field with the Currency Type Salesforce object.
Revenue Transaction	We use this field to look up the corresponding PSA object for the following fields Transaction
Project ID	We use this field to look up the corresponding PSA object for the following fields Project

Miscellaneous Adjustments

The main fields retrieved from the Miscellaneous Adjustments object in PSA are as follows.

Fields Retrieved from the Miscellaneous Adjustments Object

Field	Description
Amount	These fields are imported directly from your PSA environment. For more information about these fields, see Miscellaneous Adjustment Fields.
Bill Date
Description
Effective Date
Include In Financials
Name
Record ID
Transaction Category
Currency ISO Code	We use this field to match and augment the Conversion Rate field with the Currency Type Salesforce object.
Transaction ID	We use this field to look up the corresponding PSA object for the following fields Transaction
Project ID	We use this field to look up the corresponding PSA object for the following fields Project

Budget

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

Fields Retrieved from the Budget Object

Field	Description
Amount	These fields are imported directly from your PSA environment. For more information about these fields, see Budget Fields.
Bill Date
Budget Name
Effective Date
Record ID
Type
Currency ISO Code	We use this field to match and augment the Conversion Rate field with the Currency Type Salesforce object.
Transaction ID	We use this field to look up the corresponding PSA object for the following fields Transaction
Project	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 Billings Flow Intermediate Processing.

Augmented Fields

PSA Object	Lookup Path	Fields
Time Period	N/A	End Date
		Start Date
		Time Period Name
		Type
Transaction	N/A	Project Currency Exchange Rate
Resource (Contact)	N/A	External Resource
		Full Name
		Group ID
		Is Resource
		Is Resource Active
		Last Date
		Mailing City
		Mailing Country
		Mailing State/Province
		Practice ID
		Region ID
		Resource Role
		Salesforce User ID
		Start Date
		Work Calendar
	→ Resource → Region	IdChain	*
		NameXX	*
		NameChain	*
	→ Resource → Practice	IdChain	*
		NameXX	*
		NameChain	*
	→ Resource → Group	IdChain	*
		NameXX	*
		NameChain	*
	→ Resource → Salesforce User	Name
		Full Photo URL
Project	N/A	Account ID
		Active
		Allow Expenses Without Assignment
		Allow Self-Staffing
		Allow Timecards Without Assignment
		Billings
		Bookings
		Closed for Expense Entry
		Closed for Time Entry
		Company
		Currency
		End Date
		Financial Status
		Group ID
		Location
		Planned Hours
		Practice ID
		Pre-Bill Type
		Project Manager
		Project Name
		Project Status
		Project Type
		Record ID
		Region ID
		Schedule Status
		Scope Status
		Start Date
		Template
		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
	→ Project → Region	IdChain	*
		NameXX	*
		NameChain	*
	→ Project → Practice	IdChain	*
		NameXX	*
		NameChain	*
	→ Project → Group	IdChain	*
		NameXX	*
		NameChain	*
→ Project → Time Period	End Date
	Start Date
	Time Period Name
	Type
→ Project → Account	Name
	Account Type
	Billing Country
	Industry
	Annual Revenue
	Employees
→ Project → Project Manager (Contact)	Name
	Department