tbl_probationperiodsetuphistory

-1 rows


Description

Module: Confirmation - Probation Period Setup History/Audit Log
Purpose: Stores an immutable record of every version and change made to the master Probation Period Policy configurations (from a related tbl_ProbationPeriodSetUp table).
Data: Captures the policy name, the duration of the standard probation period, the effective date of the policy, and the specific criteria used to determine which employees the policy applies to.
Process Usage:
- Auditing: Provides a historical record of probation rules for compliance, legal defense, and ensuring correct policy application to employees based on their joining date.
- Retrospective Lookup: Used to look up the correct probation duration policy that was in effect for an employee at the time of their hiring.
Key Points:
- Immutability: Each record is a snapshot of the policy at a specific point in time.
- Links back to the active setup table via ProbationPeriodSetUpId.
Business Impact: Ensures consistent, accurate, and compliant application of probation policies during the employee confirmation cycle.

Columns

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

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

FK: public.tbl_ProbationPeriodSetUp.Id (Implied)
Meaning: The ID of the live, master probation policy record that this history entry relates to.
policyname varchar 255 √ null

The name of the probation policy in this historical version.
employeeid varchar 2147483647 √ null

FK: public.tbl_employee.employeeid (Optional)
Meaning: Placeholder for a specific employee ID, possibly used if a rule was manually applied to an individual.
probationdays numeric 0 √ null

The standard duration of the probation period defined by this policy version, measured in days.
effectivedate date 13 √ null

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

JSON or string data detailing the criteria (e.g., Job Grade, Designation, Department) for when this 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

Indexes

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

Relationships

Close relationships within degrees of separation