tbl_employeeprobation

-1 rows


Description

Module: HRMS Employee Lifecycle & Performance
Purpose: Manages and tracks the probationary period for individual employees, recording key dates, confirmation status, and any extensions.
Data: Stores the planned probation duration, actual confirmation date, and justifications for any variations from the plan.
Process Usage:
- Used to automate reminders and tasks related to the end of the probation period.
- Provides the historical record for an employee’s initial employment status transition.
Key Points:
- Critical for compliance and documenting the formal decision to make an employee permanent.
- Tracks fields related to extension and final confirmation.
Business Impact: Ensures a structured and legally compliant process for employee confirmation or termination post-probation.

Columns

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

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for the employee’s probation record.
employeeid varchar 50 null

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee whose probation status is being tracked.
Format: Integer/Varchar.
startdate timestamp 29,6 √ null

The official start date of the employee’s probationary period (often the date of joining).
Format: Date.
enddate timestamp 29,6 √ null

The initially scheduled end date of the probationary period.
Format: Date.
extended bool 1 √ false

Flag indicating whether the probationary period was officially extended beyond the initial enddate.
Format: Boolean.
extendeddate timestamp 29,6 √ null

The new, extended end date of the probationary period, if applicable.
Format: Date.
reasonforextend varchar 300 √ null

Detailed justification or performance reason for extending the probationary period.
Format: Text.
confirmed bool 1 √ false

Flag indicating whether the employee was officially confirmed (made permanent) or separated/terminated.
Format: Boolean.
confirmeddate timestamp 29,6 √ null

The actual date the employee’s service was confirmed (should be equal to or later than enddate or extendeddate).
Format: Date.
reasonforconfirm varchar 300 √ null

Detailed remarks or performance notes regarding the final decision (confirmation or termination).
Format: Text.
confirmationstatus bool 1 √ false

The final outcome of the probation review (e.g., Confirmed, Extended, Terminated).
Format: Varchar/Text.
createddate timestamp 29,6 √ null

Timestamp of when the probation record was initially created in the system.
Format: Timestamp with timezone.
createdby varchar 200 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who created the probation record.
modifiedby varchar 200 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified the probation record (e.g., recorded an extension or confirmation).
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the probation record.
Format: Timestamp with timezone.
leaveallocatedonconfirmed bool 1 √ false

Flag or date indicating if and when any final/accrued leave entitlement was allocated upon confirmation.
Format: Boolean/Date.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeeprobation_pk_tbl_employeeprobation Primary key Asc probationid

Relationships

Close relationships within degrees of separation