tbl_employeecontactinfohistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores historical records of employee contact information changes.
Data: Each record represents a modification or new entry in the employee contact details submitted by the employee.
Process Usage:
- Tracks proposed updates to employee contact details from Employee Profile → Personal Tab → Contact Details.
- Records include phone numbers, email addresses, and social media links.
- Submitted changes are stored here until reviewed and approved/rejected by HR.
Key Points:
- Approved records are reflected in the main contact information table.
- Supports auditability and change history for employee personal contact data.
Business Impact: Maintains a detailed change history of employee contact details, ensuring compliance, transparency, and traceability of updates.

Columns

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

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each contact info history record.
companyid int4 10 null
tbl_companymaster.companyid Implied Constraint R

Company ID
Format: INTEGER
FK: public.tbl_companymaster.companyid (implicit)
Meaning: Identifies the company to which the employee belongs.
Usage: Ensures data segregation in multi-tenant environments.
employeeid varchar 500 null
tbl_employee.employeeid fk_tbl_employeecontactinfohistory_employeeid R

Employee ID
Format: VARCHAR(500)
FK: public.tbl_employee.employeeid
Meaning: References the employee whose contact information is being updated.
Usage: Links this historical record to a specific employee.
contactno varchar 15 √ null

Personal Contact Number
Format: VARCHAR(15)
Meaning: Employee’s personal contact number.
Source: Employee Profile → Personal Tab → Contact Details → Contact No.
Usage: Used for personal communication with the employee.
officialno varchar 15 √ null

Official Contact Number
Format: VARCHAR(15)
Meaning: Official contact number assigned by the organization (if applicable).
Source: Employee Profile → Personal Tab → Contact Details → Official No.
Usage: Used for office-related communication.
alternatecontactno varchar 15 √ null

Alternate Contact Number
Format: VARCHAR(15)
Meaning: Secondary phone number for emergency or alternate contact.
Source: Employee Profile → Personal Tab → Contact Details → Alternate Contact No.
personalemail varchar 100 √ null

Personal Email ID
Format: VARCHAR(100)
Meaning: Employee’s personal email address.
Source: Employee Profile → Personal Tab → Contact Details → Personal Email.
Usage: Used for personal or emergency communication.
facebookurl varchar 200 √ null

Facebook URL
Format: VARCHAR(200)
Meaning: Employee’s Facebook profile link.
Source: Employee Profile → Personal Tab → Contact Details → Facebook URL.
Usage: Optional social media reference.
linkedinurl varchar 200 √ null

LinkedIn URL
Format: VARCHAR(200)
Meaning: Employee’s LinkedIn profile link.
Source: Employee Profile → Personal Tab → Contact Details → LinkedIn URL.
Usage: Used to reference the employee’s professional network.
twitterurl varchar 200 √ null

Twitter URL
Format: VARCHAR(200)
Meaning: Employee’s Twitter/X profile link.
Source: Employee Profile → Personal Tab → Contact Details → Twitter URL.
Usage: Optional social media reference.
rejectreason varchar 200 √ null

Rejection Reason
Format: VARCHAR(200)
Meaning: HR/admin remarks for rejecting the submitted contact information change.
Usage: Captured during approval/rejection workflow.
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
status varchar 20 √ null

Record Status
Format: VARCHAR(20)
Possible Values: Pending, Approved, Rejected
Meaning: Current approval state of the historical record.
Usage: Determines whether changes should be applied to the main contact table (tbl_employeeaddress).
eaddressid int8 19 √ null
tbl_employeeaddress.eaddressid Implied Constraint R

Employee Address ID
Format: BIGINT
FK: public.tbl_employeeaddress.eaddressid
Meaning: References the address record to which the contact details relate.
Usage: Links contact history entries to address records for audit consistency.

Indexes

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

Relationships

Close relationships within degrees of separation