public.vwuserlanguagemappings

public.vwuserlanguagemappings

Description

User routing language assignments with user and division context

Table Definition 
CREATE VIEW vwuserlanguagemappings AS (
 SELECT (ulm.userid)::text AS user_id,
    (ud.name)::text AS user_name,
    (ud.divisionid)::text AS division_id,
    (ud.state)::text AS user_state,
    ud.email AS user_email,
    (ud.username)::text AS username,
    (ud.title)::text AS title,
    (ud.managerid)::text AS manager_id,
    (ud.acdautoanswer)::text AS acd_auto_answer,
    (ulm.languageid)::text AS language_id,
    (ulm.languagename)::text AS language_name,
    ulm.proficiency AS language_proficiency,
    (ulm.state)::text AS language_state,
    (ud.divisionname)::text AS division_name
   FROM (userlanguagemappings ulm
     LEFT JOIN vwuserdetail ud ON (((ulm.userid)::text = (ud.id)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
user_id text true User GUID
user_name text true User name
division_id text true User division GUID
user_state text true User state
user_email text true User email address
username text true Username
title text true User title
manager_id text true Manager GUID
acd_auto_answer text true ACD auto answer setting
language_id text true Routing language GUID
language_name text true Routing language name
language_proficiency numeric(20,2) true User language proficiency
language_state text true User language mapping state
division_name text true User division name

Referenced Tables

Name Columns Comment Type
public.userlanguagemappings 7 BASE TABLE
public.vwuserdetail 18 User details with manager and division context VIEW

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

      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 score ...

    • public.participantattributesdynamic

      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 conversationenddate ...

    • public.hoursblockdata

      Columns Name Type Default Nullable Children Parents Comment keyid varchar(200) false userid varchar(50) true startdate timestamp without time zone true startdateltc timestamp without time zone true enddate timestamp without time zone true enddateltc ...

    • public.userinteractionpresencedetaileddata

      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 true endtimeltc ...