public.vwoutboundattemptdata

Description

Outbound attempt model: one row per outbound campaign dial attempt 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.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.outcome_code,
    outboundattemptdata.outcome_description,
    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.duration_seconds,
    outboundattemptdata.talk_time_seconds,
    outboundattemptdata.hold_time_seconds,
    outboundattemptdata.wrap_up_duration_seconds,
    outboundattemptdata.source_system,
    outboundattemptdata.load_ts
   FROM outboundattemptdata
)

Columns

Name	Type	Nullable
attempt_id	varchar(120)	true
conversation_id	varchar(50)	true
attempt_number	bigint	true
contact_id	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
outcome_code	varchar(255)	true
outcome_description	varchar(255)	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
duration_seconds	integer	true
talk_time_seconds	integer	true
hold_time_seconds	integer	true
wrap_up_duration_seconds	integer	true
source_system	varchar(50)	true
load_ts	timestamp(3) without time zone	true

Referenced Tables

Name	Columns	Comment	Type
public.outboundattemptdata	42	One row per outbound campaign dial attempt, rebuilt per UTC day by the Interaction job from vwOutboundAttemptDataBuild. Query vwOutboundAttemptData.	BASE TABLE