Audit Table for Queue Membership changes
CREATE VIEW vwqueueauditdata AS (
SELECT qa.queueid,
qa.userid,
ud.name,
ud.department,
ud.managername,
qa.addorremove,
qa.activeorinactive,
qa.datemodified,
qa.modifiedby,
ud1.name AS modbyname,
ud1.department AS modbydept,
ud1.managername AS modbymanager,
qd.name AS queuename,
qd.divisionid
FROM (((queueauditdata qa
LEFT JOIN vwuserdetail ud ON (((qa.userid)::text = (ud.id)::text)))
LEFT JOIN vwuserdetail ud1 ON (((qa.modifiedby)::text = (ud1.id)::text)))
LEFT JOIN vwqueuedetails qd ON (((qa.queueid)::text = (qd.id)::text)))
)
Name | Type | Default | Nullable | Children | Parents | Comment |
---|---|---|---|---|---|---|
queueid | varchar(50) | true | Queue GUID | |||
userid | varchar(50) | true | User GUID | |||
name | varchar(200) | true | User Name | |||
department | varchar(200) | true | Department | |||
managername | varchar(200) | true | Manager Name | |||
addorremove | varchar(10) | true | Action to Add or Remove | |||
activeorinactive | varchar(20) | true | Action to make active or inactive | |||
datemodified | timestamp without time zone | true | Date Modified(UTC) | |||
modifiedby | varchar(50) | true | Modified By GUID | |||
modbyname | varchar(200) | true | Modified By Name | |||
modbydept | varchar(200) | true | Modified By Department | |||
modbymanager | varchar(200) | true | Modified By Manager | |||
queuename | varchar(255) | true | Queue Name | |||
divisionid | varchar(50) | true | Division GUID |
Name | Columns | Comment | Type |
---|---|---|---|
public.queueauditdata | 9 | Audit Table for Queue Membership changes | BASE TABLE |
public.vwuserdetail | 17 | See UserDetail: User Description in detail | VIEW |
public.vwqueuedetails | 24 | See QueueDetails: Queue Lookup data | VIEW |