Plugin Mappings
This table has 1 row per task and per org id.
IDs can be mapped to multiple objects either via merging or purposeful duplicates. Consult your CRM admin for further information on how you've integrated your plugin mappings. Additionally, JOINs against Plugin_Mappings from other tables should always declare the value_type in addition to the ID = value_id condition. See examples on the plugin_mappings sheet within this documentation.
| 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. | |
| 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. |
| ENABLED_AT | Timestamp_NTZ | The last time this object was enabled or null which indicates it's disabled. | ||
| EXTERNAL_ID | Varchar | The associated ID of the external plugin, typically a Salesforce or Dynamics ID. Uses long form non-case sensitive IDs when available. | 00T3o00005HkxfABC' | A single Outreach prospect_id may map to multiple External IDs. e.g.: select external_id from plugin_mappings where value_id = 5 and value_type = 'Prospect' --returns all salesforce/dynamic ids for prospect 5 in Outreach |
| EXTERNAL_TYPE | Varchar | The record type in the external plugin. | 'Contact', 'Lead', 'User', 'Task', 'Event', 'Account' | |
| 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. | Most commonly used on joins alongside other primary keys. where a.o_id = b.o_id and a.id = b.a_id | |
| PLUGIN_ID | Varchar | The corresponding plugin this mapping relates to. | Maps to the PLUGINS table. Can be used to differentiate sandbox and non sandbox mappings | |
| 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. | |
| VALUE_ID | Varchar | The associated internal Outreach ID. Maps to different tables based on value_type. | ||
| VALUE_TYPE | Varchar | The type of ID in the value_id field. | 'Prospect', 'User', 'Mailing' |