tbl_employeerelation

-1 rows


Description

Module: HRMS Employee Information & Personal Records
Purpose: Stores the personal and contact details for an employee’s family members, dependents, or designated emergency contacts.
Data: Records the type of relationship, name, occupation, birthdate, and contact number for each related person.
Process Usage:
- Used by HR for emergency contact lists and statutory compliance (e.g., dependent benefits, insurance forms).
- Provides necessary data for benefits administration and compliance reporting.
Key Points:
- Essential for critical communication and legal/insurance purposes.
- Distinguishes between different types of relations (e.g., spouse, child, parent, emergency contact).
Business Impact: Ensures the organization has accurate and up-to-date information for critical situations and employee welfare programs.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
erelationid bigserial 19 √ nextval('tbl_employeerelation_erelationid_seq'::regclass)
tbl_employeerelationhistory.erelationid fk__tbl_emplo__erela__3b0a5e28 R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single relationship record.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee to whom the related person belongs.
Format: Integer/Varchar.
ertype varchar 40 √ null

The type of relationship to the employee (e.g., Spouse, Child, Parent, Sibling, Emergency Contact).
Format: Varchar/Text.
ername varchar 60 √ null

The full name of the related person.
Format: Varchar/Text.
eroccupation varchar 100 √ null

The occupation of the related person.
Format: Varchar/Text.
erbirthdate timestamp 29,6 √ null

The birth date of the related person.
Format: Date.
erdiscription varchar 100 √ null

Additional notes or description regarding the related person or their status (e.g., “Dependent for health insurance”).
Format: Text.
ermobileno varchar 15 √ null

The primary mobile contact number of the related person.
Format: Varchar.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeerelation_pk_tbl_employeerelation Primary key Asc erelationid

Relationships

Close relationships within degrees of separation