public.flowoutcomedetails

public.flowoutcomedetails

Description

Flow Outcome Details

Columns

Name Type Default Nullable Children Parents Comment
id varchar(255) false Flow Outcome ID
name varchar(50) false Flow Outcome Name
divisionid varchar(50) true Division ID
description varchar(50) true Description
operationid varchar(50) true Operation ID
operationcomplete bit(1) true Operation Complete
userid varchar(50) true User ID
clientid varchar(50) true Client ID
errormessage varchar(255) true Error Message
errorcode varchar(50) true Error Code
actionname varchar(50) true Action Name
actionstatus varchar(50) true Action Status
updated timestamp without time zone true Last Updated Timestamp

Constraints

Name Type Definition
flowoutcomedetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
flowoutcomedetails_pkey CREATE UNIQUE INDEX flowoutcomedetails_pkey ON public.flowoutcomedetails USING btree (id)

    • Related Articles

    • public.vwflowoutcomedetails

      Description Normalized Flow Outcome Details (with division and user lookups) Table Definition CREATE VIEW vwflowoutcomedetails AS ( SELECT fod.id, fod.name, fod.description, fod.divisionid, dd.name AS divisionname, fod.operationid, CASE WHEN ...
    • public.vwflowoutcomedata

      Description Flow Outcome Data with conversation summary enrichment and outcome name Table Definition CREATE VIEW vwflowoutcomedata AS ( SELECT fod.keyid, fod.conversationid, fod.conversationstartdate, fod.conversationstartdateltc, ...
    • 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 ...