tbl_employeelocation

-1 rows


Description

Module: HRMS Time & Attendance (Location Management)
Purpose: Stores configuration details for specific, authorized geographical locations where an employee is permitted to perform attendance actions (punch-in/out).
Data: Contains location name, coordinates (latitude/longitude), and required geofencing parameters for validation.
Process Usage:
- Referenced by the mobile application during punch-in/out to check if the employee’s current GPS location is within the defined punchinradius or fencingradius.
- Used to validate and restrict attendance based on defined work locations.
Key Points:
- Critical for ensuring that remote or field employees are reporting from authorized sites.
- Can be used for temporary project sites or permanent work-from-home locations.
Business Impact: Enhances attendance compliance and reduces time theft for non-office-based staff.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
employeelocationid bigserial 19 √ nextval('tbl_employeelocation_employeelocationid_seq'::regclass)
tbl_geofencingrulelocations.employeelocationid fk_tbl_geofencingrulelocations_employeelocationid R

Primary key
Format: Integer (auto-increment)
Used as: Unique identifier for a single authorized employee location configuration.
employeeid varchar 500 √ null
tbl_employee.employeeid fk_tbl_employeelocation_employeeid R

FK: public.tbl_employee.employeeid
Meaning: The ID of the employee to whom this specific location applies.
Format: Integer/Varchar.
locationname varchar 100 null

The user-friendly name of the authorized location (e.g., “Client Site A,” “Home Office - Mumbai,” “Project Everest”).
Format: Varchar/Text.
locationtype varchar 100 null

The classification of the location (e.g., Permanent, Temporary, Home, Project Site).
Format: Varchar/Text.
description varchar 500 √ null

Detailed remarks or instructions related to the use of this location.
Format: Text.
latitude float8 17,17 null

The geographical latitude coordinate of the center point of the authorized location.
Format: Numeric/Double Precision.
longitude float8 17,17 null

The geographical longitude coordinate of the center point of the authorized location.
Format: Numeric/Double Precision.
punchinradius float8 17,17 √ null

The required circular distance (in meters) around the center point for a successful attendance punch-in.
Format: Numeric.
fencingradius float8 17,17 √ null

The outer radius (in meters) defining the absolute boundary of the geofence.
Format: Numeric.
status varchar 100 null

The current lifecycle status of the location configuration (e.g., Active, Inactive, Pending).
Format: Varchar/Text.
statusdate timestamp 29,6 √ null

The timestamp when the current status was set.
Format: Timestamp with timezone.
statusby varchar 500 √ null
tbl_employee.employeeid fk_tbl_employeelocation_statusby R

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The ID of the user who set the current status.
statusremark varchar 500 √ null

Comments or detailed justification provided by the user who set the current status.
Format: Text.
deleted bool 1 null

Flag indicating if the location configuration has been logically deleted (soft delete).
Format: Boolean.
createdby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The user who created this location configuration.
createddate timestamp 29,6 √ null

Timestamp of when the location configuration record was created.
Format: Timestamp with timezone.
modifiedby varchar 50 √ null

FK: public.tbl_userlogin.id or public.tbl_employee.employeeid
Meaning: The last user who modified the location configuration record.
modifieddate timestamp 29,6 √ null

Timestamp of the last modification to the location configuration record.
Format: Timestamp with timezone.

Indexes

Constraint Name Type Sort Column(s)
pk_tbl_employeelocation_employeelocationid Primary key Asc employeelocationid
uq_tbl_employeelocation_locationname Must be unique Asc locationname

Relationships

Close relationships within degrees of separation