tbl_employeeemergancyhistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores the historical records of employee emergency contact information.
Process Usage:
- When an employee submits or updates their emergency contact details, the data is first stored here for approval.
- HR or Admin users can review and approve/reject the changes.
- Upon approval, the data is reflected in the main table tbl_employeeemergancy.
Key Points:
- Maintains version history of emergency contact details.
- Enables tracking of updates and approvals for audit purposes.
- Helps ensure the correctness and approval workflow of sensitive employee contact data.
Business Impact:
Improves employee safety and compliance by ensuring emergency contact details are accurate, verified, and properly approved.

Columns

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

Primary Key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each historical emergency contact record.
eemergancyid int8 19 √ null
tbl_employeeemergancy.eemergancyid fk__tbl_emplo__eemer__355184d2 R

Meaning: References the main record in tbl_employeeemergancy.
Usage: Links history entries to their corresponding active emergency contact record for traceability.
employeeid varchar 20 √ null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: Employee ID of the person whose emergency contact details are recorded.
Usage: Identifies which employee this emergency contact belongs to.
eemername varchar 60 √ null

Meaning: Name of the emergency contact person.
Usage: Displays the full name of the individual to contact in case of emergency.
eemeraddress varchar 300 √ null

Meaning: Address of the emergency contact person.
Usage: Provides the residential or communication address for emergency purposes.
eemerphone1 varchar 15 √ null

Meaning: Primary phone number of the emergency contact person (usually mobile).
Usage: Used as the first point of contact in case of an emergency.
eemerphone2 varchar 15 √ null

Meaning: Secondary phone number of the emergency contact person (usually landline).
Usage: Alternative contact number in case the primary number is unreachable.
status varchar 20 √ null

Meaning: Approval status of the emergency contact record.
Possible Values: Approved, Rejected, Pending (or NULL = Pending).
Usage: Determines whether the record has been approved and reflected in the main table.
rejectreason varchar 200 √ null

Meaning: Reason or comment entered by Admin/HR during approval or rejection.
Usage: Captures remarks for audit trail and communication purposes.
createddate timestamp 29,6 √ null
createdby varchar 50 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
eemerrelation varchar 60 √ null

Meaning: Relationship between the employee and the emergency contact person (e.g., Father, Mother, Spouse).
Usage: Helps identify the nature of relationship for HR and safety protocols.

Relationships

Close relationships within degrees of separation