The database has five main tables which include ones for administrative address, installation address, site information such as the kind of installation, substance involved and security), technical check data and administrative action.
Transactions consist of lookup of sites that haven't been checked and writing letters, locating sites that haven't been repaired and writing letters, adding technical checks and inserting or updating installations.
The code is currently 996 lines of 4GL, 66 lines for the mailmerge texts and 20 lines written in awk.