tbl_documentacceptancestatuscommunication

-1 rows


Description

Module: HRMS Document Management & Workflow
Purpose: Stores predefined questions or communication templates that are displayed to users when they interact with a document requiring status change (e.g., Acceptance, Rejection).
Data: Links text/questions to a specific document acceptance status ID.
Process Usage:
- Used by the UI to dynamically prompt the user for input (e.g., “Why are you rejecting this document?”) based on the status they are selecting.
- Standardizes the communication and data captured during document lifecycle events.
Key Points:
- Critical for compliance workflows where specific reasons or acknowledgments are required for status transitions.
- The questions field likely contains the text or structured data for the prompt.
Business Impact: Ensures required information is collected at critical decision points in the document approval process.

Columns

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

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

FK: Reference to a document acceptance status master table
Meaning: The ID of the status (e.g., “Rejected,” “Acknowledged with Query”) to which this communication/question is tied.
questions text 2147483647 √ null

The text of the question or the structure of the communication prompt to be displayed to the user.
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_documentacceptancestatuscommunication_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation