Utah DDW CMDP Rachael Cassady rcassadyutah gov 1

Utah DDW – CMDP Rachael Cassady rcassady@utah. gov 1

How Utah got started • • • Test state late 2015 all through 2016 Six labs signed on to test SCS Test requirements approved One really tested Not a great electronic transfer previously in place Division of Drinking Water | 2

Utah’s stars aligned for CMDP • • • SDWIS 3. 33 No automated electronic reporting Large labs with LIMS Large surface water systems seeking electronic way to report monthly data Miserable electronic reporting currently in place Division of Drinking Water | 3

Utah’s labs Utah needed the electronic reporting CMDP provides • • • Large state lab, 3 LIMS Chemtech Promium Small LHD labs University labs Small private labs • • • Emailing csv files for Lab to State Email hard copies CMDP Division of Drinking Water | 4

Chemtech-Ford Laboratory 5

Successful labs Promium (LIMS) CMDP State dashboard All others LIMS Excel Template (other XML parser) SDWIS CMDP Lab dashboard LHD labs CMDP Lab dashboard CMDP State dashboard Division of Drinking Water | 6

Utah CMDP Users Production • • Chemtech Ford (all chem/rad and coliform) Southern Utah University (coliform) Central Local Health Department (coliform) Metropolitan Lab (large system, coliform) Eurofins (coliform) Jordan Valley Water Conservancy District Lab (coliform) American West Analytical Lab (coliform & chems) Testing • • • Salt Lake City Water System Bear River Local Health Department Davis Local Health Department (coliform) Division of Drinking Water | 7

CMDP Lab dashboard Division of Drinking Water | 8

CMDP State dashboard Division of Drinking Water | 9

Looking forward… Roadblocks Utah had: • • • Analyte groups Translating errors CMDP Updates SCS password Understanding XML Sampling errors, which ones do we worry about? Other options besides LIMS, excel template, hand entry The good stuff: • • • Labs can see the errors in LIMS and fix them on their own. Easier than our current csv transfer Less human interaction Immediate data push Get yourself a Dallin (CMDP manager) Division of Drinking Water | 10