tbl_noticeperiodsetuphistory

-1 rows


Description

Module: Separation - Notice Period Setup History/Audit Log
Purpose: Stores an immutable record of every version and change made to the master Notice Period Policy configurations (tbl_NoticePeriodSetUp).
Data: Captures the policy name, the duration of the notice period (for probation and post-confirmation), the effective date of the policy change, and the specific application criteria.
Process Usage:
- Auditing: Essential for maintaining a historical record of notice period rules for compliance and legal purposes.
- Retrospective Calculation: Used to determine the correct, applicable notice period for an employee based on the policy that was effective on their date of joining or the date of their resignation/termination.
Key Points:
- Immutability: Each record is a snapshot of the policy at a specific point in time.
- Links back to the live setup table via NoticePeriodSetUpId.
Business Impact: Guarantees accuracy and defensibility of notice period calculations (and pay-in-lieu calculations) during employee separation.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific historical snapshot.
noticeperiodsetupid int8 19 √ null

FK: public.tbl_NoticePeriodSetUp.Id
Meaning: The ID of the live, master notice period policy record that this history entry relates to.
employeeid varchar 2147483647 √ null

FK: public.tbl_employee.employeeid (Optional)
Meaning: A flag or placeholder for employee IDs, possibly indicating a specific employee or group the policy was tied to.
noticeperiodduringprobation numeric 0 √ null

The required notice period duration (in days/months) if the employee is still in their probation period.
noticeperiodafterconfirmation numeric 0 √ null

The required notice period duration (in days/months) after the employee has successfully completed their probation.
effectivedate date 13 √ null

The date from which this specific version of the notice period policy became active.
applicationcriteria varchar 2147483647 √ null

JSON or string data detailing the conditions (e.g., Designation, Department, Job Grade) for when this notice period policy applies.
stage varchar 10 √ null

The status of the policy (e.g., Active, Inactive, Draft) at the time this history record was created.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
policyname varchar 255 √ null

The name of the notice period policy in this historical version.

Indexes

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

Relationships

Close relationships within degrees of separation