tbl_rejected_punch

-1 rows


Description

Module: Attendance
Purpose: Stores detailed records of employee punch-in/out events that were automatically rejected by the system based on predefined business or compliance rules (e.g., out of punch radius punches).
Data: Contains all original punch metadata, including time, location coordinates (lat/long), employee ID, device details (battery status, punch source), and a link to the original tracker record.
Process Usage:
- A record is created when a UserTracker record fails validation and is prevented from being recorded as a valid punch.
- Used for auditing system rejections, troubleshooting, and potentially for manual review/override of invalid punches.
Key Points:
- Quarantine: Acts as a holding area for invalid/untrusted attendance data.
- Mirrors the structure of the live punch table (UserTracker) to preserve all context.
Business Impact: Ensures the integrity and compliance of the official attendance data by isolating problematic entries.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tbl_rejected_punch_id_seq'::regclass)

Primary key
Format: Long (auto-increment)
Used as: Unique identifier for this rejected punch record.
daily_tracker_id int4 10 √ null

FK: public.tbl_user_tracker.daily_tracker_id
Meaning: The ID of the original attendance tracking record (from UserTracker) that was rejected.
employee_id varchar 500 null

FK: public.tbl_employee.employeeid
Meaning: The Employee ID associated with the rejected punch.
date timestamp 29,6 null

The date and time of the rejected punch event.
latitude varchar 30 √ null

The GPS latitude coordinate recorded at the time of the punch.
longitude varchar 30 √ null

The GPS longitude coordinate recorded at the time of the punch.
punch_type varchar 10 null

Indicates whether the rejected punch was an IN or an OUT event.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null
networking varchar 100 √ null

The calculated networking/working hours associated with this punch, prior to rejection.
siteid varchar 100 √ null

FK: public.tbl_site.id
Meaning: The work site ID recorded with the punch (used for geofencing validation).
punchfrom int4 10 √ null

Source of the punch submission (e.g., 1=Mobile App, 2=Web Portal, 3=Biometric).
batterystatus varchar 50 √ null

The battery level/status of the device used to submit the punch.
expensetracking varchar 50 √ null

A flag or identifier indicating if this punch was also linked to expense/mileage tracking.
locationname varchar 500 √ null

The resolved human-readable name of the location where the punch occurred.
punchinoutimageid int4 10 √ null

FK: ID of the image uploaded with the punch (if applicable).
Meaning: Links to the image verification record associated with the rejected punch event.
tbl_user_tracker_resync int4 10 √ null

Indexes

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

Relationships

Close relationships within degrees of separation