User routing language assignments with user and division context
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)))
)| 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 |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.userlanguagemappings | 7 | BASE TABLE | |
| public.vwuserdetail | 18 | User details with manager and division context | VIEW |