Overview
The Time Entries dataset is the primary data source for building charts and dashboards related to service entries logged by both employees and vendors. It brings together the core details of each time entry, who logged it, what project and activity it was recorded against, how hours were categorized, and what billing and cost values were calculated, giving you a comprehensive view of time across your projects and resources.
This dataset is well-suited for analyzing billable utilization, workforce costs, invoice readiness, and approval workflow status. Whether you are tracking hours by employee, reviewing write-up/write-down impacts on bill amounts, or monitoring which entries remain unpaid, the Time Entries dataset provides the granular detail needed to support those analyses.
You can access this dataset in CORE Insights Dashboard Builder under the Data panel when creating or editing a chart.
Dataset Structure
This dataset uses a simple structure of one record per individual time entry. Both employee-logged and vendor-logged time entries are included.
Fields
| Type | Column | Description | Calculation |
|---|---|---|---|
| Category | Activity Item | The Activity ID associated with the activity for which this time entry was logged. | |
| Category | Activity Sub | The Activity Sub associated with the activity for which this time entry was logged. | |
| Category | Activity UID | The unique identifier of the activity associated with this time entry. | |
| Category | Activity_ID | The unique identifier of the activity associated with this time entry. | |
| Category | Approved By | The display name of the employee who approved this time entry. If the employee has a first or last name on record, the value displays as First Name + Last Name; otherwise, it displays the employee ID. | |
| Category | Approved Date | The date when this time entry was most recently approved. | |
| Category | Approved_By | The unique identifier of the employee who approved this time entry. | |
| Category | Assigned Approver | The display name of the employee assigned to approve this time entry. If the employee has a first or last name on record, the value displays as First Name + Last Name; otherwise, it displays the employee ID. | |
| Category | Billable Status | Indicates whether this time entry is billable. Values include Billable and Non-Billable. | |
| Category | Billed Status | Indicates the billing status of this time entry. Locked means the entry is included in an invoice batch. Billed means the entry appears on a draft or final invoice. Values include Unbilled, Locked, and Billed. | |
| Category | Class | The name of the accounting class associated with this time entry. | |
| Category | Client | The Client ID of the client associated with this time entry. | |
| Category | Client Invoice Date | The date of the invoice on which this time entry was billed. | |
| Category | Client Invoice Number | The invoice number of the invoice on which this time entry was billed. | |
| Category | Client Invoice Status | Indicates the billing status of the client invoice associated with this time entry. Locked means the entry is included in an invoice batch. Billed means the entry appears on a draft or final invoice. Values include Unbilled, Locked, and Billed. | |
| Category | Client UID | The unique identifier of the client associated with this time entry. | |
| Category | Contract Status | Indicates whether this time entry falls within the contract scope or outside of it. Values include Contract and Extra. | |
| Category | Created By | The display name of the employee who created this time entry. | |
| Category | Created By UID | The unique identifier of the employee who created this time entry. | |
| Category | Credit Card Number | The credit card number associated with this time entry, if applicable. | |
| Category | Currency | The currency used for this time entry. | |
| Category | Default Activity Group | The default group assigned to the activity associated with this time entry. | |
| Category | Default Client Group | The Group ID of the default group assigned to the client associated with this time entry. | |
| Category | Default Employee Group | The Group ID of the default group assigned to the employee associated with this time entry. | |
| Category | Default Project Group | The Group ID of the default group assigned to the project or phase associated with this time entry. | |
| Category | Default Vendor Group | Unique Identifier of the Client for this invoice. | |
| Category | Description | The description entered for this time entry. | |
| Category | Employee Class | The accounting class associated with the employee linked to this time entry. | |
| Category | Employee First Name | The first name of the employee associated with this time entry. | |
| Category | Employee Full Name | The full name of the employee associated with this time entry. If the employee has a first or last name on record, the value displays as First Name + Last Name; otherwise, it displays the employee ID. | |
| Category | Employee Last Name | The last name of the employee associated with this time entry. | |
| Category | Employee Manager | The display name of the employee manager associated with this time entry. If the manager has a first or last name on record, the value displays as First Name + Last Name; otherwise, it displays the employee ID. | |
| Category | Employee UID | The unique identifier of the employee associated with this time entry. | |
| Category | Employee_ID | The unique identifier of the employee for whom this time entry was logged. | |
| Category | End Time | The end time recorded for this time entry in HH:MM AM/PM format. | |
| Category | Entry Type | Indicates the type of entry. This value is always Time Entry. | |
| Category | Expense Account | The name of the general ledger expense account associated with this time entry. | |
| Category | Hours Type | Indicates whether the logged hours are Regular or Overtime hours. | |
| Category | Income Account | The name of the general ledger income account associated with this time entry. | |
| Category | Is Comp Time | Indicates whether this time entry is recorded as compensatory time. Values include Yes and No. | |
| Category | Manager UID | The unique identifier of the project manager associated with the project or phase for this time entry. | |
| Category | MaxLastUpdated_ TimeEntry | The latest updated timestamp across all related tables for this dataset. Used for incremental updates. | |
| Category | Memo | The memo entered for this time entry. | |
| Category | Paid Date | The date and time when this time entry was paid. | |
| Category | Parent Project UID | The unique identifier of the direct parent project or phase associated with this time entry. | |
| Category | Payment Status | Indicates whether this time entry has been paid. Values include Paid and Unpaid. | |
| Category | Pending Approver ID | The unique identifier of the employee currently assigned to review this time entry. This field only populates for submitted but not yet approved entries. | |
| Category | Project Display Name | The display name of the project or phase associated with this time entry. | |
| Category | Project Manager | The display name of the project manager associated with this time entry. If the manager has a first or last name on record, the value displays as First Name + Last Name; otherwise, it displays the employee ID. | |
| Category | Project Manager UID | The unique identifier of the project manager associated with this time entry. | |
| Category | Project Name | The name of the project or phase associated with this time entry. | |
| Category | Project Sort Order | The numeric value representing the project sort sequence. | |
| Category | Project UID | The unique identifier of the project or phase associated with this time entry. | |
| Category | Project_ID | The unique identifier of the project or phase for which this time entry was logged. | |
| Category | Resource | The logical resource name associated with this time entry. | |
| Category | Resource Company Name | The company name associated with the resource if the resource is a vendor. | |
| Category | Resource ID | The employee ID or vendor ID associated with this time entry. | |
| Category | Resource Status | The current status of the resource associated with this time entry. | |
| Category | Resource Title | The title of the resource associated with this time entry. | |
| Category | Resource Type | Indicates the type of resource associated with this time entry. Values include Vendor, Contract Employee, Outside Consultant, and Regular Employee. | |
| Category | Root Project Name | The display name of the root project associated with this time entry. | |
| Category | Root Project UID | The unique identifier of the root project associated with this time entry. | |
| Category | Start Time | The start time recorded for this time entry in HH:MM AM/PM format. | |
| Category | TE Classification | The classification, employee title, or blank value associated with this time entry. | |
| Category | Time Entry Date | The date on which this time entry was logged. | |
| Category | TimeEntry UID | The unique identifier of this time entry. | |
| Category | Vendor Bill Number | The vendor bill number associated with this time entry, if applicable. | |
| Category | Vendor Name | The display name of the vendor associated with this time entry. If the vendor has a first or last name on record, the value displays as First Name + Last Name; otherwise, it displays the vendor ID. | |
| Category | Vendor UID | The unique identifier of the vendor employee record associated with this time entry. | |
| Category | Vendor_ID | The unique identifier of the vendor associated with this time entry. | |
| Category | Workflow Status | Indicates the workflow status of this time entry. Values include Pending Submittal, Pending Approval, Unapproved, Approved, and Rejected. | |
| Value | Bill Amount | The amount billed or to be billed for this time entry. | Bill Rate × Client Hours × WUD Multiplier |
| Value | Bill Rate | The hourly billing rate associated with this time entry. Does not include the WUD multiplier. | |
| Value | Billable Value | The total billable value of this time entry if fully billed. | Bill Rate × Actual Hours |
| Value | Billed Amount | The amount already billed for this time entry. | Bill Rate × Client Hours × WUD Multiplier. |
| Value | Client Hours | The number of client hours billed or to be billed for this time entry. | |
| Value | Cost Amount | The loaded cost amount associated with this time entry. Calculated as Cost Rate × Actual Hours. | Cost Rate × Actual Hours. |
| Value | Cost Rate | The loaded hourly cost rate associated with this time entry. | |
| Value | Double OT | The double overtime value associated with this time entry. | |
| Value | Entry Amount | The total amount of this time entry. | Actual Hours × Bill Rate |
| Value | Hours | The actual number of hours worked and entered for this time entry. | |
| Value | Other Payroll | Indicates whether this time entry is associated with other payroll processing. | |
| Value | Overhead Multiplier | The overhead multiplier applied to the cost calculation for this time entry. | |
| Value | Purchase Tax | The purchase tax associated with this time entry. | |
| Value | Tax 1 % | The Tax 1 percentage applied to this time entry. | |
| Value | Tax 1 Amount | The Tax 1 amount calculated for this time entry. | Bill Rate × Client Hours × Tax 1 % × (WUD Multiplier - 1) |
| Value | Tax 2 % | The Tax 2 percentage applied to this time entry. | |
| Value | Tax 2 Amount | The Tax 2 amount calculated for this time entry. | Bill Rate × Client Hours × Tax 2 % × (WUD Multiplier - 1) |
| Value | Tax 3 % | The Tax 3 percentage applied to this time entry. | |
| Value | Tax 3 Amount | The Tax 3 amount calculated for this time entry. | Bill Rate × Client Hours × Tax 3 % × (WUD Multiplier - 1) |
| Value | WUD % | The percentage by which the bill amount for this time entry was written up or written down. | (WUD Multiplier - 1) × 100. |