Related Articles
public.vwpresencedetails
Description Presence code lookup data Table Definition CREATE VIEW vwpresencedetails AS ( SELECT pd.id, pd.systempresence, pd.orgpresence, pd.deactivated, pd.type, CASE WHEN ((pd.divisionid)::text = '*'::text) THEN dd.id ELSE pd.divisionid END AS ...
public.vwqueueconvrealtime
Description Queue conversation real-time data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, queuerealtimeconvdata.conversationstate, ...
public.vwcopilotlicensedusers
Description Users with active Copilot licenses Table Definition CREATE VIEW vwcopilotlicensedusers AS ( SELECT l.userid, l.username, l.email, l.licenseid, l.licensename, l.licensetype, l.licenseassignmentdate, l.divisionid, l.updated, ud.name AS ...
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.vwqueuedetails
Description Queue lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, "substring"((qd.description)::text, ...