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

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

      Description User Presence Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false Primary Key userid varchar(50) true Agent GUID starttime timestamp without time zone false Start Time (UTC) starttimeltc ...

    • public.userinteractionpresencedetaileddata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false userid varchar(50) true starttime timestamp without time zone false starttimeltc timestamp without time zone true endtime timestamp without time zone ...

    • public.userpresencedata

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(255) false id varchar(50) true userid varchar(50) true startdate timestamp without time zone false startdateltc timestamp without time zone true timetype ...