public.vwoutboundattemptdata

public.vwoutboundattemptdata

Description

Outbound attempt model: one row per Attempt (a Conversation of an outbound campaign contact in which a call was placed) from outboundattemptdata, with attempt_number computed per contact on read.

Table Definition
CREATE VIEW vwoutboundattemptdata AS (
 SELECT outboundattemptdata.attempt_id,
    outboundattemptdata.conversation_id,
        CASE
            WHEN (outboundattemptdata.contact_id IS NOT NULL) THEN row_number() OVER (PARTITION BY outboundattemptdata.contact_list_id, outboundattemptdata.contact_id ORDER BY outboundattemptdata.attempt_start_ts, outboundattemptdata.attempt_id)
            ELSE NULL::bigint
        END AS attempt_number,
    outboundattemptdata.contact_id,
    outboundattemptdata.contact_name,
    outboundattemptdata.campaign_id,
    outboundattemptdata.campaign_name,
    outboundattemptdata.contact_list_id,
    outboundattemptdata.contact_list_name,
    outboundattemptdata.attempt_start_ts,
    outboundattemptdata.attempt_end_ts,
    outboundattemptdata.attempt_date,
    outboundattemptdata.agent_id,
    outboundattemptdata.agent_name,
    outboundattemptdata.manager_id,
    outboundattemptdata.manager_name,
    outboundattemptdata.team_id,
    outboundattemptdata.team_name,
    outboundattemptdata.queue_id,
    outboundattemptdata.queue_name,
    outboundattemptdata.media_type,
    outboundattemptdata.direction,
    outboundattemptdata.wrap_up_code,
    outboundattemptdata.wrap_up_name,
    outboundattemptdata.connect_status,
    outboundattemptdata.contact_reached,
    outboundattemptdata.right_party_contact,
    outboundattemptdata.answering_machine,
    outboundattemptdata.no_answer,
    outboundattemptdata.busy,
    outboundattemptdata.failed,
    outboundattemptdata.callback_required,
    outboundattemptdata.callback_scheduled_ts,
    outboundattemptdata.disconnect_type,
    outboundattemptdata.disconnect_reason,
    outboundattemptdata.dial_count,
    outboundattemptdata.queue_time_seconds,
    outboundattemptdata.dial_time_seconds,
    outboundattemptdata.duration_seconds,
    outboundattemptdata.talk_time_seconds,
    outboundattemptdata.hold_time_seconds,
    outboundattemptdata.wrap_up_duration_seconds,
    outboundattemptdata.handle_time_seconds,
    outboundattemptdata.source_system,
    outboundattemptdata.load_ts
   FROM outboundattemptdata
)

Columns

Name Type Default Nullable Children Parents Comment
attempt_id varchar(120) true
conversation_id varchar(50) true
attempt_number bigint true
contact_id varchar(255) true
contact_name varchar(255) true
campaign_id varchar(50) true
campaign_name varchar(200) true
contact_list_id varchar(50) true
contact_list_name varchar(200) true
attempt_start_ts timestamp(3) without time zone true
attempt_end_ts timestamp(3) without time zone true
attempt_date date true
agent_id varchar(50) true
agent_name varchar(200) true
manager_id varchar(50) true
manager_name varchar(200) true
team_id varchar(50) true
team_name varchar(200) true
queue_id varchar(50) true
queue_name varchar(255) true
media_type varchar(50) true
direction varchar(50) true
wrap_up_code varchar(255) true
wrap_up_name varchar(255) true
connect_status varchar(20) true
contact_reached boolean true
right_party_contact boolean true
answering_machine boolean true
no_answer boolean true
busy boolean true
failed boolean true
callback_required boolean true
callback_scheduled_ts timestamp(3) without time zone true
disconnect_type varchar(50) true
disconnect_reason text true
dial_count integer true
queue_time_seconds integer true
dial_time_seconds integer true
duration_seconds integer true
talk_time_seconds integer true
hold_time_seconds integer true
wrap_up_duration_seconds integer true
handle_time_seconds integer true
source_system varchar(50) true
load_ts timestamp(3) without time zone true

Referenced Tables

Name Columns Comment Type
public.outboundattemptdata 45 One row per outbound campaign Attempt (a Conversation in which a call was placed to the contact), rebuilt per UTC day by the Interaction job from vwOutboundAttemptDataBuild. Query vwOutboundAttemptData. BASE TABLE