tbl_separationworkflowsetup

4 rows


Description

Module: Separation Management - Workflow Setup Master
Purpose: Stores the configuration rules that define the required steps and timelines for an employee separation (resignation, retirement, termination).
Data: Contains flags for mandatory steps like multi-level approval, departmental clearance, and exit interviews, along with associated timeline parameters.
Process Usage:
- Process Definition: Determines the exact workflow an employee’s separation request must follow.
- Controls the initiation timing of post-resignation tasks like clearance and notification.
Key Points:
- Allows for different separation types (e.g., retirement vs. resignation) to follow different rules (implied by linking this setup to a specific employee group/reason).
- The diff method in the model suggests it is heavily audited for changes.
Business Impact: Standardizes and automates the entire employee exit process, ensuring all compliance and handover steps are followed.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific separation workflow rule set.
name varchar 50 √ null

The name given to this workflow setup (e.g., “Standard Resignation Workflow,” “Retirement Process”).
approvalrejectionrequired bool 1 true

Boolean flag: Indicates whether the separation request must undergo a formal manager/HR approval/rejection workflow.
departmentclearancerequired bool 1 true

Boolean flag: Indicates whether the departmental asset/responsibility clearance process is mandatory for this workflow.
departmentclearanceinitiation varchar 50 √ null

The trigger event based on which the clearance process is initiated (e.g., “On Resignation Date,” “On Approval”).
departmentclearanceinitiationnoofdays numeric 0 √ null

The number of days used with the DepartmentClearanceWhenToInitiation field to calculate the clearance initiation date.
departmentclearancewhentoinitiation varchar 100 √ null

Specifies the timing logic relative to the relieving date for initiating clearance (e.g., “BEFORE,” “AFTER”).
exitinterviewrequired bool 1 true

Boolean flag: Indicates whether an exit interview is a mandatory step in this separation workflow.
ageinyears numeric 0 √ null

A rule parameter: Likely used to define which employees (e.g., those reaching retirement age) this specific workflow applies to.
notifybeforenoofdays numeric 0 √ null

The number of days before the relieving date (or other key date) that relevant personnel (e.g., IT, Finance) should be notified of the separation.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation