Data Dictionary
Field | Type | Notes |
Amount Paid | Number | API: Properties.hs_amount_paid |
Amount Remaining | Number | API: Properties.hs_amount_remaining |
Archived | Boolean | Derived from text_to_boolean Archived |
Associated Companies | JSON | A JSON array that holds the Company ID and Association Type of any Companies associated with this record. |
Associated Contacts | JSON | A JSON array that holds the Contact ID and Association Type of any Contacts associated with this record. |
Category | Text | API: Properties.hs_category |
Close Date | Datetime | Derived from text_to_timestamptz Properties.hs_close_date |
Company Name | Text | API: properties.name |
Connection Name | Text | The name of the Connection. Typically the name of the HubSpot Organisation., Derived from clean_name Connection Name |
Contact Name | Text | This is derived from the Firstname and Lastname, Derived from concat First Name and Last Name |
Created | Datetime | Derived from text_to_timestamptz Service.createdAt |
Created By | Integer | The Owner ID of the person that created the record. Find related details in the Owners table., Derived from text_to_owner_id Properties.hs_created_by_user_id |
Created Date | Date | The date that the record was created. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on., Derived from timestamptz_as_text_to_date Service.createdAt |
Custom Properties | JSON | Derived from handle_null_json Service.custom_properties |
Data current as of | Datetime | Gives the date and time that this record was taken from HubSpot. |
Description | Text | API: Properties.hs_description |
Internal URL | Text | The URL to the Service record - only available to those that have access to HubSpot., API: Service.url |
Next Activity Date | Datetime | Derived from text_to_timestamptz Properties.hs_next_activity_date |
Object Source | Text | API: Properties.hs_object_source |
Object Source Detail 1 | Text | API: Properties.hs_object_source_detail_1 |
Object Source Detail 2 | Text | API: Properties.hs_object_source_detail_2 |
Object Source Detail 3 | Text | API: Properties.hs_object_source_detail_3 |
Owner Assigned Date | Datetime | Hubspot Owner Assigned Date, Derived from text_to_timestamptz Properties.hubspot_owner_assigneddate |
Owner ID | Integer | The Owner of the Service. Find related details in the Owners table., Derived from text_to_bigint Properties.hubspot_owner_id |
Owner Name | Text | Derived from concat First Name and Last Name |
Pipeline ID | Text | API: Properties.hs_pipeline |
Pipeline Stage ID | Text | Derived from generate_hash Properties.hs_pipeline and Properties.hs_pipeline_stage |
Primary Company ID | Integer | If one exists, the Company ID for the primary Company associated with this record. Find related details in the Companies table., Derived from first_id Associated Companies |
Primary Contact ID | Integer | If one exists, the Contact ID for the primary Contact associated with this record. There may not be any associated Contact. Find related details in the Contacts table., Derived from first_id Associated Contacts |
Service ID | Integer | HubSpot's unique ID for the Service., Derived from text_to_bigint Service ID |
Service Name | Text | API: Properties.hs_name |
Service Status | Text | API: Properties.hs_status |
Stage ID | Text | API: Properties.hs_pipeline_stage |
Start Date | Datetime | Derived from text_to_timestamptz Start Date |
Tag IDs | Text | API: Properties.hs_tag_ids |
Tags | Text | API: Properties.hs_tags |
Target Duration | Interval | Derived from text_milliseconds_to_interval Properties.hs_target_duration |
Target End Date | Datetime | Derived from text_to_timestamptz Properties.hs_target_end_date |
Team ID | Text | API: Properties.hubspot_team_id |
Total Cost | Number | API: Properties.hs_total_cost |
Updated | Datetime | Derived from text_to_timestamptz Service.updatedAt |
Updated By | Integer | Derived from text_to_owner_id Properties.hs_updated_by_user_id |
Updated Date | Date | The date that the record was updated. This is useful so you can create a relationship with the Dates table, and analyze data over days, weeks, months and so on., Derived from timestamptz_as_text_to_date Service.updatedAt |
