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 (fod.operationcomplete = '1'::"bit") THEN true
WHEN (fod.operationcomplete = '0'::"bit") THEN false
ELSE NULL::boolean
END AS operationcomplete,
fod.userid,
ud.name AS username,
fod.clientid,
fod.errormessage,
fod.errorcode,
fod.actionname,
fod.actionstatus,
fod.updated
FROM ((flowoutcomedetails fod
LEFT JOIN divisiondetails dd ON (((fod.divisionid)::text = (dd.id)::text)))
LEFT JOIN vwuserdetail ud ON (((fod.userid)::text = (ud.id)::text)))
)
Columns
id |
varchar(255) |
|
true |
|
|
Flow Outcome ID |
name |
varchar(50) |
|
true |
|
|
Flow Outcome Name |
description |
varchar(50) |
|
true |
|
|
Flow Outcome Description |
divisionid |
varchar(50) |
|
true |
|
|
Division ID |
divisionname |
varchar(50) |
|
true |
|
|
Division Name |
operationid |
varchar(50) |
|
true |
|
|
Operation ID |
operationcomplete |
boolean |
|
true |
|
|
Operation Complete |
userid |
varchar(50) |
|
true |
|
|
User ID |
username |
varchar(200) |
|
true |
|
|
User Name |
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 |
Referenced Tables
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) ...