public.vwuserdetail

public.vwuserdetail

Description

See UserDetail: User Description in detail

Table Definition

CREATE VIEW vwuserdetail AS (
 SELECT ud.id,
    ud.name,
    ud.jabberid,
    ud.state,
    ud.title,
    lower((ud.email)::text) AS email,
    ud.username,
    ud.department,
    ud.manager AS managerid,
    md.name AS managername,
    ud.username AS agentname,
    ud.divisionid,
    ud.employeeid,
    ud.datehire,
    ud.updated,
    dd.name AS divisionname,
    dd.homedivision
   FROM ((userdetails ud
     LEFT JOIN userdetails md ON (((md.id)::text = (ud.manager)::text)))
     LEFT JOIN divisiondetails dd ON (((ud.divisionid)::text = (dd.id)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) true User GUID
name varchar(200) true User Name
jabberid varchar(100) true Jabber GUID
state varchar(50) true User State
title varchar(200) true User Title
email text true Email Address
username varchar(200) true Username
department varchar(200) true User Department
managerid varchar(50) true Manager GUID
managername varchar(200) true Manager Name
agentname varchar(200) true Agent Name
divisionid varchar(50) true Division GUID
employeeid varchar(50) true Employee GUID
datehire varchar(50) true Employee Hire Date
updated timestamp without time zone true Last Updated
divisionname varchar(50) true Division Name
homedivision varchar(50) true Home Division

Referenced Tables

Name Columns Comment Type
public.userdetails 13 BASE TABLE
public.divisiondetails 4 BASE TABLE

    • Related Articles

    • public.vwteammemberdata

      Description Team Member Data View Table Definition CREATE VIEW vwteammemberdata AS ( SELECT tm.userid, ud.name AS "Agent Name", td.name AS "Team Name" FROM ((teammemberdata tm LEFT JOIN vwuserdetail ud ON (((tm.userid)::text = (ud.id)::text))) LEFT ...

    • public.vwmumemberdata

      Description MU Member Data Table Definition CREATE VIEW vwmumemberdata AS ( SELECT mudetails.id AS mu_id, mudetails.name AS mu_name, mumemberdata.id AS user_id, vwuserdetail.name AS user_name, vwuserdetail.managername AS manager_name FROM ...

    • public.vwskillmemberdata

      Description Contains data on skill mappings for users Table Definition CREATE VIEW vwskillmemberdata AS ( SELECT sm.userid, ud.name AS user_name, sd.name AS skill_name, sm.proficiency, sm.state FROM ((userskillmappings sm LEFT JOIN vwuserdetail ud ON ...

    • public.vwuserqueuemappings

      Description UserQueueMappings: View for mappings in between User and Queue Table Definition CREATE VIEW vwuserqueuemappings AS ( SELECT qm.queueid, qd.name AS queuename, qm.userid, ud.name, ud.department, ud.managername, qm.divisionid FROM ...

    • public.vwtimeoffdata

      Description See TimeOffData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwtimeoffdata AS ( SELECT td.userid, td.businessunitdate, td.length, td.description, td.activitycode, td.paid, td.timeoffrequestid, ud.name AS ...