Meeting Attributions
This table has 1 row per meeting attribution and per org id.
| Column | Type | Definition | Sample Value(s) | Sample Use |
|---|---|---|---|---|
| BENTO | Varchar | A collection of machines that power the Outreach app. Orgs live inside these. | This may distinguish orgs that are in different data centers. | |
| CALENDAR_EVENT_ID | Number | The ID of the calendar event is associated with. | ||
| CREATED_AT | Timestamp_NTZ | The date and time the sequence template was created. | ||
| DML_AT | Timestamp_NTZ | A datetime (local to server) in which the row was last modified. dml_at can be used to identify updated and new records, but as tables may not see changed records every day, it is not authoritative on when the table was last synced. | 2019-01-01 12:14:01:10 | Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days. |
| DML_TYPE | Varchar | The type of manipulation that last occurred to a row. | 'update', 'delete', 'insert', 'backfill', 'backfill-delete' | Where dml_type <> 'delete' Excludes deleted rows. |
| ID | Varchar | Represents an individual row of data in a table. Fields in other tables that match to this ID will be called thisTable_id. e.g. ID in the calls table will appear as the call_id in another table. | ||
| IS_DELETED_IN_APP | Boolean | Is the latest dml_type "delete" or "backfill-delete". | Where is_deleted_in_app = false Only keeps undeleted rows. | |
| O_ID | Varchar | Organization ID, also called instance ID. This is the ID for your unique Outreach account. | ||
| SEQUENCE_ID | Varchar | The associated sequence ID for this Meeting attribution | ||
| SEQUENCE_STEP_ID | Varchar | The associated sequence step ID for the Meeting Attribution | ||
| SEQUENCE_STATE_ID | Varchar | The associated sequence state ID for the Meeting Attribution | ||
| SEQUENCE_TEMPLATE_ID | Varchar | The template used for this sequence template | ||
| SURROGATE_ID | Varchar | An md5 hash of bento, o_id and ID for a table. | This can be used to get distinct counts of records if an account has more than 1 org instance. Two orgs will both have a prospect with ID of "1" but each will have a different surrogate ID. | |
| UPDATED_AT | Timestamp_NTZ | The UTC datetime for when this sequence template was updated. |