Project Report Data Reference – Project Insight Help Center

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 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

Related articles