public.wrapupdetails

public.wrapupdetails

Description

Wrap Up Code Details Lookup Up Data

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary Key / Wrap Up GUID
name varchar(255) true Wrap Up Name
updated timestamp without time zone true Date Row Updated (UTC)
isrightpartycontact boolean true Outbound Wrap Up Code Mapping: Right Party Contact flag (NULL when the mapping could not be read)
iscontactuncallable boolean true Outbound Wrap Up Code Mapping: Contact Uncallable flag (NULL when the mapping could not be read)
isnumberuncallable boolean true Outbound Wrap Up Code Mapping: Number Uncallable flag (NULL when the mapping could not be read)
businesscategory varchar(20) true Outbound Wrap Up Code Mapping: Business Category (Success, Failure, Neutral; NULL when none is set)

Constraints

Name Type Definition
wrapupdetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
wrapupdetails_pkey CREATE UNIQUE INDEX wrapupdetails_pkey ON public.wrapupdetails USING btree (id)

    • Related Articles

    • public.vwwrapupdetails

      Description WrapUpDetails Table Definition CREATE VIEW vwwrapupdetails AS ( SELECT wrapupdetails.id, wrapupdetails.name, wrapupdetails.updated, wrapupdetails.isrightpartycontact, wrapupdetails.iscontactuncallable, wrapupdetails.isnumberuncallable, ...

    • public.vwconvsummarydata

      Description Conversation summary data with lookup expansion Table Definition CREATE VIEW vwconvsummarydata AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationstartdateltc, cs.conversationenddate AS convstartdateusrtz, ...

    • public.vwuserinteractiondata

      Description User interaction data with lookup expansion Table Definition CREATE VIEW vwuserinteractiondata AS ( SELECT userinteractiondata.keyid, userinteractiondata.startdate AS startdateutc, userinteractiondata.startdateltc, ...

    • 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.vwqueueinteractiondata

      Description Queue Interaction Data Interval Data - Interval is from (15-60) Min(s) Table Definition CREATE VIEW vwqueueinteractiondata AS ( SELECT queueinteractiondata.keyid, queueinteractiondata.startdate, queueinteractiondata.startdateltc, ...