---
title: "Harvest data warehouse table groups"
slug: "harvest-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Harvest. See all the tables and the fields included in them."
updated: 2026-03-05T14:16:47Z
published: 2026-03-05T14:16:47Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Harvest data warehouse table groups

Search fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### Table: PROJECT_DETAILS

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__bill_by** \| \| --- \| \| \\| Display name \\| Bill by \\| \\| --- \\| --- \\| \\| Description \\| The method by which the project is invoiced \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Bill by \| \| Description \| The method by which the project is invoiced \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__bill_by** |
| \| Display name \| Bill by \| \| --- \| --- \| \| Description \| The method by which the project is invoiced \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Bill by |
| Description | The method by which the project is invoiced |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__budget** \| \| --- \| \| \\| Display name \\| Budget \\| \\| --- \\| --- \\| \\| Description \\| The budget in hours for the project when budgeting by time \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Budget \| \| Description \| The budget in hours for the project when budgeting by time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| project_details__budget** |
| \| Display name \| Budget \| \| --- \| --- \| \| Description \| The budget in hours for the project when budgeting by time \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Budget |
| Description | The budget in hours for the project when budgeting by time |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| project_details__budget_by** \| \| --- \| \| \\| Display name \\| Budget by \\| \\| --- \\| --- \\| \\| Description \\| The method by which the project is budgeted \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Budget by \| \| Description \| The method by which the project is budgeted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__budget_by** |
| \| Display name \| Budget by \| \| --- \| --- \| \| Description \| The method by which the project is budgeted \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Budget by |
| Description | The method by which the project is budgeted |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__budget_is_monthly** \| \| --- \| \| \\| Display name \\| Budget is monthly \\| \\| --- \\| --- \\| \\| Description \\| Option to have the budget reset every month \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Budget is monthly \| \| Description \| Option to have the budget reset every month \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| project_details__budget_is_monthly** |
| \| Display name \| Budget is monthly \| \| --- \| --- \| \| Description \| Option to have the budget reset every month \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Budget is monthly |
| Description | Option to have the budget reset every month |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| project_details__client_id** \| \| --- \| \| \\| Display name \\| Client ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the client \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Client ID \| \| Description \| The unique ID of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__client_id** |
| \| Display name \| Client ID \| \| --- \| --- \| \| Description \| The unique ID of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Client ID |
| Description | The unique ID of the client |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__client_name** \| \| --- \| \| \\| Display name \\| Client name \\| \\| --- \\| --- \\| \\| Description \\| The name of the client \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Client name \| \| Description \| The name of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__client_name** |
| \| Display name \| Client name \| \| --- \| --- \| \| Description \| The name of the client \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Client name |
| Description | The name of the client |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__cost_budget** \| \| --- \| \| \\| Display name \\| Cost budget \\| \\| --- \\| --- \\| \\| Description \\| The monetary budget for the project when budgeting by money \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Cost budget \| \| Description \| The monetary budget for the project when budgeting by money \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| project_details__cost_budget** |
| \| Display name \| Cost budget \| \| --- \| --- \| \| Description \| The monetary budget for the project when budgeting by money \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Cost budget |
| Description | The monetary budget for the project when budgeting by money |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| project_details__cost_budget_include_expenses** \| \| --- \| \| \\| Display name \\| Cost budget include expenses \\| \\| --- \\| --- \\| \\| Description \\| Option for budget of Total Project Fees projects to include tracked expenses \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Cost budget include expenses \| \| Description \| Option for budget of Total Project Fees projects to include tracked expenses \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| project_details__cost_budget_include_expenses** |
| \| Display name \| Cost budget include expenses \| \| --- \| --- \| \| Description \| Option for budget of Total Project Fees projects to include tracked expenses \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Cost budget include expenses |
| Description | Option for budget of Total Project Fees projects to include tracked expenses |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| project_details__created_at** \| \| --- \| \| \\| Display name \\| Created at \\| \\| --- \\| --- \\| \\| Description \\| Date and time the project was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created at \| \| Description \| Date and time the project was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| project_details__created_at** |
| \| Display name \| Created at \| \| --- \| --- \| \| Description \| Date and time the project was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created at |
| Description | Date and time the project was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| project_details__currency** \| \| --- \| \| \\| Display name \\| Currency \\| \\| --- \\| --- \\| \\| Description \\| The currency code associated with the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.currency.code](/apidocs/field-data-types#currency) \\| \| \| Display name \| Currency \| \| Description \| The currency code associated with the project \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| project_details__currency** |
| \| Display name \| Currency \| \| --- \| --- \| \| Description \| The currency code associated with the project \| \| Field type \| dimension \| \| Data type \| [string.currency.code](/apidocs/field-data-types#currency) \| |
| Display name | Currency |
| Description | The currency code associated with the project |
| Field type | dimension |
| Data type | [string.currency.code](/apidocs/field-data-types#currency) |
| \| project_details__ends_on** \| \| --- \| \| \\| Display name \\| Ends on \\| \\| --- \\| --- \\| \\| Description \\| Date the project will end \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Ends on \| \| Description \| Date the project will end \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| project_details__ends_on** |
| \| Display name \| Ends on \| \| --- \| --- \| \| Description \| Date the project will end \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Ends on |
| Description | Date the project will end |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| project_details__fee** \| \| --- \| \| \\| Display name \\| Fee \\| \\| --- \\| --- \\| \\| Description \\| The amount you plan to invoice for the project. Only used by fixed-fee projects \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Fee \| \| Description \| The amount you plan to invoice for the project. Only used by fixed-fee projects \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| project_details__fee** |
| \| Display name \| Fee \| \| --- \| --- \| \| Description \| The amount you plan to invoice for the project. Only used by fixed-fee projects \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Fee |
| Description | The amount you plan to invoice for the project. Only used by fixed-fee projects |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| project_details__hourly_rate** \| \| --- \| \| \\| Display name \\| Hourly rate \\| \\| --- \\| --- \\| \\| Description \\| Rate for projects billed by Project Hourly Rate \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Hourly rate \| \| Description \| Rate for projects billed by Project Hourly Rate \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| project_details__hourly_rate** |
| \| Display name \| Hourly rate \| \| --- \| --- \| \| Description \| Rate for projects billed by Project Hourly Rate \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Display name | Hourly rate |
| Description | Rate for projects billed by Project Hourly Rate |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| project_details__id** \| \| --- \| \| \\| Display name \\| Project ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Project ID \| \| Description \| The unique ID of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__id** |
| \| Display name \| Project ID \| \| --- \| --- \| \| Description \| The unique ID of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Project ID |
| Description | The unique ID of the project |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__is_active** \| \| --- \| \| \\| Display name \\| Is active \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is active or archived \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is active \| \| Description \| Whether the project is active or archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| project_details__is_active** |
| \| Display name \| Is active \| \| --- \| --- \| \| Description \| Whether the project is active or archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is active |
| Description | Whether the project is active or archived |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| project_details__is_billable** \| \| --- \| \| \\| Display name \\| Is billable \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is billable or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is billable \| \| Description \| Whether the project is billable or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| project_details__is_billable** |
| \| Display name \| Is billable \| \| --- \| --- \| \| Description \| Whether the project is billable or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is billable |
| Description | Whether the project is billable or not |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| project_details__is_fixed_fee** \| \| --- \| \| \\| Display name \\| Is fixed fee \\| \\| --- \\| --- \\| \\| Description \\| Whether the project is a fixed-fee project or not \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is fixed fee \| \| Description \| Whether the project is a fixed-fee project or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| project_details__is_fixed_fee** |
| \| Display name \| Is fixed fee \| \| --- \| --- \| \| Description \| Whether the project is a fixed-fee project or not \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is fixed fee |
| Description | Whether the project is a fixed-fee project or not |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| project_details__name** \| \| --- \| \| \\| Display name \\| Project name \\| \\| --- \\| --- \\| \\| Description \\| The name of the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Project name \| \| Description \| The name of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__name** |
| \| Display name \| Project name \| \| --- \| --- \| \| Description \| The name of the project \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Project name |
| Description | The name of the project |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__notes** \| \| --- \| \| \\| Display name \\| Notes \\| \\| --- \\| --- \\| \\| Description \\| Project notes \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Notes \| \| Description \| Project notes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| project_details__notes** |
| \| Display name \| Notes \| \| --- \| --- \| \| Description \| Project notes \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Notes |
| Description | Project notes |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| project_details__starts_on** \| \| --- \| \| \\| Display name \\| Starts on \\| \\| --- \\| --- \\| \\| Description \\| Date the project was started \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Starts on \| \| Description \| Date the project was started \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| project_details__starts_on** |
| \| Display name \| Starts on \| \| --- \| --- \| \| Description \| Date the project was started \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Starts on |
| Description | Date the project was started |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| project_details__updated_at** \| \| --- \| \| \\| Display name \\| Updated at \\| \\| --- \\| --- \\| \\| Description \\| Date and time the project was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Updated at \| \| Description \| Date and time the project was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| project_details__updated_at** |
| \| Display name \| Updated at \| \| --- \| --- \| \| Description \| Date and time the project was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Updated at |
| Description | Date and time the project was last updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| today** \| \| --- \| \| \\| Display name \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| today** |
| \| Display name \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |

### Table: TEAM_DETAILS

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| team_details__avatar_url** \| \| --- \| \| \\| Display name \\| Avatar URL \\| \\| --- \\| --- \\| \\| Description \\| The URL to the user’s avatar image \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.url](/apidocs/field-data-types#text) \\| \| \| Display name \| Avatar URL \| \| Description \| The URL to the user’s avatar image \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| team_details__avatar_url** |
| \| Display name \| Avatar URL \| \| --- \| --- \| \| Description \| The URL to the user’s avatar image \| \| Field type \| dimension \| \| Data type \| [string.text.url](/apidocs/field-data-types#text) \| |
| Display name | Avatar URL |
| Description | The URL to the user’s avatar image |
| Field type | dimension |
| Data type | [string.text.url](/apidocs/field-data-types#text) |
| \| team_details__cost_rate** \| \| --- \| \| \\| Display name \\| Cost rate \\| \\| --- \\| --- \\| \\| Description \\| The cost rate to use for this user when calculating a project’s costs vs billable amount \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost rate \| \| Description \| The cost rate to use for this user when calculating a project’s costs vs billable amount \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| team_details__cost_rate** |
| \| Display name \| Cost rate \| \| --- \| --- \| \| Description \| The cost rate to use for this user when calculating a project’s costs vs billable amount \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Display name | Cost rate |
| Description | The cost rate to use for this user when calculating a project’s costs vs billable amount |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| team_details__created_at** \| \| --- \| \| \\| Display name \\| Created at \\| \\| --- \\| --- \\| \\| Description \\| Date and time the user was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Created at \| \| Description \| Date and time the user was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| team_details__created_at** |
| \| Display name \| Created at \| \| --- \| --- \| \| Description \| Date and time the user was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Created at |
| Description | Date and time the user was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| team_details__default_hourly_rate** \| \| --- \| \| \\| Display name \\| Default hourly rate \\| \\| --- \\| --- \\| \\| Description \\| The billable rate to use for this user when they are added to a project \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Default hourly rate \| \| Description \| The billable rate to use for this user when they are added to a project \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| team_details__default_hourly_rate** |
| \| Display name \| Default hourly rate \| \| --- \| --- \| \| Description \| The billable rate to use for this user when they are added to a project \| \| Field type \| metric \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Display name | Default hourly rate |
| Description | The billable rate to use for this user when they are added to a project |
| Field type | metric |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| team_details__email** \| \| --- \| \| \\| Display name \\| Email \\| \\| --- \\| --- \\| \\| Description \\| The email address of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.email](/apidocs/field-data-types#text) \\| \| \| Display name \| Email \| \| Description \| The email address of the user \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| team_details__email** |
| \| Display name \| Email \| \| --- \| --- \| \| Description \| The email address of the user \| \| Field type \| dimension \| \| Data type \| [string.text.email](/apidocs/field-data-types#text) \| |
| Display name | Email |
| Description | The email address of the user |
| Field type | dimension |
| Data type | [string.text.email](/apidocs/field-data-types#text) |
| \| team_details__first_name** \| \| --- \| \| \\| Display name \\| First name \\| \\| --- \\| --- \\| \\| Description \\| The first name of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| First name \| \| Description \| The first name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| team_details__first_name** |
| \| Display name \| First name \| \| --- \| --- \| \| Description \| The first name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | First name |
| Description | The first name of the user |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| team_details__id** \| \| --- \| \| \\| Display name \\| User ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User ID \| \| Description \| The unique ID of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| team_details__id** |
| \| Display name \| User ID \| \| --- \| --- \| \| Description \| The unique ID of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User ID |
| Description | The unique ID of the user |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| team_details__is_active** \| \| --- \| \| \\| Display name \\| Is active \\| \\| --- \\| --- \\| \\| Description \\| Whether the user is active or archived \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is active \| \| Description \| Whether the user is active or archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| team_details__is_active** |
| \| Display name \| Is active \| \| --- \| --- \| \| Description \| Whether the user is active or archived \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is active |
| Description | Whether the user is active or archived |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| team_details__is_contractor** \| \| --- \| \| \\| Display name \\| Is contractor \\| \\| --- \\| --- \\| \\| Description \\| The contractor status of the user associated with the reported hours \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is contractor \| \| Description \| The contractor status of the user associated with the reported hours \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| team_details__is_contractor** |
| \| Display name \| Is contractor \| \| --- \| --- \| \| Description \| The contractor status of the user associated with the reported hours \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is contractor |
| Description | The contractor status of the user associated with the reported hours |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| team_details__last_name** \| \| --- \| \| \\| Display name \\| Last name \\| \\| --- \\| --- \\| \\| Description \\| The last name of the user \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Last name \| \| Description \| The last name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| team_details__last_name** |
| \| Display name \| Last name \| \| --- \| --- \| \| Description \| The last name of the user \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Last name |
| Description | The last name of the user |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| team_details__roles** \| \| --- \| \| \\| Display name \\| Roles \\| \\| --- \\| --- \\| \\| Description \\| The role names assigned to this person \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Roles \| \| Description \| The role names assigned to this person \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| team_details__roles** |
| \| Display name \| Roles \| \| --- \| --- \| \| Description \| The role names assigned to this person \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Roles |
| Description | The role names assigned to this person |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| team_details__telephone** \| \| --- \| \| \\| Display name \\| Telephone \\| \\| --- \\| --- \\| \\| Description \\| The user’s telephone number \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.phone](/apidocs/field-data-types#text) \\| \| \| Display name \| Telephone \| \| Description \| The user’s telephone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| team_details__telephone** |
| \| Display name \| Telephone \| \| --- \| --- \| \| Description \| The user’s telephone number \| \| Field type \| dimension \| \| Data type \| [string.text.phone](/apidocs/field-data-types#text) \| |
| Display name | Telephone |
| Description | The user’s telephone number |
| Field type | dimension |
| Data type | [string.text.phone](/apidocs/field-data-types#text) |
| \| team_details__timezone** \| \| --- \| \| \\| Display name \\| Timezone \\| \\| --- \\| --- \\| \\| Description \\| The user’s timezone \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.timezone](/apidocs/field-data-types#time) \\| \| \| Display name \| Timezone \| \| Description \| The user’s timezone \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| team_details__timezone** |
| \| Display name \| Timezone \| \| --- \| --- \| \| Description \| The user’s timezone \| \| Field type \| dimension \| \| Data type \| [string.time.timezone](/apidocs/field-data-types#time) \| |
| Display name | Timezone |
| Description | The user’s timezone |
| Field type | dimension |
| Data type | [string.time.timezone](/apidocs/field-data-types#time) |
| \| team_details__updated_at** \| \| --- \| \| \\| Display name \\| Updated at \\| \\| --- \\| --- \\| \\| Description \\| Date and time the user was last updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Updated at \| \| Description \| Date and time the user was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| team_details__updated_at** |
| \| Display name \| Updated at \| \| --- \| --- \| \| Description \| Date and time the user was last updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Updated at |
| Description | Date and time the user was last updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| team_details__weekly_capacity** \| \| --- \| \| \\| Display name \\| Weekly capacity \\| \\| --- \\| --- \\| \\| Description \\| The number of hours per week this person is available to work in seconds, in half hour increments. For example, if a person’s capacity is 35 hours, the API will return 126000 seconds \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Weekly capacity \| \| Description \| The number of hours per week this person is available to work in seconds, in half hour increments. For example, if a person’s capacity is 35 hours, the API will return 126000 seconds \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| team_details__weekly_capacity** |
| \| Display name \| Weekly capacity \| \| --- \| --- \| \| Description \| The number of hours per week this person is available to work in seconds, in half hour increments. For example, if a person’s capacity is 35 hours, the API will return 126000 seconds \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Weekly capacity |
| Description | The number of hours per week this person is available to work in seconds, in half hour increments. For example, if a person’s capacity is 35 hours, the API will return 126000 seconds |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| today** \| \| --- \| \| \\| Display name \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| today** |
| \| Display name \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |

### Table: TIME_DETAILS

| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| --- |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__billable** \| \| --- \| \| \\| Display name \\| Billable \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the time entry is billable \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Billable \| \| Description \| Whether or not the time entry is billable \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| time_entries__billable** |
| \| Display name \| Billable \| \| --- \| --- \| \| Description \| Whether or not the time entry is billable \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Billable |
| Description | Whether or not the time entry is billable |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| time_entries__billable_rate** \| \| --- \| \| \\| Display name \\| Billable rate \\| \\| --- \\| --- \\| \\| Description \\| The billable rate for the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Billable rate \| \| Description \| The billable rate for the time entry \| \| Field type \| dimension \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| time_entries__billable_rate** |
| \| Display name \| Billable rate \| \| --- \| --- \| \| Description \| The billable rate for the time entry \| \| Field type \| dimension \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Display name | Billable rate |
| Description | The billable rate for the time entry |
| Field type | dimension |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| time_entries__client_id** \| \| --- \| \| \\| Display name \\| Client ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the client associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Client ID \| \| Description \| The unique ID of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__client_id** |
| \| Display name \| Client ID \| \| --- \| --- \| \| Description \| The unique ID of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Client ID |
| Description | The unique ID of the client associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__client_name** \| \| --- \| \| \\| Display name \\| Client name \\| \\| --- \\| --- \\| \\| Description \\| The name of the client associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Client name \| \| Description \| The name of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__client_name** |
| \| Display name \| Client name \| \| --- \| --- \| \| Description \| The name of the client associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Client name |
| Description | The name of the client associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__cost_rate** \| \| --- \| \| \\| Display name \\| Cost rate \\| \\| --- \\| --- \\| \\| Description \\| The cost rate for the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.number.ratio](/apidocs/field-data-types#number) \\| \| \| Display name \| Cost rate \| \| Description \| The cost rate for the time entry \| \| Field type \| dimension \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| time_entries__cost_rate** |
| \| Display name \| Cost rate \| \| --- \| --- \| \| Description \| The cost rate for the time entry \| \| Field type \| dimension \| \| Data type \| [float.number.ratio](/apidocs/field-data-types#number) \| |
| Display name | Cost rate |
| Description | The cost rate for the time entry |
| Field type | dimension |
| Data type | [float.number.ratio](/apidocs/field-data-types#number) |
| \| time_entries__created_at** \| \| --- \| \| \\| Display name \\| Time entry created at \\| \\| --- \\| --- \\| \\| Description \\| Date and time the time entry was created \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Time entry created at \| \| Description \| Date and time the time entry was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| time_entries__created_at** |
| \| Display name \| Time entry created at \| \| --- \| --- \| \| Description \| Date and time the time entry was created \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Time entry created at |
| Description | Date and time the time entry was created |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| time_entries__ended_time** \| \| --- \| \| \\| Display name \\| Ended time \\| \\| --- \\| --- \\| \\| Description \\| Time the time entry was ended if tracking by start/end times \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Ended time \| \| Description \| Time the time entry was ended if tracking by start/end times \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__ended_time** |
| \| Display name \| Ended time \| \| --- \| --- \| \| Description \| Time the time entry was ended if tracking by start/end times \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Ended time |
| Description | Time the time entry was ended if tracking by start/end times |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__entries** \| \| --- \| \| \\| Display name \\| Time entries \\| \\| --- \\| --- \\| \\| Description \\| The number of time entries \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Time entries \| \| Description \| The number of time entries \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| time_entries__entries** |
| \| Display name \| Time entries \| \| --- \| --- \| \| Description \| The number of time entries \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Time entries |
| Description | The number of time entries |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| time_entries__hours** \| \| --- \| \| \\| Display name \\| Hours \\| \\| --- \\| --- \\| \\| Description \\| The amount of hours clocked in the time entry \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Hours \| \| Description \| The amount of hours clocked in the time entry \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| time_entries__hours** |
| \| Display name \| Hours \| \| --- \| --- \| \| Description \| The amount of hours clocked in the time entry \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Hours |
| Description | The amount of hours clocked in the time entry |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| time_entries__hours_without_timer** \| \| --- \| \| \\| Display name \\| Hours without timer \\| \\| --- \\| --- \\| \\| Description \\| The amount of hours clocked in the time entry before the timer was last started \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Hours without timer \| \| Description \| The amount of hours clocked in the time entry before the timer was last started \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| time_entries__hours_without_timer** |
| \| Display name \| Hours without timer \| \| --- \| --- \| \| Description \| The amount of hours clocked in the time entry before the timer was last started \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Hours without timer |
| Description | The amount of hours clocked in the time entry before the timer was last started |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| time_entries__is_billed** \| \| --- \| \| \\| Display name \\| Is billed \\| \\| --- \\| --- \\| \\| Description \\| Whether or not the time entry has been marked as invoiced \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is billed \| \| Description \| Whether or not the time entry has been marked as invoiced \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| time_entries__is_billed** |
| \| Display name \| Is billed \| \| --- \| --- \| \| Description \| Whether or not the time entry has been marked as invoiced \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is billed |
| Description | Whether or not the time entry has been marked as invoiced |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| time_entries__is_project_manager** \| \| --- \| \| \\| Display name \\| Is project manager \\| \\| --- \\| --- \\| \\| Description \\| Determines if the user has Project Manager permissions for the project \\| \\| Field type \\| dimension \\| \\| Data type \\| [bool](/apidocs/field-data-types#primitive) \\| \| \| Display name \| Is project manager \| \| Description \| Determines if the user has Project Manager permissions for the project \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| time_entries__is_project_manager** |
| \| Display name \| Is project manager \| \| --- \| --- \| \| Description \| Determines if the user has Project Manager permissions for the project \| \| Field type \| dimension \| \| Data type \| [bool](/apidocs/field-data-types#primitive) \| |
| Display name | Is project manager |
| Description | Determines if the user has Project Manager permissions for the project |
| Field type | dimension |
| Data type | [bool](/apidocs/field-data-types#primitive) |
| \| time_entries__notes** \| \| --- \| \| \\| Display name \\| Notes \\| \\| --- \\| --- \\| \\| Description \\| Notes attached to the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Notes \| \| Description \| Notes attached to the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__notes** |
| \| Display name \| Notes \| \| --- \| --- \| \| Description \| Notes attached to the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Notes |
| Description | Notes attached to the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__project_id** \| \| --- \| \| \\| Display name \\| Project ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the project associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Project ID \| \| Description \| The unique ID of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__project_id** |
| \| Display name \| Project ID \| \| --- \| --- \| \| Description \| The unique ID of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Project ID |
| Description | The unique ID of the project associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__project_name** \| \| --- \| \| \\| Display name \\| Project name \\| \\| --- \\| --- \\| \\| Description \\| The name of the project associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Project name \| \| Description \| The name of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__project_name** |
| \| Display name \| Project name \| \| --- \| --- \| \| Description \| The name of the project associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Project name |
| Description | The name of the project associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__rounded_hours** \| \| --- \| \| \\| Display name \\| Rounded hours \\| \\| --- \\| --- \\| \\| Description \\| The amount of hours clocked in the time entry used in summary reports and invoices. This value is rounded according to the Time Rounding setting in your Preferences within Harvest \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Rounded hours \| \| Description \| The amount of hours clocked in the time entry used in summary reports and invoices. This value is rounded according to the Time Rounding setting in your Preferences within Harvest \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| time_entries__rounded_hours** |
| \| Display name \| Rounded hours \| \| --- \| --- \| \| Description \| The amount of hours clocked in the time entry used in summary reports and invoices. This value is rounded according to the Time Rounding setting in your Preferences within Harvest \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Rounded hours |
| Description | The amount of hours clocked in the time entry used in summary reports and invoices. This value is rounded according to the Time Rounding setting in your Preferences within Harvest |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| time_entries__spent_date** \| \| --- \| \| \\| Display name \\| Spent date \\| \\| --- \\| --- \\| \\| Description \\| Date of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Spent date \| \| Description \| Date of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| time_entries__spent_date** |
| \| Display name \| Spent date \| \| --- \| --- \| \| Description \| Date of the time entry \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Spent date |
| Description | Date of the time entry |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| time_entries__started_time** \| \| --- \| \| \\| Display name \\| Started time \\| \\| --- \\| --- \\| \\| Description \\| Time the time entry was started if tracking by start/end times \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Started time \| \| Description \| Time the time entry was started if tracking by start/end times \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__started_time** |
| \| Display name \| Started time \| \| --- \| --- \| \| Description \| Time the time entry was started if tracking by start/end times \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Started time |
| Description | Time the time entry was started if tracking by start/end times |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__task_assignment_hourly_rate** \| \| --- \| \| \\| Display name \\| Task assignment hourly rate \\| \\| --- \\| --- \\| \\| Description \\| Custom rate used when the project is billed by tasks \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Task assignment hourly rate \| \| Description \| Custom rate used when the project is billed by tasks \| \| Field type \| dimension \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| time_entries__task_assignment_hourly_rate** |
| \| Display name \| Task assignment hourly rate \| \| --- \| --- \| \| Description \| Custom rate used when the project is billed by tasks \| \| Field type \| dimension \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Task assignment hourly rate |
| Description | Custom rate used when the project is billed by tasks |
| Field type | dimension |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| time_entries__task_assignment_id** \| \| --- \| \| \\| Display name \\| Task assignment ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the task assignment \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Task assignment ID \| \| Description \| The unique ID of the task assignment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__task_assignment_id** |
| \| Display name \| Task assignment ID \| \| --- \| --- \| \| Description \| The unique ID of the task assignment \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Task assignment ID |
| Description | The unique ID of the task assignment |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__task_name** \| \| --- \| \| \\| Display name \\| Task name \\| \\| --- \\| --- \\| \\| Description \\| The name of the task associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Task name \| \| Description \| The name of the task associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__task_name** |
| \| Display name \| Task name \| \| --- \| --- \| \| Description \| The name of the task associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Task name |
| Description | The name of the task associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__time_entry_id** \| \| --- \| \| \\| Display name \\| Time entry ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Time entry ID \| \| Description \| The unique ID of the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__time_entry_id** |
| \| Display name \| Time entry ID \| \| --- \| --- \| \| Description \| The unique ID of the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Time entry ID |
| Description | The unique ID of the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__updated_at** \| \| --- \| \| \\| Display name \\| Time entry updated at \\| \\| --- \\| --- \\| \\| Description \\| Date and time the time entry was updated \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.datetime](/apidocs/field-data-types#time) \\| \| \| Display name \| Time entry updated at \| \| Description \| Date and time the time entry was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| time_entries__updated_at** |
| \| Display name \| Time entry updated at \| \| --- \| --- \| \| Description \| Date and time the time entry was updated \| \| Field type \| dimension \| \| Data type \| [string.time.datetime](/apidocs/field-data-types#time) \| |
| Display name | Time entry updated at |
| Description | Date and time the time entry was updated |
| Field type | dimension |
| Data type | [string.time.datetime](/apidocs/field-data-types#time) |
| \| time_entries__user_assignment_hourly_rate** \| \| --- \| \| \\| Display name \\| User assignment hourly rate \\| \\| --- \\| --- \\| \\| Description \\| Custom rate used when the project is billed by people and default rate is not being used \\| \\| Field type \\| dimension \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| User assignment hourly rate \| \| Description \| Custom rate used when the project is billed by people and default rate is not being used \| \| Field type \| dimension \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| time_entries__user_assignment_hourly_rate** |
| \| Display name \| User assignment hourly rate \| \| --- \| --- \| \| Description \| Custom rate used when the project is billed by people and default rate is not being used \| \| Field type \| dimension \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | User assignment hourly rate |
| Description | Custom rate used when the project is billed by people and default rate is not being used |
| Field type | dimension |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| time_entries__user_id** \| \| --- \| \| \\| Display name \\| User ID \\| \\| --- \\| --- \\| \\| Description \\| The unique ID of the user associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User ID \| \| Description \| The unique ID of the user associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__user_id** |
| \| Display name \| User ID \| \| --- \| --- \| \| Description \| The unique ID of the user associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User ID |
| Description | The unique ID of the user associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| time_entries__user_name** \| \| --- \| \| \\| Display name \\| User name \\| \\| --- \\| --- \\| \\| Description \\| The name of the user associated with the time entry \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| User name \| \| Description \| The name of the user associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| time_entries__user_name** |
| \| Display name \| User name \| \| --- \| --- \| \| Description \| The name of the user associated with the time entry \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | User name |
| Description | The name of the user associated with the time entry |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| today** \| \| --- \| \| \\| Display name \\| Today \\| \\| --- \\| --- \\| \\| Description \\| Today's date, e.g. 2017-01-31 \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Today \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| today** |
| \| Display name \| Today \| \| --- \| --- \| \| Description \| Today's date, e.g. 2017-01-31 \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Today |
| Description | Today's date, e.g. 2017-01-31 |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |