Opportunities Prospect Roles

This table has 1 row per prospect role, per opportunity, per primary flag, and per org id.

Note: Because of the nature of contacts and leads in many objects, unusual prospect assignment may occur for multiple roles.

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.
CREATED_AT	Timestamp_NTZ	The date the prospect role was created in UTC datetime.		Can be used to dedupe rows for prospects with multiple roles to favor more recently created role mappings
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.		Count(1), count(id), and count(distinct id) are equivalent in a table without joins or groupings for a given bento & o_id.
IS_DELETED_IN_APP	Boolean	Is the latest dml_type "delete" or "backfill-delete".		Where is_deleted_in_app = false Only keeps undeleted rows.
OPPORTUNITY_ID	Varchar	The associated opportunity for this prospect role.		Maps to the OPPORTUNITIES table
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
PRIMARY	Boolean	A Boolean flag for "Is the prospect the primary contact?".		NULL can be assumed False
PROSPECT_ID	Varchar	The associated prospect in Outreach.		Maps to the PROSPECTS table
ROLE	Varchar	A categorical string for a role the prospect plays in the opportunity.	Buyer', 'Influencer', 'Champion'
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 the last time this record was updated.	2019-01-01 20:14:01:10	Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion.