tbl_geofencingrulelocations

-1 rows


Description

Module: HRMS geo-fencing Module
Purpose: Defines the association between geofencing rules and physical work locations to enforce location-based attendance policies.
Data: Each row represents a unique assignment of a geofencing rule to a specific employee work location.
Process Usage:
- Used by the mobile app and backend services to determine applicable geofencing rules for check-in/check-out validation.
- Managed by administrators to configure which rules apply to which physical locations.
Key Points:
- Enforces unique combinations of rules and locations through a composite unique constraint.
- Serves as the configuration backbone for location-based access control and attendance tracking.
Business Impact: Ensures accurate location validation for attendance, prevents time fraud, and maintains compliance with work-site policies.

Columns

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

Primary key
Format: Bigint (auto-increment)
Used as: Unique identifier for a single rule-location assignment.
geofencingruleid int8 19 null
tbl_geofencingrule.geofencingruleid fk_tbl_geofencingrulelocations_geofencingruleid R

FK: public.tbl_geofencingrule.geofencingruleid
Meaning: The geofencing rule being applied to a location.
Dependency: Links to the master rule defining the geofence boundaries and policies.
employeelocationid int8 19 null
tbl_employeelocation.employeelocationid fk_tbl_geofencingrulelocations_employeelocationid R

FK: public.tbl_employeelocation.employeelocationid
Meaning: The physical work location where this geofencing rule is enforced.
Dependency: Specifies the actual site/office subject to the rule restrictions.
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)
pk_tbl_geofencingrulelocations_geofencingrulelocationsid Primary key Asc geofencingrulelocationsid
tbl_geofencingrulelocations_uq_tbl_employeelocation_geofencingr Must be unique Asc/Asc geofencingruleid + employeelocationid

Relationships

Close relationships within degrees of separation