tbl_announcement

1 rows


Description

Module: HRMS Communications & Announcements
Purpose: Stores all formal internal communications, notifications, and events intended for various employee groups.
Data: Contains the content, schedule, targeting, and status of published announcements.
Process Usage:
- Used by the system to display announcements on employee dashboards and push notifications.
- Manages the scheduling and delivery of internal communication based on start/end dates.
Key Points:
- Essential for corporate communication, internal marketing, and regulatory notices.
- Supports multiple delivery methods (dashboard, email, push notification).
Business Impact: Ensures timely and targeted dissemination of official information to the workforce.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
announcementid serial 10 √ nextval('tbl_announcement_announcementid_seq'::regclass)

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single announcement record.
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R

FK: Reference to a company master table
Meaning: The company to which this announcement belongs or is restricted to.
stateid int8 19 √ null
tbl_statemaster.stateid Implied Constraint R

FK: Reference to a state master table
Meaning: The geographical state or region targeted by this announcement.
branchid varchar 2147483647 √ null

FK: Reference to a branch master table
Meaning: The specific branch or location targeted by this announcement.
announcementtitle varchar 50 null

The main subject or title of the announcement (e.g., “Annual Holiday Schedule,” “System Maintenance Notice”).
Format: Varchar/Text.
announcementdiscription varchar 500 √ null

The detailed body or content of the announcement.
Format: Text.
announcementdate timestamp 29,6 √ null

The official date the announcement was created or recorded.
Format: Date.
announcestatus bool 1 null

The current lifecycle status of the announcement (e.g., Draft, Scheduled, Active, Expired, Archived).
Format: Varchar/Text.
com1 varchar 2147483647 √ null

Custom field 1 (General Purpose) - Reserved for specific, non-standard business data.
Format: Varchar/Text.
com2 varchar 2147483647 √ null

Custom field 2 (General Purpose).
Format: Varchar/Text.
com3 varchar 2147483647 √ null

Custom field 3 (General Purpose).
Format: Varchar/Text.
com4 varchar 2147483647 √ null

Custom field 4 (General Purpose).
Format: Varchar/Text.
com5 numeric 0 √ null

Custom field 5 (General Purpose).
Format: Varchar/Text.
com6 numeric 0 √ null

Custom field 6 (General Purpose).
Format: Varchar/Text.
com7 int8 19 √ null

Custom field 7 (General Purpose).
Format: Varchar/Text.
com8 int8 19 √ null

Custom field 8 (General Purpose).
Format: Varchar/Text.
com9 bool 1 √ null

Custom field 9 (General Purpose).
Format: Varchar/Text.
com10 bool 1 √ null

Custom field 10 (General Purpose).
Format: Varchar/Text.
com11 timestamp 29,6 √ null

Custom field 11 (General Purpose).
Format: Varchar/Text.
com12 timestamp 29,6 √ null

Custom field 12 (General Purpose).
Format: Varchar/Text.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The ID of the user who created the announcement.
createdon timestamp 29,6 √ null

Legacy timestamp of when the announcement was initially created (may be redundant with createddate).
Format: Timestamp.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The ID of the last user who modified the announcement.
modifiedon timestamp 29,6 √ null

Legacy timestamp of the last modification to the announcement (may be redundant with modifieddate).
Format: Timestamp.
createddate timestamp 29,6 √ null

Meaning: The exact timestamp of when the record was created.
Stored as: UTC
Format: Timestamp with timezone.
modifieddate timestamp 29,6 √ null

Meaning: The exact timestamp of the last modification to the record.
Stored as: UTC
Format: Timestamp with timezone.
recipientgroup varchar 255 null

Meaning: Defines the rule or group criteria used to target the announcement (e.g., Department, Designation, All Employees).
Format: Varchar/Text.
recipientgroupmember text 2147483647 √ null

JSON or Text list specifying the actual IDs/names of the targeted members based on the recipientgroup rule.
Format: JSONB/Text.
startdate date 13 null

The date from which the announcement should become active/visible.
Format: Date.
enddate date 13 null

The date on which the announcement should expire and be hidden.
Format: Date.
type varchar 100 null

The category of the announcement (e.g., Announcement, Event, News Letter).
Format: Varchar/Text.
eventstartdate date 13 √ null

If the announcement is an event, the start date of the actual event.
Format: Date.
eventstarttime time 15,6 √ null

If the announcement is an event, the start time of the actual event.
Format: Time.
eventenddate date 13 √ null

If the announcement is an event, the end date of the actual event.
Format: Date.
eventendtime time 15,6 √ null

If the announcement is an event, the end time of the actual event.
Format: Time.
notifyemail bool 1 null

Flag indicating if the announcement should be sent as an email notification.
Format: Boolean.
notifypush bool 1 null

Flag indicating if the announcement should be sent as a mobile push notification.
Format: Boolean.
notifysent bool 1 false

Flag indicating whether the notification job (email/push) has successfully completed for this announcement.
Format: Boolean.
filename varchar 500 √ null

The name of the attached file, if any.
Format: Varchar/Text.
filedownloadable bool 1 √ null

Flag indicating whether the attached file is available for employees to download.
Format: Boolean.
to_cc_bcc varchar 2147483647 √ 'To'::character varying

JSON or Text list specifying custom To, CC, and BCC email recipients beyond the defined recipient group.
Format: JSONB/Text.

Indexes

Constraint Name Type Sort Column(s)
tbl_announcement_pk_tbl_announcement2 Primary key Asc announcementid

Relationships

Close relationships within degrees of separation