tbl_letter_acceptance_status_communication

-1 rows


Description

Module: HRMS Document Workflow & Communication
Purpose: Stores predefined questions, reasons, or communication templates that are prompted to a user when they accept, reject, or acknowledge an official system-generated letter.
Data: Links text/questions to a specific type of letter and its acceptance status.
Process Usage:
- Used by the UI to dynamically prompt the user for required input (e.g., “State your reason for rejection”) when changing the letter status. br>Key Points:
- Critical for compliance workflows where a formal record of the user’s reason for action is required.
- The questions field likely contains the text or structured data for the user prompt.
Business Impact: Ensures consistent data collection and provides auditability for all official letter communications.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single communication/question configuration record.
letterid int8 19 null

FK: Reference to a letter master table (e.g., tbl_offermaster, tbl_promotionletter)
Meaning: The ID of the specific type of official letter to which this communication is tied.
questions varchar 500 null

The text of the question or the structure of the communication prompt to be displayed to the user.
Usage: Prompts user for reasons, remarks, or confirmation.
Format: Text or JSONB.
createdby varchar 500 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who created this configuration record.
createddate timestamp 29,6 √ null

Timestamp of when the configuration record was created.
Format: Timestamp with timezone.
modifiedby varchar 500 √ null

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

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

Indexes

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

Relationships

Close relationships within degrees of separation