Harvest data warehouse table groups

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

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
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
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
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
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
project_details__client_id
Display name Client ID
Description The unique ID of the client
Field type dimension
Data type string.text.value
project_details__client_name
Display name Client name
Description The name of the client
Field type dimension
Data type string.text.value
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
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
project_details__created_at
Display name Created at
Description Date and time the project was created
Field type dimension
Data type string.time.datetime
project_details__currency
Display name Currency
Description The currency code associated with the project
Field type dimension
Data type string.currency.code
project_details__ends_on
Display name Ends on
Description Date the project will end
Field type dimension
Data type string.time.date
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
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
project_details__id
Display name Project ID
Description The unique ID of the project
Field type dimension
Data type string.text.value
project_details__is_active
Display name Is active
Description Whether the project is active or archived
Field type dimension
Data type bool
project_details__is_billable
Display name Is billable
Description Whether the project is billable or not
Field type dimension
Data type bool
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
project_details__name
Display name Project name
Description The name of the project
Field type dimension
Data type string.text.value
project_details__notes
Display name Notes
Description Project notes
Field type dimension
Data type string.text.value
project_details__starts_on
Display name Starts on
Description Date the project was started
Field type dimension
Data type string.time.date
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

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
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
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
team_details__created_at
Display name Created at
Description Date and time the user was created
Field type dimension
Data type string.time.datetime
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
team_details__email
Display name Email
Description The email address of the user
Field type dimension
Data type string.text.email
team_details__first_name
Display name First name
Description The first name of the user
Field type dimension
Data type string.text.value
team_details__id
Display name User ID
Description The unique ID of the user
Field type dimension
Data type string.text.value
team_details__is_active
Display name Is active
Description Whether the user is active or archived
Field type dimension
Data type bool
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
team_details__last_name
Display name Last name
Description The last name of the user
Field type dimension
Data type string.text.value
team_details__roles
Display name Roles
Description The role names assigned to this person
Field type dimension
Data type string.text.value
team_details__telephone
Display name Telephone
Description The user’s telephone number
Field type dimension
Data type string.text.phone
team_details__timezone
Display name Timezone
Description The user’s timezone
Field type dimension
Data type string.time.timezone
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
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date

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
time_entries__billable
Display name Billable
Description Whether or not the time entry is billable
Field type dimension
Data type bool
time_entries__billable_rate
Display name Billable rate
Description The billable rate for the time entry
Field type dimension
Data type float.number.ratio
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
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
time_entries__cost_rate
Display name Cost rate
Description The cost rate for the time entry
Field type dimension
Data type float.number.ratio
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
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
time_entries__entries
Display name Time entries
Description The number of time entries
Field type metric
Data type int.number.value
time_entries__hours
Display name Hours
Description The amount of hours clocked in the time entry
Field type metric
Data type float.number.value
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
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
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
time_entries__notes
Display name Notes
Description Notes attached to the time entry
Field type dimension
Data type string.text.value
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
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
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
time_entries__spent_date
Display name Spent date
Description Date of the time entry
Field type dimension
Data type string.time.date
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
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
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
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
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
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
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
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
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
today
Display name Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date