User details with manager and division context
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.updated,
ud.employeeid,
ud.datehire,
dd.name AS divisionname,
dd.homedivision,
ud.acdautoanswer
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)))
)| 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 | |||
| 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 | |||
| updated | timestamp without time zone | true | Last Updated | |||
| employeeid | varchar(50) | true | Employee GUID | |||
| datehire | varchar(50) | true | Employee Hire Date | |||
| divisionname | varchar(50) | true | Division Name | |||
| homedivision | varchar(50) | true | Home Division | |||
| acdautoanswer | boolean | true | ACD Auto Answer Enabled |
| Name | Columns | Comment | Type |
|---|---|---|---|
| public.userdetails | 14 | BASE TABLE | |
| public.divisiondetails | 5 | BASE TABLE |