tbl_attendancenotification

6 rows


Description

Module: HRMS Time & Attendance (Notification Configuration)
Purpose: Stores individual employee settings to control the types, frequency, and timing of automated notifications related to attendance (e.g., late-coming alerts, shift start reminders).
Data: Defines the user’s subscription to different notification categories.
Process Usage:
- Referenced by the notification engine to determine if and how to alert a specific employee about an attendance event.
- Allows employees or administrators to customize notification delivery.
Key Points:
- Essential for managing internal communication and proactive attendance compliance.
- Supports various types of alerts and delivery schedules.
Business Impact: Helps improve employee adherence to shift timings and reduces manual follow-up by HR.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('tbl_attendancenotification_id_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single notification preference record.
notificationtype varchar 255 null

The category of the notification (e.g., Late Punch-in Warning, Missing Punch Alert, Shift Start Reminder).
Format: Varchar/Text.
frequency varchar 255 null

How often the notification should be sent (e.g., Daily, Weekly, Once Per Event, Never).
Format: Varchar/Text.
sendtype varchar 255 null

The channel used for delivery (e.g.,Admin manager , employee).
Format: Varchar/Text.
employeeid varchar 255 √ null

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee whose notification preferences are stored in this record.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user (often the employee themselves or an administrator) who created this preference record.
createddate timestamp 29,6 √ null

Timestamp of when the notification preference record was created.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified this notification preference record.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the notification preference record.
Format: Timestamp with timezone.

Indexes

Constraint Name Type Sort Column(s)
tbl_attendancenotification_pk_tbl_attendancenotification Primary key Asc id

Relationships

Close relationships within degrees of separation