Recent Articles
public.vwoutboundcampaign
Description Outbound campaign model: one row per voice campaign as currently configured in Genesys Cloud, from odcampaigndetails. Table Definition CREATE VIEW vwoutboundcampaign AS ( SELECT c.id AS campaign_id, c.name AS campaign_name, ...
public.vwoutboundattemptdatabuild
Description Build query for the outboundattemptdata table: one row per Attempt (one dial placed for an outbound campaign) computed from detailedinteractiondata alone; companion Sessions are attributed by peer. The Interaction job selects one UTC day ...
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, ...
public.outboundattemptdata
Description One row per outbound campaign dial attempt, rebuilt per UTC day by the Interaction job from vwOutboundAttemptDataBuild. Query vwOutboundAttemptData. Columns Name Type Default Nullable Children Parents Comment attempt_id varchar(120) false ...
public.vwinteractionlegdatabuild
Description Build query for the interactionlegdata table: one row per answered Leg computed from detailedinteractiondata, keyed by (conversationid, conversationstartdate). The Interaction job selects one UTC day of conversationstartdate at a time ...