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

Task Report Data Reference

Selector Box Field Name

Column Displayed As

Explanation

Unit

Actual End Date

Actual End Date

Actual End date as entered by the task owner.

Date

Actual Expense

Actual Expenses

Total expenses entered as Expense Entries.

Currency

Actual Hours

Actual Hours

Actual hours entered as Time Entries

Hours

Actual Rate

Actual Rate

Actual Time / Actual Hours

Currency

Actual Start Date

Actual Start Date

Actual Start date as entered by the task owner.

Date

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

Admin

Admin

Administrative

Icon with Click Function

Attachments

Attachments

Icon indicators to identify the existence of attached items.

Icon with Click Function

Auto-Rescheduling Type

Auto-Rescheduling Type

References an option which may be set to automatically change the task schedule under certain pre-defined conditions.

Text

Baseline Duration

Baseline Duration

Duration value from the current baseline.

Days, Hours and Minutes

Baseline End Date

Baseline End Date

End Date value from the current baseline.

Date

Baseline Start Date

Baseline Start Date

Start Date value from the current baseline.

Date

Baseline Work Hours

Baseline Work Hours

Work Hours value from the current 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 values.

Hours

Billable Rate

Billable Rate

Bill Rate for 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

Company Contract Default

Company Contract Default

Company Contract assigned to the task.

Text

Company Contract Default Number

Company Contract Default Number

Company Contract Number assigned to the task.

Text

Company Default

Company Default

Company assigned to the task.

Text

Constraint Date

Constraint Date

Date entered into the task as a constraint. Works relative to the Constraint Type.

Date

Constraint Type

Constraint Type

Type of constraint applied to the Constraint Date

Text

Deadline Date

Deadline Date

Date by which the task should be completed. Used as a reference date. Does not change the schedule as does a Constraint Type and Constraint Date.

Date

Description

Description

Task description for more verbose explanation of the task than would normally be contained within the task Name.

Text

Duration

Duration, hh mm

Working days as entered in the task(s). When calculating more than one task, the duration is the total number of working days in the work calendar between the start date of the task with the earliest start and the end date of the task with the latest finish.

Days, Hours and Minutes

Duration Delay

Duration Delay, hh mm

Working days delay used to change the task schedule with auto-rescheduling settings and tasks imported with resource leveling delays included.

Days, Hours and Minutes

Early End Date

Early End Date

Earliest possible end date for the task.

Date

Early Start Date

Early Start Date

Earliest possible start date for the task.

Date

End Date

End Date

End Date scheduled for the task.

Est. Expense

Est. Expense

Total costs estimated in Est. Expense for the task.

Currency

Est. Hours

Est. Hours

Total hours estimated in Est. Hours for the task.

Hours

Est. Rate

Est. Rate

Rate estimated in Est. Rate for the task.

Currency

Est. Time

Est. Time

Est. Rate x Est. Hours

Currency

Est. Total

Est. Total

Est. Time + Est. Expense

Currency

Forward Progress

Forward Progress

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

Date

Indicators

Indicators

Icon indicators to identify Health Parameters and Critical Tasks. Clicking icons will display pages with more detail as to why the icons are displayed.

Icon/Hyperlink

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

Rate on current invoices for Invoiced Hours

Currency

Invoiced Time Total

Invoiced Time Total

Total currency value of all Invoiced Hours

Currency

Invoiced Total

Invoiced Total

Invoiced Expense + Invoiced Time Total

Currency

Late End Date

Late End Date

Latest possible end date for the task.

Date

Late Start Date

Late Start Date

Latest possible start date for the task.

Date

Name

Name

Task Name.

Text

Number

Number

Task Number assigned sequentially to the task upon task entry. Cannot be changed.

Text

Number (Full)

Number (Full)

Displays both the project number and the task number separated by a decimal ProjectNumber.TaskNumber

Text

Percent Complete

Percent Complete

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

com; app

com - 100% complete task when checked; app - 100% completion status has been approved by a project manager.

Checkbox

Percent Complete (Duration)

Percent Complete Duration

Percent Complete based on the task schedule as opposed to the Work. In this calculation, a one-day duration task with one hour of work is weighted the same as a one-day duration task with eight hours of work.

Percent

Pred. By #

Pred. By #

Displays the predecessor task by (task) Number and allows data entry for predecessors by Number. Also allows for Predecessor Type (i.e. FS = Finish-to-Start) and lead/lag time as minus (-) and plus (+).

Number, Text and + or - designator (Comma Separated)

Predecessors

Predecessors

Task Names of all Tasks entered as Predecessors.

Text

Project

Project

The name of the project within which the task resides.

Text

Project Companies

Project Companies

The list of the Companies assigned to the Project.

Text

Project Company Contract Default

Project Company Contract Default

The Default Company Contract assigned to the Project.

Text

Project Company Contract Default Number

Project Company Contract Default Number

The Default Company Contract Number assigned to the Project.

Text

Project Company Contracts

Project Company Contracts

The list of the Company Contracts assigned to the Project.

Text

Project Company Default

Project Company Default

The Default Company assigned to the Project.

Text

Project Groups

Project Groups

The Groups assigned to the Project within which the task resides. This is NOT in reference to resource assignments.

Text

Project Managers

Project Managers

The resources assigned as Project Managers for the Project.

Text

Project Number

Project Number

Project Number assigned sequentially to the task upon task entry. Cannot be changed.

Text

Project Sponsor(s)

Project Sponsor(s)

The list of Sponsors assigned to the Project.

Text

Project State

Project State

The Project State assigned to the Project.

Text

Project Status

Project Status

The Project Status assigned to the Project.

Text

Project Status Comment (Last) Author

Project 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

Project Status Comment (Last) Comment

Project 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

Project Status Comment (Last) Type

Project 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

Project Type

Project Type

The Project Type assigned to the Project.

Text

Project Type Code

Project Type Code

The Project Type Code assigned to the Project.

Text

Prop. Expense

Prop. Expense

The Proposed Expense for the task.

Currency

Prop. Hours

Prop. Hours

The Proposed Hours for task.

Hours

Prop. Rate

Prop. Rate

The proposed rate as entered in the Prop. Rate for task.

Currency

Prop. Time

Prop. Time

Prop. Rate x Prop. Hours

Currency

Prop. Total

Prop. Total

Prop. Time + Prop. Expense

Currency

Resource Type/Role

Resource Type/Role

Resource Type/Role entered for the task

Text

Resource Type/Role Code

Resource Type/Role Code

Resource Type/Role Code associated with the Resource Type/Role as a Custom Code.

Text

Resources

Resources

Additional resources to the task owner who have also been assigned to a task

Text

Start Date

Start Date

Start Date scheduled for the Work

Date

Status Comment (Last) Author

Status Comment (Last) Author

The last (most recent) Task Status Comment Author posting the last (most recent) Task 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) Task Status Comment assigned to the task in the Task Detail 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) Task Status Comment Type assigned to the task in the Task Detail 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

Summary Task

Summary Task

The summary task Name within which the task is assigned.

Text

Task Owner

Task Owner

The primary resource responsible for updating the work completion percentage, actual start and actual end dates for the task.

Text

Task Summary Path

Task Summary Path

The complete path reference of all summary tasks within which the task resides.

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

Currrency

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 Total

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 Total

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 Total - Billable Time Total

Currency

Var. Invoiced Time vs Billable %

Var. Invoiced Time vs Billable %

Var. Invoiced Time vs Billable / Invoiced Time Total

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 Total

Currency

Var. Prop. Expense vs Billable %

Var. Prop. Expense vs Billable %

Var. Prop. Expense vs Billable / Prop. Expense

Percent

Var. Prop. Hours vs Billable

Var. Prop. Hours vs Billable

Var. Prop. Hours vs Billable

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 Total

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 Total

Currency

Var. Work Billable Expense Total vs Billable Expense Total %

Var. Work Billable Expense Total vs Billable Expense Total %

Var. Work Billable Expense vs Billable / Work Billable Expense Total

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 Total vs Billable

Var. Work Billable Time Total vs Billable

Work Billable Time Total - Billable Time Total

Currency

Var. Work Billable Time Total vs Billable %

Var. Work Billable Time Total vs Billable %

Var. Billable Time Total vs Billable / Work Total Time Billable

Percent

Var. Work Billable Total Cost vs Billable

Var. Work Billable Total Cost vs Billable

Work Billable Total Cost - Billable Total

Currency

Var. Work Billable Total Cost vs Billable %

Var. Work Billable Total Cost vs Billable %

Var. Work Billable Total Cost vs Billable / Work Billable Total Cost

Percent

Var. Work Expense Total vs Actual

Var. Work Expense Total vs Actual

Work Expense Total vs Actual - Actual Expense Total

Currency

Var. Work Expense Total vs Actual %

Var. Work Expense Total vs Actual %

Var. Work Expense Total vs Actual / Work Expense Total

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 Total

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 Cost vs Actual

Var. Work Total Cost vs Actual

Work Total Cost - Actual Total

Currency

Var. Work Total Cost vs Actual %

Var. Work Total Cost vs Actual %

Var. Work Total Cost vs Actual / Work Total Cost

Percent

WBS

WBS

The WBS code entered for the task. May optionally be auto-calculated.

Text

Work Billable Earned Value

Work Billable Earned Value

Work Hours Completed x Billable Rate

Currency

Work Billable Estimate At Completion

Work Billable Estimate At Completion

Actual Total + Work Billable Estimate To Complete

Currency

Work Billable Estimate At Completion (CPI)

Work Bill. Est. 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 Expense

Work Billable Expense

Total Billable Work Expense entered for the task.

Currency

Work Billable Planned Hours

Work Billable Planned Hours

Total Work Billable Planned Hours for completion the task through the previous working day.

Hours

Work Billable Planned Value

Work Billable Planned Value

Work Billable Planned Hours x Billable Rate

Currency

Work Billable Rate

Work Billable Rate

Work Billable Time / Work Hours

Currency

Work Billable Total

Work Billable Total

Work Billable Time + Work Billable Expense

Currency

Work Billable Time

Work Billable Time

Work Hours x Work Billable Rate

Currency

Work Calendar

Work Calendar

The Work Calendar for the task. It is usually the Project Default calendar.

Text

Work Earned Value

Work Earned Value

Work Hours x Burden Rate x Percent Complete

Currency

Work Estimate At Completion

Work Estimate At Completion

Work Estimate To Complete + Work Total

Currency

Work Estimate At Completion (CPI)

Work Estimate At Completion (CPI)

Work Estimate To Complete + Work Total / Cost Performance Index

Currency

Work Expense

Work Expense

Total Work Expense entered for the task.

Currency

Work Hours

Work Hours

Total Work as entered in the task.

Hours

Work Hours Completed

Work Hours Completed

Work x Percent Complete

Hours

Work Hours Estimate At Completion

Work Hours Estimate At Completion

Work Hours Estimate To Complete + Actual Hours

Hours

Work Hours Estimate At Completion (CPI)

Work Hours Estimate At Completion (CPI)

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 Remaining

Work Hours Remaining

Work Hours - Work Hours Completed

Hours

Work Planned Hours

Work Planned Hours

Work hours planned for completion through the previous working day.

Hours

Work Planned Value

Work Planned Value

Worked Planned Hours x Work Rate

Currency

Work Rate

Work Rate

Work Time / Work Hours

Currency

Work Time Total

Work Time

Sum total of Work Hours x Work Rate for all assigned resources.

Currency

Work Total Cost

Work Total

Work Time + Work Total Expense

Currency