tbl_employee_contract

-1 rows


Description

Module: Employee Lifecycle Management - Employee Contract Master
Purpose: Stores the formal employment contract details for each employee, tracking the validity period and type of engagement.
Data: Captures the unique contract ID, the employee ID, the start and end dates of the agreement, the contract type (e.g., Permanent, Fixed-Term, Consultant), and its current active status.
Process Usage:
- Term Management: Used to track the tenure of fixed-term contracts and trigger renewal or separation workflows before the end_date.
- Compliance: Serves as the system record of the employment agreement terms.
- Payroll/Benefits: May influence eligibility for certain benefits based on contract_type.
Key Points:
- Lifecycle Data: Critical data point for the employee lifecycle, often updated upon promotion, renewal, or extension.
- The @Where(clause = "erunning = true") annotation suggests a filtered relationship to the current active EmployeeStructure record.
Business Impact: Essential for legal compliance, workforce planning, and managing tenure-based policies.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this specific contract instance.
employeeid varchar 255 √ null
tbl_employee.employeeid fk_employee R

FK: public.tbl_employee.employeeId
Meaning: The Employee ID to whom this contract applies.
start_date date 13 √ null

The effective start date of this specific contract period (often the joining date or renewal date).
end_date date 13 √ null

The stipulated end date of the contract. Null if the contract is for an indefinite term (e.g., Permanent).
contract_type varchar 255 √ null

The category or type of the contract (e.g., PERMANENT, FIXED_TERM, CONSULTANT, TEMPORARY).
is_active bool 1 √ null

Boolean flag: Indicates if this contract record is the current, active employment agreement for the employee.
createdby varchar 255 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 255 √ null
modifieddate timestamp 29,6 √ null

Indexes

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

Relationships

Close relationships within degrees of separation