Administering BioTime 8.5.3 sometimes requires backend intervention. Follow these steps to remove a transaction via SQL and prevent it from reappearing via the hardware device.

Step 1: Identify the Transaction

Locate the specific record in the SQL database. Replace '158' with the actual employee ID.


SELECT * FROM iclock_transaction 
WHERE emp_code = '158' 
AND punch_time BETWEEN '2026-01-28 00:00:00' AND '2026-01-28 23:59:59'

Step 2: Note the ID

From the results of Step 1, find the id column. You will use this in the next steps (Example ID: 560317).

Step 3: Remove Foreign Key References

BioTime prevents deletion if the record is referenced in the payload table. Delete this reference first:


DELETE FROM att_payloadpunch WHERE orig_id = 560317

Step 4: Delete the Main Transaction

Once the reference is gone, you can remove the raw punch log from the main table:


DELETE FROM iclock_transaction WHERE id = 560317

Step 5: Force Recalculation (UI)

To update the employee's attendance reports, you must trigger a recalculation in the Web Interface:

  • Navigate to Attendance >> Calculation.
  • Select the Employee ID and Date Range.
  • Click the Calculator Icon to refresh the data.

Step 6: Clear Transaction from Physical Device

To prevent the ADMS from re-uploading the deleted entry from the hardware memory, remove it from the device via the BioTime UI:

  • Go to Device >> Data Clean >> Clean Attendance Data.
  • Change the mode to Specified (instead of "All").
  • Enter the Start Date, End Date, and Exact Time to target the specific entry.
  • Click Delete.