tbl_employee_geofencing_tracking_report

-1 rows


Description

Module: HRMS Geo-fencing Module
Purpose: Stores analyzed geo-fencing event pairs with calculated time durations between location events for employee movement analysis and attendance validation.
Data: Each row represents a time-bound event pair (start and end) with calculated duration, enabling analysis of employee presence, movement patterns, and GPS availability periods.
Process Usage:
- Tracks time durations between related geo-fencing events (GPS ON/OFF, location entries/exits).
- Calculates idle time periods and employee presence duration at locations.
- Provides analyzed data for attendance compliance and movement pattern reporting.
Key Points:<br-**Paired event tracking with start and end location data.
- Automated duration calculation in minutes between events.
- Supports both movement tracking and GPS status change monitoring.
Business Impact: Enables accurate time tracking for attendance purposes, monitors GPS reliability, and provides insights into employee movement patterns and location compliance.

Columns

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

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

FK: public.tbl_employee.employeeid
Purpose: Identifies the employee for this tracking analysis record.
Dependency: Links analyzed tracking data to employee master records.
locationid1 int8 19 √ null

FK: public.tbl_geofencing_location_master.location_id
Purpose: Reference to the predefined location for the start event.
Usage: Identifies the geo-fence zone where the time period began.
locationname1 varchar 500 √ null

Format: String
Purpose: Human-readable name of the start location.
Usage: Display purposes in reports and analytics dashboards.
latitude1 float8 17,17 null

Format: Double (Decimal degrees)
Purpose: Geographic latitude coordinate at the start of the tracking period.
Usage: Start point for distance calculations and movement analysis.
longitude1 float8 17,17 null

Format: Double (Decimal degrees)
Purpose: Geographic longitude coordinate at the start of the tracking period.
Usage: Start point for distance calculations and movement analysis.
timestamp1 timestamp 29,6 √ null

Format: Timestamp
Purpose: Exact date and time when the start event occurred.
Usage: Beginning of the calculated time period for duration analysis.
eventtype1 varchar 100 null

Format: String
Event Types: GPS_ON, GPS_OFF, GEO_FENCE_IDLE, GEO_FENCE_ENTER, GEO_FENCE_EXIT
Purpose: Classification of the start event that initiated this tracking period.
batterystatus1 varchar 100 √ null

Format: String
Purpose: Mobile device battery level at the start event time.
Usage: Device reliability assessment and data quality monitoring.
locationid2 int8 19 √ null

FK: public.tbl_geofencing_location_master.location_id
Purpose: Reference to the predefined location for the end event.
Usage: Identifies the geo-fence zone where the time period ended.
locationname2 varchar 500 √ null

Format: String
Purpose: Human-readable name of the end location.
Usage: Display purposes in reports and analytics dashboards.
latitude2 float8 17,17 √ null

Format: Double (Decimal degrees)
Purpose: Geographic latitude coordinate at the end of the tracking period.
Usage: End point for distance calculations and movement analysis.
longitude2 float8 17,17 √ null

Format: Double (Decimal degrees)
Purpose: Geographic longitude coordinate at the end of the tracking period.
Usage: End point for distance calculations and movement analysis.
timestamp2 timestamp 29,6 √ null

Format: Timestamp
Purpose: Exact date and time when the end event occurred.
Usage: Conclusion of the calculated time period for duration analysis.
eventtype2 varchar 100 √ null

Format: String
Event Types: GPS_ON, GPS_OFF, GEO_FENCE_IDLE, GEO_FENCE_ENTER, GEO_FENCE_EXIT
Purpose: Classification of the end event that concluded this tracking period.
batterystatus2 varchar 100 √ null

Format: String
Purpose: Mobile device battery level at the end event time.
Usage: Device reliability assessment and data quality monitoring.
totaltime varchar 100 √ null

Format: String (stored as minutes)
Purpose: Calculated duration between the start and end events in minutes.
Calculation: (timeStamp2 - timeStamp1) converted to minutes
Usage: Primary metric for attendance duration, idle time analysis, and presence tracking.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_employee_geofencing_tracking_report_pk Primary key Asc geofencingtrackingreportid

Relationships

Close relationships within degrees of separation