# Goals ## Documentation The goals set for users, teams and the company. Each request costs 20 tokens of the daily budget of the company. - Catalog: `Pipedrive` - Schema: `Goals` - Primary Keys: `id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Goals` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `assignee_id` | `int64` | | ☐ | The ID of the goal assignee. | | `assignee_type` | `varchar2` | | ☐ | The type of the assignee. | | `assignee` | `varchar2` | | ☐ | Who this goal is assigned to. Only taken when writing; empty when read. | | `duration_end` | `varchar2` | | ☐ | The end date of the goal. | | `duration_start` | `varchar2` | | ☐ | The start date of the goal. | | `duration` | `varchar2` | | ☐ | The date when the goal starts and ends. Only taken when writing; empty when read. | | `expected_outcome_target` | `int64` | | ☐ | The numeric target of the goal. | | `expected_outcome_tracking_metric` | `varchar2` | | ☐ | The tracking metric of the goal. | | `expected_outcome` | `varchar2` | | ☐ | The expected outcome of the goal. Only taken when writing; empty when read. | | `id` | `varchar2` | | ☑ | The ID of the goal. | | `interval` | `varchar2` | | ☐ | The interval of the goal. | | `is_active` | `char` | | ☐ | Whether the goal is currently active or not. | | `owner_id` | `int64` | | ☐ | The ID of the creator of the goal. | | `report_ids` | `varchar2` | | ☐ | The IDs of the reports that belong to the goal. | | `title` | `varchar2` | | ☐ | The title of the goal. | | `type_name` | `varchar2` | | ☐ | The name of the goal type. | | `type_params` | `varchar2` | | ☐ | The parameters that accompany the goal type. | | `type` | `varchar2` | | ☐ | The type of the goal. Only taken when writing; empty when read. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `owner_id` | [[Users-Users\|Users.Users]] | `id` | Declared by the connector, not enforced by the platform |