Notification Report (Employee-Specific)

Generates a detailed notification settings report for a specific user, showing their notification preferences for individual employees. This report displays notification types and status flags for each employee the user has notification settings configured for.

Parameters

• USERID - The specific user ID to check notification settings for (hardcoded in WHERE clause, example: 1322)

Data Components

The report consists of:

1. User Identification - The specific user being analyzed
2. Employee Information - Details of employees with notification settings
3. Notification Configuration - Type and status of notifications for each employee

Output Format

Technical Implementation

The script uses:

• INNER JOIN to link USEREMPNOTIF and EMPLOYEES tables
• CASE statements to translate notification type codes to readable descriptions
• CASE statements to translate notification flag codes to status descriptions
• Direct filtering by USERID for specific user analysis

Notification Types

• 0 - Leave Request notifications
• 1 - Time Card Trigger notifications
• Other - Both types of notifications

Notification Status Flags

• 1 - Filtered (conditional notifications)
• 2 - Always (all notifications)
• Other - Never (no notifications)

Notes

• Focuses on a single user's notification preferences for individual employees
• Useful for troubleshooting notification issues for specific users
• Shows granular control over employee-specific notification settings
• The USERID parameter must be manually updated in the script for different users

Alternative Formats

• Export results to CSV or Excel for notification configuration documentation
• Can be modified to show notification settings for multiple users by removing the USERID filter

T-SQL

Select 
	UN.USERID,
	E.LASTNAME + ', ' + E.FIRSTNAME AS FullName,
    E.IDNUM,
	CASE 
        WHEN UN.NOTIFTYPE = 0 THEN 'Leave Request'
        WHEN UN.NOTIFTYPE = 1 THEN 'Time Card Trigger'
        ELSE 'Both'
    END AS 'Notif Type',
    CASE 
        WHEN UN.NOTIFFLAG = 1 THEN 'Filtered'
        WHEN UN.NOTIFFLAG = 2 THEN 'Always'
        ELSE 'Never'
    END AS 'Notif Status'

from USEREMPNOTIF UN

Inner Join Employees e
ON UN.FILEKEY = e.FILEKEY

where USERID = 1322

Content Inventory

• Doc File: content/docs/reports/users_information/notificationreport_of_some_kind.mdx
• SQL Script: SQL/reports/users_information/notificationreport_of_some_kind.sql