Page Comparison

Include Page

	Data Fields Definition for Pivot Tables
	Data Fields Definition for Pivot Tables

Tip

title	So many fields!

The PPR report contains hundreds of fields, and keeping track of them can be difficult. This section helps you get a handle on what each field means.

You'll finding a naming schema that recurs throughout the report. Substitute in hours, system revenue, odc revenue, etc for the letter XThe first thing to understand is that many of the fields have similar names but follow simple naming schema. By understanding the schema, you can quickly narrow down the fields you are actually interested in. There are six fields in the schema. Simply substitute in the metric you are looking for (revenue, hours, etc).

Actual X
Actual X to date
Projected X
Projected X to date
Projected X to

completion

complete
X at completion

So what do each of these actually mean? To start, keep in mind that they all They differ based on the date ranges that they cover. You'll see three distinct ranges.

From start to end of project (actual, projected, actual/projected mix)
From start to use actuals through date (actual, projected)
From use actuals through date to end (projected)

The graphic below helps visualize them. See below the image for some real world examples of using them.Image Removedworld examples of using them. ("UATD" stands for "Use Actuals Through Date")

Image Added

So why do we have all the fields and why would you choose one over another? I think the best example is when you want to look at the difference between what work was expected and what work was actually done. This is what our variance report shows. For example, you might use -

Projected X vs. Actual X. Show the variance between the work planned and the work that was actually done
Actual X to date vs. Projected X to date. Very similar to the last example, but you only care about the variance up to a specific date.
Projected X vs. X at completion. Show the difference between my initial plan and what I am likely to deliver.

...

Data Fields

Tip
If you are looking for a way to force all projects into the report output, trying adding the data field Tasks At Completion. As all projects must have at least one task, it should always return a value.

Field	Field Category	Description
% Achieved Milestones	Billing Fields	Percentage of billing milestones that have been achieved
% Achieved Milestones to Date	Billing Fields	Percentage of billing milestones that should have been achieved to date that have been achieved
% Calendar Days Elapsed	Task Planning Fields	Percentage of time (based on calendar days) that has elapsed since the start of the project
% Complete Based on Contract Revenue	Percent Complete Fields	Actual Contract Revenue to Date / Contract Revenue at Completion
% Complete Based on Hours	Percent Complete Fields	Actual Hours to Date / Hours at Completion
% Complete Based on Resource Direct Costs	Percent Complete Fields	Actual Resource Direct Cost to Date / Resource Direct Cost at Completion
% Complete Based on Task Hours	Percent Complete Fields	Actual Task Hours to Date / Task Hours at Completion
% Cost Written Down	Billing Fields	Percentage of actual disbursed costs that have been written down
% Elapsed	Task Planning Fields	Percentage of time (based on working days) that has elapsed since the start of the project
% Foregone Milestones	Billing Fields	Percentage of billing milestones that have been foregone
% Foregone Milestones to Date	Billing Fields	Percentage of billing milestones that should have been achieved to date that have been foregone
% Incomplete Delivery Milestones to Date	Task Planning Fields	Percentage of delivery milestones that should have been completed to date that have not yet been completed
% Incomplete Tasks to Date	Task Planning Fields	Percentage of tasks that should have been completed to date that have not yet been completed
% Late Delivery Milestones at Completion	Task Planning Fields	Percentage of delivery milestones that actually were completed late or which are planned to be completed late
% Late Delivery Milestones to Date	Task Planning Fields	Percentage of delivery milestones that should have been completed already, but which have not yet been completed or which were completed late
% Late Issues	Issue Fields


% Late Tasks at Completion	Task Planning Fields	Percentage of tasks that actually were completed late or which are planned to be completed late
% Late Tasks to Date	Task Planning Fields	Percentage of tasks that should have been completed already, but which have not yet been completed or which were completed late
% of Budgeted Billing Adjusted Revenue Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Billing Adjusted Revenue Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Chargeable Hours Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Chargeable Hours Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Client Amount Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Client Amount Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Contract Revenue Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Contract Revenue Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Disbursed Amount Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Disbursed Amount Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Expense Amount Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Expense Amount Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Hours Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Hours Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Resource Direct Cost Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Resource Direct Cost Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Budgeted Task Hours Consumed	Performance to Budget Fields	Percentage of budget consumed, using the actuals to date method
% of Budgeted Task Hours Remaining	Performance to Budget Fields	Percentage of budget remaining, using the actual to date method
% of Time Contract Value Recognized	Revenue Recognition Fields	Portion of an engagement's contract value that has already been recognized
% of Time Contract Value to be Recognized	Revenue Recognition Fields	Portion of an engagement's contract value that remains to be recognized
% Open High Priority Issues	Issue Fields


% Open Issues	Issue Fields


% Overbudget Tasks at Completion	Task Planning Fields	Percentage of tasks that are already or will be over budget based on actual hours plus remaining hours
% Overbudget Tasks to Date	Task Planning Fields	Percentage of tasks that are already or will be over budget based on actual hours plus remaining hours that should have been completed to date
% Time Written Down	Billing Fields	Percentage of actual time that has been written down
% Total Written Down	Billing Fields	Percentage of actual time and disbursed costs that have been written down
% Unachieved Milestones to Date	Billing Fields	Percentage of billing milestones that should have been achieved to date that have not been achieved to date
% Unbilled Billing Adjusted Revenue	Billing Fields	Percentage of actual time that has not yet been billed
% Unbilled Client Amount	Billing Fields	Percentage of actual costs that have not yet been billed
% Unbilled Hours	Billing Fields	Unbilled Hours / Hours at Completion
% Variance to Budgeted Billing Adjusted Revenue at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Chargeable Hours at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Client Amount at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Contract Revenue at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Disbursed Amount at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Expense Amount at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Hours at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Resource Direct Cost at Completion	Performance to Budget Fields	Percentage variance to budget expected, using the estimate at completion method
% Variance to Budgeted Task Hours at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method
Achieved Milestones	Billing Fields	Number of billing milestones that have been achieved
Achieved Milestones to Date	Billing Fields	Number of billing milestones that have been achieved to date
Actual Billing Adjusted % of Contract	Rate Realization Fields


Actual Billing Adjusted % of Contract to Date	Rate Realization Fields


Actual Billing Adjusted Rate	Rate Realization Fields


Actual Billing Adjusted Rate to Date	Rate Realization Fields


Actual Billing Adjusted Revenue	Performance to Budget Fields	Actual time worked, measured in billing adjusted revenue
Actual Billing Adjusted Revenue to Complete	Project Performance to Budget Fields


Actual Billing Adjusted Revenue to Date	Performance to Budget Fields	Actual time worked to date, measured in billing adjusted revenue
Actual Chargeable Hours	Performance to Budget Fields	Actual time worked, measured in chargeable hours
Actual Chargeable Hours to Complete	Project Performance to Budget Fields


Actual Chargeable Hours to Date	Performance to Budget Fields	Actual time worked to date, measured in chargeable hours
Actual Client Amount	Performance to Budget Fields	Actual costs expended, measured using client amount
Actual Client Amount to Complete	Project Performance to Budget Fields


Actual Client Amount to Date	Performance to Budget Fields	Actual costs expended to date, measured using client amount
Actual Contract % of Standard	Rate Realization Fields


Actual Contract % of Standard to Date	Rate Realization Fields


Actual Contract Rate	Rate Realization Fields


Actual Contract Rate to Date	Rate Realization Fields


Actual Contract Revenue	Performance to Budget Fields	Actual time worked, measured in contract revenue
Actual Contract Revenue to Complete	Project Performance to Budget Fields


Actual Contract Revenue to Date	Performance to Budget Fields	Actual time worked to date, measured in contract revenue
Actual Cost (ACWP)	Earned Value Fields	Actual cost (also known as Actual Cost of Work Performed); approved hours spent on task through actuals cutoff date
Actual Cost End Date	Activity Fields	Date of the last reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses.
Actual Cost Start

Date

Activity Fields

Date of the first reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses.

Date	Activity Fields	Date of the first reported expenses for the project. Includes unapproved (submitted) expenses if the report is configured to include unapproved expenses. Null if no reported expenses.
Actual Deferred Revenue	Revenue Fields	Will be null unless you bring in a row field that is at the contract line item level or higher
Actual Deferred Revenue to Date	Revenue Fields	Will be null unless you bring in a row field that is at the contract line item level or higher
Actual Disbursed Amount	Performance to Budget Fields	Actual costs expended, measured using disbursed amount
Actual Disbursed Amount to Complete	Project Performance to Budget Fields


Actual Disbursed Amount to Date	Performance to Budget Fields	Actual costs expended to date, measured using disbursed amount
Actual Expense Amount	Performance to Budget Fields	Actual costs expended, measured using expense amount
Actual Expense Amount to Complete	Project Performance to Budget Fields


Actual Expense Amount to Date	Performance to Budget Fields	Actual costs expended to date, measured using expense amount
Actual Hours	Performance to Budget Fields	Actual time worked for the entire duration of a project. Useful for comparing actual against projected hours (similar to schedule variance report)
Actual Hours End Date	Activity Fields	Date of the last reported hours for the project. Includes unapproved (submitted) hours if the report is configured to include unapproved hours. Null if no reported hours.
Actual Hours Start Date	Activity Fields	Date of the first reported hours for the project. Includes unapproved (submitted) hours if the report is configured to include unapproved hours. Null if no reported hours.
Actual Hours to Complete	Project Performance to Budget Fields


Actual Hours to Date	Performance to Budget Fields	Actual time through the Use Actuals Through Date
Actual ODC Revenue Amount	Revenue Fields


Actual ODC Revenue Amount to Date	Revenue Fields


Actual Project Margin	Profit Fields	Project profit of actual time and costs as a percentage of revenue
Actual Project Margin to Date	Profit Fields	Project profit of actual time and costs to date as a percentage of revenue
Actual Project Profit	Profit Fields	Project profit of actual time and costs; (ActualSystemRevenue) + (ActualOdcRevenueAmount) - (ActualResourceDirectCost) - (ActualExpenseAmount) \|
Actual Project Profit to Date	Profit Fields	Project profit of actual time and costs to date; (ActualSystemRevenueToDate) + (ActualOdcRevenueAmountToDate) - (ActualResourceDirectCostToDate) - (ActualExpenseAmountToDate)
Actual Resource Direct Cost	Performance to Budget Fields	Actual time worked, measured using resource direct cost
Actual Resource Direct Cost to Complete	Project Performance to Budget Fields


Actual Resource Direct Cost to Date	Performance to Budget Fields	Actual time worked to date, measured using resource direct cost
Actual Resource Direct Rate	Rate Realization Fields


Actual Resource Direct Rate to Date	Rate Realization Fields


Actual Resource Margin	Profit Fields	Project profit of actual time as a percentage of revenue;
Actual Resource Margin to Date	Profit Fields	Project profit of actual time to date as a percentage of revenue
Actual Resource Profit	Profit Fields	Project profit of actual time; (ActualSystemRevenue)- (ActualResourceDirectCost)
Actual Resource Profit to Date	Profit Fields	Project profit of actual time to date; (ActualSystemRevenueToDate) - (ActualResourceDirectCostToDate)
Actual Standard Rate	Rate Realization Fields


Actual Standard Rate to Date	Rate Realization Fields


Actual Standard Revenue	Revenue Fields


Actual Standard Revenue to Date	Revenue Fields


Actual System % of Billing Adjusted	Rate Realization Fields


Actual System % of Billing Adjusted to Date	Rate Realization Fields


Actual System % of Contract	Rate Realization Fields


Actual System % of Contract to Date	Rate Realization Fields


Actual System % of Standard	Rate Realization Fields


Actual System % of Standard to Date	Rate Realization Fields


Actual System Rate	Rate Realization Fields


Actual System Rate after ODC	Rate Realization Fields


Actual System Rate after ODC to Date	Rate Realization Fields


Actual System Rate to Date	Rate Realization Fields


Actual System Revenue	Revenue Fields


Actual System Revenue after ODC	Rate Realization Fields	(ActualSystemRevenue) + (ActualOdcRevenueAmount)- (ActualExpenseAmount)
Actual System Revenue after ODC % of Contract	Rate Realization Fields


Actual System Revenue after ODC % of Contract to Date	Rate Realization Fields


Actual System Revenue after ODC % of Standard	Rate Realization Fields


Actual System Revenue after ODC % of Standard to Date	Rate Realization Fields


Actual System Revenue after ODC % of System	Rate Realization Fields


Actual System Revenue after ODC % of System to Date	Rate Realization Fields


Actual System Revenue after ODC to Date	Rate Realization Fields	(ActualSystemRevenueToDate) + (ActualOdcRevenueAmountToDate)- (ActualExpenseAmountToDate)
Actual System Revenue Recognized to Date	Revenue Recognition Fields


Actual System Revenue to be Recognized to Date	Revenue Recognition Fields	Actual System Revenue to Date - Actual System Revenue Recognized to Date
Actual System Revenue to Date	Revenue Fields


Actual Task Hours	Performance to Budget Fields	Actual time worked, measured in hours
Actual Task Hours to Date	Performance to Budget Fields	Actual time worked to date, measured in hours
Actual Total Revenue	Revenue Fields	(ActualSystemRevenue) + (ActualOdcRevenueAmount)
Actual Total Revenue to Date	Revenue Fields	(ActualSystemRevenueToDate) + (ActualOdcRevenueAmountToDate)
Billed Billing Adjusted Revenue	Billing Fields	Actual time that has been billed, measured in billing adjusted revenue
Billed Client Amount	Billing Fields	Actual costs that have been billed, measured in client amount
Billing Days	Hours Fields	Number of billable days. Useful when you use daily billing.
Billed Hours	Billing Fields	Actual time that has been billed (T&M and NTE only)
Billed Milestone Amount	Billing Fields	Milestones that have been billed
Billing Adjusted % of Contract at Completion	Rate Realization Fields


Billing Adjusted Rate at Completion	Rate Realization Fields


Billing Adjusted Revenue at Completion	Performance to Budget Fields	Actual plus projected time, measured in billing adjusted revenue
Billing Adjusted Revenue Backlog	Backlog Fields	Work that has been committed or budgeted, but not yet delivered to date, measured in billing adjusted revenue; (BudgetedBillingAdjustedRevenueAtCompletion) - (ActualBillingAdjustedRevenueToDate), never less than zero \|
Billing Adjusted Revenue Variance to Date	Variance Fields	Variance between actual time compared to projected time to date
Budgeted Billing Adjusted Revenue at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Billing Adjusted Revenue Remaining	Performance to Budget Fields	Work that has been budgeted, but not yet delivered to date, measured in billing adjusted revenue; (BudgetedBillingAdjustedRevenueAtCompletion) - (ActualBillingAdjustedRevenueToDate)
Budgeted Chargeable Hours at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Chargeable Hours Remaining	Performance to Budget Fields	Work that has been budgeted, but not yet delivered to date, measured in chargeable hours; (BudgetedChargeableHoursAtCompletion) - (ActualChargeableHoursToDate)
Budgeted Client Amount at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Client Amount Remaining	Performance to Budget Fields	Costs that have been budgeted, but not yet expended to date, measured in client amount; (BudgetedClientAmountAtCompletion) - (ActualClientAmountToDate)
Budgeted Contract Revenue at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Contract Revenue Remaining	Performance to Budget Fields	Work that has been budgeted, but not yet delivered to date, measured in contract revenue; (BudgetedContractRevenueAtCompletion) - (ActualContractRevenueToDate)
Budgeted Disbursed Amount at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Disbursed Amount Remaining	Performance to Budget Fields	Costs that have been budgeted, but not yet expended to date, measured in disbursed amount; (BudgetedDisbursedAmountAtCompletion) - (ActualDisbursedAmountToDate)
Budgeted Expense Amount at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Expense Amount Remaining	Performance to Budget Fields	Costs that have been budgeted, but not yet expended to date, measured in expense amount; (BudgetedExpenseAmountAtCompletion) - (ActualExpenseAmountToDate)
Budgeted Hours at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Hours Remaining	Performance to Budget Fields	Work that has been budgeted, but not yet delivered to date, measured in hours; (BudgetedHoursAtCompletion) - (ActualHoursToDate)
Budgeted Resource Direct Cost at Completion	Performance to Budget Fields

This is the same as your budget.
Budgeted Resource Direct Cost Remaining	Performance to Budget Fields	Work that has been budgeted, but not yet delivered to date, measured in resource direct cost; (BudgetedResourceDirectCostAtCompletion) - (ActualResourceDirectCostToDate)
Budgeted Task Hours at Completion	Performance to Budget Fields	Same as Planned Hours. For the active task baseline, how many hours were budgeted from day one?
Budgeted Task Hours Remaining	Performance to Budget Fields	Work that has been budgeted, but not yet delivered to date, measured in task hours
Chargeable Hours at Completion	Performance to Budget Fields	Actual plus projected time, measured using chargeable hours
Chargeable Hours Backlog	Backlog Fields	Work that has been committed or budgeted, but not yet delivered to date, measured in chargeable hours; (BudgetedChargeableHoursAtCompletion) - (ActualChargeableHoursToDate), never less than zero \|
Chargeable Hours Variance to Date	Variance Fields	Variance between actual time compared to projected time to date
Client Amount at Completion	Performance to Budget Fields	Actual plus projected costs, measured using client amount
Client Amount Backlog	Backlog Fields	Costs that have been committed or budgeted, but not yet expended to date, measured in client amount; (BudgetedClientAmountAtCompletion)- (ActualClientAmountToDate), never less than zero
Client Amount Variance to Date	Variance Fields	Variance between actual costs compared to planned costs to date;


Contract % of Standard at Completion	Rate Realization Fields


Contract Rate at Completion	Rate Realization Fields


Contract Revenue at Completion	Performance to Budget Fields	Actual plus projected time, measured in contract revenue
Contract Revenue Backlog	Backlog Fields	Work that has been committed or budgeted, but not yet delivered to date, measured in contract revenue; (BudgetedContractRevenueAtCompletion) - (ActualContractRevenueToDate), never less than zero
Contract Revenue Variance to Date	Variance Fields	Variance between actual time compared to projected time to date;


Cost Performance Index	Earned Value Fields	Ratio of how much the accomplished work should have cost versus how much it actually cost; Earned value / Actual cost (greater than 1 is under budget, less than 1 is over budget)
Cost Variance	Earned Value Fields	Comparison of the actual cost of the work completed as compared to how much that work should have cost as measured in hours; Earned value - Actual cost (negative is over budget, positive is under budget)
Cost Written Down	Billing Fields	Actual costs that have been written down; (ActualDisbursedAmount) - (ActualClientAmount)
Delivery Milestones at Completion	Task Planning Fields	Number of delivery milestones
Delivery Milestones to Date	Task Planning Fields	Number of delivery milestones that should have been completed already
Disbursed Amount at Completion	Performance to Budget Fields	Actual plus projected costs, measured using disbursed amount
Disbursed Amount Backlog	Backlog Fields	Costs that have been committed or budgeted, but not yet expended to date, measured in disbursed amount; (BudgetedDisbursedAmountAtCompletion) - (ActualDisbursedAmountToDate), never less than zero
Disbursed Amount Variance to Date	Variance Fields	Variance between actual costs compared to planned costs to date
Earned Value (BCWP)	Earned Value Fields	Number of hours the project has "earned" based on percent of work completed (also known as Budgeted Cost of Work Performed); % complete X Budgeted hours
Expense Amount at Completion	Performance to Budget Fields	Actual plus projected costs, measured using expense amount
Expense Amount Backlog	Backlog Fields	Costs that have been committed or budgeted, but not yet expended to date, measured in expense amount; (BudgetedExpenseAmountAtCompletion) - (ActualExpenseAmountToDate), never less than zero
Expense Amount Variance to Date	Variance Fields	Variance between actual costs compared to planned costs to date
Foregone Milestones	Billing Fields	Billing milestones that have been manually marked as foregone
Foregone Milestones to Date	Billing Fields	Billing milestones to date that have been manually marked as foregone
Hours at Completion	Performance to Budget Fields	Actual plus projected time, measured in hours
Hours Backlog	Backlog Fields	Work that has been committed or budgeted, but not yet delivered to date, measured in hours; (BudgetedHoursAtCompletion) - (ActualHoursToDate), never less than zero
Hours Variance to Date	Variance Fields	Variance between actual time compared to projected time to date
Incomplete Delivery Milestones to Date	Task Planning Fields	Number of delivery milestones that should have been completed to date that have not yet been completed
Incomplete Tasks to Date	Task Planning Fields	Number of tasks that should have been completed to date that have not yet been completed
Late Delivery Milestones at Completion	Task Planning Fields	Number of delivery milestones that actually were completed late or which are planned to be completed late
Late Delivery Milestones to Date	Task Planning Fields	Number of delivery milestones that should have been completed already, but which have not yet been completed or which were completed late
Late Issues	Issue Fields	Issues with due dates in the past that are still open
Late Milestones	Billing Fields


Late Tasks at Completion	Task Planning Fields	Number of tasks that actually were completed late or which are planned to be completed late
Late Tasks to Date	Task Planning Fields	Number of tasks that should have been completed already, but which have not yet been completed
ODC Revenue Amount at Completion	Revenue Fields


Open High Priority Issues	Issue Fields


Open Issues	Issue Fields


Overbudget Tasks at Completion	Task Planning Fields	Number of tasks that are already or will be over budget based on actual hours plus remaining hours
Overbudget Tasks to Date	Task Planning Fields	Number of tasks that are already or will be over budget based on actual hours plus remaining hours that should have been completed to date
Planned Value (BCWS)	Earned Value Fields	Number of hours of work that should have been completed to date based on elapsed time (also known as Budgeted Cost of Work Scheduled); % elapsed X Budgeted hours
Project Margin at Completion	Profit Fields	Project profit of actual plus projected time and costs as a percentage of revenue
Project Profit at Completion	Profit Fields	Project profit of actual plus projected time and costs; (SystemRevenueAtCompletion) + (OdcRevenueAmountAtCompletion) - (ResourceDirectCostAtCompletion) - (ExpenseAmountAtCompletion)
Projected Billing Adjusted % of Contract	Rate Realization Fields


Projected Billing Adjusted % of Contract to Complete	Rate Realization Fields


Projected Billing Adjusted Rate	Rate Realization Fields


Projected Billing Adjusted Rate to Complete	Rate Realization Fields


Projected Billing Adjusted Revenue	Variance Fields	Projected time as planned (useful for variance analysis), measured in billing adjusted revenue
Projected Billing Adjusted Revenue to Complete	Performance to Budget Fields	Projected time, measured in billing adjusted revenue
Projected Billing Adjusted Revenue to Date	Variance Fields	Projected time as planned to date (useful for variance analysis), measured in billing adjusted revenue
Projected Chargeable Hours	Variance Fields	Projected time as planned (useful for variance analysis), measured using chargeable hours
Projected Chargeable Hours to Complete	Performance to Budget Fields	Projected time, measured using chargeable hours
Projected Chargeable Hours to Date	Variance Fields	Projected time as planned to date (useful for variance analysis), measured using chargeable hours
Projected Client Amount	Variance Fields	Projected costs as planned (useful for variance analysis), measured using client amount
Projected Client Amount to Complete	Performance to Budget Fields	Projected costs, measured using client amount
Projected Client Amount to Date	Variance Fields	Projected costs as planned to date (useful for variance analysis), measured using client amount
Projected Contract % of Standard	Rate Realization Fields


Projected Contract % of Standard to Complete	Rate Realization Fields


Projected Contract Rate	Rate Realization Fields


Projected Contract Rate to Complete	Rate Realization Fields


Projected Contract Revenue	Variance Fields	Projected time as planned (useful for variance analysis), measured in contract revenue
Projected Contract Revenue to Complete	Performance to Budget Fields	Projected time, measured in contract revenue
Projected Contract Revenue to Date	Variance Fields	Projected time as planned to date (useful for variance analysis), measured in contract revenue
Projected Cost End Date	Activity Fields	Date of the last projected expenses for the project. Null if no reported expenses.
Projected Cost Start Date	Activity Fields	Date of the first projected expenses for the project. Null if no reported expenses.
Projected Disbursed Amount	Variance Fields	Projected costs as planned (useful for variance analysis), measured using disbursed amount
Projected Disbursed Amount to Complete	Performance to Budget Fields	Projected costs, measured using disbursed amount
Projected Disbursed Amount to Date	Variance Fields	Projected costs as planned to date (useful for variance analysis), measured using disbursed amount
Projected Expense Amount	Variance Fields	Projected costs as planned (useful for variance analysis), measured using expense amount
Projected Expense Amount to Complete	Performance to Budget Fields	Projected costs, measured using expense amount
Projected Expense Amount to Date	Variance Fields	Projected costs as planned to date (useful for variance analysis), measured using expense amount
Projected Hours	Variance Fields	Projected time as planned (useful for variance analysis), measured in hours
Projected Hours End Date	Activity Fields	Date of the last projected hours for the project. Includes requested hours if the report is configured to include requested hours. Null if no scheduled hours.
Projected Hours Start Date	Activity Fields	Date of the first projected hours for the project. Includes requested hours if the report is configured to include requested hours. Null if no scheduled hours.
Projected Hours to Complete	Performance to Budget Fields	Projected time, measured in hours
Projected Hours to Date	Variance Fields	Projected time as planned to date (useful for variance analysis), measured in hours
Projected ODC Revenue Amount	Revenue Fields


Projected ODC Revenue Amount to Complete	Revenue Fields


Projected Project Margin	Variance Fields	Project profit of projected time and costs as planned as a percentage of revenue (useful for variance analysis)
Projected Project Margin to Complete	Profit Fields	Project profit of projected time and costs as a percentage of revenue
Projected Project Profit	Variance Fields	Project profit of projected time and costs as planned (useful for variance analysis); (ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) - (ProjectedResourceDirectCost) - (ProjectedExpenseAmount)
Projected Project Profit to Complete	Profit Fields	Project profit of projected time and costs; (ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) - (ProjectedResourceDirectCost) - (ProjectedExpenseAmount)
Projected Resource Direct Cost	Variance Fields	Projected time as planned (useful for variance analysis), measured using resource direct cost
Projected Resource Direct Cost to Complete	Performance to Budget Fields	Projected time, measured using resource direct cost
Projected Resource Direct Cost to Date	Variance Fields	Projected time as planned to date (useful for variance analysis), measured using resource direct cost
Projected Resource Direct Rate	Rate Realization Fields


Projected Resource Direct Rate to Complete	Rate Realization Fields


Projected Resource Margin	Variance Fields	Project profit of projected time as planned as a percentage of revenue (useful for variance analysis)
Projected Resource Margin to Complete	Profit Fields	Project profit of projected time as a percentage of revenue;
Projected Resource Profit	Variance Fields	Project profit of projected time as planned (useful for variance analysis); (ProjectedSystemRevenue)- (ProjectedResourceDirectCost)
Projected Resource Profit to Complete	Profit Fields	Project profit of projected time; (ProjectedSystemRevenue)- (ProjectedResourceDirectCost)
Projected Standard Rate	Rate Realization Fields


Projected Standard Rate to Complete	Rate Realization Fields
Projected Standard Revenue	Revenue Fields


Projected Standard Revenue to Complete	Revenue Fields


Projected System % of Billing Adjusted	Rate Realization Fields


Projected System % of Billing Adjusted to Complete	Rate Realization Fields


Projected System % of Contract	Rate Realization Fields


Projected System % of Contract to Complete	Rate Realization Fields


Projected System % of Standard	Rate Realization Fields


Projected System % of Standard to Complete	Rate Realization Fields


Projected System Rate	Rate Realization Fields


Projected System Rate after ODC	Rate Realization Fields


Projected System Rate after ODC to Complete	Rate Realization Fields


Projected System Rate to Complete	Rate Realization Fields


Projected System Revenue	Revenue Fields


Projected System Revenue after ODC	Rate Realization Fields	(ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount) - (ProjectedExpenseAmount)
Projected System Revenue after ODC % of Contract	Rate Realization Fields


Projected System Revenue after ODC % of Contract to Complete	Rate Realization Fields


Projected System Revenue after ODC % of Standard	Rate Realization Fields


Projected System Revenue after ODC % of Standard to Complete	Rate Realization Fields


Projected System Revenue after ODC % of System	Rate Realization Fields


Projected System Revenue after ODC % of System to Complete	Rate Realization Fields


Projected System Revenue after ODC to Complete	Rate Realization Fields	(ProjectedSystemRevenueToComplete) + (ProjectedOdcRevenueAmountToComplete) - (ProjectedExpenseAmountToComplete)
Projected System Revenue to Complete	Revenue Fields


Projected Task Hours to Complete	Performance to Budget Fields	Task hours to complete, inclusive of hours remaining updates by resources
Projected Total Revenue	Revenue Fields	(ProjectedSystemRevenue) + (ProjectedOdcRevenueAmount)
Projected Total Revenue to Complete	Revenue Fields	(ProjectedSystemRevenueToComplete) + (ProjectedOdcRevenueAmountToComplete)
Rate Loss due to Contract Terms at Completion	Rate Realization Fields


Rate Loss due to Discounting at Completion	Rate Realization Fields


Rate Loss due to Write Downs at Completion	Rate Realization Fields


Remaining Task to Projected Hours Ratio	Task Planning Fields	Ratio that expresses how accurate scheduled hours are as compared to task hours ( less than 1 indicates overstaffing, greater than 1 indicates understaffing); (ProjectedTaskHoursToComplete) / (ProjectedHoursToComplete)
Resource Direct Cost at Completion	Performance to Budget Fields	Actual plus projected costs, measured using resource direct cost
Resource Direct Cost Backlog	Backlog Fields	Work that has been committed or budgeted, but not yet delivered to date, measured in resource direct cost; (BudgetedResourceDirectCostAtCompletion)- (ActualResourceDirectCostToDate), never less than zero
Resource Direct Cost Variance to Date	Variance Fields	Variance between actual time compared to projected time to date
Resource Direct Rate at Completion	Rate Realization Fields


Resource Margin at Completion	Profit Fields	Project profit of actual plus projected time to date as a percentage of revenue
Resource Profit at Completion	Profit Fields	Project profit of actual plus projected time; (SystemRevenueAtCompletion) - (ResourceDirectCostAtCompletion)
Schedule Performance Index	Earned Value Fields	Ratio of how much work actually was accomplished versus how much should have been completed; Earned value / Planned value (greater than 1 is ahead of schedule, less than 1 is behind schedule)
Schedule Variance	Earned Value Fields	Comparison of the amount of work that should have been completed to date versus how much work actually was completed to date; Earned value - Planned value (positive is ahead of schedule, negative is behind schedule)
Standard Rate at Completion	Rate Realization Fields


Standard Revenue at Completion	Revenue Fields


System % of Billing Adjusted at Completion	Rate Realization Fields


System % of Contract at Completion	Rate Realization Fields


System % of Standard at Completion	Rate Realization Fields


System Rate after ODC at Completion	Rate Realization Fields


System Rate at Completion	Rate Realization Fields


System Revenue after ODC % of Contract at Completion	Rate Realization Fields


System Revenue after ODC % of Standard at Completion	Rate Realization Fields


System Revenue after ODC % of System at Completion	Rate Realization Fields


System Revenue after ODC at Completion	Rate Realization Fields	(SystemRevenueAtCompletion) - (ExpenseAmountAtCompletion)
System Revenue at Completion	Revenue Fields


System Revenue Recognized	Revenue Recognition Fields


System Revenue to be Recognized	Revenue Recognition Fields	System Revenue at Completion - System Revenue Recognized
Task Days	Task Planning Fields	Task Days to Date + Task Days to Complete
Task Days to Complete	Task Planning Fields


Task Days to Date	Task Planning Fields


Task Hours at Completion	Performance to Budget Fields	Actual plus projected time, measured in task hours
Task Hours Backlog	Backlog Fields	Work that has been committed or budgeted, but not yet delivered to date, measured in task hours; (BudgetedTaskHoursAtCompletion) - (ActualTaskHoursToDate), never less than zero
Task Hours Variance	Variance Fields	Variance between actual hours compared to budgeted task hours
Task Plan End Date	Activity Fields	Latest task end date for the project.
Task Plan Start Date	Activity Fields	Earliest task start date for the project.
Tasks at Completion	Task Planning Fields	Total number of tasks in the current task plan, not including parent or roll-up tasks
Tasks to Date	Task Planning Fields	Total number of tasks in the current task plan, not including parent or roll-up tasks, that should have been completed to date
Time Written Down	Billing Fields	Actual time that has been written down; (ActualContractRevenue) - (ActualBillingAdjustedRevenue)
Total Issues	Issue Fields


Total Milestones to Date	Billing Fields	Billing milestones that should have been achieved to date
Total Revenue at Completion	Revenue Fields	(SystemRevenueAtCompletion) + (OdcRevenueAmountAtCompletion)
Total Revenue Recognized	Revenue Recognition Fields


Total Written Down	Billing Fields	Actual time and disbursed costs that have been written down; (TimeWrittenDown) + (CostWrittenDown)
Unachieved Milestones to Date	Billing Fields	Billing milestones that should have been achieved to date that have not been achieved
Unbilled Billing Adjusted Revenue	Billing Fields	Actual time that has not yet been billed, measured in billing adjusted revenue
Unbilled Client Amount	Billing Fields	Actual costs that have not yet been billed, measured in client amount
Unbilled Hours	Billing Fields	Actual time that has not yet been billed
Unbilled Milestone Amount	Billing Fields	Milestones that have not yet been billed
Variance to Budgeted Billing Adjusted Revenue at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (BillingAdjustedRevenueAtCompletion) - (BudgetedBillingAdjustedRevenueAtCompletion)
Variance to Budgeted Chargeable Hours at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (ChargeableHoursAtCompletion)- (BudgetedChargeableHoursAtCompletion)
Variance to Budgeted Client Amount at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (ClientAmountAtCompletion) - (BudgetedClientAmountAtCompletion)
Variance to Budgeted Contract Revenue at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (ContractRevenueAtCompletion) - (BudgetedContractRevenueAtCompletion)
Variance to Budgeted Disbursed Amount at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (DisbursedAmountAtCompletion) - (BudgetedDisbursedAmountAtCompletion)
Variance to Budgeted Expense Amount at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (ExpenseAmountAtCompletion) - (BudgetedExpenseAmountAtCompletion)
Variance to Budgeted Hours at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (HoursAtCompletion) - (BudgetedHoursAtCompletion)
Variance to Budgeted Resource Direct Cost at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method; (ResourceDirectCostAtCompletion) - (BudgetedResourceDirectCostAtCompletion)
Variance to Budgeted Task Hours at Completion	Performance to Budget Fields	Variance to budget expected, using the estimate at completion method;

Versions Compared

Old Version 8

New Version Current

Key

Data Fields