This table has 1 row per call and per org id.

Many timestamps will be blank for manually logged calls. Calls completed via Outreach will be the most detail rich.

ColumnNameDefinitionSample Value(s)Sample Use
ANSWERED_ATTimestamp_NTZThe UTC datetime that the phone call finished ringing and connected. This includes voicemails.
BENTOVarcharA collection of machines that power the Outreach app. Orgs live inside these.This may distinguish orgs that are in different data centers.
CALLEE_HELDBooleanA Boolean value for if the dialer put the call on hold.
CALL_DISPOSITION_IDVarcharMaps a call outcome to a disposition in the CALL_DISPOSITIONS table.
CALL_PURPOSE_IDVarcharMaps a call to the reason for the call in the CALL_PURPOSES table.
COMPLETED_ATTimestamp_NTZThe UTC datetime for when the call was hung up.The difference between answered_at and completed_At is call duration!
CREATED_ATTimestamp_NTZThe UTC datetime for when a call was recorded. For most calls this is synonymous with dialed_at.
DIALED_ATTimestamp_NTZThe UTC datetime for when the user clicked "dial" in the app.
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.
EXTERNAL_VENDORVarcharIf a call service was used, it will show the provider name. If manually logged it will be NULL.
FROMVarcharThe phone number that initiated the call. For inbound calls this is the prospects phone #.
IDVarcharRepresents 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_APPBooleanIs the latest dml_type "delete" or "backfill-delete".Where is_deleted_in_app = false Only keeps undeleted rows.
MISSED_ATTimestamp_NTZFor inbound calls, this is the UTC datetime for when the prospect had called.
NOTEVarcharAny freeform notes associated with the call.
OPPORTUNITY_IDVarcharIf the call is associated with an opportunity, its ID will be listed here.Maps to the OPPORTUNITIES table
OUTBOUNDBooleanA Boolean field for if the call was outbound. False implies when OUTBOUND = FALSE then 'Inbound' else 'Outbound' end as call_direction
OUTCOMEVarcharA freeform text field for the outcome of a call. Often Null.
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
PHONE_IDVarcharThe phone ID of the rep.Maps to the PHONES table
PHONE_NUMBER_IDVarcharAn ID for the Phone number that was dialed.Maps to the PHONE_NUMBERS table
PROSPECT_IDVarcharThe ID of the prospect that was called.Maps to the PROSPECTS table
RINGING_ATTimestamp_NTZThe UTC datetime for when the dial tone is first heard.differences between Dialed_at and Ringing_at can be used to triage bad call connectivity
SEQUENCE_ACTIONVarcharA nominal field for the action the call causes in the sequence.
SEQUENCE_IDVarcharThe sequence ID if this call was done in sequence.Maps to the SEQUENCES table
SEQUENCE_STATE_IDVarcharThe sequence state ID if this call was done in sequence.Maps to the SEQUENCE_STATES table
SEQUENCE_STEP_IDVarcharThe sequence step of the associated sequence state ID.maps to the SEQUENCE_STEPS table
SHOULD_RECORD_CALLBooleanA Boolean flag for if this call will be recorded or not.
STATEVarcharA nominal field describing the current state of the call. if a call occurs mid ETL you may see "ringing".'ringing', 'complete', 'no_answer', 'canceled'
STATE_CHANGED_ATTimestamp_NTZThe UTC datetime of when a calls state has changed. This is redundant if looking for answered_at or completed_at datetimes.
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.
TASK_IDVarcharThe associated task ID if the call is on behalf of a call task.Maps to the TASKS table
TOVarcharThe phone number that was dialed. For inbound calls it is the reps phone number.
TRANSFEREE_USER_IDVarcharThe user ID that initiated a call transfer.Maps to the USERS table
TRANSFERRED_FROM_CALL_IDVarcharThe call ID of the original call that was transfered.Maps to the CALLS table
TRANSFERRED_TO_USER_IDVarcharThe User ID the call was transferred to.Maps to the USERS table
UIDVarcharA unique call hashed ID provided for Twilio calls. It does not not map to anything, but can be used for unique counts.
UPDATED_ATTimestamp_NTZThe UTC datetime for the last time this record was updated.2019-01-01 20:14:01:10Almost equivalent to dml_at (but adjusted for time zones), but doesn't include record creation or deletion.
UPDATER_IDVarcharSame as creator_id above, but refers to who last did the update of the record.
UPDATER_TYPEVarcharSame as creator_type above, but may allow different field values.'plugin', 'app', 'user', 'trigger', 'import'
USER_CALL_TYPEVarcharIf the call was conducted over VoIP or Bridge.'voip', 'bridge'
USER_IDVarcharThe user ID associated with the call.Maps to the USERS table
XFEREE_HELDBooleanA Boolean flag for if the transferee put the call on hold.
XFEREE_IDVarcharAn ID that maps to who was transferred.Maps to the PROSPECTS table