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.

ColumnNameDefinitionSample Value(s)Sample Use
BENTOVarcharA collection of machines that power the Outreach app. Orgs live inside these.This may distinguish orgs that are in different data centers.
DML_ATTimestamp_NTZA 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:10Where dml_at::date >= current_date-7 This will return all rows modified in the last 7 days.
DML_TYPEVarcharThe type of manipulation that last occurred to a row.'update', 'delete', 'insert', 'backfill', 'backfill-delete'Where dml_type <> 'delete' Excludes deleted rows.
ENABLED_ATTimestamp_NTZThe last time this object was enabled or null which indicates it's disabled.
EXTERNAL_IDVarcharThe 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_TYPEVarcharThe record type in the external plugin.'Contact', 'Lead', 'User', 'Task', 'Event', 'Account'
IS_DELETED_IN_APPBooleanIs the latest dml_type "delete" or "backfill-delete".Where is_deleted_in_app = false Only keeps undeleted rows.
O_IDVarcharOrganization ID, also called instance ID. This hashed string reflects a specific Outreach app instance within a bento. 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 = b.a_id
PLUGIN_IDVarcharThe corresponding plugin this mapping relates to.Maps to the PLUGINS table. Can be used to differentiate sandbox and non sandbox mappings
SURROGATE_IDVarcharAn 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_IDVarcharThe associated internal Outreach ID. Maps to different tables based on value_type.
VALUE_TYPEVarcharThe type of ID in the value_id field. 'Prospect', 'User', 'Mailing'