tbl_employee_geofencing_tracking

-1 rows


Description

Module: HRMS Geo-fencing Module
Purpose: Tracks real-time employee location data and geo-fencing events for attendance validation, movement monitoring, and location-based compliance.
Data: Each row represents a location tracking event captured from employee mobile devices or GPS systems, including coordinates, timestamps, and device status.
Process Usage:
- Captures employee location data for attendance marking and geo-fencing compliance.
- Monitors device status changes (GPS ON/OFF) for tracking reliability.
- Provides audit trail for employee movement and location-based validations.
Key Points:
- Real-time location tracking with GPS coordinates and timestamps.
- Device status monitoring including battery levels and GPS availability.
- Integration with geo-fencing rules and attendance validation workflows.
Business Impact: Enables accurate attendance tracking, ensures field employee accountability, and provides location-based compliance for remote workforce management.

Columns

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

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for each geo-fencing tracking event.
employeeid varchar 500 √ null
tbl_employee.employeeid Implied Constraint R

FK: public.tbl_employee.employeeid
Purpose: Identifies the employee being tracked in this location event.
Dependency: Links tracking data to employee master records for reporting and validation.
locationid int8 19 √ null

FK: public.tbl_geofencing_location_master.location_id
Purpose: Reference to predefined geo-fencing location or zone.
Usage: Associates tracking event with specific company locations, branches, or designated areas.
latitude float8 17,17 null

Format: Double (Decimal degrees)
Purpose: Geographic latitude coordinate of the employee’s location.
Precision: Typically 6 decimal places (~10cm accuracy)
Range: -90.0 to +90.0
Usage: Primary coordinate for distance calculations and map plotting.
longitude float8 17,17 null

Format: Double (Decimal degrees)
Purpose: Geographic longitude coordinate of the employee’s location.
Precision: Typically 6 decimal places (~10cm accuracy)
Range: -180.0 to +180.0
Usage: Primary coordinate for distance calculations and map plotting.
timestamp timestamp 29,6 √ null

Format: Timestamp
Purpose: Exact date and time when the location event was captured.
Collection Source: Device system time or server reception time.
Usage: Critical for attendance validation, shift timing, and event sequencing.
eventtype varchar 100 null

Format: String
Event Types: GPS_ON, GPS_OFF
Purpose: Classifies the type of tracking event for workflow processing.
Business Logic:
- GPS_ON/GPS_OFF: Device GPS status changes
- GEO_FENCE_IDLE: Regular location updates within geo-fence
- GEO_FENCE_ENTER/EXIT: Boundary crossing events
- LOCATION_UPDATE: Periodic coordinate updates
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
batterystatus varchar 100 √ null

Format: String
Purpose: Captures the mobile device battery level at time of tracking.
Values: Percentage (e.g., “85%”), “CHARGING”, “LOW”, “CRITICAL”
Usage: Monitors tracking reliability and identifies potential data gaps due to device power issues.
locationname varchar 500 √ null

Format: String
Purpose: Human-readable name of the location or address derived from coordinates.
Usage: Display purposes in reports and UI, reverse geocoding result.
Examples: “Office Building A”, “Client Site - Mumbai”, “Home Address”

Indexes

Constraint Name Type Sort Column(s)
tbl_employee_geofencing_tracking_pk Primary key Asc geofencingtrackingid

Relationships

Close relationships within degrees of separation