tbl_employeeaddresshistory

-1 rows


Description

Module: Employee Profile
Purpose: Stores employee address history, including both current and permanent addresses.
Data: Each record represents a submitted or approved address update for an employee.
Process Usage:
- When an employee updates their address, it is stored here with Pending status.
- Once the admin approves the address, the record is marked as Approved and the data is reflected in tbl_employeeaddress.
- If rejected, Rejected status is set with the reason stored in rejectreason.
Key Points:
- Maintains historical changes to employee addresses.
- Ensures data auditability and approval-based address management.

Columns

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

Meaning: Primary key.
Format: BIGSERIAL (auto-increment).
Usage: Uniquely identifies each address history record.
eaddressid int8 19 √ null
tbl_employeeaddress.eaddressid fk__tbl_emplo__eaddr__345d6099 R

Meaning: Foreign key referencing tbl_employeeaddress.
Usage: Identifies which main employee address record this history entry belongs to.
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: Employee ID.
Usage: Identifies the employee whose address history record this entry belongs to.
eaddress varchar 300 √ null

Meaning: Current address line 1.
Usage: Stores the main address details (current residence).
ecity varchar 100 √ null

Meaning: Current address city.
Usage: Stores the city for the current address.
estate varchar 100 √ null

Meaning: Current address state.
Usage: Stores the state/region for the current address.
ecountry varchar 100 √ null

Meaning: Current address country.
Usage: Stores the country for the current address.
epostcode varchar 100 √ null

Meaning: Current address postal code.
Usage: Stores the ZIP or PIN code.
ephoneno varchar 15 √ null

Meaning: Current address phone number.
Usage: Landline or contact number for current address.
emobileno varchar 15 √ null

Meaning: Current address mobile number.
Usage: Primary contact number for the employee.
epersonalemail varchar 100 √ null

Meaning: Personal email ID.
Usage: Used for personal communication outside the organization email.
eaddress1 varchar 300 √ null

Meaning: Permanent address line 1.
Usage: Stores the main address details (permanent residence).
ecity1 varchar 100 √ null

Meaning: Permanent address city.
Usage: Stores the city for the permanent address.
estate1 varchar 100 √ null

Meaning: Permanent address state.
Usage: Stores the state/region for the permanent address.
ecountry1 varchar 100 √ null

Meaning: Permanent address country.
Usage: Stores the country for the permanent address.
epostcode1 varchar 100 √ null

Meaning: Permanent address postal code.
Usage: ZIP or PIN code for the permanent address.
ephoneno1 varchar 15 √ null

Meaning: Permanent address phone number.
Usage: Landline or contact number for permanent address.
emobileno1 varchar 15 √ null

Meaning: Permanent address mobile number.
Usage: Primary contact number for permanent address.
evillage varchar 50 √ null

Meaning: Current address village name.
Usage: Used for rural area identification.
etaluka varchar 50 √ null

Meaning: Current address taluka/sub-district name.
Usage: Administrative subdivision for rural address mapping.
evillage1 varchar 50 √ null

Meaning: Permanent address village name.
Usage: Used for rural area identification (permanent address).
etaluka1 varchar 50 √ null

Meaning: Permanent address taluka/sub-district name.
Usage: Administrative subdivision for permanent address.
dist varchar 20 √ null

Meaning: Current address district name.
Usage: Identifies the district for the current address.
post varchar 20 √ null

Meaning: Current address post office name.
Usage: Used for mail routing and validation.
dist1 varchar 20 √ null

Meaning: Permanent address district name.
Usage: Identifies the district for the permanent address.
post1 varchar 20 √ null

Meaning: Permanent address post office name.
Usage: Used for mail routing (permanent address).
component1 varchar 50 √ null

Meaning: Custom component 1.
Usage: Optional address-related component (reserved for future use).
component2 varchar 50 √ null

Meaning: Custom component 2.
Usage: Optional address-related component (reserved for future use).
component3 varchar 50 √ null

Meaning: Custom component 3.
Usage: Optional address-related component (reserved for future use).
component4 varchar 50 √ null

Meaning: Custom component 4.
Usage: Optional address-related component (reserved for future use).
component5 varchar 50 √ null

Meaning: Custom component 5.
Usage: Optional address-related component (reserved for future use).
status varchar 20 √ null

Meaning: Record status.
Possible Values: Approved, Rejected, Pending.
Usage: Tracks whether the address update is approved, rejected, or awaiting approval.
rejectreason varchar 200 √ null

Meaning: Reason for rejection.
Usage: Captures admin/HR remarks explaining why the address update was rejected.
createddate timestamp 29,6 √ null
createdby varchar 200 √ null
modifieddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
facebookurl varchar 200 √ null

Meaning: Employee’s Facebook profile link.
Usage: Optional social profile reference.
linkedinurl varchar 200 √ null

Meaning: Employee’s LinkedIn profile link.
Usage: Optional professional social profile reference.
twitterurl varchar 200 √ null

Meaning: Employee’s Twitter (X) profile link.
Usage: Optional social profile reference.
building varchar 300 √ null

Meaning: Current address building or apartment name.
Usage: Additional address detail.
building1 varchar 300 √ null

Meaning: Permanent address building or apartment name.
Usage: Additional address detail.
street varchar 300 √ null

Meaning: Current address street name.
Usage: Used for precise location identification.
street1 varchar 300 √ null

Meaning: Permanent address street name.
Usage: Used for precise location identification.
addressline2current varchar 300 √ null

Meaning: Current address line 2.
Usage: Secondary line for additional address information.
addressline2permanent varchar 300 √ null

Meaning: Permanent address line 2.
Usage: Secondary line for additional address information.
country_id int8 19 √ null

Meaning: Foreign key reference for current address country.
Usage: Links to master country table.
state_id int8 19 √ null

Meaning: Foreign key reference for current address state.
Usage: Links to master state table.
city_id int8 19 √ null

Meaning: Foreign key reference for current address city.
Usage: Links to master city table.
pincode_id int8 19 √ null

Meaning: Foreign key reference for current address pincode.
Usage: Links to master pincode table.
country1_id int8 19 √ null

Meaning: Foreign key reference for permanent address country.
Usage: Links to master country table.
state1_id int8 19 √ null

Meaning: Foreign key reference for permanent address state.
Usage: Links to master state table.
city1_id int8 19 √ null

Meaning: Foreign key reference for permanent address city.
Usage: Links to master city table.
pincode1_id int8 19 √ null

Meaning: Foreign key reference for permanent address pincode.
Usage: Links to master pincode table.

Indexes

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

Relationships

Close relationships within degrees of separation