tbl_employeeaddress

-1 rows


Description

Module: Employee Profile
Purpose: To store employee current and permanent address details.
Data: One row is created per employee to hold current and permanent address fields as entered via the Profile Approval page or directly by admins.
Process Usage:
- Stores address details submitted from the profile approval workflow or admin UI.
- Used for contact information, mailing, and identity verification.
Key Points:
- Contains both current and permanent address fields and related metadata.
Business Impact: Ensures accurate contact information for employees and supports HR workflows, compliance, and communication.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
eaddressid bigserial 19 √ nextval('tbl_employeeaddress_eaddressid_seq'::regclass)
tbl_employeeaddresshistory.eaddressid fk__tbl_emplo__eaddr__345d6099 R
tbl_employeecontactinfohistory.eaddressid Implied Constraint R
view_employeedetail.eaddressid Implied Constraint R

Primary key
Format: BIGSERIAL (auto-increment)
Used as: Unique identifier for each address record.
employeeid varchar 20 null
tbl_employee_previous_pf.employeeid Implied Constraint R

Meaning: Identifies which employee this address belongs to.
Format: VARCHAR(20)
Usage: Links the address record to the employee master record.
eaddress varchar 300 √ null

Meaning: Current address - Street Address Line 1.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Current).
ecity varchar 100 √ null

Meaning: Current address - City name.
Format: VARCHAR(100)
Usage: Stores selected city name for current address.
estate varchar 100 √ null

Meaning: Current address - State name.
Format: VARCHAR(100)
Usage: Stores selected state name for current address.
ecountry varchar 100 √ null

Meaning: Current address - Country name.
Format: VARCHAR(100)
Usage: Stores selected country name for current address.
epostcode varchar 100 √ null

Meaning: Current address - Pincode with description.
Format: VARCHAR(100)
Example: ‘384001 - Mahesana Bazar’
Usage: Stores pincode along with location description for current address.
ephoneno varchar 15 √ null

Meaning: Current address - Contact number.
Format: VARCHAR(15)
Usage: Source: Employee Profile → Personal Tab → Contact Details → Contact No.
emobileno varchar 15 √ null

Meaning: Current address - Official mobile number.
Format: VARCHAR(15)
Usage: Source: Employee Profile → Personal Tab → Contact Details → Official No.
epersonalemail varchar 100 √ null

Meaning: Personal email address.
Format: VARCHAR(100)
Usage: Source: Employee Profile → Personal Tab → Contact Details → Personal Email.
eaddress1 varchar 300 √ null

Meaning: Permanent address - Street Address Line 1.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Permanent).
ecity1 varchar 100 √ null

Meaning: Permanent address - City name.
Format: VARCHAR(100)
Usage: Stores selected city name for permanent address.
estate1 varchar 100 √ null

Meaning: Permanent address - State name.
Format: VARCHAR(100)
Usage: Stores selected state name for permanent address.
ecountry1 varchar 100 √ null

Meaning: Permanent address - Country name.
Format: VARCHAR(100)
Usage: Stores selected country name for permanent address.
epostcode1 varchar 100 √ null

Meaning: Permanent address - Pincode with description.
Format: VARCHAR(100)
Example: ‘384001 - Mahesana Bazar’
Usage: Stores pincode along with location description for permanent address.
ephoneno1 varchar 15 √ null

Meaning: Permanent address - Contact number.
Format: VARCHAR(15)
Status: Not specifically used in code.
Potential Use: Could be used for alternate contact storage.
emobileno1 varchar 15 √ null

Meaning: Permanent address - Alternate contact number.
Format: VARCHAR(15)
Usage: Source: Employee Profile → Personal Tab → Contact Details → Alternate Contact No.
evillage varchar 50 √ null

Meaning: Current address - Village.
Format: VARCHAR(50)
Status: Present in code but no specific active usage documented.
etaluka varchar 50 √ null

Meaning: Current address - Taluka (sub-district).
Format: VARCHAR(50)
Status: Present in code but no specific active usage documented.
evillage1 varchar 50 √ null

Meaning: Permanent address - Village.
Format: VARCHAR(50)
Status: Present in code but no specific active usage documented.
etaluka1 varchar 50 √ null

Meaning: Permanent address - Taluka (sub-district).
Format: VARCHAR(50)
Status: Present in code but no specific active usage documented.
dist varchar 20 √ null

Meaning: Current address - District.
Format: VARCHAR(20)
Status: Present in code but no specific active usage documented.
post varchar 20 √ null

Meaning: Current address - Post office code/name.
Format: VARCHAR(20)
Status: Present in code but no specific active usage documented.
dist1 varchar 20 √ null

Meaning: Permanent address - District.
Format: VARCHAR(20)
Status: Present in code but no specific active usage documented.
post1 varchar 20 √ null

Meaning: Permanent address - Post office code/name.
Format: VARCHAR(20)
Status: Present in code but no specific active usage documented.
component1 varchar 50 √ null

Meaning: Component 1 (used to store Skype ID historically).
Format: VARCHAR(50)
Status: Present in code but not actively used in workflows.
component2 varchar 50 √ null

Meaning: Component 2.
Format: VARCHAR(50)
Status: Present in code but not actively used in workflows.
component3 varchar 50 √ null

Meaning: Component 3.
Format: VARCHAR(50)
Status: Present in code but not actively used in workflows.
component4 varchar 50 √ null

Meaning: Component 4.
Format: VARCHAR(50)
Status: Present in code but not actively used in workflows.
component5 varchar 50 √ null

Meaning: Component 5.
Format: VARCHAR(50)
Status: Present in code but not actively used in workflows.
facebookurl varchar 200 √ null

Meaning: Facebook profile URL.
Format: VARCHAR(200)
Usage: Source: Employee Profile → Personal Tab → Contact Details → Facebook URL.
linkedinurl varchar 200 √ null

Meaning: LinkedIn profile URL.
Format: VARCHAR(200)
Usage: Source: Employee Profile → Personal Tab → Contact Details → LinkedIn URL.
twitterurl varchar 200 √ null

Meaning: Twitter profile URL.
Format: VARCHAR(200)
Usage: Source: Employee Profile → Personal Tab → Contact Details → Twitter URL.
building varchar 300 √ null

Meaning: Current address - Building/Flat No.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Current).
building1 varchar 300 √ null

Meaning: Permanent address - Building/Flat No.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Permanent).
street varchar 300 √ null

Meaning: Current address - Street No/Street Name.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Current).
street1 varchar 300 √ null

Meaning: Permanent address - Street No/Street Name.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Permanent).
addressline2current varchar 300 √ null

Meaning: Current address - Street Address Line 2.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Current).
addressline2permanent varchar 300 √ null

Meaning: Permanent address - Street Address Line 2.
Format: VARCHAR(300)
Usage: Source: Employee Profile → Personal Tab → Address (Permanent).
country_id int8 19 √ null

Meaning: Current address - Country ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant country identifier for current address.
state_id int8 19 √ null

Meaning: Current address - State ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant state identifier for current address.
city_id int8 19 √ null

Meaning: Current address - City ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant city identifier for current address.
pincode_id int8 19 √ null

Meaning: Current address - Pincode ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant pincode identifier for current address.
country1_id int8 19 √ null

Meaning: Permanent address - Country ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant country identifier for permanent address.
state1_id int8 19 √ null

Meaning: Permanent address - State ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant state identifier for permanent address.
city1_id int8 19 √ null

Meaning: Permanent address - City ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant city identifier for permanent address.
pincode1_id int8 19 √ null

Meaning: Permanent address - Pincode ID (master tenant lookup).
Format: INT8
Usage: Stores master tenant pincode identifier for permanent address.

Indexes

Constraint Name Type Sort Column(s)
tbl_employeeaddress_pk_tbl_employeeaddress Primary key Asc eaddressid

Relationships

Close relationships within degrees of separation