Project Portfolio Report - Data Fields


In Projector a data field represents the information that you are interested in. For Excel Pivot Tables this information can be cross-referenced by the row and column fields to compile the data. In this image you see project profit organized by project name and month. Project Profit is the data field. Project Name is the row field. Month is the column field. If this sounds confusing, read our introductory article on pivot tables.


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.

The 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).

  1. Actual X
  2. Actual X to date
  3. Projected X
  4. Projected X to date
  5. Projected X to complete
  6. X at completion

So what do each of these actually mean? 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. ("UATD" stands for "Use Actuals Through Date")

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

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 HoursBilling FieldsUnbilled 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.

Actual Deferred RevenueRevenue FieldsWill be null unless you bring in a row field that is at the contract line item level or higher
Actual Deferred Revenue to DateRevenue FieldsWill 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 DaysHours FieldsNumber of billable days. Useful when you use daily billing.
Billed HoursBilling FieldsActual 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 HoursBilling FieldsActual 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;