tbl_attendancenotificationhistory

6 rows


Description

Module: HRMS Time & Attendance (Notification Audit Log)
Purpose: Stores the historical, immutable audit log of all changes made to individual employee attendance notification preferences in public.tbl_attendancenotification.
Data: Contains a snapshot of the notification settings (type, frequency, channel) at the time a modification was made.
Process Usage:
- Used for auditing and compliance to track who changed an employee’s notification settings and when.
- Essential for troubleshooting issues where an employee claims they did or did not receive specific alerts.
Key Points:
- Ensures accountability for changes to user-specific communication preferences.
- The id in this history table is unique for each change event.
Business Impact: Provides a transparent record of all configuration changes affecting automated attendance alerts.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for this single historical event/snapshot.
notificationtype varchar 255 null

The category of the notification (e.g., Late Punch-in Warning, Missing Punch Alert) as configured at the time of this history event.
Format: Varchar/Text.
frequency varchar 255 null

How often the notification was set to be sent (e.g., Daily, Weekly, Once Per Event) at the time of this history event.
Format: Varchar/Text.
sendtype varchar 255 null

The channel used for delivery (e.g.,Admin manager Employee ) as configured at the time of this history event.
Format: Varchar/Text.
employeeid varchar 255 √ null

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee whose notification preferences were changed.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user (employee or administrator) who performed the action that created this history record.
createddate timestamp 29,6 √ null

Timestamp of when the historical record was created (i.e., when the modification to the preference occurred).
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified the preference record before this history snapshot was taken.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the preference record before this history snapshot was taken.
Format: Timestamp with timezone.

Indexes

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

Relationships

Close relationships within degrees of separation