Related Articles
public.vwpresencedetails
Description See PresenceDetails: 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 ...
public.vwuserpresencedatadaily
Description See UserPresenceDataDaily - Expands all the GUIDs with their lookups(Daily) Table Definition CREATE VIEW vwuserpresencedatadaily AS ( SELECT userpresencedatadaily.id, userpresencedatadaily.userid, userdetail.name AS agentname, ...
public.vwrealtimeuser
Description Real-time user data Table Definition CREATE VIEW vwrealtimeuser AS ( SELECT rd.name AS user_name, rd.id AS user_id, rd.divisionid, rd.groupname, rd.managername, rd.managerid, CASE WHEN (rd.systempresence = 'ON_QUEUE'::text) THEN ...
public.vwrealtimeuser_groups
Description Table Definition CREATE VIEW vwrealtimeuser_groups AS ( SELECT rd.name AS user_name, rd.id AS user_id, rd.divisionid, rd.division_name, rd.groupid, rd.groupname, rd.managername, rd.managerid, CASE WHEN (rd.systempresence = ...
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 ...