User Notifications

Select 
	--UN.USERID,
	u.FRIENDLYNAME as 'User',
	--un.FILEKEY,
	e.LASTNAME,
	e.FIRSTNAME,
	e.IDNUM,
	w1.NAME as WG1,
	w2.NAME as WG2,
	w3.NAME as WG3,
	Case 
		when un.NOTIFTYPE = 0 then 'Leave Request'
		when un.NOTIFTYPE = 0 then 'Time Card Trigger'
	end As 'Notif Type',
	Case 
		when un.NOTIFFLAG = 0 then 'Never'
		when un.NOTIFFLAG = 1 then 'Filtered'
		when un.NOTIFFLAG = 2 then 'Always'
	end as 'Notif Status'
	
from USEREMPNOTIF UN
INNER Join USERS u on UN.USERID = u.UNIQUEID
INNER JOIN EMPLOYEES e on un.FILEKEY = e.FILEKEY
Inner join WORKGROUP1 w1 on e.WG1 = w1.WGNUM
inner join WORKGROUP2 w2 on e.wg2 = w2.WGNUM
inner join WORKGROUP3 w3 on e.wg3 = w3.WGNUM

Where UN.NOTIFFLAG != 0 --Hide Nevers

order by u.FRIENDLYNAME

/*
Table only keeps records for employees changed from Never.

Notiftype = 0 = Leave Request.
			1 = Timecard Triggers

Notifflag = 0 = Never
			1 = Filtered
			2 = Always
*/