Custom Reports Datasets Cheat Sheet: Traffic
Allocated Hours Data | Task Assignment Data | Task Assignment Weekly Data | Time Detail Data | Time Detail Data (no costs) | Time Detail Data (with Employee custom fields)
Allocated Hours Data
Account Manager
Active
Actual Completion Date
Actual Hours
Actual Start Date
Allocated Hours
Approved Change Order Gross Expense
Approved Change Order Hours
Approved Change Order Labor
Baseline Completion Date
Baseline Start Date
Budgeted Hours
Campaign Name
Campaign Segment
Class ID
Class Name
Client Full Name
Client ID
Client Name
Client Project Number
Company ID
Company Name
Department
Estimate Total
Estimate Total Gross Expense
Line Number
Office
Original Budget Gross Expense
Original Budget Hours
Original Budget Labor
Original Budget Net Expense
Percentage Complete
Plan Completion Date
Plan Start Date
Project Billing Status
Project Due Date
Project Name
Project Number
Project Start Date
Project Status
Project Status Description
Project Status Note
Project Type
Role
Summary Task Full Name
Summary Task ID
Summary Task Line Number
Summary Task Name
Task Description
Task Hourly Rate
Task ID
Task Name
Task Priority
Task Taxable
Task Type
Track Budgets
Track Schedules
User First Name
User Full Name
User Last Name
Task Assignment Data
Account Manager
Active
Actual Completion Date
Actual Start Date
Actual Task Assignment Labor Hours
Actual Task Assignment Labor Total
Actual Task Labor Hours
Actual Task Labor Total
All Assigned People
All Assigned People Full Name
Allocated Hours
Approved Change Order Gross Expense
Approved Change Order Hours
Approved Change Order Labor
Assigned User
Assignment Actual Completion Date
Assignment Actual Start Date
Assignment Comments
Assignment Duration
Assignment Percentage Complete
Assignment Plan Completion Date
Assignment Plan Start Date
Assignment Subject
Assignment Work Order
Baseline Completion Date
Baseline Start Date
Billing Contact
Campaign ID
Campaign Name
Campaign Segment
Class ID
Class Name
Client Division
Client Division ID
Client ID
Client Name
Client Product
Client Product ID
Client Project Number
Company ID
Company Name
Constraint
Created Date
Date Task Assigned
Default GLCompany Full Name
Default GLCompany ID
Default Service
Description of Assignment
Description of Work
Due By
Exclude From Status
Key People 1
Key People 2
Key People 3
Key People 4
Key People 5
Key People 6
Office
Open To Do Items
Original Budget Gross Expense
Original Budget Hours
Original Budget Labor
Original Budget Net Expense
Percentage Complete
Plan Completion Date
Plan Start Date
Predecessors Completed
Project Billing Status
Project Close Date
Project Due Date
Project Full Name
Project Name
Project Number
Project Start Date
Project Status
Project Status Description
Project Status Note
Project Type
Role
Row
Service
Summary Task ID
Summary Task Name
Summary Taxable
Summary Taxable 2
Task Days
Task Description
Task ID
Task Name
Task Priority
Task Taxable
Task Taxable 2
Task Type
Team Name
Time Approver
Time Completed
Time Completed By
Timeline Segment
Title
Track Budgets
Track Schedules
User Department
Task Assignment Weekly Data
NOTE: Some fields have specific calculations behind them.
Week Hours = This field is the focus of this report. It shows what is in the weekly buckets of the Task Assignments. And mimics what you can see in the Staff Schedule when in Week view. This means going forward it shows the allocated hours for that week, but in the past it is replaced with the Actual Hours of that week (and any time entries entered prior to the first week or the task).
"Month" Hours (i.e. January Hours) = Hours for the Weeks where Monday starts in that month. The Weekly buckets are Mon-Sun. For example, if the 1st of the month is a Sunday, then those hours will not be part of the month that Sunday is in and instead will be part of the prior months hours.
Actual Task Assignment Week Labor Hours = The weeks actual hours for that assignment.
Actual Task Assignment Labor Hours = Total actual hours for that assignment.
Allocated Hours = Total hours allocated to that assignment.
Week Start Date = Tasks that are "In Progress" for that week.
Account Manager
Active
Actual Completion Date
Actual Start Date
Actual Task Assignment Labor Hours
Actual Task Assignment Labor Total
Actual Task Labor Hours
Actual Task Labor Total
Adjustment Type
All Assigned People
Allocated Hours
Approved Change Order Gross Expense
Approved Change Order Labor
April Hours
Assigned User
Assignment Actual Completion Date
Assignment Actual Start Date
Assignment Comments
Assignment Duration
Assignment Percentage Complete
Assignment Plan Completion Date
Assignment Plan Start Date
Assignment Subject
Assignment Work Order
August Hours
Baseline Completion Date
Baseline Start Date
Billing Contact
Campaign ID
Campaign Name
Campaign Segment
Class ID
Client Name
Client Product
Client Product ID
Client Project Number
Company ID
Company Name
Constraint
CustomFieldKey2
Date Task Assigned
December Hours
Default GLCompany ID
Default Service
Description of Work
Due By
Exclude From Status
February Hours
January Hours
July Hours
June Hours
Key People 1
Key People 2
Key People 3
Key People 4
Key People 5
Key People 6
March Hours
May Hours
November Hours
October Hours
Office
Original Budget Gross Expense
Original Budget Hours
Original Budget Labor
Original Budget Net Expense
Percentage Complete
Plan Completion Date
Plan Start Date
Predecessors Completed
Project Billing Status
Project Close Date
Project Due Date
Project Full Name
Project Name
Project Number
Project Start Date
Project Status
Project Status Description
Project Status Note
Project Type
Role
Row
September Hours
Service
Summary Task ID
Summary Task Name
Summary Taxable
Summary Taxable 2
Task Days
Task Description
Task ID
Task Name
Task Priority
Task Taxable
Task Taxable 2
Task Type
Team Name
Time Completed
Time Completed By
Timeline Segment
Title
Track Budgets
Track Schedules
User Department
Week Gross
Week Hours
Week Net
Week Rate
Week Start Date
Year
Time Detail Data
NOTE: This reports one row per Time Entry. So if no time has been entered to a task or allocated assignment, then there is no data to pull.
Account Manager
Active Project
Actual Billable Amount
Actual Billable Hours
Actual Billing Rate
Actual Cost Rate
Actual Hours Worked
Actual Net Profit
Actual Non Billable Amount
Actual Non Billable Hours
Actual Total Cost
Approval Status
Approved By
Assignment Full Name
Assignment ID
Assignment Subject
Billed Comments
Billed Difference
Billed Hours
Billed Net Profit
Billed Rate
Billed Service Code
Billed Total Amount
Billing Item ID
Billing Item Name
Billing Status
Budget Hours
Campaign ID
Campaign Name
Campaign Segment
Class ID
Class Name
Client Company Type
Client Division
Client ID
Client Name
Client Product
Client Project Number
Comments
Company ID
Company Name
Current Approver
Date and Time Approved
Date and Time Created
Date and Time Submitted
Date Approved
Date Billed
Date Created
Date Submitted For Approval
Date Worked
Date Worked Month
Date Worked Month Formatted
Date Worked Week
Date Worked Year
Date Worked Year Formatted
Default GL Company Name
Default GL Company ID
Downloaded
End Date Time
End Time
Home Address 1
Home Address 2
Home Address 3
Home Address City
Home Address Country
Home Address Postal Code
Home Address State
Invoice Number
Line Number
Marked Billed Hours
Marked Billed Total
Non Billable Project
Other Address 1
Other Address 2
Other Address 3
Other Address City
Other Address Country
Other Address Postal Code
Other Address State
Parent Company
Posted Into WIP
Posted Out Of WIP
Project Amount Billed
Project Billing Method
Project Billing Status
Project Budget Hours
Project Budget Labor Gross
Project Due Date
Project Full Name
Project Name
Project Number
Project Office Name
Project Primary Contact
Project Start Date
Project Status
Project Total Budget
Project Total Budget wo Taxes
Project Type
Retainer Name
Service Code
Service Description
Service Rate Level
Start Date Time
Start Time
Task Description
Task Full Name
Task ID
Task Name
Task Type
Timesheet From
Timesheet To
Transferred Out
User Company Name
User Department
User First Name
User Full Name
User Last Name
User Office Name
User System ID
Verified
Write Off Hours
Write Off Reason
Write Off Total
Time Detail Data (no costs)
Account Manager
Active Project
Actual Billable Amount
Actual Billable Hours
Actual Billing Rate
Actual Hours Worked
Actual Non Billable Amount
Actual Non Billable Hours
Approval Status
Approved By
Assignment Full Name
Assignment ID
Assignment Subject
Billed Difference
Billed Hours
Billed Rate
Billed Service Code
Billed Total Amount
Billing Item ID
Billing Item Name
Billing Status
Budget Hours
Campaign ID
Campaign Name
Campaign Segment
Client Company Type
Client Division
Client ID
Client Name
Client Product
Client Project Number
Comments
Company ID
Company Name
Current Approver
Date and Time Approved
Date and Time Created
Date and Time Submitted
Date Approved
Date Billed
Date Created
Date Submitted For Approval
Date Worked
Date Worked Month
Date Worked Month Formatted
Date Worked Week
Date Worked Year
Date Worked Year Formatted
Downloaded
End Date Time
End Time
Invoice Number
Line Number
Marked Billed Hours
Marked Billed Total
Non Billable Project
Parent Company
Posted Into WIP
Posted Out Of WIP
Project Amount Billed
Project Billing Method
Project Budget Hours
Project Budget Labor Gross
Project Due Date
Project Full Name
Project Name
Project Number
Project Office Name
Project Primary Contact
Project Start Date
Project Status
Project Total Budget
Project Total Budget wo Taxes
Project Type
Service Code
Service Description
Service Rate Level
Start Date Time
Start Time
Task Description
Task Full Name
Task ID
Task Name
Task Type
Timesheet From
Timesheet To
Title
Transferred Out
User Company Name
User Department
User First Name
User Full Name
User Last Name
User Office Name
User System ID
Verified
Write Off Hours
Write Off Reason
Write Off Total
Time Detail Data (with Employee custom fields)
Account Manager
Active Project
Actual Billable Amount
Actual Billable Hours
Actual Billing Rate
Actual Cost Rate
Actual Hours Worked
Actual Net Profit
Actual Non Billable Amount
Actual Non Billable Hours
Actual Total Cost
Approval Status
Approved By
Assignment Full Name
Assignment ID
Assignment Subject
Billed Difference
Billed Hours
Billed Net Profit
Billed Rate
Billed Service Code
Billed Total Amount
Billing Item ID
Billing Item Name
Billing Status
Campaign ID
Campaign Name
Campaign Segment
Class ID
Class Name
Client Company Type
Client Division
Client ID
Client Name
Client Product
Client Project Number
CO Budget Expense Gross
CO Budget Expense Net
CO Budget Hours
CO Budget Labor Gross
CO Budget Labor Net
Comments
Company ID
Company Name
Current Approver
Current Budget Expense Gross
Current Budget Hours
Current Budget Labor Gross
Current Total Budget
Current Total Budget wo Taxes
Date and Time Approved
Date and Time Created
Date and Time Submitted
Date Approved
Date Billed
Date Created
Date Submitted For Approval
Date Worked
Date Worked Month
Date Worked Month Formatted
Date Worked Week
Date Worked Year
Date Worked Year Formatted
Default GL Company Full Name
Default GL Company ID
Downloaded
End Date Time
End Time
Estimate Profit
Home Address 1
Home Address 2
Home Address 3
Home Address City
Home Address Country
Home Address Postal Code
Home Address State
Invoice Number
Line Number
Marked Billed Hours
Marked Billed Total
Non Billable Project
Original Budget Expense Gross
Original Budget Expense Net
Original Budget Hours
Original Budget Labor Gross
Original Budget Labor Net
Other Address 1
Other Address 2
Other Address 3
Other Address City
Other Address Country
Other Address Postal Code
Other Address State
Parent Company
Posted Into WIP
Posted Out Of WIP
Project Amount Billed
Project Billing Method
Project Billing Status
Project Budget Hours
Project Budget Labor Gross
Project Due Date
Project Full Name
Project Name
Project Number
Project Office Name
Project Primary Contact
Project Start Date
Project Status
Project Total Budget
Project Total Budget wo Taxes
Project Type
Retainer Name
Service Code
Service Description
Service Rate Level
Start Date Time
Start Time
Task Description
Task Full Name
Task ID
Task Name
Task Type
Timesheet From
Timesheet To
Transferred Out
User Company Name
User Department
User First Name
User Full Name
User Last Name
User Office Name
User System ID
Verified
Work Address 1
Work Address 2
Work Address 3
Work Address City
Work Address Country
Work Address Postal Code
Work Address State
Write Off Hours
Write Off Reason
Write Off Total