tbl_probationperiodsetup

-1 rows


Description

Module: Employee Lifecycle/Confirmation Management - Probation Period Policy Master
Purpose: Stores the active, master rule sets that define the standard duration and application criteria for the employee probation period.
Data: Captures the policy name, the duration in days, the effective date of the rule, and the criteria (e.g., job grade, department) that determine which employees are subject to this policy.
Process Usage:
- Default Setting: Used to determine the default probation end date for a new employee based on their join date and applicable criteria.
- Confirmation Workflow: Feeds the duration into the confirmation process workflow.
- Auditing: Changes to this table trigger a record entry into tbl_ProbationPeriodSetUpHistory.
Key Points:
- Rule Master: This table holds the current, actively used set of rules.
- The ApplicationCriteria field allows for varying probation policies across different employee groups.
Business Impact: Standardizes the initial employment period across the organization, ensuring fairness and compliance.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this probation policy rule set.
policyname varchar 255 √ null

The unique name given to this probation policy (e.g., “Standard 6 Month Policy,” “Leadership 3 Month Policy”).
employeeid varchar 2147483647 √ null

FK: public.tbl_employee.employeeid (Optional)
Meaning: Placeholder for a specific employee ID, used if a policy is defined for an individual rather than a group.
probationdays numeric 0 √ null

The length of the standard probation period, expressed in total number of days.
effectivedate date 13 √ null

The date from which this specific policy rule set is officially active and applicable.
applicationcriteria varchar 2147483647 √ null

JSON or string data detailing the conditions (e.g., {“JobGrade”: [“A”, “B”], “Department”: [“IT”]}) for when this policy is applied to a new employee.
stage varchar 10 √ null

The current lifecycle stage of the policy (e.g., Active, Inactive).
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_probationperiodsetup_pk__tbl_prob__3214ec074330537c Primary key Asc id

Relationships

Close relationships within degrees of separation