Backflow

Every backflow prevention assembly and air gap in the service area is recorded with the details the Cross-Connection Control Policy Handbook names: the hazard or application, location, owner, type, manufacturer and model, size, installation date and serial number. Assembly types and hazard degrees use the Handbook's defined terms.

An assembly is current for one year after its latest passing field test, then due soon and overdue. A new assembly is untested until its first test after installation. A failed assembly shows the date its repair is due, 30 days after the failure was notified, and stays failed until a passing test closes it.

The program counts on the register page always match the list each one opens, because both come from the same evaluation.

A test qualifies only when the tester held a valid certification on the test date. The tester's name, certification number and expiry are copied onto each test when it is entered, so a later change to the tester list cannot rewrite who signed an old test. Certifications expiring within 30 days are flagged.

Test records are append only and an assembly with tests is marked removed rather than deleted, so the history the Handbook asks a water system to keep stays on file.

A daily check sends one digest of the assemblies newly overdue, a notice for each failed assembly past its repair window, and a notice for each tester certification about to lapse. The signed test report attaches to the assembly as a document.

An existing register and its test history import from a spreadsheet, and the register exports to CSV.