tbl_employeeemergancy

-1 rows


Description

Module: HRMS Employee Information & Safety
Purpose: Stores the contact details of the person(s) to be notified in the event of an employee emergency, accident, or critical health issue.
Data: Records the name, address, phone numbers, and relationship for each designated emergency contact.
Process Usage:
- Essential for use by HR, Security, or Administration staff during an on-site emergency or when an employee is unreachable.
- Often a mandatory field during the onboarding process.
Key Points:
- Critical for ensuring employee safety and compliance with workplace safety regulations.
- Includes provisions for two separate phone numbers for improved reliability.
Business Impact: Facilitates immediate contact with an employee’s family or next-of-kin during a crisis.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
eemergancyid bigserial 19 √ nextval('tbl_employeeemergancy_eemergancyid_seq'::regclass)
tbl_employeeemergancyhistory.eemergancyid fk__tbl_emplo__eemer__355184d2 R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single emergency contact 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 this emergency contact belongs.
Format: Integer/Varchar.
eemername varchar 60 √ null

The full name of the emergency contact person.
Format: Varchar/Text.
eemeraddress varchar 300 √ null

The full residential or mailing address of the emergency contact person.
Format: Text.
eemerphone1 varchar 15 √ null

The primary contact phone number of the emergency contact.
Format: Varchar.
eemerphone2 varchar 15 √ null

A secondary or alternate contact phone number for the emergency contact.
Format: Varchar.
eemerrelation varchar 60 √ null

The relationship of the contact person to the employee (e.g., Spouse, Parent, Sibling, Friend).
Format: Varchar/Text.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeeemergancy_pk_tbl_employeeemergancy Primary key Asc eemergancyid

Relationships

Close relationships within degrees of separation