Home

Publication - Alberta Environment

1. Station m Station No 4BOSEBS994 PRIOR TO CHLORINE ADC APW Id 00195446 APY Name 4444 SYSTEM File Name 00195448 20060316 K 1 999 Variables Variable YMY Code Method Count Lowest Value Highest Value Reading Type Fuow poa nonn neo uso FoR Tae o es ver tt FLOW for 0502 UNKNOWN METHOD USED FOR TH k z z FORE bs ona e e e e SoS Coo O C O O O T Measurements Date Time Flag Value Unit Sample Frequency femara r0 eo e a sc e hemar2o8 ro bo ks bay sc hemar2o8 rof foo us bay sc femar208 roof o ks bay sc COo C 4 m mm m ED SD a z The last tab has SUBMITTED DATA reporting capabilities Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page A2 4
2. 2007 APR 00195448 20071104 K 3 999 04 NOV 2007 OPERATOR SUBMITTED DATA Report Stations Station No Description Matrix atus Reviewed ABOSEB9994 PRIOR TO CHLORINE ADDITION 6 RAW WATER fopR Stn Status 4 a Berne ation LIS a Sats aS ee e IF tess ii hapara enw gew abea pla jama dagiiwgp Awp A00 webheml report At C E UNSUBMITTED DATA REPORT Unsubmittad Data J E STA TRH MAE HAME MSH DEROAN PENN SAMPLE MEO DATETIME PRY TYPE MA TRIT CODE TORMENT VARIABLE FIR HAME YH FLAG VBL UAIT READE TIPE TORRENT EE TFLS DATA PERA Tey Appia 13544600 AAAA SYSTEM Data Fee 2008 From 388 OPERATOR SUBMITTED DATA Unsutenited File 00156445 200803 16 1 989 Date Sani 1B telae 200 File Noles Submitlad notes whiew do wi soe lhose PPR P PRE AAAA TEST WATERWORES SYSTEM AAAA PRIOR TO CHLORINE ADDITION 1E Wa A DALY 1 E ogee ile i a ETA AND Tor APVO wren bo senpe elg FLOAT S000 S55 Lie Eira Foi S002 S000 Le Ae Een FL S002 S00 IL Ai Eins FLOAT S00 296 Lie Eira TORET 9826 MTU AWG Esia TURE Y 926 E MTU Eira TORET 9826 MTU AW Esia TORET 926 MTU Eira E W 04 200 DALY 138 pe files ths i EXTRA AND for APD vrien to nampis rera FLOAT S002 58 Lie Eira FLD Sf DED S000 Life Ae Seis FLAG DSDS S000 Li A Ech FLT S002 258 Lie Eira TORET 9826 MTU AWG Esia TORET 9826 MTU Eira Tes RT a dee Alberta Environment Electronic Data Transfer Manual for Drinking Wat
3. Approval ld 239029 oo 00 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 COMMUNITY A WATERWORKS SYSTEM QADIST Reading Crt Frequency Parameter Type Unit zor gt Value Sample Date Sampling Location Ta Measurement Revision x 03 OCT 2008 OI EE Approval id 239029 0 0 COMMUNITY REGIONAL WATERWORKS SYSTEM samping Location DISTRIBUTION BACTERIOLOGICAL RANDOMLOCATIONS ro Reading Type T Frequency trt OO Sy Sample Type SAMPLE BASED ON CALCULATED VALUES EG Vater Type TREATED WATER ss S Sample Date 02 0cT 2008 E Proposed Measurement Sample Type Parameter Unit OF gt Value Water Type CHLORINE TOTAL g 0 800000 Sample Comments Ei Method TITRIMETRIC ANALYSIS Comment The record with a value of 0 8 is highlighted Click on the Measurement Revision button The form that pops up will allow you to Request a Revision Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 5 2 Section 5 SUBMITTED DETAILS TAB Change the value to the correct value You must enter a comment as to Why you are requesting the revision a 6a Measurement Revision Approval kd 239029 fo fo COMMUNITY REGIONAL VWATERVVORES SYSTEM Sampling Location DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS Reading Type hii Frequen
4. sssssssesssessessesssssrresrrrsssrereessrresssrresrtressrerressrreeserressereesseeee 2 3 DE ENE AE ETEA A TE AE ene ES A AE eee ene 2 3 New Unsubmitted Details Tab Features esssssssssssssrsssseresrsrsssrrresrrrreesrrressrrresreresrsreesrrrest 2 4 New Unsubmitted Details Tab Contract Lab Data oo cece cceecccsseccceeececetececseececaececseeeeaees 2 5 New Unsubmitted Details Tab Explanation of the Details for Entering Data 0 2 5 BERIN O ect pete cist sre sss oie descr tac eng gists ea te un sae clp Serentice E 2 5 SOE GV FCS ONEEN AE AAE S E E A E E E 2 6 Column Heading Descriptio Mesisenaare aee E 2 7 Loome Lo ai e E E EAE 2 7 PAR O OUI P E E E E EE E E A TE TE A E A E AE AA EE TT 2 7 Bat OO ICY a a E E ame sndaevcantens 2 4 Parameter oso ec ce eats hse sec cane de ve acted sesso pe vis ep in tes seat ena ponareaeteanu ogee ial 2 LRE TINE a oe ee ee ene 2 7 GS UTNE and Selecting a OIG cosas cetescsesen teas i 2 7 POW Fe cotetne yeas sa epee E toe anecupeties ped eu esas 2 Bg rarer eareunisanate E dansonwacabadandeesaesdawtonsenastacetaesdeetsaaiascenas 2 7 Oe Ca eagle sticcnea E ton cones podeaeganetucednetencrsneunee toe teesonre sat ess mu eocersa 2 Sample B ciel dhe a 0 9 are ne ee neh ae Stee eet nn oe Eee ee oe eee 2 8 W ae 0 mare renee nae Ot en nc O 2 8 TEMENO oa ES E E 2 8 AN E N a E E E 2 8 13 Missing Measurement Code cccccssecccssecceesecceescceeeeceeeuec
5. Location Status Submission Notes Save ReportFile Submit CancelLagatt From Date To Date Month Year What is a DATE RANGE EZ 01 0ct 2008 SSS PB hi cct 208 ys 3 POLE Range In the first example above the Month Year date range was chosen and in the second example a period of 01 OCT 2008 through 11 OCT 2008 was chosen Remember you can choose a From Date To Date for any time period of up to 61 days 2 months The form defaults to today s date If you are entering data on any date OTHER THAN today s date then you will have to choose the date using the drop down calendar The double arrows move you either forward or back an entire year and the single arrows move Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 5 Section 2 DATA ENTRY FORM Can I Sort the parameter records you either forward or back one month at a time When you reach the desired date highlight it and click OK ApprovaliRegistration 239029 00 00 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 COMMUNITY A WATERWORKS SYSTEM DIST From Date To Date Month Year EE o1 vec 2008 S BD i bec 2008 a E Query Data Contract Lab Data a Calendar Window Sample Location Unit lt or gt Value Date i a DISTRIBUTION RANDOM LOCATIONS maL O R 01 DEC 2008 ENTERING DISTRIBUTION SYSTEM
6. Semi annual Monthly Facility Sample Identifier Sample Date Received No AENV Approval Registration No Facility Name Sampled at Station Station No Description Sample Matrix 10 T R p erie 10 Treated 6 Raw Sample Type Type Grab Grab Sample Frequency ANNUL Annual MONTH Monthy Monthly Sample Date Time 24 hr clock _ j zro MMM aoe DD Comments Analysis Type circle what is appropriate for this sample Potable Water Inorganic Organic Trihalomethanes Other Raw Water Ground Water Surface Water Inorganic Organic Other All Municipal Drinking Water Facilities regulated by Alberta Environment must have their annual semi annual and or specific monthly samples analyzed at an ISO IEC 17025 accredited laboratory AENV will only accept data in their specific electronic format Billing payment is the responsibility of the facility The above information must be submitted by the facility and recorded by the laboratory to insure that it is forwarded with the sample data Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page A2 2 Appendix 2 Contract Lab The laboratory should send you a paper or pdf copy of your sample results and notify you that the file has been sent to Alberta Environment After the laboratory sends the file through the secure ftp site it loads into a temporary data storage area just like in the previ
7. 22 Drinking Water Quality Data TOW are connected ta EMS err erie teeters ute cete erent err cece ace Perr r rrr rrr rrr rere rrr rere rer rrr re rerere New Unsubmitted Details Unsubmitted Summary Submitted Summary Samtec Marilis ApprovaliRegistration 239029 00 on COMMUNITY REGIONAL VWATERIVORES SYSTEM Operation 22071 4 COMMUNITY AWWA TERVVORES SYSTEM VYDIST From Date To Date Month ear 2 fto nov 2008 DE 2 t9 Nov 2008 Query Data Contract Lab Data Reading Sample Location Count Freque Parameter Type Unit 43 or Value Date DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL MIN mo henov zs A DISTRIBUTION RANDOM LOCATIONS 5 VWeekly Ce CHLORINE TOTAL ma man S 19 NowW 2008 ENTERING DISTRIBUTION SYSTEM 5 eekly Ce FLOW ToT IL Livr SL hs now 2008 Dol I I E C C a es ee a eee cr ttt ST E CO CCE SC Sample Type SAMPLE BASED ON CALCULATED VALUE S EG Method TITRIMETRIC ANALYSIS 0000o Veter Type TREATED WATER Missing Measurement Code EE Measurement Comment dt w Select Approval Location Status Submission Notes have Report File Submit Cancel Logatt QUESTIONS AND ANSWERS New Un submitted Details Tab Un submitted Nhen you sign on with your Username and Password you will be presented with a form for pie Tab submission of your monitoring information This form will identify the information that you are ene required to su
8. DISTRIBUTION BACTERIOLOGICAL F DISTRIBUTION BACTERIOLOGICAL F A You are about to exit the drinking water data entry screen DISTRIBUTION BACTERIOLOGICAL F DISTRIBUTION BACTERIOLOGICAL F DISTRIBUTION BACTERIOLOGICAL F on DISTRIBUTION BACTERIOLOGICAL F soe cancel Sample Type Method 3 Water Type TREATEDWATER Missing Measurement Code E Measurement Comment e Ls Le Slee Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 6 1 Appendix 1 Disclaimer Terms of Use and Disclaimer APPENDIX 1 Electronic submission of drinking water quality information disclaimer 1is Site ContactUs Aberta Environment Alberta ca Environment gt Programs Services Drinking Water Program gt Knowledge gt Electronic submission Disclaimer Programs Services Legislation Protection Drinking water systems Performance assurance Knowledge Full Cost Accounting Electronic submission Disclaimer Quick links Environmental Hotline Authorization Approval Viewer Information Centre Water Advisories Drinking Water Quality Alberta River Basins Frequently Asked Questions Questions and Comments Legislation Guidelines E Seach AA Forms Applications Reports Data Advisories Monitoring Newsroom Education About Us Electronic submission
9. 2 Appendix 2 Contract Lab APPENDIX 2 Electronic submission of Contract Laboratory Data Contract By clicking on the Contract Lab Data button you are linking to a form which displays the UNSUBMITTED analytical results of samples sent to an accredited laboratory You will be able to review the results of the analysis and sign it off thereby submitting it to AENV a Drinking Vater Quality Data You are connected to EMSU Laboratory data New Unsubmitted Details Unsubmitted Summary Submitted Summary Shigmittsel Datak ApprovalRegistration 195448 foo oo AAAA SYSTEM Operation f 50011 AAAA TEST WATERWORKS SYSTEM From Date To Date Month Year EZ 2o nov 2008 SSS Hey Lonov 2008 Sys 3 Query Data Before you can view contract lab data on this form your lab must be capable of sending data to AENV electronically in the AENV fixed format If they are not capable you will have to instruct your contract laboratory to get in touch with the dwq datacoord gov ab ca for instruction Once your lab is capable of sending data to AENV electronically in the AENV fixed format then your responsibility will be in correctly identifying your sample s The laboratory must be able to record the sample identification data and subsequently send it in the file to the AENV ftp site In the past when you began reporting electronically you were sent a letter about contract lab data In that letter there was sample iden
10. 710 y Bl U gt Al v fe From Date B C D E R G H J K L Mi N From DatealTo Date Approval N Approval Name 2 1 Oct 08 30 Nov 08 00239029 COMMUNITY REGIONAL WATERWORKS SYSTEM 3 Location Parameter Date lt or gt Value Unit Sample Ty Frequency Count Water Typ Reading TiMethod Measurement Comments 4 COMMUNICHLORINE 1 Oct 08 0 03 mg L SAMPLE EWEEK 1 TREATED MIN TITRIMETF 5 COMMUNI CHLORINE 2 Oct 08 0 8 mg L SAMPLE EWEEK 1 TREATED MIN TITRIMETF 6 COMMUNICHLORINE 4 Oct 06 1 1 mg L SAMPLE EWEEK 1 TREATED MIN TITRIMETF COMMUNI CHLORINE 5 Oct 08 1 mg L SAMPLE EWEEK 1 TREATED MIN TITRIMETF 8 COMMUNICHLORINE 6 Oct 08 0 9 mg L SAMPLE EWEEK 1 TREATED MIN TITRIMETF 9 COMMUNICHLORINE 7 Oct 08 0 95 mg L SAMPLE EWEEK 1 TREATED MIN TITRIMETF 10 11 Number of Records 6 If you choose Save Target As the data will be downloaded and you can then save it to your computer My Computer I l 5 A Iili gt File name 239029 2008111917471 0 ce4 My Network Save as type Microsoft Office Excel Comma Separated Value w Cancel Lat QUESTIONS AND ANSWERS New Un submitted Details Tab LIMIT CHECKING Question What happens if the data is compared with the requirements of my Approval Registration and a monitoring value exceeds the limit Answer Verify the value you entered If the value is truly outside the Approval Registration limit then you will need to follow the emergency response procedure as specifie
11. Liyr o k 01 DEC 2008 F E 3 SS Measurement Comment veroa TRMETRICANALYSS event coce ES oS zg z gt gt gt Select Approval Location Status Submission Notes Save ReportFie Submt CancelLogoff You can scroll one day at a time backward or forward by using the single arrow buttons on either side of the From Date or To Date From Date ni Date r nec 2008 O14 DEC 2008 Ge O41 DEC 2008 or nec 2008 E The form will not allow you to enter data in Hine future When you choose or change a date range the screen must be refreshed to bring forward the records for the dates specified This is done by clicking on the Query Data button If you forget the system will remind you by giving you an error message Forms pd The query criteria has changed Data must be regueried Please click the Query Data button to requery Cancel SORTING RECORDS __22tple Location Count Freque Parameter The records within the date range can be sorted by clicking on the Sample Location button or the Frequency button or the Parameter button The above example was sorted by Sample Location in ascending date order If you want to reset the original sort order click on Query Data Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 6 Section 2 DATA ENTRY FORM
12. SYSTEM Sampling Location DISTRIBUTION BACTERIOLOGICAL RANDOMLOCATIONS Reading Type vin Frequency Sample Type SAMPLE BASED ON CALCULATED VALUE S EG Water Type TREATED WATER Sample Date o2 0cT 2008 Proposed Measurement Revision Parameter Unit sor Value CHLORINE TOTaR O MA SE oseo Method TITRIMETRIC ANALYSIS Comment f missed entering the second 8 This is an administrative error A Request Revision Cancel Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 5 3 Section 5 SUBMITTED DETAILS TAB QUESTIONS AND ANSWERS Measurement Revision Question When can make a request for a measurement revision nee Answer You can make ONE request for a revision on any individual parameter that measurement Bokan has been submitted to AENV When you submit a request for revision the red P indicates that it is still pending As long as the request is pending you have the ability to change the data and again click on the Request Revision button However once AENV accepts the change it is complete You no longer have the option to submit a SECOND revision request on that specific parameter AENV will accept only one revision per record Question want to enter a value for a record that has been submitted with a Missing Measurement Code The form Measurement Revision won t allow a value to be entered why Answer A record that does not have a val
13. Un submitted montonny Details Tab OR from the Un submitted Summary Tab records to AENV The records that are submitted as well as the date on which it is submitted will be used to assess compliance with the requirements of your Approval Registration This is the monitoring information that will also be made available to the public through the AENV website a Drinking Water Quality Data You are connected to EMSU New Unsubmitted Details Samita Varzik Approval Registration 239029 oo oo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 COMMUNITY A WATERWORKS SYSTEM VWDIST From Date To Date Month Year es a Oe lS oco Query Data Contract Lab Data Reading Sample Location Count Freque Parameter Type Unit or gt Yalue Date Weekly MN mo O SREB f1 ocr 2008 L A DISTRIBUTION BACTERIOLOGICAL F 1 Wweekly CHLORINE TOTAL MN mgt gt 0800000 02 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F 1 weekly CHLORINE TOTAL MN fma z 03 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F 1 weekly CHLORINE TOTAL MN fma 1 100000 04 0cT 2008 _ DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL MIN mgt amp 1 000000 05 ocT 2008 DISTRIBUTION BACTERIOLOGICAL F 41 weekly CHLORINE TOTAL MN fma z i 0 900000 o6 OcT 2008 DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL Mn mg 0 950000 07 OCT 2008 Sample Type SAMPLE BASED ON CALC
14. What do the COLUMN HEADING DESCRIPTION oe The records on the form are the specific monitoring requirements for your waterworks system eadings Hap i l mean If this is not consistent with what you monitor then please contact DWQ UserCoord gov ab ca Reading Sample Location Count Freque Parameter Type Unit oF Yalue Date DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL mn img 11 00 2008 An explanation of the column headings are 1 Sample Location the location where sampling takes place 2 Count the number of samples or measurements that are to be taken for the frequency period 3 Frequency the period of time example a Weekly means calendar week b WKGW means calendar week except statutory holidays c Month means calendar month d Annual means calendar year 4 Parameter means the chemical that you are analyzing for or value you are measuring for example chlorine residual turbidity flow volume 5 Reading Type means the type of sample taken example a n a means discrete sample or grab sample b MIN means minimum value of a number of sample measurements such as continuous monitoring c MAX means maximum value of a number of sample measurements d AVG means average value of a number of sample measurements 6 UNIT and SELECTING A UNIT The parameter unit is associated with the analytical method If you change your method of analyzing a parameter
15. be reported to AENV as specified in the Approval Registration WHO DOES THE ELECTRONIC REPORTING Drinking Water Quality DWQ monitoring information is sent submitted electronically to AENV by the Operators of the regulated waterworks system e the Provincial Laboratory for Public Health on behalf of the regulated waterworks system and e the accredited independent laboratory contracted by the owner of the regulated waterworks system SECURE ON LINE REPORTING The security and confidentiality of information exchange is a key consideration in this initiative All of the information submitted to AENV via the web is subject to username password protection and is via secure connections and file transfers The staff of the regulated waterworks system and only their staff are able to review this information prior to final submission Once the data is submitted to AENV it is considered public information as it has been submitted as required by the Approval Registration The data will be available for public access on the external web site of AENV How does a Regulated waterworks system get on line i Ree Frequently Asked Questions GETTING ON LINE What s involved Potable water facilities contact the Approvals staff in the AENV Regional office or the dwq usercoord gov ab ca Determine How the Data is to be Submitted to AENV e AENV has provided web forms for direct input of monitoring and repor
16. button and you will be asked if you really intend to submit the information to the Director When you click Yes the results you have entered saved and identified for submission will be submitted You can confirm that your results were successfully submitted by clicking on the Submitted Data tab 5 Results that you submit will be assumed correct and to be intended by you to be your reporting of the Drinking Water Quality Monitoring results under your Approval Registration The information that you submit as well as the time at which it is submitted will be used by AENV and the Director to assess compliance with your Approval Registration requirements the same as a report in writing would be used to assess compliance with your Approval Registration The results will also be made available to the public through the Home Page of Alberta Environment Web site 6 You will comply with the Drinking Water Quality Web site User Agreement and User Manual at all times 7 In the event of a conflict or discrepancy between the terms and conditions of use for this Web site the User Agreement and the terms and conditions of your Approval Registration the Approval Registration shall prevail 8 Alberta Environment will not be responsible for any damages you or any third party suffers as a result of the submission of results through this Web site Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page A1
17. meee Answer For any missing values highlight the value that is missing Use the LOV s down arrow beside the Missing Measurement Code to select the reason for the missing data Then use the comments area to further elaborate as to why the data is missing The missing measure code will be saved along with the values entered for the other parameters or dates Question Do I have to enter a Missing Measurement Code Answer Yes The Approval Registration requires monitoring at specific stations for specific parameters at specified frequencies If a measurement is missed it could become a compliance issue In addition if a missing measurement code is not entered it would be considered an incomplete report which would trigger another compliance incident QUESTIONS AND ANSWERS ADDITIONAL MONITORING Question What if collected data for a parameter more frequently than my approval Monitoring requires Questions A The f r f f B PE nswer e form allows for only one value per parameter per day If you continuously monitor a parameter the form will show a reading type of MIN minimum for the frequency specified i e daily or MAX maximum for the frequency specified or AVG average for the frequency specified If you monitor a parameter daily and the frequency specified is 1 grab sample week then you can enter one value per day This would mean that 6 of the 7 values would be considered additional data If you wer
18. ocT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 08 OCT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOMLOCATIONS o9 ocT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 10 0cT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 01 Nov 2008 eO E EAEE aaae a ri Check All Uncheck All T1711 7 a IN W Page 4 1 Section 4 Can I see the results of bacteriological samples taken on my system Can I see the results of my annual samples on line SUBMIT DETAILS Check the records you want to view and Double click on the records or click on Submitted Details a Drinking Water Quality Data You are connected to EMSU Approval Id 239029 oo foo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 COMMUNITY A WATERWORKS SYSTEM VYDIST Reading Sample Date Sampling Location Crt Frequency Parameter Type Uni lt or gt Yalue 01 OCT 2008 00 00 00 DISTRIBUTION BACTERIOLOGIC 1 week CHLORINE TOTAL an fmo OO OO 030000 02 OCT 2008 00 00 00 DISTRIBUTION BACTERIOLOGIC 1 WEEK CHLORINE TOTAL hati mgt 0 600000 P Q I a a a R e The radio button Bacteriological Data Ta Drinking Water Quality Data You are connected to EMSU Submitted Summary C Submitted DEHE Approval Id 2390293 o0 00 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 E COMMUNITY 4 WATERWORKS SYSTEM WDIST Query Data From Date 01 OCT 200
19. of drinking water quality information disclaimer Alberta Environment provides this Web site to enable electronic reporting of drinking water quality monitoring results By submitting information through this Web site you are consenting to the terms and conditions set out below A Terms of Use and Disclaimer Alberta Environment AENV is providing this Web site to enable electronic reporting of Drinking Water Quality Monitoring results that Approval Registration holders of the Alberta Environmental Protection and Enhancement Act AEPEA approved regqistered waterworks systems are required to provide to a Director under the Waterworks Limits and Monitoring and Reporting sections of their Approval Registration This Web site may only be used by Approval Registration Holders and their Authorized Users who have a valid User Agreement with the Minister of Environment By submitting information through this Web site you are consenting to the terms and conditions set out below acceptthese conditions and wish to submit data Terms of Use and Disclaimer AENV is providing this Web site to enable electronic reporting of Drinking Water Quality Monitoring results that Approval Registration holders of the Alberta Environmental Protection and Enhancement Act AEPEA approved registered waterworks systems are required to provide to a Director under the Waterworks Limits and Monitoring and Reporting sections of their Approval Regis
20. provide access to the website 24 hours x 7 day week If you have problems or if the website is not available please try again later and or contact the Drinking Water Quality DWQ User Coordinator during business hours at DWQ UserCoord gov ab ca or by phone at 780 415 9378 V Question Will I be penalized for a late submission if am unable to access the web site Answer No as long as you notify the DWQ User Coordinator immediately that you are unable to submit monitoring information because the website is down You also must e mail the information preferably in Excel format The details are outlined in the Drinking Water Quality User Agreement for Approval holders or the conditions of the Appendix attached to the written notice provided by the Director for Registration holders In addition you must submit your monitoring information using the AENV web forms as soon as possible once the website is operational Question What reporting requirements will need to enter Answer Your reporting requirements are Approval Registration dependent and will be presented to you on the data submission web form It is your responsibility to ensure that the requirements on the form reflect the drinking water quality monitoring information that your Approval Registration requires to be submitted electronically Question Where is the un submitted data stored Answer The un submitted data is stored in a secure account It is not vie
21. then you must change the unit criteria by choosing from the List of Values LOV s Reading Sample Location Count Fregue Parameter Tyge Unit g walie values for Uns ee ee a e aa a aa a a a e a a a a a a ae a aed ae e a a eee a a a eee Find Writ Code Method wh Code mail CHLORINE FREE amp TOTAL ANALYSIS DONE IN THE FIELD BY HACH 101193 Find Cancel 7 lt or gt means the less than or greater than symbols These are used if your monitoring result is less than a analytical detection limit or shows greater than the value Ignore these if they are not applicable 8 Value means the measured numeric value of the parameter 9 Date means the date when the sample measurement was taken Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 7 Section 2 What do the Fields under the parameters refer to DATA ENTRY FORM SAMPLE DESCRIPTION Near the bottom of the form are 5 highlighted fields boxes The information in this area pertains to the record or parameter that is highlighted above it Reading Sample Location Count Freque Farameter Type Unit or gt alue Date DISTRIBUTION BACTERIOLOGICAL F 1 CHLORINE TOTAL MIN mgt st 00CT 208 DISTRIBUTION BACTERIOLOGICAL F 1 1 Weekly a ing 2 02 OCT 2006 DISTRIBUTION BACTERIOLOGICAL F 1 vveekly CHLORINE TOTAL hn fmol a 03
22. 008 DISTRIBUTION BACTERIOLOGICAL F 1 000000 05 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F 0 900000 06 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F z 0 950000 07 OCT 2008 0 950000 o7 ocT 2008 Sample Type Method Water Type TREATED WATER Missing Measurement Code ANB Analyzer Broken Measurement Comment replacement ordered l za lt H gt H gt Select Approval Location Status Submission Hot _ ReportiFile i CanceliLogott Click OK and you will be provided with a Summary of Limit Checking This identifies the number of measurements checked and whether they were within the limits or guidelines of the Approval Registration also the Exceedance Details are shown if a parameter is outside of a limit or guideline Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 11 Section 2 DATA ENTRY FORM Ta Limit Checking Results Summary of Limit Checking Number of measurements that were checked 000000 Ce Number of measurements that were WITHIN the limit s or guideline s si S SS Number of measurements that were OUTSIDE the limit s or guideline s See Exceedance Details below 1 Number of measurements where compliance could not be cleary determined See notesbelow 0 Exceedance Details NOTE Alberta Environment does not yet have access to this information Please ensure you have c
23. 22071 4 4j COMMUNITY A WATERWORKS SYSTEM VYDIST To Date 30 NOV 2008 amp o1 ocT 2008 Vy C Data File CS Format Ok Cancel Measurement TRAE iii ols le 03 OCT 2008 06 OCT 2008 lo7 ocT 2008 Select Approval Location Status Submission Hot Cancel Logoff Save ReportFile Submit Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 12 Section 2 DATA ENTRY FORM E Reta jaria goat qos ferta_cheg thea cheng S00 _wath Htenl_roport 1 DRINKING WATER REPORT UNSUBMITTED DATA Fron Daie 1 01 2008 Te Date SOM 20G Aypprocal Ha JJA Location COMMUNITY AJ DESTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS Parameter TREATED WATER CHLORINE TOTAL REATED WATER CHLORINE TOTAL REATED WATER CHLORINE TOTAL REATED WATER CHLORINE TOTAL ging ppc 20a PAL EG AVE w j En e REATED WATER OALORINE TOTAL sit OF O0T TREATED WATER CHLORINE TOTAL 008 By selecting the Data File output type you will be able the save the un submitted records to your own computer Right mouse click on the csv file will give you a list of options Drinking Water Quality Report lt br gt Microsoft Internet Explorer ogg Fie Edit View Favorites Tools Help Q pack QJ x a A J gt Search Pe Favorites E2 B7 TN fal rel EJ A Address http envext02 env gov ab ca pls emsu_dwg
24. 8 To Date 11 OCT 2008 Operator EntereQ Bacteriological Data Annual All bacteriological samples that are taken by the operator must be sent for analysis to the Provincial Laboratory for Public Health Edmonton or Calgary labs These labs send all of the results electronically to AENV Therefore by Querying the Data for a specified Date range the results received from the Provincial Laboratory will be displayed Sample Date Sampling Location of Records 08 APR 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 1 A 15 APR 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 1 22 4PR 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS r SSS NNANAAAAAANNNSNS SAOAAAAA Oe Double click on the records or click on Submitted Details Reading Sample Date Sampling Location Count Frequency Parameter Type Unit lt or gt Value 08 APR 2008 12 00 00 DISTRIBUTION BACTERIOLOGIC 4 MONTH COLIFORMSToTAL wa fa oomo 08 APR 2008 12 00 00 DISTRIBUTION BACTERIOLOGIC 4 MONTH ESCHERICHIA COLI Inia Pia 0 00 f 5 APR 2008 12 00 00 DISTRIBUTION BACTERIOLOGIC 4 MONTH COLIFORMS TOTAL na Pra 0 00 f 5 APR 2008 12 00 00 DISTRIBUTION BACTERIOLOGIC 4 MONTH ESCHERICHIA COLI Inia Pra 0 00 LO O TNn TAATOA 4 S Sample Type DISCRETE SAMPLE GRAB Measurement Comments S Water Type TREATED WATER Method COLIFORMS BY DEFINED ENZYME SUBSTRATE TEST Sam
25. BUTION RANDC ENTERING DISTRIBUTIC DISTRIBUTION BACTEI Submission notes Notes entered here will be sent to Alberta Environment with the next submission of measurements COMMUNITY A 03 OCT 2008 The chlorine analyzer used for sampling chlorine in the distribution system broke A replacement was ordered but analysis was not performed Measurement Commer gt n lt j gt Select Approval Save Cancel Saving SAVE DATA records Select Approval Location Status Submission Hot RepotfFie Submit Cancellogatt You must save the data that you have entered prior to submitting it to AENV The data will be compared against the limits defined by your Approval Registration A pop up message will show you the number of records saved updated and or deleted New Unsubmitted Details Jnsubmitte SUMMA Submitte UmMmMary eieierittese Catz ile ApprovaliRegistration 239029 00 00 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 COMMUNITY A WATERWORKS SYSTEM WDIST From Date To Date Month Year lt Es Wi E J joctrzo08 Query Data Contract Lab Data Reading _ Sample Location orms p Date DISTRIBUTION BACTERIOLOGICAL F 0 030000 01 0CT 2008 DISTRIBUTION BACTERIOLOGICAL F 0 800000 02 0CT 2008 o 7 record s inserted 0 record s updated 1 record s DISTRIBUTION BACTERIOLOGICAL F deleted 1 100000 04 OCT 2
26. Count Freque Parameter Type Unit lt or gt Value Date DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL MN mgt _ Ihenov 208 DISTRIBUTION RANDOM LOCATIONS 5 Weekly Ce CHLORINE TOTAL Inia img f 9 NO Y 2008 ENTERING DISTRIBUTION SYSTEM 5 Weekly Ce FLOW ToT Lyr z fi 9 NO 2008 3 vv Sample Type SAMPLE BASED ON CALCULATED VALUE S EG Method TITRIMETRIC ANALYSIS o Water Type TREATED WATER tt sssts S Missing Measurement Code 3 a Measurement Comment aa a gt gt gt Select Approval Location Status Submission Notes Save ReportFile Submit Cancel Logoft Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 1 Section 2 Select your facility DATA ENTRY FORM ENTRY Please Select Your Facility A waterworks system that is defined as an activity according to the EPEA Activities Designation Regulation must hold either a Registration or an Approval for that system Many of the AENV Approvals now contain more than one unique operating system within the one approval The Please Select Your Facility form allows the authorized user or operator to choose the operation that will be reported on When this form opens several situations can exist L Choose the Facility click OK then click Next If you operate only ONE system the Approval Registration ID field and the Facility Operatio
27. Details Tab 2 0 0 0 cece cccececsceccecscsceccececaccececscscaucesscscarausecsceusecseas 5 1 Submitted Details Tab Measurement Revision ccccceccsceccscccscccscuceecececcecescecaecusaecess 5 2 Q amp A Measurement REVISION ccececececcccecscecscecececscecscucntaeaeasaseeeseeeeeeaeeecscscncsencaeaeas 5 4 SECTION 6 CANCEL LOGOFF CANCEL LOGOFF the secure website cceccccssseccccessceccescececeesececsuececeeeecseususecesaueseeaunsssss 6 1 APPENDIX 1 DISCLAIMER Electronic submission Information Disclaimer c ccceccsceccscsccecsccccscccsccescescsceccscasescuees A1 1 APPENDIX 2 CONTRACT LABORATORY DATA Electronic submission of Contract Laboratory Data cccccccccsssecccesececeeseceeeeeeeceeeaneeeetes A2 1 Overview and Introduction INTRODUCTION This manual is provided to Operators of Drinking Water facilities that are ready to submit their data electronically Electronic submission provides the user the ability to store and retrieve data and generate reports that can be printed and or saved for future reference In this manual the following abbreviations will apply e Alberta Environment will be referred to as AENV e Approval to Operate will be referred to as Approval e Registered system operating according to the last Approval to Operate will be referred to as Registration e Registered system following either the Code of Practice for Waterworks Systems Using Hig
28. Electronic Reporting of Drinking Water Quality Monitoring Information User Manual for Drinking Water Operators Web Form Data Submission Prepared by Alberta Environment Environmental Assurance Monitoring Reporting and Innovation Branch Version 2 1 December 2008 updated March 2010 TABLE OF CONTENTS HTT CO AE ea one cas ooean taco sence gare eve A EEEN iii BAOU aR AE E EA E N iv Scope of Electronic REDOMING sisavacesassrarciavnadtendaaeceatansmensdananncasavaccebaeaneundaasiandeerenrsbarsseninananeraiese V Who Does the Electronic Reporting ssssessseesssesssrerssrrssrrrssrreseresrrersreresreeseersseresereesrersrereseerse V Secure On line Reporting acicciecosssadentacsencedanstscateac cedeaeoasadeunaecanesuacaduaeadennseaabdadesaedactabansabeanedadeees V Gewinne ONNE sesiuni inr aE ENE A E Ea vi Questions and ANSWETS sssssssessssssrssrrserrsrersstesrrrstesrtesresttsrtrsttssresttsttstesstestesstesrerseeeseeseeeseene vi SECTION 1 LOGON Systemi ReguirementS cavewsscistetentueesncstseinceann pane cconnouares eimanciabennctuneineeismoussineeadecenmeimenevanaceaienens 1 1 Gethin otarrea LOGON israse rnos n n aA EE LEE EEEE ON 1 1 STe S a E E E E cute N E E E E E N E E E 1 2 EOT OU e E E E E E E AS 1 3 EER PE A E N pantie O A E EE EA E E AN 1 3 SECTION 2 DATA ENTRY FORM FOM FOF Da aou SI ON e T E NEE 2 1 Entry PlGase Select Your FACIIUY oeseyieacns ie E NEEESE 2 2 New Unsubmitted Details Tab
29. OCT 2008 DISTRIBLITION BACTERIGLOGICAL F 1 Weekly CHLORINE TOTAL n fing DA 04 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F T T Weekly CHLORINE TOTAL MIN fm I 5 00 2008 DISTRIBUTION BACTERIOLOGICAL F weky CHLORINE TOTAL ban mga AmE 06 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F 1 vWeekly CHLORINE TOTA o7 oct 2008 tai wile aimple Tyne SAMPLE BASED ON CALCULATED VALUE S EG Method Water Type TREATED WATER Missing Measurement Code z ei Neazoremenct Comment SS 1 OO An explanation of these 5 fields are 10 Sample Type refers to how the sample was collected For example a discrete grab sample means that a grab sample was taken and analyzed for the parameters as defined in the Approval to Operate or applicable Code of Practice In the example above the Reading Type or Sample Type is to be recorded as the MINIMUM value of the continuous monitoring data for that day 11 Method this refers to the type of analyzer or methodology used to determine the values of the parameter analyzed see No 6 Unit 12 Water Type refers to which water is being sampled either from the RAW water or TREATED water 13 Missing Measurement Code If there is no data for a required sample you must choose a reason from the List of Values LOV s to ensure that the measurement is accounted for when you submit your data Note you can ent
30. PPROVAL REGISTRATION NOTIFICATION AND CONSULTATION AND MONITORING RESULTS UNDER EMERGENCY OPERATIONS OR REPORTING OF SOME OTHER ADDITIONAL MONITORING RESULTS BEYOND THOSE REQUIRED AS PART OF THE APPROVAL REGISTRATION y re Electronic Reporting BACKGROUND of Alberta Environment s on line reporting for Drinking Water Systems The Electronic Reporting of Drinking Water Quality Monitoring Data was a project initiated in November 2001 The objectives are to benefit the Regulated waterworks systems and the Public of Alberta Regulated Waterworks Systems have been given access to e secure web forms which will enable them to o report monitoring data in a timely and efficient manner and o see immediately if the value of the parameter is within the Approval Registration defined limit including the limits of the Guidelines for Canadian Drinking Water Quality o electronically submit day to day operational monitoring results o electronically view the bacteriological sampling results which have been submitted on the behalf of the Approval Registration owner by the Provincial Laboratory or Public Health Microbiology and o electronically view and submit the results of the annual samples analyzed by the accredited laboratory which has been contracted by the Approval Registration holder e The Public of Alberta has been provided self serve access to appropriate information about the quality of their drinking water The inten
31. Sample Location Count Freque Parameter ia ili or Value Date DISTRIBUTION BACTERIOLOGICAL F 1 wveekty CHLORINE TOTAL mn ma alo henov zme iA DISTRIBUTION RANDOM LOCATIONE 5 vveekly cel CHLORINE TOTAL va mar ianov z008 ENTERING DISTRIBUTION SYSTEM Weekly e FLOW TOT kar Sf o hanow 2o Ll I A SA E a S S a E Oo S Sample Type SAMPLE BASED ON CALCULATED VALUE S EG Method TITRIMETRIC ANALYSIS 00o Water Type TREATED WATER 0 Missing Measurement Code PO Measurement Comment Select Approval Location Status Submission Notes have Report File Submit Cancel Logatt On the New Un submitted Details Tab you can e Select a different OPERATION if the approval has multiple operations within the one approval e View un submitted details of the samples that have been analyzed by your contract laboratory These records will be available ONLY IF your contract laboratory is submitting the results electronically to AENV see Appendix 2 e Select a specific data range using the From Date and To Date fields The range can be anywhere up to 61 days approximately two months e Select one month at atime using the Month Year field e Sort the records within the date range by Sample Location or Frequency or Parameter e Find the last record within the date range by using the navigation VCR buttons I J e Return to the Entry form to select another approval by us
32. TRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 06 OCT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS o7 ocT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 08 OCT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 09 ocT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS 10 0cT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS SS T Check All Uncheck All 2 eS Se GS a Drinking Water Quality Data You are connected to EMSU aE Submitted Details Approval Id 239029 oo oo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 COMMUNITY A WATERWORKS SYSTEM VWDIST Reading Sample Date Sampling Location Crt Frequency Parameter Type Uni lt or gt Yalue 02 OCT 2008 00 00 00 DISTRIBUTION BACTERIOLOGIC 1 WEEK CHLORINE TOTAL mn mgt 800000 03 ocT 2008 00 00 00 DISTRIBUTION BACTERIOLOGICA WEEK CHLORINE TOTAL hain 04 OCT 2008 00 00 00 DISTRIBUTION BACTERIOLOGICA WEEK CHLORINE TOTAL han Img 1 100000 rs A a es CE Loo O EO O O COOC CE Rj Sample Type SAMPLE BASED ON CALCULATED VALUE S EG Measurement Comments Water Type TREATED WATER Method TITRIMETRIC ANALYSIS Sample Comments Missing Measurement Code 0 Ee i es ee Select Approval Location Status Submitted Notes Measurment Revision Cancel Logoff The Submitted Details tab lists the details of the data submitted organized in s
33. ULATED VALUE S EG Method TITRIMETRIC ANALYSIS Water Type TREATED WATER Missing Measurement Code 3 a Measurement Comment L a sjsj Je J Select Approval Location Status Submission Hot Save ReportFile sum D Cancel Logoff C m za Drinking Water Quality Data You are connected to EMSU Unsubmitted Summary Se ieierittae atziz Approval Id 239029 oo foo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 Community A WATERWORKS SYSTEM VVDIST Query Data Sample Location of Records Sample Date Select Approval sim Report File Cancel Lagoft You can view ALL un submitted details from the Un submitted Summary When you click Submit you will be given a warning message as follows Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 3 1 section 3 FORMS SUBMIT RECORDS Forms Environment Click OF to continue Any saved location status changes and notes will be included in the submission Click OK and a pop up message will appear telling you how many records were submitted to AENV and a Reference number is given Record the reference number it serves as a receipt for submission of your data T record s submitted to Alberta Environment Your reference number for this submission is 2 oe When you click the OK the records are subm
34. X MIN Submitted Notes From Date 01 OCT 2008 To Date 22 NO 2008 Submitted Date 20 Nov 08 COMMUNITY A 03 OCT 2008 he chlorine analyzer used for sampling chlorine in the distribution system broke A replacement was ordered but analysis was not performed Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 4 4 Section 5 SUBMITTED DETAILS TAB QUESTIONS AND ANSWERS Submitted Details Tab How to access Question would like to see the submitted record detail using the Submitted Details the Submitted Tab but it is greyed out inactivated How can I access it Details Tab Answer When on the Submitted Summary tab you can view a measurement detail by double clicking on a row or select a number of rows by checking the boxes or click the Check All button then click on the Submitted Details tab 2 Drinking Water Quality Data You are onnecied io CMSU r n Submitted Summary Approval Id 239029 foo oo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 COMMUNITY A WATERWORKS SYSTEM VYDIST Query Data From Date 01 OCT 2008 To Date 11 OCT 2008 Operator Entered Bacteriological Dat Annual Sample Location of Records DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS Sample Date 01 OCT 2008 02 oct 2008 os ocT 2008 sv o4 ocT 2008 ae v 05 OCT 2008 DIS
35. actUs Aberta Environment hia Alberta ca Environment gt Welcome AA Programs Services Legislation Forms Applications a Reports Data Advisories Newsroom Education About Us Guidelines Monitoring Alberta Environment Alberta ca Environment gt Reports Data ater rograms Services ie slation f Forms Applications Reports Data Guid es Alberta river water quality index Alberta s river basins Quick links Reports Data E Scroll down to the Water section and click on the Electronic Environmental Protection Commission Reports submission of drinking water aiik ran can quality information disclaimer Groundwater information system Groundwater observation well network link Maps and data summaries You will have to agree to the conditions 082 Dam preliminant feasibility study River ice observation reports of the disclaimer befo re you can South Saskatchewan River Basin Water Information Portal proceed see Appendix 1 Cold Lake Beaver River state of the basin reports Surface water quality data User Manual for Drinking Water Operators Water use reporting system Water well drilling report submissions The Web form is found at the following address internet browser address https envext02 env gov ab ca servlet f60serviet form dwaf3500 amp config Java Note the address is dwqf3500 not dwgf3500 SET UP The first time you link to this form y
36. ample date ascending order The Location Status and Submitted Notes are used the same as on the Submitted Summary tab Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 5 1 Section 5 SUBMITTED DETAILS TAB How to request a submitted measurement revision Submitted Details Tab MEASUREMENT REVISION The Measurement Revision button is used if a submitted value must be changed a Drinking Water Quality Data You are connected to EMSU Submitted Details Approval Id 239029 oo foo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 COMMUNITY A WATERWORKS SYSTEM VYDIST Reading Sample Date Sampling Location Crt Frequency Parameter Type Unt lt or gt Value Sample Type SAMPLE BASED ON CALCULATED VALUE S EG Water Type TREATED WATER Sample Comments Missing Measurement Code ANB Analyzer Broken 02 0cT 2008 00 00 00 DISTRIBUTION BACTERIOLOGIC 1 WEEK CHLORINE TOTAL Min img 0 800000 i T Cl z aa z gt gt gt Select Approval Location Status Submitted TC Cancel Logoff In the above example the record highlighted does not have a value associated with it but it has a Missing Measurement Code A record that DOES NOT HAVE A VALUE cannot be revised You are connected to EMSU 3 Drinking Water Quality Data Submitted Details
37. ation Water Typ Sit Shut Down OPR Operating Measurement Commer AOL Analyzer offline EDZE TRN Turnaround Facility Save f Cancel UOL Unit off line el prova ocation ubmission ubm ancel Lago Select Ap Location Status Submissi Submit G ILogoff Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 10 Section 2 DATA ENTRY FORM How are SUBMISSION NOTES Submission Select Approval Location Status Notes Used Submission Motes Save Report File Submit Cancel Lagott Submission notes is a field that can be used to record day to day happenings at the plant The notes are stored by approval registration ID This means that when you are entering data on an approval that has more than one operation within it you should enter the name of the operation and the date then the note otherwise you will not be able to tell which operation the note belongs to When you submit records the submission notes are also submitted BUT it is important to understand that the date recorded will be the date of submission NOT the date you entered the note THEREFORE DATE and Ae title your notes Sample Location Count Freque Parameter Type g lt or ee Date DISTRIBUTION RANDOM LOCATIONE 5 Weekly e e CHLORINE TOTAL CEAN m o ENTERING DISTRIBUTICH mas Submission Notes DISTRIBUTION BACTEI DISTRI
38. bmit electronically as a condition of your Approval Registration AENV has done its best to ensure that the form reflects the drinking water quality monitoring information that your Approval Registration requires to be submitted electronically However it is your responsibility to ensure that you comply with the Requirements of your Approval Registration at all times Question What if there are errors on the form Answer If you believe there are errors omissions or discrepancies in the form you are presented or in the information you are asked to provide please contact via Email DWQ UserCoord gov ab ca Let the DWQ User Coordinator know the name of your operation your Approval Registration number the date you logged on and the nature of the problem The Coordinator will investigate and advise you of the outcome Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 3 Section 2 DATA ENTRY FORM New Un submitted Details Tab FEATURES Perr rrr rrr rw rw rere rere rer rerererr rer rere rerere Un submitted Details Tab NewLnsubmitted Details Unsubmitted Summary Submitted Summary Suemmitise Deae Feature Overview ApprovaliRegistration 239029 oo oo COMMUNITY REGIONAL WATERWORKS SYSTEM 000 Operation 220744 COMMUNITY AYWATERVWORKS SYSTEM GADISTI 00000 From Date To Date Month ear Tf wov 2008 2 9Nov 2008 e 4 Guery Data Contract Lak Data
39. cility Operation field will automatically populate but if the Approval has MORE THAN ONE operation you will have to choose which operation you want to enter the monitoring details Then click Next to proceed What is the LOCATION STATUS Location Select Approval Location Statue Submission Notes Save Reportrile Submit CanceliLogott ee Status Each of the sampling station locations are by default OPERATING If it became necessary to SHUT DOWN a station then monitoring at that location would not be performed Unless you change the STATUS of the station the system will expect monitoring data to be completed and the data entered on the form If you have not changed the location status your monthly report will be considered INCOMPLETE and an INCIDENT will be triggered automatically When the station is again UP and RUNNING you should change the LOCATION STATUS back to NORMAL OPERATION ES Location Status Sampling Location ENTERING CLEARVVELL RESERVOIR Last Submitted Status 17 DEC 20020PR Operating Initial default status Sample Location DISTRIBUTION RANDC DISTRIBUTION RANDC ENTERING CLEARVYVELI Status Date Status Status Description Status Comment 19 NOV 2008 Valid values for Station Status Indicators x ENTERING DISTRIBUTIC 5 ee ENTERING DISTRIBUTIC Z ENTERING DISTRIBUTIC m Status Indi Description Sample Typi H Normal Oper
40. cy CO Sample Type SAMPLE BASED ON CALCULATED ALLIE S EG Water Type TREATED WATER Sample Date o2 0cT 2008 i Proposed Measurement SSM O Parameter Unit oe Valle CHLORINE TOTAL mail oseoo00 Method TITRIMETRIC ANALYSIS Comment missed entering the second 3 This if an administrative error Click Request Revision After you click OK you will be prompted to contact the DWQ User Coordinator DWQ UserCoord gov ab ca to request that the revision be accepted 8 Measurement Revision Approval td 23 Sampling Location DI Measurement revision has been submitted Contact the Reading Type Ml Alberta Environment Drinking Water User Coordinator at Sample Type sa dwg usercoordmqoy ab ca to request that this revision be accepted Water Type TF Sample Date oz Proposed Measu Parameter CHLORINE TOTAL Method TITRIMETRIC ANALYSIS Comment missed entering the second 8 This is an administrative error The request will be considered and you will be advised of the outcome A red P indicates that a revision is pending The letter will change to a red R when the revision is accepted by AENV Reading Sample Date Sampling Location Crt Frequency Parameter Type Uni lt or gt Yalue By double clicking on the red P the system will show you the details of the request a Measurement Revision Approval Id 239029 0 0 COMMUNITY REGIONAL WATERWORKS
41. d in your Approval Registration This includes calling the AENV 24 hour complaint emergency response number 1 780 422 4505 Question There is a red L showing beside a saved record What does it mean Answer The red L indicates that a measurement is outside of the limit as defined by the Approval Registration Code of Practice Double clicking on the red letter will result in a message pop up explaining this Reading Sample Location Count Freque Parameter Type Unit 3 or gt Value Date DISTRIBUTION BACTERIOLOGICAL F 1 vveekly CHLORINE TOTAL rt ima 0 030000 o1 OCT 2006 L DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL hay nga a 0 800000 02 OCT 2008 Measurement value is outside of approval Limit Question What if I ve saved a record but not submitted it Can I change the value Answer You can change and re save the value of UN SUBMITTED records as often as is necessary Only once it s submitted to AENV does it become a problem to change a value It s important to CHECK the ACCURACY of the saved records including the CORRECT DATE BEFORE submitting them to AENV Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 14 section 3 FORMS SUBMIT RECORDS New Un submitted Details Tab Un submitted Summary Tab SUBMIT records to AENV Send the saved You can submit the records that you have entered and saved from the New
42. ded result is to provide assurance to Albertans regarding the safety of their drinking water supply The web address is http environment alberta ca apps RegulatedDWQ default aspx Address amp http environment alberta ca apps RequlatedDWO default aspx sing this Site ContactUs Aberta Environment uE Alberta ca gt Environment Regulated Drinking Water AA Programs Services Legislation Forms Applications Reports Data Advisories Newsroom Education About Us Guidelines Monitoring Home Alphabetical list of municipal water system plants Frequently Asked Questions about Drinking Water Glossary Private Systems Other Links of interest Quick links Environmental Hotline Authorization Approva Viewer Information Centre Water Advisories Drinking Water Quality Alberta River Basins Frequently Asked Questions Regulated Drinking Water in Alberta Alberta Environment is committed to working with partners to assure safe secure supplies of drinking water for Albertans Alberta Environment regulates municipal systems that serve over 80 per cent of the province s population about 2 75 million Albertans The rest receive their water from systems that are addressed by Regional Health Authorities RHA Alberta Health and Wellness Federal agencies or Indian and Northern Affairs Canada More To review information on a particular water treatment facility please enter your community b
43. dwgp_dwqr3500_web html_csv_help v Go Links 1 Click on the link below with the RIGHT mouse button then choose Save Target As 2 Select the desired folder and type in a file name ending with csv eg DWQ Data 2002 03 31 csv 3 Click Save ciy ma Open Open in New Window Save Target s Print Target Copy Shortcut Add to Favorites Convert link target to Adobe PDF Convert link target to existing PDF Opens selected link in a new window Laal intranet Properties Choose Open in New Window and the report will open in Excel format in a new window You will be given the option of opening the file or saving the file File Download Xx Do you want to open or save this file oN Name 239029 _20081119174503 csy Type Microsoft Office Excel Comma Separated Values Fil From envext z env gow ab ca harm pour computer IF you do not trust the source do not open or G While tiles from the Internet can be useful some files can potentially save this file What s the risk Choose Open Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 13 Section 2 DATA ENTRY FORM Saved date is limit checked Questions and Answers l Microsoft Excel 239029_20081119174503 1 csv AE File Edit View Insert Format Tools Data Window Help ABRA ee We OS Ae oO Cee Rane Ane ae tm MC Arial
44. e sending in monitoring data by ftp flat file transfer process then the system would be able to accept additional data without problem Se if O New Un submitted Details Tab TASK BUTTONS i E F z ik i ee Userhas SELECT AN APPROVAL more than Select Approval D Location Status Submission Notes Save ReportFile Submit CancelLagott to report on The Select Approval button is found on each of the four tabs When you are authorized user operator for more than ONE approval you can enter details for the other approved registered systems without terminating your on line session This is accomplished by clicking on the Select Approval button to return to the Please Select Your Approval form When you have returned to the Please Select Your Approval form use the LOV s down arrow to choose the next Approval Registration Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 9 Section 2 DATA ENTRY FORM H Drinking Water Data Entry Please Select Your Facility NGS cesarean EEE oo joc OMMLINITY REGIONAL WATERWORKS SYSTEM Facility Operation MMAR Fri eee 39046 COMMUNITS AT TEM Hi FEMM TREATMENT 299029 COMMUNITY REGIONAL WATERWORKS SYSTEM 2 M CARTE zF ate Click OK when the name of the correct Approval Registration is highlighted Then proceed as before REMEMBER If the Approval has only ONE operation then the Fa
45. eeeeesaecesausceesaneeenens 2 8 14 Measurement Comment ccsccsccsccnecnecnecsccscosscsecnecececoecoscosceecessenscaecascasces 2 8 Q amp A Missing Measurement COdEC cccsescccssecccesececesecceessceceececeneceeeneeseesceseusecenenees 2 9 Q amp A Additional Monitoring ccccscccssssccccsssccsusscesssecesseseusvencossscecuseseuesescussencuess 2 9 New Unsubmitted Details Tab Task Buttons ccccccccceeececccceseseecsceseeessecsceeeeececeeeeueeeeeeeuens 2 9 SCICCE GMA NOV All wii dacata sens a E 2 9 PO CATION S Ca CUS asana iow alettcacgan tare a a aa a a 2 10 SUDRAISSIOM INOUSS cepen a nonce oes ees sedate tentiseecheoeeessedabecawe 2 11 SVD c nnn ne eo RC ne ee aE Sere ae en rE nS eee ee 2 11 REDOT FIE e Aenea tire at re NEI ee ae E nee cen eens eT 2 12 OTE CIO CRINE aeeoa A E A E 2 14 SECTION 3 SUBMIT RECORDS New Unsubmitted Details Tab Unsubmitted Summary Tab Submit 3 1 SECTION 4 SUBMIT DETAILS Submitted Summary Tab Radio or Option Buttons esssssssssressrrsesrrssrrrsrrresrrrsrrrsrrreereens 4 1 Operator Entero eroien an EA A a eae 4 1 BacterologicalDa laea E E T E 4 2 AOO a a A saa aeeaten aise 4 2 Submitted Summary Tab TasSK BUTTON S ansari n EE ieee 4 3 SCIE OAP OVa E N 4 3 LOCATION StAtUs ern E E E E aus cuenieeiaateavent 4 3 SUDNI EA NOLE arrra AA E 4 3 REDOT IESni ea E AN A 4 4 SECTION 5 SUBMITTED DETAILS TAB Q amp A Submitted
46. elow Community Finder by Municipality Counties MD s only or you can find your facility using the Alphabetical List Community Please choose a community If you have specific questions or concerns regarding your drinking water quality please contact your local municipal officials Regional Health Authorities work with your facility owners to provide notification if there is a health concern related to your drinking water quality V Reported Electronically to AENV responsible to Report Electronically to AENV Is the web form secure SCOPE OF ELECTRONIC REPORTING The monitoring data for a regulated waterworks system is required to be sent electronically and is defined by e the Code of Practice for Waterworks Systems Using High Quality Groundwater or e the Code of Practice fora Waterworks System Consisting Solely of a Water Distribution System or e the conditions attached to the Approval Some of the parameters included are e those parameters considered to be of greatest value as indicators of public health concerns example bacteriological turbidity chlorine fluoride e other parameters that are monitored as required by the Approval Registration example iron manganese e annual water chemistry sample results as required by the Approval Registration Electronic submission of monitoring data does not replace compulsory notification requirements All Approval Registration incidents must
47. er Operators March 2010 Page A2 3 Appendix 2 Contract Lab When you have highlighted a file you can view the data within that file in two ways By double clicking on a File in New Un submitted Files Tab you can view the un submitted details by Sample This is intended for viewing a sample which has many parameters i e annual samples Ta Review Drinking Water Data You are connected to EMSU View by Sample File File Name 90195448 20080316 K 1 999 Station Desc PRIOR TO CHLO Sample Date Time 16 MA4R 2008 00 00 0 Source Lab OPERATOR SUBMITTED DATA APY Id 00195446 APY Name AAAA SYSTEM Opr Name AAAA TEST WATERWORKS SYSTEM Station Samples Station No ABOSEBO994 Station Desc PRIOR TO CHLORINE ADDITION Reading Type OO a Sample Date Time 18 MAR 2008 01 00 00 Matrix RAWWATER Sample Type DISCRETE SAMPLE GRAI Sample Freq Day 000 Sample Comment opr file this is EXTRA AND for APVID written to sample xrefs 0000 E Sample No 0800713265 Lab Sample No foss _Gaps Variables amp Measurements Variable Name Flag Value Unit i o a i MTE TMTNT MMMM MA By double clicking on a Station in New Un submitted Files Tab you can view the un submitted details by Station This is intended for viewing a few parameters that have many measures for each i e large volume of operator data by ftp a Review Drinking Water Data You are connected to EMSU View by Stations
48. er a comment into the Measurement Comment explaining the reason for the Ene measure Valid values for Missing Measurement Code Sample Location br gt Value Date DISTRIBUTION BACTERIOLOGICAL F Missing M Description 0 120000 01 OCT 2008 DISTRIBUTION BACTERIOLOGICAL F Laboratory Error v 0 200000 02 OCT 2008 Analyzer Broken aS 03 OCT 2008 TPE Transposing Error Entered on wrong day 0 180000 04 0CT 2008 EIO Either Or Missing Measurement re Chlorine R 7 0 190000 05 OCT 2008 J 0 200000 06 OCT 2008 Mgoooo 07 oct 2008 F Missing Measurement Code SARs DISTRIBUTION BACTERIOLOGICAL F DISTRIBUTION BACTERIOLOGICAL F DISTRIBUTION BACTERIOLOGICAL F DISTRIBUTION BACTERIOLOGICAL F Vater Type E Measurement Comment aa lt gt gt gt 14 Measurement Comment a field where you can add a comment specific to the parameter For example the address where the sample was taken in the distribution system could be entered into the Measurement Comment field Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 8 Section 2 DATA ENTRY FORM QUESTIONS AND ANSWERS A MISSING MEASUREMENT CODE Missing Question What if am missing data for a particular date and wish to save the other data pe ement collected along with the record that a data measurement is missing ee
49. forms net HTTPNStream getResponse Unknown Source oO Dat oracle forms net HTTPNStream doFlush Unknown Source oO Dat oracle forms net HTTPNStream flush Unknown Source oO Dat java io DataOutputStream flush Unknown Source oO Dat oracle forms net StreamMessagevvriter run Unknown Source o Answer In the event that the connection at AENV is terminated such as could occur during system updates one of the messages above could be displayed on your screen This would occur if you had already logged on and the session was terminated during your time logged on You may also receive the second message in the event that you have been timed out The system is set to time out after one hour Solution Shut down the screen by selecting the X in the top right hand corner of the screen You will be able to log on once AENV has re established the connection Or contact DWQ UserCoord gov ab ca Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 1 3 Section 1 LOGON Question What is my username and password Answer Each Authorized User will receive a unique Username and Password from AENV to submit drinking water quality information electronically through this website If you have not yet obtained a Username and Password please contact DWQ UserCoord gov ab ca Question have entered my username and password but the following message pops up What is wrong Failed to connect You a
50. g results please contact dwq datacoord gov ab ca and identify the name of your operation the Approval ID Registration ID the nature of the problem and the date 3 When you have finished entering Drinking Water Quality Monitoring results and save it the results you save will be compared against the respective limits defined by your Approval Registration You will have an opportunity to verify the results you have entered prior to submitting it to the Director To assist you you will be presented with a pop up window that identifies the number of saved results records the number that meets the requirements of your Approval Registration and the number of saved results records that exceed the guidelines and limits defined by your Approval Registration You will also be provided with an Exceedance Details report that identifies the relevant records and whether it is the Guidelines for Canadian Drinking Water Quality or the limit defined by your approval registration that has been exceeded If you believe that these saved records or the Exceedance Details are in error please contact dwq datacoord gov ab ca and identify the name of your operation the Approval ID Registration ID the nature of the problem and the date 4 Once you are satisfied that the results you have entered have been inputted correctly and you have identified the records you intend to submit to the Director by clicking on the check box then click on the Submit Data
51. h Quality Groundwater or Code of Practice for a Waterworks System Consisting Solely of a Water Distribution System will be referred to as Registration Data is submitted to a Secure Website DWQ Website which only Authorized Users will be allowed to access AENV will provide a unique Username and Password to each authorized user The authorized user logged into the system is allowed access only to their own data A user can enter save modify and or submit data to AENV depending on their assigned Authorized User privileges There are two types of Authorized User privileges DWQ Save Only User can save and or modify saved data DWQ Save and Submit User can save and or modify data and has the authority to submit the data to AENV This is the electronic equivalent of signing off the report i e certifying that the data is correct It is recommended that a minimum of two Designated Users be assigned Save amp Submit user privileges to provide opportunity for personnel backup for data submission This website is designed to support only the monthly and annual reporting of drinking water quality monitoring results specified in the Approval Registration as having to be submitted electronically to AENV It does not relieve you of the obligation to retain your raw data and other records for the period specified in your Approval Registration THIS WEBSITE DOES NOT SUPPORT IMMEDIATE REPORTING OF CONTRAVENTIONS OF THE A
52. ing Select Approval e Change the status of a monitoring location using the Location Status e Enter detailed notes on the operation using the Submission Notes e Enter comments specific for an individual measurement e Save the values entered for each parameter e Report on the saved but un submitted values entered for the specified date range e Submit the values entered for the specified date range e Cancel or Logoff the secure website Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 4 a ae FS Drinking Water Quality Data You are connected to EWG felerere re ee eee ee er errr eee Section 2 DATA ENTRY FORM New Un submitted Details Tab CONTRACT LAB DATA Viewing One of the features of this secure web form is the ability to view the results of your water Contract analysis that has been performed by your contract laboratory Of course this can only be done Laboratory l data when your contract laboratory has arranged with AENV to have the analytical results sent electronically to AENV on the behalf of the Approval Registration holder For information on this process including the submission of the data to AENV refer to Appendix 2 p9 Drinking Water Quality Data You are connected to EMASU cere rere Hew Unsubmitted Details Unsubmitted Summary Submitted Summary Submitted Details ApprovaliRegistration 239029 oo foo COMMUNITY REGIONAL WATERWORKS SYSTEM Opera
53. itted to AENV and the Un submitted Summary form will clear You will no longer be able to view the records on the New Un submitted Details Tab za Drinking Water Quality Data You are connected to EMSU THe eierieease atziz Approval Id 239029 oo foo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 E community A WATERWORKS SYSTEM VYDIST Sample Date Sample Location of Records Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 3 2 Section 4 Can I see the data that I submitted to AENV What do the Option buttons do Viewing the Operator submitted details Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 SUBMIT DETAILS Submitted Summary Tab RADIO or OPTION BUTTONS Once data has been submitted to AENV it is no longer accessible through the New Un submitted Details and Un submitted Summary tabs The submitted data can be viewed on the Submitted Summary tab Choose the date range by using the popup Calendar when you click on the down arrow za Drinking Water Quality Data You are connected to EMSU eared epee Submitted Summary Approval Id 239029 00 Operation 220714 00 COMMUNITY REGIONAL WATERWORKS SYSTEM E COMMUNITY A WATERWORKS SYSTEM QADIST Query Data A
54. n ID field will automatically be populated or completed If you have ONE Approval with TWO or more unique operations within the Approval then the form will automatically populate the Approval Registration ID field but you will have to use the down arrow List of Values LOV s to choose which operation you will be entering the monitoring records for If you operate more than ONE Approved Registered System then you will have to choose the Approval Registration using the down arrow List of Values and if the approval contains more than ONE operation you will have to use the down arrow List of Values to choose which operation you will be entering the monitoring records for 3 Drinking Water Data Entry l l ApprovalRegistration 239029 Facility Operation racilities le COMMUNITY Operation ID 220714 220716 ta Drinking Water Data Entry Please Select Your Facility Approval Registration 239029 oo oo community REGIONAL WATERWORKS SYSTEM Facility Operation 20714 3 COMMUNITY A WATERWORKS SYSTEM VYDIST Aberta Environment CancelLogoti inactive sessions will expire in 60 minutes Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 2 2 Section 2 DATA ENTRY FORM New Un submitted Details Tab Entering This is the form that is used to enter the monitoring ice Monitoring details See ey eee eee I eke es ee Sa ete ee a E T
55. nnual TO To Date 20 NOV 2008 Operator Entered Bacteriological Data gt lt ya Calendar Window a gt gt gt of Records _ lt October 2008 d oe Cad Cl eee al E amp E L z ERESERED i 26 27 28 29 30 31 z L E OW Check All Uncheck All Select Approval Location Status Submitted Hotes ReportFile Cancel Logoff Select the type of data by clicking on one the radio buttons i e Operator Entered Bacteriological Data or Annual Then Query Data The radio button Operator Entered The system default is Operator Entered monitoring data records All the data that the authorized user entered saved and then submitted to AENV will be displayed 3 Drinking Vater Quality Data You are connected to EMSU Submitted Summary Approval id eiA p0 00 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 E COMMUNITY A WATERWORKS SYSTEM WDIST Query Data From Date 01 OCT 2008 4 To Date 20 Nov 2008 3 Operator Entered Bacteriological Data Annual Sample Date Sample Location of Records 03 0cT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS o4 0cT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS o5 0cT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOMLOCATIONS 7 o6 OcT 2008 DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS o7
56. omplied with all Emergency Operation actions and reporting required by your approval Parameter Value Lower Limit Limit Type Date Sampling Location Upper Limit Approval indicates the limit is defined in your Alberta Environment Approval GCDWQ indicates the limit is defined in the Guideline for Canadian Drinking Water Quality Creating a report on saved records REPORT FILE Select Approval Location Status Submission Motes Submit Cancel Lagatt You can print a report or export the saved records into a data set that can be opened in Microsoft Excel format Report File Two report output types exist e A printable report which is created on line and e A Data File which is exported in csv format This format can be opened in Microsoft Excel Click on the REPORT FILE button Choose the From Date and To Date and the type of output in this example it will generate a printable report Click OK a Unsubmitted Details Date 239029 foo oo COMMUNITY REGIONAL WATERWORKS SYSTEM 01 OCT 2008 L __ SampleLoc ReportFile Approval Id 02 OCT 2008 DISTRIBUTION DISTRIBUTION a Sampling Location DISTRIBUTION 4 04 2CT 2008 aR Sample Frequency t DISTRIBUTION 15 OCT 2008 Parameter Ed DISTRIBUTION DISTRIBUTION Sar Facilty Operation From Date Output Type Printable Report
57. on to return to the Please Select Your Approval form for more details see page 2 9 LOCATION STATUS displays the status of the stations at the start of the period and any changes that were made within the defined date range ma Location Status iirc eee ere Status From Date 01 OCT 2008 To Date 11 OCT 2008 Sampling Location Status Date Status Status Comment s PISTRIBUTION RANDOM LOCATIONS 24 APR 2007 OPR Operating Initial default status ENTERING DISTRIBUTION SYSTEM 24 APR 2007 OPR Operating Initial default status DISTRIBUTION BACTERIOLOGICAL R 24 APR 2007 OPR Operating initial default status status of the location at the start of the selected period Cancel SUBMITTED NOTES displays the notes that were entered and saved from the New Un submitted Details tab Note that the Submitted date is the computer stamped date of submission If you do not date the Note when it was made you will not be able to tell what date it occurred or operation if it isa One approval to Many operations facility it belongs to a DS ee i i i i i i i a i a i i i i i i i i i i i i i i i i i i i i er Submitted notes From Gate 01 May 2008 To Date 21 NO w 2008 Submitted Motes 20 NOYy 2008 COMMUNITY A 03 OCT 2008 14 02 46 The chlorine analyzer used for sampling chlorine in the distribution Expand Cancel When you highlight the notation of interest and click Expand a popup will display the comple
58. ou will have to go through a short set up process to install the Sun Java software on your machine Once this process is successfully completed you will not have to repeat it unless you are trying to access the DWQ web forms on another computer The Sun Java software is free of charge Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 1 1 Section 1 LOGON As soon as you try to load the login screen shown above you will be prompted to install Sun Java If you are unable to download the form contact the DWQ User Coordinator during business hours at DWQ UserCoord gov ab ca or by phone at 780 415 9378 Internet Explorer Security Warning Do you want to install this software Name Javai TMi SE Runtime Environment amp Update 11 Publisher Sun Microsystems Inc e More options Install Don t Install While Files From the Internet can be useful this File type can potentially harm vour computer Only install software From publishers you trust what s the risk The next screen will be this Security Warning click Install to proceed Downloading Java Installer Java installer is being downloaded please wait Estimated time lett 13 sec Java is found everwhere on mobile phones desktop computers Blu ray Disc players settop boxes and even in Your Car By installing Java you will be able to experience the power of Ja
59. ous form Only your authorized users will have access to this data The electronic data should be compared to the paper pdf sample results If for some reason you think the data is erroneous you must contact the laboratory Whether you need to have the lab re run the sample or just verify a parameter s value if there are any changes then the WHOLE file must be deleted It is not possible to change a value on this form only delete the file After the lab has made any adjustments they must then resend the file under a new name The original file must be deleted prior to a resend file Only the submit user will be able to signoff the data and thereby submit it to AENV You will receive a message with a reference number Please record this number The look and Tabs of this linked form are Tab New Un submitted Files The ability to Report on each file waiting to be submitted is provided both for print and csv data file Ty Review Drinking Water Data You are connected to EMSU New Unsubmitted Files TER Approval Approval id P0195448 4444 SYSTEM APV Status Issued Approval Holder AAA TEST SYSTEM Operation ASAA TEST WATERWORKS SYSTEM Files Year Month File Name Loaded Date Source Lab Fi le List Nptes 2008 00195448 20080316 K 1 999 16 MaR 2008 OPERATOR SiB A QUBMITTED NOTES WHERE DO WEG Repot D 2007 APR 00195448 20071104 K 2 999 04 NOV 2007 OPERATOR SUBMITTED DATA Repot
60. ple Comments 4 8801400 5 08R010216 M D OF ACADIA 34 Missing Measurement Cod D Location Status Submitted Notes Measurement Revision Cancel Logoff The radio button Annual a Drinking Water Quality Data You are connected to EMSU Submitted Summary supmied Detale Approval ld 239029 o0 o0 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 TE COMMUNITY A WATERWORKS SYSTEM DIST Query Data From Date 01 OCT 2008 To Date 11 OCT 2008 Operator Entered Bacteriological Data The submitted accredited laboratory data will be viewed by clicking on the Query Data button Please remember that the contract lab that you use must first contact AENV so that the bulk file can be created and transferred electronically See Appendix 2 Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 4 2 Section 4 SUBMIT DETAILS Submitted Summary Tab TASK BUTTONS The four buttons Select Approval Location Status Submitted Notes and the Report File Select Approval Location Status Submitted Hotes Report rile CanceliLoagott SELECT APPROVAL The Select Approval button is found on each of the four tabs When you are authorized user operator for more than ONE approval you can enter details for the other approved registered systems without terminating your on line session This is accomplished by clicking on the Select Approval butt
61. re not connected to the database Answer You may have entered your username or password in incorrectly Please try again If the message occurs again then contact the DWQ UserCoord gov ab ca REMEMBER YOUR USERNAME AND PASSWORD ARE NOT TRANSFERABLE AND IT IS YOUR RESPONSIBILITY TO MAINTAIN THEIR SECURITY Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 1 4 Section 2 DATA ENTRY FORM FORM FOR DATA SUBMISSION Introduction The website application is composed of a form with 4 tabs plus the entry page Please Select Your Facility form a l Drinking Water Data Entry Please Select Your Facility Approval Registration z Facility Operation 3 Aberta Environment Net _CancetLogot inactive sessions will expire in 60 minutes The name of each tab is displayed along the top of the form These tabs are e New Un submitted Details e Un submitted Summary e Submitted Summary e Submitted Details ra Drinking Water Guatily Daia New Unsubmitted Details Unsubmitted Summary Yuu are connected ta FMSU Sisenitese Vatis ApprovalRegistration 239029 oo oo COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 22071 4 COMMUNITY A WATERWORKS SYSTEM VYDIST From Date To Date Month Year ZU 19 Nov 2008 SSN S Zi ia nov 2008 Ss 3 Query Data Contract Lab Data Reading Sample Location
62. te text wording 4 4 L a Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 4 3 Section 4 SUBMIT DETAILS Ho Submitted notes From Date 01 OCT 2008 To Date 30 NOW 2008 Submitted Notes S 20 NO V 2008 COMMUNITY A 03 OCT 2008 14 02 48 The chlorine analyzer used for sampling chlorine in the distribution r Editor OMMUNITY A 03 OCT 2008 The chlorine analyzer used for sampling chlorine in the distribution system broke A replacement was ordered but analysis was not performed eae D REPORT FILE report on the submitted details including measurement comments and submission note It can be a Printable Report or a Data File csv format which can be opened in Microsoft Excel See the New Un submitted Details reporting explanation on page 2 12 Alberic environment DRINKING WATER REPORT Submitted Data From Date 01 OCT 2008 To Date 24 NO V 2008 Approval No 239029 00 00 Location COMMUNITY A DISTRIBUTION BACTERIOLOGICAL RANDOM LOCATIONS eS Parameter Value Count A Measurement Comments EEE BASED ON 01 OCT 4 CALCULATED REATED WATER CHLORINE TOTAL 2008 mg L WALUE S EG AVE MIN MAX MIN SAMPLE BASED ON 02 OCT CALCULATED REATED WATER CHLORINE TOTAL 2008 mail WALUE S EG AVE MIN MAX MIN 04 OCT CALCULATED REATED WATER ICHLORINE TOTAL fae 11 mgl Wal UE S EG AVE MIN MA
63. tification criteria for you to forward with your sample s to the laboratory as well as a sample label like the following Potable Water Sampling Annual Quarterly Semi annual Monthly AENV Approval Registration No Sampled at Station Station No Description Sample Matrix 10 T R leone 20 rene Sample Type 1 Grab Sample Frequency ANNUL Annual a Monthly Sample Date amp Time hr clock Comments As of December 2008 the sample label has been expanded to become a sample request form on next page This form with the correct sample identification must accompany the sample to the laboratory If information is missing the laboratory s file may end up being rejected by the AENV file loading system AENV will still provide the initial sample identification necessary so you can correctly fill out the form You must be cognisant of the parameters required under your approval registration Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page A2 1 Appendix 2 Contract Lab Municipal Drinking Water Facility Sample Request Form as per Alberta Environment Approval Registration one sample per form LABORATORY INFORMATION Name Address Phone FAX FOR LAB USE Lab Sample Number Date Received Account BILLING SAMPLE REQUESTER INFORMATION Name Address Phone E mail Other Facility Water Sampling Annual Quarterly
64. ting information e 6A bulk transfer ftp flat file transfer process for larger volumes of operator data and e A bulk transfer ftp flat file transfer process for the accredited contract laboratory The First Step AENV has provided the option of using a test site for new users The waterworks system Operator is encouraged to use the test site to familiarize him her self with the look and feel of the form To use these forms AENV will issue a Username and password for each user designated by the system owner to have access to the secure site What happens after the testing Approved Waterworks Systems e a Drinking Water Quality User Agreement is entered into between the Approval holder and AENV e The Approval is amended to reflect the electronic monitoring and reporting requirements Registered Waterworks Systems The Director provides written notice to begin reporting electronically as specified in either the Code of Practice For Waterworks Systems Using High Quality Groundwater or Code of Practice For A Waterworks System Consisting Solely Of A Water Distribution System AENV issues a new secure password and sends it by registered mail to the Approval Registration holder along with the web address to the secure Production website QUESTIONS AND ANSWERS Throughout this manual frequently asked questions and answers will be included Question When can access the website Answer AENV will endeavour to
65. tion 220714 E COMMUNITY A WATERWORKS SYSTEM WWDIST From Date To Date Monthy ear E m E JE ocras W Query Data E New Un submitted Details Tab EXPLANATION OF THE DETAILS for ENTERING DATA Un submitted Ta Drinking Water Quality Data You are connected to EMSU cee er ete iran ot Ogre rer te Details Tab NewUnsubmitted Details Unsubmitted Summary Submitted Summary Simmittse WEEE Entering Monitoring ApprovalRegistration 239029 oo o0 COMMUNITY REGIONAL WATERWORKS SYSTEM results Operation 220714 E COMMUNITY A WATERWORKS SYSTEM DIST From Date To Date Month ear i gt 4 ii cs ocT2008 Query Data Contract Lab Data Readin Sample Location Count Freque Parameter Type an or Value Date DISTRIBUTION BACTERIOLOGICAL F 1 vveskiy CHLORINE TOTAL MIN m alo l to T 2008 jA DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL Mn ha Tw Ss T 2008 DISTRIBUTION BACTERIOLOGICAL 1 vWeekly CHLORINE TOTAL Mn ma H O peoc DISTRIBUTION BACTERIOLOGICAL 1 Weekly CHLORINE TOTAL Mn mgt H O O ocr DISTRIBUTION BACTERIOLOGICAL F 1 Weekly CHLORINE TOTAL Min mnga 06 ocT 2008 DISTRIBUTION BACTERIOLOGICAL 1 Weekly CHLORINE TOTAL n fng x I fov oct 2008 F Sample Type SAMPLE BASED ON CALCULATED WALUE S EG Method Water Type TREATED WATER missing Measurement Code IP Measurement Comment SS Select Approval
66. tration This Web site may only be used by Approval Registration Holders and their Authorized Users who have a valid User Agreement with the Minister of Environment By submitting information through this Web site you are consenting to the terms and conditions set out below 1 2 Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 This Web site supports only the monthly and annual reporting of drinking water quality monitoring results that are specified in your Approval Registration to be submitted electronically to AENV THIS SITE DOES NOT SUPPORT IMMEDIATE REPORTING OF CONTRAVENTIONS OF THE APPROVAL REGISTRATION NOTIFICATION AND CONSULTATION AND MONITORING RESULTS UNDER EMERGENCY OPERATIONS OR REPORTING OF ALL OTHER ADDITIONAL MONITORING RESULTS BEYOND THOSE REQUIRED AS PART OF THE APPROVAL REGISTRATION When you sign on with your User ID and password you will be presented with a form Page A1 1 Appendix 1 Disclaimer for the entry and submission of your Drinking Water Quality Monitoring results This form should reflect the Drinking Water Quality Monitoring results that your Approval Registration requires to be electronically reported to the Director It does remain however your responsibility to ensure that you comply with the requirements of your Approval Registration at all times If you find that this form is not adequate to report the Drinking Water Quality Monitorin
67. ue cannot be revised using the Measurement Revision form You will have to contact the DWQ User Coordinator DWQ UserCoord gov ab ca to request the revision Question entered saved and submitted records then realized they were entered on the wrong date What do I do Answer The Measurement Revision form will not allow DATE changes You will have to contact the DWQ User Coordinator DWQ UserCoord gov ab ca to request the revision Please remember to be very aware of the date when entering data You can change UNSUBMITTED data as often as is necessary BUT once it is submitted you will require Alberta Environment intervention if the data was entered for the wrong date Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 5 4 Section 6 CANCEL LOGOFF CANCEL LOGOFF the secure website Logoff The Cancel Logoff button can be found on each of the four Tabs When you click on this button any unsaved changes will be lost and you will exit the secure site Select Approval Location Status Submission Motes Save ReportFile Submit CanceliLogott D Window 73 Drinking Water Quality Data You are connected to EMSU New Unsubmitted Details ApprovalRegistration 239029 00 00 COMMUNITY REGIONAL WATERWORKS SYSTEM Operation 220714 COMMUNITY A WATERWORKS SYSTEM DIST From Date To Date Month Year DO e DO D e E Reading Sample Location
68. va broughtto you by Sun Microsystems ric Visitus at http java com Cancel The computer will then install the program onto your machine When the process is complete the Finish Installation pop up will display click Finish Installation and the Set Up process will complete Alberta Environment Electronic Data Transfer Manual for Drinking Water Operators March 2010 Page 1 2 Section 1 LOGON Logon LOGON In future the Java Applet will automatically load and the Logon Screen will appear fey EWS Logon Ir E Username Password Enter your unique username and password that AENV has provided Do not share your password if you find that another individual requires access to the web forms contact the DWQ User Coordinator with their information and a username and password will be issued specifically for them QUESTIONS AND ANSWERS LOGON Logon Question received a Failure has occurred on the Server or a Trigger raised tials unhandled exception error what do I do now Answers FRNI 407 35 YWHER YVALIDATE ITEM trigger raised Unhandled exception ORA 03114 FRM 92101 A failure has occurred on the Server You will need to reestablish your session By 1 a Java Exception oracle forms net ConnectionException Forms session lt 8 gt aborted unable to communicate with runtime process O Oat oracle forms net ConnectionException createConnectionExceptionfUnknown Sourc Dat oracle
69. wable by AENV until you submit it Question When is the information made public Answer This is a secure website and only submitted data will be accessed and reviewed by AENV It is this data that will be made available to the public through AENV s home web page The submitted data is published to the AENV external website world wide web approximately 30 45 days later Question Are there any helpful hints once am logged on the system Answer Yes simply place the mouse cursor on an area on the form you would like more information on and a yellow popup box shall appear For example by holding the cursor near the Query Data button the yellow drop down lets you know the buttons purpose Approval Id 4 95445 oo ba Flaaaa SYSTEM Sampling Location ALL sample Frequency ALL Sample Date 02 MAY 2007 gt Vil Section 1 LOGON System Requirements Loading Sun Java interface Set Up SYSTEM REQUIREMENTS Internet Access Internet Explorer 7 is supported Operating system Windows 2000 and above are supported VISTA is supported Sun Java 6 installation is required In some instances you may have to allow pop ups for the application and In some instances you may have to turn off your firewall to install GETTING STARTED LOGON The logon form can be found through the Government of Alberta Environment web page Address http Awww environment alberta ca Using this Site Cont

Publication - Alberta Environment

Contents

Download Pdf Manuals

Related Search

Related Contents