tbl_employeetrackingpolicymapping

-1 rows


Description

Module: HRMS Employee Tracking
Purpose: Manages the assignment of tracking policies to individual employees, defining their specific location tracking requirements and monitoring rules.
Data: Each row represents a tracking policy assigned to an employee, linking employee records to their applicable tracking configurations and monitoring rules.
Process Usage:
- Associates employees with specific tracking policies based on role, department, or individual requirements.
- Enables granular control over employee monitoring levels and tracking frequency.
- Supports flexible policy assignment for different workforce segments (field staff, remote workers, office staff).
Key Points:
- Simple many-to-many relationship between employees and tracking policies.
- Enables role-based tracking configuration and compliance requirements.
- Supports dynamic policy updates and employee reassignments.
Business Impact: Ensures appropriate tracking levels for different employee types, maintains compliance with monitoring policies, and enables flexible workforce management.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('tbl_employeetrackingpolicymapping_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for each employee tracking policy assignment.

employeeid varchar 50 null

FK: public.tbl_employee.employeeid
Purpose: Identifies the employee to whom this tracking policy is assigned.
Dependency: Links policy assignments to employee master records for personalized tracking configuration.
Usage: Determines which tracking rules and monitoring frequency apply to specific employees.

trackingpolicyid int8 19 null

FK: public.tbl_tracking_policy.TrackingPolicyId
Purpose: References the specific tracking policy being assigned to the employee.
Usage: Defines tracking parameters such as frequency, location accuracy requirements, working hours tracking, and monitoring intensity.
Policy Examples: “High-Frequency Field Tracking”, “Standard Office Tracking”, “Minimal Remote Tracking”, “Client Site Monitoring”.

createdby varchar 20 null
createddate timestamp 29,6 null
modifiedby varchar 20 null
modifieddate timestamp 29,6 null

Indexes

Constraint Name Type Sort Column(s)
tbl_employeetrackingpolicymapping_pk_tbl_employeetrackingpolicy Primary key Asc id

Relationships