tbl_approvalconfiguration

1 rows


Description

Module: HRMS Workflow & Approval Engine
Purpose: Stores the high-level configuration records for different approval workflows (e.g., Leave Approval, Expense Approval, Transfer Approval) used across the system.
Data: Defines the unique name, the organizational unit (SBU) it applies to, and the status of the overall configuration.
Process Usage:
- Referenced by transaction modules (e.g., Leave, Expense) to identify which specific approval chain should be used for a submission.
- The content of the approval steps (e.g., who approves, in what order) is typically stored in a related detail table.
Key Points:
- Critical for compliance and automating governance across organizational processes.
- Ensures consistency in how requests are routed for management review.
Business Impact: Defines the operational structure for all managerial and HR decision-making workflows.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single master approval configuration record.
sbuid varchar 50 √ null

FK: Reference to SBU master table
Meaning: The Strategic Business Unit (SBU) to which this approval configuration is going in approval or pending.
approvalconfigname varchar 50 √ null

The user-friendly name of the workflow (e.g.,Employee promotion).
Format: Varchar/Text.
status bool 1 √ null

The current lifecycle status of the configuration (e.g., Active, Inactive, Draft).
Format: Varchar/Text.
createddate timestamp 29,6 √ null

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

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

Timestamp of the last modification to the configuration record.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified this configuration record.

Indexes

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

Relationships

Close relationships within degrees of separation