You are here: Using Project Insight > Reports > Project Report Data Reference

Project Report Data Reference

Selector Box Field Name

Column Displayed As

Explanation

Unit

Actual Expense

Actual Expense

Total expenses entered as Expense Entries for all tasks in the project(s) + all Expense Entries entered at the project level (not on tasks).

Currency

Actual Hours

Actual Hours

Actual hours entered as Time Entries for all tasks in the project(s) + all Time Entries entered at the project level (not on tasks).

Hours

Actual Rate

Actual Rate

Actual Time / Actual Hours

Currency

Actual Time

Actual Time

Each time entry multiplied by its burden rate and subsequently summed for all time entries.

Currency

Actual Total

Actual Total

Actual Time + Actual Expenses Total

Currency

Approval Requests

Approval Requests

Hyperlinks to Approval Request with the name and approval status of the request.

Hyperlink Text

At Risk

At Risk

"At Risk" is manually assigned by a project manager.

Checkbox

Baseline Duration

Baseline Duration

The number of working days, hours and minutes in the saved baseline.

Days

Baseline End Date

Baseline End Date

The scheduled end date of the saved baseline.

Date

Baseline Start Date

Baseline Start Date

The scheduled start date of the saved baseline.

Date

Baseline Work Hours

Baseline Work Hours

The number of work hours assigned in the saved baseline.

Hours

Billable Expense

Billable Expense

Total expenses entered in Expense Entry as billable values.

Currency

Billable Hours

Billable Hours

Total hours entered in the Time Entry as billable hours.

Hours

Billable Rate

Billable Rate

Bill Rate for the resources' time entries.

Currency

Billable Time

Billable Time

Each time entry multiplied by its billable rate and subsequently summed for all time entries.

Currency

Billable Total

Billable Total

Billable Time + Billable Expense

Currency

Companies

Companies

Companies associated with the project by a project manager in the Project Add/Edit form.

Text

Company Contract Default

Company Contract Default

Company Contract assigned as the Contract Default for the project by the project manager in the Project Add/Edit form. It is displayed as "Company - Contract Number"

Text

Company Contract Default #

Company Contract Default #

Company Contract assigned as the Contract Default for the project by the project manager in the Project Add/Edit form. It is displayed as "Contract Number"

Text

Company Contracts

Company Contracts

Company Contracts (default and others) assigned to the project by the project manager in the Project Add/Edit form. It is displayed as "Company Name - Contract Number"

Text

Company Default

Company Default

Company assigned as the Company Default for the project by the project manager in the Project Add/Edit form.

Text

Current Critical Task

Current Critical Task

All critical tasks with a scheduled start date on or before the current date (today).

Text

Customer Job #

Customer Job #

Customer Job # entered as text by the project manager in the Project Add/Edit form.

Text

Customer Name

Customer Name

Customer Name entered as text by the project manager in the Project Add/Edit form.

Text

Description

Description

Project Description entered as text by the project manager in the Project Add/Edit form.

Text

Duration

Duration

Total working days, hours and minutes as calculated from the earliest scheduled start date and time to the latest scheduled end date and time in the project.

Days, Hours and Minutes

Est. Expense

Est. Expense

Total costs estimated in Estimated Fixed Cost for all tasks.

Currency

Est. Hours

Est. Hours

Total hours estimated in Estimated Hours for all tasks.

Hours

Est. Rate

Est. Rate

Rate estimated in Estimated Rate for task(s).

Currency

Est. Time

Est. Time

Estimated Rate x Estimated Hours

Currency

Est. Total

Est. Total

Estimated Time Total + Estimated Expense Total

Currency

Forward Progress

Forward Progress

Calculated work progress date based on percent complete and scheduled start date.

Date

Groups

Groups

Groups assigned to the project by the project manager in the Project Add/Edit form.

Text

Indicators

Indicators

Icon indicators to identify Health Parameters and Project Status.

Icon

Invoiced Expense

Invoiced Expense

Total Expense Entries included on current invoices.

Currency

Invoiced Hours

Invoiced Hours

Total Time Entries included on current invoices.

Hours

Invoiced Rate

Invoiced Rate

Calculated rate on current invoices for all currently Invoiced Hours. Calculated as "Invoiced Time / Invoiced Rate"

Currency

Invoiced Time

Invoiced Time

Total currency value of all Invoiced Hours

Currency

Invoiced Total

Invoiced Total

Invoiced Expense + Invoiced Time

Currency

Name

Name

Project Name as entered in the Project Add/Edit form.

Text

Number

Number

Project Number automatically assigned to the project when it is created.

Text

Percent Complete

Percent Complete

% Complete value as entered by the Task Owner. When calculated for more than one task: "Work Hours Completed/Work" for all included tasks.

Percent

Percent Complete (Duration)

Percent Complete (Duration)

Completed duration divided by Duration.

Percent

Profit - Actual

Profit - Actual

Target Billable Total - Actual Total. Profit you are targeting at the overall project level.

Currency

Profit - Actual %

Profit - Actual %

Profit - Target / Target Billable Total)

Percent

Profit - Actual (Invoice)

Profit - Actual (Invoice)

Invoiced Total - Actual Total

Currency

Profit - Actual (Invoice)%

Profit - Actual (Invoice)%

Profit - Actual (Invoice) / Invoiced Total

Percent

Profit - Estimated

Profit - Estimated

Profit - Estimated

Currency

Profit - Estimated %

Profit - Estimated %

Profit - Estimated / Proposed Total

Percent

Profit - Forecasted

Profit - Forecasted

Target Billable Total - Work Estimate At Completion

Currency

Profit - Forecasted %

Profit - Forecasted %

Profit - Forecasted / Target Billable Total

Percent

Profit - Forecasted CPI

Profit - Forecasted CPI

Target Billable Total - Work Estimate At Completion (CPI)

Integer

Profit - Planned

Profit - Planned

Target Billable Total - Work Total

Currency

Profit - Planned %

Profit - Planned %

Profit – Planned Total / Target Billable Total

Percent

Profit - Planned Time & Materials

Profit - Planned Time & Materials

Work Billable Planned Value - Actual Total

Currency

Profit - Planned Time & Materials %

Profit - Planned Time & Materials %

Profit - Planned Time & Materials / Work Billable Planned Value

Percent

Profit - Target

Profit - Target

Target Billable Total - Target Total

Currency

Profit - Target %

Profit - Target %

Profit - Target / Target Billable Total

Percent

Profit - Time & Materials

Profit - Time & Materials

Billable Total - Actual Total

Currency

Profit - Time & Materials %

Profit - Time & Materials %

Profit - Time & Materials / Billable Total

Percent

Profit - Forecasted Time & Materials

Profit - Forecasted Time & Materials

Work Billable Estimate at Completion - Work Estimate at Completion

Currency

Profit - Forecasted Time & Materials %

Profit - Forecasted Time & Materials %

Profit – Forecasted Time & Materials / Work Billable Estimate at Completion

Percent

Profit - Forecasted Time & Materials CPI

Profit - Forecasted Time & Materials CPI

Work Billable Estimate at Completion (CPI) - Work

Estimate at Completion (CPI)

Integer

Profit - Forecasted Time & Materials CPI %

Profit - Forecasted Time & Materials CPI %

Profit – Forecasted Time & Materials CPI / Work Billable Estimate at Completion (CPI)

Percent

PO/Job #

PO/Job #

PO/Job # entered as text by the project manager in the Project Add/Edit form.

Text

Project Approval Request(s)

Project Approval Request(s)

The name of the approval (with a hyperlink to it)for any approval requested for the project.

Text

Project Managers

Project Managers

All resources assigned to the Project with the Resource Type as Project Manager.

Text

Prop. Expense

Prop. Expense

Sum of Proposed Expenses for all project(s) tasks.

Currency

Prop. Hours

Prop. Hours

Sum of all hours from Proposed Hours for all project(s) tasks.

Hours

Prop. Rate

Prop. Rate

Proposed Time Total / Proposed Hours

Currency

Prop. Time

Prop. Time

Sum of all Proposed Time Total from all project(s) tasks

Currency

Prop. Total

Prop. Total

Proposed Time Total + Proposed Expense Total

Currency

Recovery Billable Percent (CPI)

Recovery Billable Percent (CPI)

Target Budget Billable / Work Billable Estimate at Completion (CPI)

Percent

Recovery Percent (CPI)

Recovery Percent (CPI)

Target Work Total / Work Estimate at Completion

Percent

Recovery Billable Percent

Recovery Billable Percent

Target Budget Billable Total / Work Billable Estimate at Completion

Percent

Recovery Percent

Recovery Percent

Target Budget Total / Work Estimate at Completion

Percent

Resources

Resources

All resources assigned to the Project with the Resource Type as Project Resource or Project Scheduler.

Text

Scorecard Score

Scorecard Score

Current score from the most recent scorecard update on the project.

Integer

Sponsor(s)

Sponsor(s)

Project Sponsors selected for the project in the Project Add/Edit form.

Text

Start Date

Start Date

Schedule Start Date based on the start date of the earliest task schedule start date in the project.

Date

State

State

Project State assigned to the project in the Project Add/Edit form.

Text

Status

Status

Project Status assigned to the project in the Project Add/Edit form.

Text

Status Code

Status Code

Project Status Code as associated with the corresponding Project Status selection assigned to the project in the Project Add/Edit form. Project Status Codes are associated with Project Status in the Global Settings by Project Insight administrators.

Text

Status Comment (Last) Author

Status Comment (Last) Author

The last (most recent) Project Status Comment Author posting the last (most recent) Project Status Comment. If status comment filtering is applied in the report, this will be the last comment matching the status comment filtering options in the report.

Text

Status Comment (Last) Comment

Status Comment (Last) Comment

The last (most recent) Project Status Comment assigned to the project in the Project Status View. If status comment filtering is applied in the report, this will be the last comment matching the status comment filtering options in the report.

Text

Status Comment (Last) Type

Status Comment (Last) Type

The last (most recent) Project Status Comment Type assigned to the project in the Project Status View. If status comment filtering is applied in the report, this will be the last comment matching the status comment filtering options in the report.

Text

Status Description

Status Description

Status Description as entered in the Project Add/Edit form.

Text

Schedule End Baseline

End Date Baseline

Schedule End Date from the current baseline.

Date

Schedule End Date

End Date

Schedule End Date based on the end date of the latest task end date in the project.

Date

Schedule Start Baseline

Start Date Baseline

Schedule Start Date from the current baseline.

Date

Status Description

Status Description

Status Description entered in the Project Add/Edit form.

Text

Target Billable Expense

Target Billable Expense

Target Billable Expense entered in the Project Add/Edit form.

Currency

Target Billable Hours

Target Billable Hours

Target Work Billable Hours entered in the Project Add/Edit form.

Hours

Target Billable Rate

Target Billable Rate

Target Billable Rate entered in the Project Add/Edit form.

Currency

Target Billable Time

Target Billable Time

Target Billable Time entered in the Project Add/Edit form.

Currency

Target Billable Total

Target Billable Total

Target Billable Total entered in the Project Add/Edit form.

Currency

Target Expense

Target Expense

Target Expense entered in the Project Add/Edit form.

Currency

Target Hours

Target Hours

Target Hours entered in the Project Add/Edit form.

Hours

Target Rate

Target Work Rate

Target Rate entered in the Project Add/Edit form.

Currency

Target Time

Target Time

Target Time entered in the Project Add/Edit form.

Currency

Target Total

Target Total

Target Total entered in the Project Add/Edit form.

Currency

Type

Type

Project Type assigned to the project in the Project Add/Edit form.

Text

Type Code

Type Code

Project Type assigned to the project in the Project Add/Edit form.

Text

Var. Est Expense vs Actual

Var. Est Expense vs Actual

Est. Expense - Actual Expenses Total

Currency

Var. Est Expense vs Actual %

Var. Est Expense vs Actual %

Var. Est Expense vs Actual / Estimated Expense Total

Percent

Var. Est Hours vs Actual

Var. Est Hours vs Actual

Est. Hours - Actual Hours

Hours

Var. Est Hours vs Actual %

Var. Est Hours vs Actual %

Var. Est Hours vs Actual / Estimated Hours

Percent

Var. Est Rate vs Actual

Var. Est Rate vs Actual

Est. Rate - Actual Rate

Currency

Var. Est Rate vs Actual %

Var. Est Rate vs Actual %

Var. Est Rate vs Actual / Estimated Rate

Percent

Var. Est Time vs Actual

Var. Est Time vs Actual

Est. Time - Actual Time

Currency

Var. Est Time vs Actual %

Var. Est Time vs Actual %

Var. Est Time vs Actual / Estimated Time Total

Percent

Var. Est Total vs Actual

Var. Est Total vs Actual

Est. Total - Actual Total

Currency

Var. Est Total vs Actual %

Var. Est Total vs Actual %

Var. Est Total vs Actual / Estimated Total

Percent

Var. Invoiced Expense vs Billable

Var. Invoiced Expense vs Billable

Invoiced Expense - Billable Expense

Currency

Var. Invoiced Expense vs Billable %

Var. Invoiced Expense vs Billable %

Var. Invoiced Expense vs Billable / Invoiced Expense

Percent

Var. Invoiced Hours vs Billable

Var. Invoiced Hours vs Billable

Invoiced Hours - Billable Hours

Hours

Var. Invoiced Hours vs Billable %

Var. Invoiced Hours vs Billable %

Var. Invoiced Hours vs Billable / Invoiced Hours

Percent

Var. Invoiced Rate vs Billable

Var. Invoiced Rate vs Billable

Invoiced Rate - Billable Rate

Currency

Var. Invoiced Rate vs Billable %

Var. Invoiced Rate vs Billable %

Var. Invoiced Rate vs Billable / Invoiced Rate

Percent

Var. Invoiced Time vs Billable

Var. Invoiced Time vs Billable

Invoiced Time - Billable Time

Currency

Var. Invoiced Time vs Billable %

Var. Invoiced Time vs Billable %

Var. Invoiced Time vs Billable / Invoiced Time

Percent

Var. Invoiced Total vs Billable

Var. Invoiced Total vs Billable

Invoiced Total - Billable Total

Currency

Var. Invoiced Total vs Billable %

Var. Invoiced Total vs Billable %

Var. Invoiced Total vs Billable / Invoiced Total

Percent

Var. Prop. Expense vs Billable

Var. Prop. Expense vs Billable

Prop. Expense - Billable Expense

Currency

Var. Prop. Expense vs Billable %

Var. Prop. Expense vs Billable %

Var. Prop. Expense vs Billable / Proposed Expense Total

Percent

Var. Prop. Hours vs Billable

Var. Prop. Hours vs Billable

Prop. Hours - Billable Hours

Hours

Var. Prop. Hours vs Billable %

Var. Prop. Hours vs Billable %

Var. Prop. Hours vs Billable / Prop. Hours

Percent

Var. Prop. Rate vs Billable

Var. Prop. Rate vs Billable

Prop. Rate - Billable Rate

Currency

Var. Prop. Rate vs Billable %

Var. Prop. Rate vs Billable %

Var. Prop. Rate vs Billable / Prop. Rate

Percent

Var. Prop. Time vs Billable

Var. Prop. Time vs Billable

Prop. Time - Billable Time

Currency

Var. Prop. Time vs Billable %

Var. Prop. Time vs Billable %

Var. Prop. Time vs Billable / Prop. Time

Percent

Var. Prop. Total vs Billable

Var. Prop. Total vs Billable

Prop. Total - Billable Total

Currency

Var. Prop. Total vs Billable %

Var. Prop. Total vs Billable %

Var. Prop. Total vs Billable / Prop. Total

Percent

Var. Work Billable Expense vs Billable

Var. Work Billable Expense vs Billable

Work Billable Expense - Billable Expense

Currency

Var. Work Billable Expense vs Billable %

Var. Work Billable Expense vs Billable %

Var. Work Billable Expense vs Billable / Work Billable Expense

Percent

Var. Work Billable Rate vs Billable

Var. Work Billable Rate vs Billable

Work Billable Rate - Billable Rate

Currency

Var. Work Billable Rate vs Billable %

Var. Work Billable Rate vs Billable %

Var. Work Billable Rate vs Billable / Work Billable Rate

Percent

Var. Work Billable Time vs Billable

Var. Work Billable Time vs Billable

Work Billable Time - Billable Time

Currency

Var. Work Billable Time vs Billable %

Var. Work Billable Time vs Billable %

Var. Billable Time vs Billable / Work Total Time Billable

Percent

Var. Work Billable Total vs Billable

Var. Work Billable Total vs Billable

Work Billable Total - Billable Total

Currency

Var. Work Billable Total vs Billable %

Var. Work Billable Total vs Billable %

Var. Work Billable Total vs Billable / Work Billable Total

Percent

Var. Work Expense vs Actual

Var. Work Expense vs Actual

Work Expense vs Actual - Actual Expense

Currency

Var. Work Expense vs Actual %

Var. Work Expense vs Actual %

Var. Work Expense vs Actual / Work Expense

Percent

Var. Work Hours vs Actual

Var. Work Hours vs Actual

Work Hours - Actual Hours

Hours

Var. Work Hours vs Actual %

Var. Work Hours vs Actual %

Var. Work Hours vs Actual / Work Hours

Percent

Var. Work Hours Billable vs Billable

Var. Work Hours Billable vs Billable

Work Hours - Billable Hours

Hours

Var. Work Hours Billable vs Billable %

Var. Work Hours Billable vs Billable %

Var. Work Hours Billable vs Billable / Work Hours

Percent

Var. Work Rate vs Actual

Var. Work Rate vs Actual

Work Rate - Actual Rate

Currency

Var. Work Rate vs Actual %

Var. Work Rate vs Actual %

Var. Work Rate vs Actual / Work Rate

Percent

Var. Work Total Time vs Actual

Var. Work Total Time vs Actual

Work Total Time - Actual Time

Currency

Var. Work Total Time vs Actual %

Var. Work Total Time vs Actual %

Var. Work Total Time vs Actual / Work Total Time

Percent

Var. Work Total vs Actual

Var. Work Total vs Actual

Work Total - Actual Total

Currency

Var. Work Total vs Actual %

Var. Work Total vs Actual %

Var. Work Total vs Actual / Work Total

Percent

Work Billable Earned Value

Work Billable Earned Value

Total Work Billable Earned Value for all tasks in the project(s). Uses the work percent complete multiplied by hours and billable rates.

Currency

Work Billable Estimate At Completion

Work Billable Estimate At Completion

Total Work Billable Estimate At Completion for all tasks in the project(s). Actual Total + Work Billable Estimate To Complete

Currency

Work Billable Estimate At Completion (CPI)

Work Billable Estimate At Completion (CPI)

Work Billable Estimate At Completion divided by the Cost Performance Index. Assumes that the remaining billable work will be performed at the same level of efficiency (performance) as the completed billable work.

Currency

Work Billable Estimate At Completion (CPI) - Aggregated Weight

Work Billable Estimate At Completion (CPI) - Aggregated Weight

 

Currency

Work Billable Estimate To Complete

Work Billable Estimate To Complete

Work Billable Total - Work Billable Earned Value

Currency

Work Billable Expense

Work Billable Expense

Work Billable Expense total for all project tasks.

Currency

Work Billable Planned Hours

Work Billable Planned Hours

Total of all Work Billable Planned Hours for completion on all project(s) tasks through the previous working day.

Hours

Work Billable Planned Value

Work Billable Planned Value

Total of all Work Billable Planned Value for completion on all project(s) tasks through the previous working day.

Currency

Work Billable Rate

Work Billable Rate

Work Billable Time / Work Hours

Currency

Work Billable Total

Work Billable Total

Total Work Billable Time and Expenses for all tasks in the project(s). Work Billable Time + Work Billable Expense

Currency

Work Billable Time

Work Billable Time

Total Work Billable Time for all tasks in the project(s). The sum of the work hours multiplied by the billable rates for the resources assigned to the work.

Currency

Work Earned Value

Work Earned Value

Total of all Work Earned Value completed on all project(s) tasks. Based on the Work Hours and Work Rate multiplied by the Work Percent Complete on the project tasks.

Currency

Work Estimate At Completion

Work Estimate At Completion

Total Work Estimate At Completion for all project tasks. Work Estimate To Complete + Work Total

Currency

Work Estimate At Completion (CPI)

Work Estimate At Completion (CPI)

Total Work Estimate At Completion for all project tasks. Work Estimate To Complete + Work Total / Cost Performance Index

Currency

Work Estimate At Completion (CPI) - Aggregated Weight

Work Estimate At Completion (CPI) - Aggregated Weight

Total Work Estimate At Completion for all project tasks. Work Estimate To Complete + Work Total / Cost Performance Index

Currency

Work Estimate To Complete

Work Estimate To Complete

Work Total - Work Earned Value.

Currency

Work Expense

Work Expense

Total of all Work Expense for all tasks in the project(s).

Currency

Work Hours

Work Hours

Total Work Hours for all tasks in the project(s).

Hours

Work Hours Completed

Work Hours Completed

Total Work Hours Completed for all tasks in the project(s).

Hours

Work Hours Estimate At Completion

Work Hours Estimate At Completion

Total Work Hours Estimate At Completion for all project tasks. Work Hours Estimate To Complete + Actual Hours

Hours

Work Hours Estimate At Completion (CPI)

Work Hours Estimate At Completion (CPI)

Total Work Hours Estimate At Completion for all project tasks. Work Hours Estimate To Complete + Actual Hours / Cost Performance Index

Hours

Work Hours Estimate To Complete

Work Hours Estimate To Complete

Work Hours - Work Hours Completed

Hours

Work Hours Estimate To Complete (CPI) - Aggregated Weight

Work Hours Estimate To Complete (CPI) - Aggregated Weight

Hours

Work Planned Hours

Work Planned Hours

Total of all Work Planned Hours for completion on all project(s) tasks through the previous working day.

Hours

Work Planned Value

Work Planned Value

Total of all Work Planned Value for completion on all project(s) tasks through the previous working day.

Currency

Work Rate

Work Rate

Work Total Time / Work Hours

Currency

Work Time

Work Time

Total of all Work Time for all tasks in the project(s). Based on the Work Hours and the hourly rates of the resources assigned to the work.

Currency

Work Total

Work Total

Total of all Work Total for all tasks in the project(s). Work Time Total + Work Expense

Currency