public.odcampaigndetails

public.odcampaigndetails

Description

Outbound Dialling Campaign Lookup Data

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary Key / Campaign GUID
name varchar(200) true Campaign Name
datecreated timestamp without time zone true Campaign Date Created (UTC)
datecreatedltc timestamp without time zone true Campaign Date Created (LTC)
datemodified timestamp without time zone true Campaign Date Modified (UTC)
datemodifiedltc timestamp without time zone true Campaign Date Modified (LTC)
version integer true Campaign Version
automatictimezonemapping bit(1) true
division varchar(50) true Campaign Division GUID
divisionname varchar(200) true Campaign Division Name
contactlist varchar(50) true
contactlistname varchar(200) true Campaign Contact List Name
script varchar(50) true Campaign Script GUID
scriptname varchar(200) true Campaign Script Name
queue varchar(50) true Campaign Queue GUID
dialingmode varchar(50) true Campaign Dialling Mode GUID
campaignstatus varchar(50) true Campaign Status
abandonrate numeric(20,2) true Campaign Abandon Rate
callanalysisresponseset varchar(50) true Campaign No Answer Time Out
callanalysisresponsesetname varchar(200) true Campaign Call Analysis Response Set Call Analysis
callername varchar(200) true Campaign Call Analysis Response Set Caller Name
calleraddress varchar(200) true Campaign Call Analysis Response Set Caller Address
outboundlinecount integer true Campaign Name
skippreviewdisabled bit(1) true Campaign Call Analysis Response Set Skip Preview Disabled
previewtimeoutseconds numeric(20,2) true Campaign Call Analysis Response Set Preview Timeout Seconds
singlenumberpreview bit(1) true Campaign Call Analysis Response Set Single Number Preview
alwaysrunning bit(1) true Campaign Always Running
noanswertimeout numeric(20,2) true Campaign Call Analysis Response Set
priority integer true Campaign Priority
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
odcampaigndetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
odcampaigndetails_pkey CREATE UNIQUE INDEX odcampaigndetails_pkey ON public.odcampaigndetails USING btree (id)

    • Related Articles

    • README

      Logo Genesys Adapter Data Dictionary Tables Name Columns Comment Type public.tabledefinitions 5 Subscription Detailed Data BASE TABLE public.activeqmembersdata 9 Historical Active Membership of Queues BASE TABLE public.activitycodedetails 11 Activity ...

    • public.participantattributesdynamic

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...

    • public.convvoicetopicdetaildata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true participant varchar(50) true ...

    • public.evalquestiondata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false evaluationid varchar(50) false evaluationformid varchar(50) false questiongroupid varchar(50) true questionid varchar(50) true answerid varchar(50) true ...

    • public.evaldata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false conversationid varchar(50) false evaluationid varchar(50) false calibrationid varchar(50) true evaluationformid varchar(50) true evaluatorid varchar(50) ...