tbl_email_notification

-1 rows


Description

Module: System Configuration & Utilities (Email)
Purpose: Stores configuration details for automated email notifications and scheduled reports.
Data: Defines the frequency (cycle, day), type, and recipients for system-triggered emails.
Process Usage:
- Referenced by a background scheduler service to determine which emails to send and when.
- Allows administrators to configure recurring notifications without code changes.
Key Points:
- Central control for all scheduled outbound email communication.
- Critical for reminders, system reports, and policy updates.
Business Impact: Ensures timely communication of critical information to stakeholders.

Columns

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

Primary key for the email notification configuration record.
Format: Integer (auto-increment)
Used as: Unique identifier for a single scheduled email job.
cycle varchar 255 null

The frequency cycle for the notification.
Meaning: Common values are ‘DAILY’, ‘WEEKLY’, ‘MONTHLY’, or ‘YEARLY’.
Logic: Determines which scheduling columns (dayofcurrentmonth, etc.) are relevant.
type varchar 255 null

The specific type or template of the email notification.
Meaning: Examples: ‘Attendance_Reminder’, ‘Monthly_Payroll_Report’, ‘Leave_Approval_Alert’.
Dependency: Links to the email template content (not stored here).
mailto varchar 255 null

The comma-separated list of email addresses or user groups to receive the notification.
Format: String (max length 255)
Logic: Can contain static emails or dynamic variables (e.g., ‘$HR_MANAGERS’).
dayofcurrentmonth varchar 255 √ null

The day of the current month to trigger the email.
Format: Integer (1-31)
Logic: Only relevant if cycle is ‘MONTHLY’.
dayofnextmonth varchar 255 √ null

The day of the next month to trigger the email (used for end-of-month processes).
Format: Integer (1-31)
Logic: Typically used for processing payroll or reports after the current month ends.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id
Meaning: The user (administrator) who initially configured this email notification.
Usage: Identifies the user responsible for setting up the job.
createddate timestamp 29,6 √ null

Timestamp of when this email notification configuration record was created.
Stored as: UTC
Format: Full timestamp, e.g., 2025-10-23T10:00:00Z
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id
Meaning: The user who last modified this email notification configuration.
Usage: Tracks the last person to update the job schedule or recipients.
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation