A database administrator is writing an automated script to archive inactive user accounts. During a test run, some active accounts are incorrectly flagged for deletion. The administrator decides to construct a trace table to debug the script.
Explain how the administrator uses a trace table to locate and resolve this logical error.