816B08001
T
 *
Step-by-Step Guide to the
Data Collection and Tracking
System (DOTS)

-------
Office of Water (4606)        EPA 816-B-08-001          www.epa.gov/safewater            February 2008

-------
This document is intended to provide step-by-step instructions to public water systems,
laboratories, state drinking water programs, and EPA on the use of the Data Collection
and Tracking System (DCTS). The DCTS is used to collect and track information on the
Long Term 2 Enhanced Surface Water Treatment Rule (LT2ESWTR or LT2) and the
Stage 2 Disinfection and Disinfectant Byproducts Rule (Stage 2 DBPR or Stage 2). This
document is divided into four major section based on the type of DCTS user.

   •   DCTS for Public Water Systems: LT2
       Intended for PWSs that need to submit sampling schedules and sampling
       locations, approve sample results, and work with the laboratories conducting their
       Cryptosporidium and E. coll analysis.

   •   DCTS for Public Water Systems: Stage 2
       Intended for PWSs using the DCTS to submit their systems Initial  Distribution
       System Evaluation (IDSE) Plan and/or Report.

   •   DCTS for Laboratories
       Intended for laboratories that are conducting LT2 compliance analysis for surface
       water systems.

   •   DCTS for States and EPA
       Intended for primacy agency personnel responsible for oversight.
It is important that the instructions in this guide are followed carefully. If you think a
report is missing data or is not generating properly, please first make sure the data were
entered correctly.

-------
                            Contact Information
Central Data Exchange
Access to the DCTS is through EPA's Central Data Exchange (CDX). If you have
questions regarding the CDX that this step-by-step guide does not answer, you should
contact the CDX's Web Submission Support. The three support options available are:

   •   By Telephone: Person-to-person telephone support is available from 8:00 am to
       6:00 pm (EST). Call our toll-free line at 888-890-1995.

   •   By E-mail: Send e-mail to Technical Support at EPACDX@CSC.COM with
       "Technical Support" in the Subject line.

   •   By Fax: Assistance requests are accepted 24 hours a day at 301-429-3905.
       Support personnel will respond to faxed requests Monday through Friday from
       8:00 am to 6:00 pm EST/EDT.

A list of Frequently Asked Questions about the CDX is available at:
https://cdx.cpa.gov/SSL/cdx/FAQ.asp

DCTS Registration
If you have registration questions regarding the DCTS you can e-mail EPA's LT2/Stage
2 Inbox at stage2mdpb(ajepa.gov.

Stage 2 DBPR and LT2ESWTR
A list of contacts by state that can answer specific state questions about the Stage 2
DBPR is available at:
vvwvv.epa.go\/safewatcr/disinfection.stage2/pdfs/contacts_stage2_compliancehelp.pdf

A list of contacts by state for the LT2ESWTR is available at
wwvv.epa.go\'/sal'evvatcr/'disinl'cction/lt2/compliancc.htiTil

Also the following EPA contacts can provide further support
Region 1 -
Adrienne Harris
Region 2 -
Michael Lowy
Region 3 -
Nick Tymchenko
Region 4 -
Robert Burns &
Amy Newbold
Region 5 -
Miguel Del Toral
harris.adrienne@epa.gov
lowy.michael@epa.gov
tymchenko.nick@epa.gov
burns.robert@epa.gov
newbold.amy@epa.gov
deltoral.miguel@epa.gov
Region 6 -
Nancy Ho &
Mark McCasland
Region 7 -
Doug Brune &
Monica Wurtz
Region 8 -
Robert Clement
Region 9 -
Jason
Gambatese
Region 10 -
Wendy Marshall
ho.nancy@epa.gov
mccasland.mark@epa.gov
brune.doug@epa.gov
wurtz.monica@epa.gov
clement.robert@epa.gov
gambatese.jason@ epa.gov
marshall.wendy@epa.gov

-------
                                      Contents
DCTS for Public Water Systems: LT2
   A. Step-by-Step Registration for DCTS for New CDX Users	1
   B. Step-by-Step Registration for DCTS for Current CDX Users	5
   C. How to Add a Facility and Sampling Points to a Public Water System	9
   D. How to Enter Sample Schedules	11
   E. How to Enter Other LT2ESWTR Data	13
   F. How to Identify Contracted Labs (Administrative Users Only)	15
   G. How to Approve Standard Users (Administrative Users Only)	17
   H. How to Search for LT2 Samples	19
   I.  How to Approve, Contest, or Return a Sample to the Lab	21

DCTS for Public Water Systems: Stage 2
   A. Step-by-Step Registration for DCTS for New CDX Users	1
   B. Step-by-Step Registration for DCTS for Current CDX Users	5
   C. How to Submit a 40/30 Certification Plan using the IDSE Tool	9
   D. How to Submit a Standard Monitoring Plan using the IDSE Tool..	15
   E. How to Submit a System Specific Study (SSS) - Existing Monitoring Results using the IDSE Tool ...19
   F. How to Submit a System Specific Study (SSS) - Hydraulic Modeling using the IDSE Tool	25

DCTS for Laboratories
   A. Uploading Your Ciyptosporidium or E. Co//Laboratory into DCTS	1
   B. Step-by-Step Registration for DCTS using CDX	3
   C. How to Create a New Sample	5
   D. How to Search for LT2 Samples	9
   E. How to View Sampling Schedules	11

-------
DCTS for States and EPA

LT2/Stage 2 Tracking System
   A.   How to Search fora Public Water System	1
   B.   How to Create and Assign a New CDS ID	5
   C.   How to View or Edit Public Water System Contact Information	7
   D.   How to Approve an Alternative Schedule	9
   E.   How to Upload a Submission Received from a Public Water System	11
   F.   How to View a Public Water System Submission	13
   G.   How to Generate a List of Received Submissions	15
   H.   How to Approve Submissions	17
   I.    How to Approve a Batch of Submissions	19
   J.    How to Add Notifications	21

LT2 Data Collection System
   K.   How to Approve DCTS Users (Administrative Users Only) 	23
   L.   How to Search for a Public Water System's LT2 Samples	25
   M.   How to View a Public Water System's LT2 Grandfathered Data and Sampling Locations	27
   N.   How to View a PWS's LT2 Sampling Dates	31

LT2 Data Collection System Reports
   O.   How to Generate a Report in the LT2.Data Collection System	33
   P.   How to Generate a Sample Tracking Report	35
   Q.   How to Generate a Sample Backlog Report	37
   R.   How to Generate a Sample History Report	39
   S.   How to Generate a PWS Schedule Submission Compliance Report	41
   T.   How to Generate a Binning Report	43
   U.   How to Generate a Missed and Re-Sampled Events Report	45
   V.   How to Generate a Grandfathered Data Report	47
   W.   How to Generate a Monitoring  Waived Report	49

-------
X.  How to Generate a PWS Sample Location Plan Compliance Report	51
Y.  How to Generate a Sample Pair Incomplete Report	53
Z.  How to Generate a PWS Facility Compliance Report	55
AA. How to Generate a List of PWSs without Facilities	57
BB. How to Generate a List of Users (EPA Only)	59
CC. How to Generate a LT2 DCTS Usage Report (EPA Only)	61

-------

-------
 DCTS for Public Water Systems
               LT2
&EPA
  United States
  Environmental Protection
  Agency

-------

-------
                     DCTS for Public Water Systems:  LT2

                                        Contents

   A. Step-by-Step Registration for DCTS for New CDX Users	1
   B. Step-by-Step Registration for DCTS for Current CDX Users	5
   C. How to Add a Facility and Sampling Points to a Public Water System	9
   D. How to Enter Sample Schedules	11
   E. How to Enter Other LT2ESWTR Data	13
   F. How to Identify Contracted Labs (Administrative Users Only)	15
   G. How to Approve Standard Users (Administrative Users Only)	".... 17
   H. How to Search for LT2 Samples	19
   I.  How to Approve, Contest, or Return a Sample to the Lab	21
DCTS for PWSs: LT2                                                                 February 2008

-------
DC7-SforPWSs:L72                                                                      February 2008

-------
        Steo-bv-Steo Registration for DOTS for New CDX Users
        (Steps A.1 - A.17 need to be completed for registration. Once the password is setup, go to A.19.)
A.1 Goto: http://www.epa.gov/cdx
A.2 Click on "Log-in to CDX" (on sidebar) - New screen will appear
A.3 Click on "Registration" (on sidebar) - New screen will appear
A.4 Read the Warning Notice and Privacy Statements
A.5 Click on "Click here to continue" - New screen will appear
A.6 Read the Terms and Conditions and click on "I Accept" - New screen will appear
A.7 Input a user's first and last name, user name (following recommended format), password (following recommended format)
and re-enter the password, a question that can be used in case you forget your password, and the answer to the question - New
screen will appear
A.8 Input the water system's name in the Organization Name field and all other requested information/Click on "Next" - New
screen will appear

CDX Registration: Add Program
A.9 Select "LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2)" (see Figure 1).
                                                Figure 1
                                          CDX Registration: Add Program

                                               Facility Registry System - Update Service (FRS-US):

                                                          Lead-Based Paint Activities (LEAD):

                                             LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2):

                                                         Ozone Depleting Substances (ODS):

                                                             Radionuclide NESHAPs (RAD):

                                           Resource Conservation and Recovery Act Site ID (RCRA):

                                                   Stormwater Notice of Intent (eNOI) (SWENOI):

                      Toxic Release Inventory Made Easy Web (Approved Pilot Submitters ONLY) (TRIMEweb):

                                           Toxic Substance Control Act - HaSD Form (TSCA-HASD):

                                                    Compliance Information Systems (VERIFY):

                                 Request Manufacturer Code for OTAQ Compliance (VERIFY MFR REG):

                                                    Water Contaminant Information Tool (WCIT):
A. 10 Click on "Next" - New screen will appear
Complete Role Information -
A.11 Role is "Asubmitter" only option
A.12 Select "Standard" (This is CDX. This is not where you request DCTS Admin access.)
A.13 Input your water system's federal PWSID (i.e., WA5312345) in the ID field. If you don't know your PWSID please send an
e-mail to stage2mdbp@epa.gov.
A. 14 Submission method is "WEBFORM" (only option)
A. 15 Click on "Next"
A. 16 Read the  message
A.17 Click on "Finished"
A. 18 You should receive confirmation from "CDX Registration" [EPACDX@csc.com] within 24 hours of submitting your request.
Once you have received the e-mail confirming your CDX set-up, you can log into the DCTS.

Logging into the Data Collection and Tracking System (DOTS)
A. 19 Follow steps A.1. and A.2.
A.20 Input your user name and password - This is the user name you choose for yourself when setting up your CDX account
(see Step A.7). Click "Login" - New screen will appear
A.21 Click "LT2: LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry" program (see
Figure 2) - New window will appear
DCTS for PWSs: LT2
                                                                                                     February 2008

-------
                                                   Figure 2
Centra
Welcome,
Mr. John Smith
CDX Registration Status: Active
Data Exchange- MyCDX
Last Login:
Registered Since:
Recertification Date:


July 21, 2006
July 21", 2006
July 21, 2006
You have 0 new messages in your Inbox
Change System Edit Persor
Password Infor.matior
al Edit Current
Account Profiles
Add New
Employer Profile
Available Account Profiles:
• LT2: LT2 Data Collection. LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry

SEE STEP
A.21.
  A.22 To submit your IDSE Plan electronically for compliance with the Stage 2 DBPR click on IDSE Plan/Report Entry (see
  Figure 3). This is the final registration step for DCTS users that need to comply with the Stage 2 DBPR requirements for
  only one water system.

  If you  need access to multiple systems to complete multiple IDSE plans/reports or if you need to comply with the LT2
  requirements, you must request access to the LT2 Data Collection System. To obtain access to the LT2 Data Collection
  System you must contact your system's DCTS administrator. If you do not know your system's DCTS administrator, e-mail
  your system's PWSID, water system name, state, and CDX user name to stage2mdbp@epa.gov.
  A.23 Once access is granted to the LT2 Data Collection System click on the LT2 Data Collection System link that will
  appear above the IDSE Plan/Report Entry link (see Figure 3)
                                                     Figure 3
                     Systems
                     The system recognizes you as an approved user for the following applications, please select a system to launch...

                     LT2 Data Collection System
                     Launches the LT2 Data Collection System for the submission and review of samples

                     IDSE Plan/Report Entry
                     Launches IDSE Plan/Report Entry, which will lead you through filling out and submitting your IDSE Plan or Report
  A.24 Click on the "User Profile" icon
DCTS for PWSs: LT2
February 2008

-------
  A.25 Update information for First Name, Last Name, State, Phone Number, or E-mail Address if any are incorrect (see
  Figure 4)
                                                             Figure 4
                        * - Required Field
                        The following information is provided by CDX. If you feel any of the information is incorrect, please access CDX to update/verify
                                 r"
                        User Profile
UserName ;
*f~irst A/ame
''Last /Vame
'State
"Phong jVwm&sr
"Email 4 duress
SmithJohn
John
Smith
UN
(123)456-789;)
;ohnsnnthi_Q>somewhe
acorn
                                                         Save and Continue   Exs£ Registration
  A.26 Click on "Save and Continue"
  A.27 Input your water system's federal PWSID (i.e., WA5312345) in the Organization Code field (see Figure 5)
  A.28 Click on "Lookup Organization" (see Figure 5)
                                                             Figure 5
                      Please enter your Organization ID and click "Lookup Organization." The "Lookup Organization" link will be replaced with a "Request
                      Access" link and an "Undo" link. If your correct organization is displayed, click "Request Access." If you have incorrectly entered the
                      organization ID, click "Undo" and repeat the process. If you are an E. colt laboratory and your lab is missing from the list of organizations,
                      please click "E. co//Lab Registration."

                      If you are an existing user and would like access to the IDSE Plan/Report entry. Enter the code for the desired PWS and select LT2 from
                      the system list. Otherwise, you  should enter the PWSs organization code in the Program ID field when registering via CDX.
                                                                              Lookup Organization
                                 E. coli Lab Registration    Edit User information    Save and Continue  Exit Rsqistratton
  A.29 A new field "System Type" will appear; select "Both" (even if you only need access to one of the rules)
  A.30 Click on "Request Access"
  A.31 Click on "Save and  Continue"
  A.32 If you need to request access to additional systems, repeat steps A.27 through A.31. Once you are finished, click on
  "Exit Registration."

  Once your user name has been authenticated by the DCTS administrator for your system, you will be granted access to
  the data system for these additional system(s).
DCTS for PWSs: LT2
                                                                                                                           February 2008

-------
DOTS for PWSs: LT2                                                 4                                                       February 2008

-------
8.
Steo-bv-Steo Registration for DOTS for Current CDX Users
(Steps B.1 - B.6 need to be completed for registration. Once the password is setup, go to B.7.)
BJ. Log-in to the system using your CDX user name and password.
B.2. On the "MyCDX Screen" select "Edit Current Account Profiles" link.
B.3. Select "Add New Program."
B.4. Select "LT2ESWTR: LT2ESWTR, Stage 2 DBPR, and IDSE Plan/Report Entry" from the list of CDX applications (see
Figure 1).
                                                    Figure 1
                                                CDX Recnslr alkm: Add Program
                                                        LHd'J Ba.eJ Paint »rtMtiPs(LE/>Di
                                              ""LT: LI. Singe .. HndlDSEPIaii'Feiiurt Entry iLTii   "
                                                          Radionuclide NESHAPs (F-Di
                                            Resource conservation and Recovery Act Site ID (RCR
-------
Figure 3




Central Data Exchange- MyCOX
Welcome, Last Login:
Mr. John Smith Registered Since:
Recertification Date:
CDX Registration Status: Active
July 2 1.2006
July 21. 2006
July 21. 2006
You have 0 new messages in your Inbox
Change System Edit Personal Edit Current
Password Information Account Profiles
Add New
Employer Profile
Available Account Profiles:
• LT2: LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry

SEE STEP
B.9.


  B.10 To submit your IDSE Plan electronically for compliance with the Stage 2 DBPR click on IDSE Plan/Report Entry (see
  Figure 4). This is the final registration step for DCTS users that need to comply with the Stage 2 DBPR requirements for
  only one water system.
  If you need access to multiple systems to complete multiple IDSE plans/reports or if you need to comply with the LT2
  requirements, you must request access to the LT2 Data Collection System. To obtain access to the LT2 Data Collection
  System you must contact your system's DCTS administrator.  If you do not know your system's DCTS administrator, e-mail
  your system's PWSID, water system name, state, and CDX user name to stage2mdbp@epa.gov.
                                                      Figure 4
           SEE STEP
            B.11.
          SEE STEP
            B.10.
                        Systems
                        The system recognizes you as an approved user for the following applications, please select a system to launch...


                        LT2_Data^oi!ection_System
                        Launches the LT2 Data CoMection System for the submission and review of samples


                        IDSE Plan/Report Entry
                        Launches !DSE Pbn/Report Entry, which wiH lead you through fUHng out and submitting your IDSE P!an or Report
  B.11 Once access is granted to the LT2 Data Collection System click on the LT2 Data Collection System link that will
  appear above the IDSE Plan/Report Entry link (see Figure 4)
  B.12 Click on the "User Profile" icon
  B.13 Update information for First Name, Last Name, State, Phone Number, or E-mail Address if any are incorrect (see
  Figure 5)
DCTS for PWSs: LT2
February 2008

-------
                                                                 Figure 5
                              Jser Profile
                              = Required Field

                              he following information is provided by CDX. If you feel any of the information is incorrect, please access CDX to update/verify.
                                SEE
                               STEP
                               B.13.
                                                             Save and Continue   Exit
   B.14 Click on "Save and Continue"
   B.15 Input your water system's federal PWSID (i.e., WA5312345) in the Organization Code field (see Figure 6)
   B.16 Click on "Lookup Organization" (see Figure 6)
   B.17 A new field "System Type" will appear; select "Both" (even if you only need access to one of the rules)
                                                                Figure 6
                           Please enter your Organization ID and click "Lookup Organization." The "Lookup Organizalion" link will be replaced with a "Request
                           Access" link and an "Undo" link. If your correct organization is displayed, click "Request Access." If you have incorrectly entered the
                           organization ID. click "Undo" and repeat the process. If you are an E. coli laboratory and your lab is missing from the fist of organizations,
                           please click "£. coli Lab Registration."

                           if you are an existing user and would like access to the iDSE Plan/Reporl entry. Enter the code for the desired PWS and select LT2 from
                           the system list. Otherwise, you should enter the PWSs organization code in the Program ID field when registering via CDX.
                                                                                  Lookup Organization
                                      £. coli Lab Registration    Edit User information   Save and Continue  Exit Registration
   B.18 Click on "Request Access"
   B.19 Click on "Save and Continue"
   B.20 If you need to request access to additional systems, repeat steps B.15 through B.19. Once you are finished, click on
   "Exit Registration."

   Once your user name has been authenticated by the DCTS administrator for your system, you will be granted access to
   the data system for these additional system(s).
DCTS for PWSs: LT2
                                                                                                                               February 2008

-------
DCTSforPU/Ss:LT2                                              8                                                    February 2008

-------
 c.
How to Add a Facility and Sampling Points to a Public Water System
C.1  To add a facility and sampling points to your water system, select the "Facility Information" icon
     in the LT2 Data Collection system. This will direct you to a new page. Pre-populated facilities for
     your PWS will be listed on this page. If you need to change the name of your facility or sampling point email the
     Stage 2 Inbox (Stage2mdbp@epa.gov) the following information: PWSID water system name, state, facility
     name, and required change.
C.2  Select "Add Facility/Sampling Point" (see Figure 1). Once the facility or sampling point has been added you will
     not be able to delete it. To have the facility or sampling point deleted email the system's PWSID, water system
     name, state, facility name, and information to be deleted to the Stage 2 Inbox at Stage2mdbp@epa.gov.
                                                Figure 1
         Facility and Sampling Point Infomtation

         Click on the facility or sampling point name to edit the associated information.

                                ~««—|fc f ADD FACILITY/SAMPLING PQINL
«H ''•**.*£ '"W^^^:^<
F*it|,
:»
TP

Treatment Plant

Active
li»
-**
'^^^^Ml^^^^^^^^

,4" * W #'-*%> ,,*t
CoIliettonFiitf , , ,; „
D -
SP
• •••;.:•• Nagt -:': ""!"
Sample Point
                                        s   ADD FACILiT//SAMPLING POINT \
C.3  In order to add a facility, you must enter the following information (see Figure 2):

       a.  PWS Facility ID: the federal ID for that facility (eg., NY1234567, VA1234567)

       b.  Facility Name: e.g., South Treatment Plant

       c.  Facility Status: Whether the facility is currently Active, Inactive, or only used Seasonally.

       d.  Facility Type: Refers to where you will take your LT2 samples: TP - treatment plant; IN - source intake
       e.  Water Type:

               •  SW - for those PWSs that use surface water only or surface water and ground and/or ground
                  under direct influence of surface water (ground UDI surface); or

               •  GW - for those systems that use ground and/or ground  under direct influence of surface water
                  (ground UDI  surface);

       f.   Filtered: Select Yes or No to answer - Does your system filter the water?
DOTS for PWSs: LT2
                                                                                   February 2008

-------
                                                    Figure 2
tne following information tor trie hici iir
PWS Facility ID

Facility Name

F.icilily Status

Facility Type

Water Type

Filtered

">"
...... ,.L~II 	 IIZH
V
V
V
	 •*
Yes v TJ,
                                           D Our system has no separate facility IDs
C.4  Once the facility is entered, select "Insert New Sampling Point" to add single samples or "Insert Composite
     Sampling Point" to enter samples comprised of water from multiple sources (see Figure 3).
                                                   Figure 3
          Please enter/review the following information for the Sample Collection Point, which is related to the above Facility.
Sample Collection Point
Ifi

Name

                                        DOur system has no separate sample point IDs
                                    INSERT NEW SAMPLING POINT

                                    INSERT COMPOSITE SAMPLING POINT
                                    (for samples comprised of water collected from multiple source:
          After you have completed this information please remember to enter a sample schedule
                          the activities of this facility.
C.5  Select "Reset" to clear the information shown in Figure 2 and Figure 3, "Cancel" to stop entering a new facility
     and return to the screen shown in Figure 1,  or "Save" to store your changes.
C.6  Once the information has been saved, you will be able to see the facility listed in the table as shown in Figure 1.
     If you need to delete the sampling point, email the PWSID, water system name, state, facility name, and
     sampling point to be deleted to the Stage 2  Inbox at Stage2mdbp@epa.gov.
DOTS for PWSs: LT2
10
February 2008

-------
        How to Enter Sample Schedules
You will only be able to enter a sample schedule before your system's regulatory deadline. If you miss the regulatory
deadline, EPA will have to enter the sample schedule for you. If you miss the regulatory deadline send an e-mail to
stage2mdbp(5)epa.gov with your proposed sample schedule, PWSID, water system name, and state.
D.1  To enter sample schedules for your water system, select the "Sample Dates" icon  *\j'  in the LT2 Data
     Collection system, which is located on the left side of the screen.                m^Lj
D.2  Select the frequency with which you want to enter sample dates (e.g., individual, weekly,  monthly, etc.) for each
     facility (see Figure 1).
                                                  Figure 1
           Select the facility you would like to viewj'enter sampling dates for in the drop-down menu below. Next, select one of the methods below
           enter/edit dates for when the>samples will be collected- Once the sample dates are saved, and appear in the sampling dates list box, t
           are available for EPA review.
            Facility
            Method
                       In 'iddual Date Entry - one date at a time  .
                       *i pUy Date Entry - recurrence pattern for a specific weekday
                       Mrnttily Date Entry - recurrence pattern for specific day of a month
                       I ifi', Dates - copy existing sampling schedule to another facility
D.3  Select the "Save" button to store your changes.
D.4  If you are unable to find a certain facility listed on this page, make sure the facility is listed under the
     facility/sampling module and that all required fields for the facility have been completed. To enter the facility into
     DCTS, see Section C - How to Add a Facility and Sampling Points to a Public Water System.
D.5  To edit or remove individual dates, select the sample on the menu to the right of the screen and select "Edit
     Sampling Date" (see Figure 2). Remember to select "Save Sampling Date"  if you make changes to the
     sampling schedule.
D.6  Select "View/Print Sampling Dates" to view or print all of the sampling dates for your water system.
DCTS for PWSs: LT2
11
February 2008

-------
                                                                     Figure  2
                 Individual Date Entry

                                   Month
                                                   Day
                                                           Year
                        Click the Save Sampling Date button after making your selection to display the dates

                              Please note that the system does not check for holidays crime eke nds
                          You must manually verify the sampling dates and make the appropriate changes.
                            f    S.iv- Sitmpliu!) D.ile V^r      Edij S.iin|>Siri;j [i.rt«

                             Peiti'tv* Sampling Date £3       Reninve All p.ttg$
                             S
-------
          How  to Enter Other LT2ESWTR Data
E.1   To enter other LT2ESWTR data for your water system, select the "Submit GF and Sample Location" icon
      in the LT2 Data Collection system, which is located on the left side of the screen.
E.2  Select a facility (see Figure 1).
                                                             Figure 1
             GF Data & Sampling Plan
             Piease select a Facility and click VIEW.
                           Facility

E.3  Enter data (i.e., grandfathering information, source water monitoring information, intent to treat, uncovered
      finished water reservoirs) and select options as prompted by DCTS (see Figure 2). Note: if you have multiple
      facilities, you will  have to enter data separately for each facility.
                                                               Figure 2
            1.     PWS intends to submit grandfathered data

               a.  Notice of Intent to (rrandfather submitted   Q

                  VI**••'.' intent to j^^rMifathef Form

                  Date EPA received Intent to Grandfather Form
               b
                  (mm/dd.'Vyyy)

               c.  Number of grandfathered samples to be submitted

                  Date range grandfathered samples to be
                  su b m itte d(m m/d dtyyyy)

               e.  PWS intends to submit additional samples

               t.  Number of additional samples to be submitted



               g.  Upload grandfathered data
            This field cannot be edited by a PWS.
                End:
Start:

 D
                                                        This function is locked until an "Intent to Grandfather" form is received. Once EPA receives the
                                                        form, you may upload your data.
               "Note: All grandfathered data must be submitted to EPA (via email or mail) either in MS Excel spreadsheet (.xls) or text file f.txt) format. Do not submit
               files in the .xml file format that is used in the lab sample upload module.
               Sending hardcopy grandfather data by mail

            2.  EPA receipt of sample location plan


               3.  Upload sample location plan
 D
Not Received
                    Browse..
                                                        Please ensure the PWS ID and facility name are in the files you upload.

               b.  Sending sample location plan/schematic by mail    [~~j

            3.  EPA review of sample schedule                  Not Received

            ,   PWS intends to waive monitoring and proceed to BIN  i—j
               4 classification                              '—'
                  Date EPA received Intent to Waive Monitoring
                  (mm/dd/yvyy)

            5.  PWS has uncovered finished reservoirs

               a   Uncovered finished reservoirs
            This field cannot be edited by a PWS
No
                                                         Add a Reservoir.
DOTS for PWSs: LT2
          13
February 2008

-------
E.4  Select the "Save" button at the bottom of each screen (see Figure 3) to store your changes.
                                                                Figure 3
                  Note: Stage 1 Data (i.e. TTHM and HAAS data) will not be dynamically loaded into this system. This data will be uploaded in a
                  format that is outlined in guidance and on the attachment page of the IDSE Tool. Stage 1 compliance monitoring data should
                  continue to be transferred to the Agency through SDWIS or another State database or through the normal mechanism that
                  States employ.

                  If sending  a hard copy by  mail, please send it in the appropriate format (per note below) to IPMC at P.O. Box 98, Dayton, OH,
                  45401  or email the information to your state representative. The following items must be submitted as either a MS Word (.doc)
                  or PDF file:

                  » Sample location plan/schematic
                  * A Notice of Intent to Provide Maximum Treatment (submit you intend to waive monitoring and proceed to BIN 4 classification)
                  « A plan of action for uncovered finished reservoirs (must be submitted to EPA within three years of rule promulgation)
DC7Sfo/-PWSs;L72
14
February 2008

-------
        How to Identify Contracted Labs (Administrative Users Only)
F.1  Each water system has an administrative user. The administrative user is responsible for granting access to
     other DCTS users for that PWS. These are called standard users. Administrative and standard users will have
     the same access to all tools in the DCTS except for the "Update Contract Lab" and the "Update User" tool. The
     administrative user of each water system must be registered before other users can access the DCTS. If you
     are not the administrator and need to be, email your system's PWSID, water system  name, state, and CDX
     user name to stage2mdbp@epa.gov.
F.2  You must identify contracted labs through DCTS. If a lab has not been identified by the water system, the lab
     will not be able to enter your data in DCTS.
F.3  To identify contracted labs for your water system, select the "Update Contract Labs" icon
     Data Collection system, which is located on the left side of the screen.
                                                                 \ in the LT2
F.4  Select "Cryptosporidium" or "E. co//"and a state (see Figure 1).
F.5  To select a lab or labs, check the box(es) to the left of the lab name(s) and select "Submit Selected Labs."
                                                   Figure 1
          There are no labs associated with your organization.
          Please select the contracting labs for your PWS. Select the type of lab you are looking for (either C/yptosporidiuiri or E. coll) and then
          select the state where the lab is located. You can use the navigation buttons to jump to a different section, or click a letter to bring yoi.
          the first listing associated with that letter

          *ln order for your lab to enter your data for LT2, they must be registered in the system. If the lab does not appear in this list, please asl
          them to contact the LT2 Help Desk to be enrolled in the system.
                      Wiurt type of !      - to
American Water - IL00028
                               Analytical Services - VTD0003
F.6  Once you select a lab, it will be moved to the top of the page and it will no longer be on the list.
DCTS for PWSs: LT2
                         15
February 2008

-------
DCTS for PWSs: LT2                                 16                                      February 2008

-------
 G.
How to Approve Standard Users (Administrative Users Only)
G.1  Each water system has an administrative user. The administrative user is responsible for granting access to
     other DCTS users for that PWS. These are called standard users. Administrative and standard users will have
     the same access to all tools in the DCTS except for the "Update Contract Lab" and the "Update User" tool. The
     administrative user of each water system must be registered before other users can access the DCTS. If you
     are not the administrator and  need to be, email your system's PWSID, water system name, state, and CDX
     user name to stage2mdbp@epa.gov.
G.2  To approve users for your water system, or to update the status of existing users for your water system, select
     the "Update Users" icon tOa  in the LT2 Data Tracking System.
G.3  Use the pull down menu in the "LT2 Status" column to accept the new user or to change the status of an
     existing user. The status of all new users is "Pending" until approved by the administrative user (see Figure 1).
     Select "Submit Changes" to save your changes.
                                                Figure 1
              PWS -ZZTestlc -DC1c

              You are listed Aiiiiiiiti-;tr,U«»i for this organization,
                                               Your user role is
              The following people have requested permission to access LT2 for your organization. Please select the appropriate role (where
              necessary) and designate a second administrative user. Click "Delete" if you wish to remove the user
Fit it ll.iiiie
Sarah
gondetCG
Harry
L'»S v
Pendinq v ^,^m ,
"feat ,«.
Adtiiiiibtratoi

&
f ;

Delete

Delete
Delete
DCTS for PWSs: LT2
                                            17
February 2008

-------
DOTS for PWSs: LT2                                 18                                      February 2008

-------
H.
How to Search for LT2 Samples
H.1  For every sample submitted by the laboratory, you must either:

       a.  Approve the sample
       b.  Contest the sample, OR
       c.  Return the sample to the lab
H.2  To search for samples in your water system, select the "View Samples" icon '^-4   in the LT2 Data Collection
     system, located on the left side of the screen.                               ^
H.3  Select "Cryptosporidium" or "E. coir and set search parameters (see Figure 1). Select "Search Samples" to
     view a list of samples for your system. DCTS  defaults to the checked "Lab Approval Date" selection, you need
     to uncheck this if you do not what to search on "Lab Approval Date."
^H








HJJ^HIH
Pie
.-,..,-,- - C
DPWS Inventory Data
D Status
El Lab Approval Date
ED Sample Collection Date


Figure 1
mse enter as much data as possible to H roft the search* to a targeted sol of results.
Large data retrievals can produoe protrie ms v-ith the tfispiay of the rastjts.
'YptOSpOriCffUm ," 5. CO// v Select Method
Facility. v Sampling Point: v
v
Start 10/1 3/2006 End 11/13/2006
Start : End ; :
SEAR'" H RAM pi Ffi ^L .










H.4  In order to see the samples, the lab needs to release the results to the PWS. If the lab has entered the data and
     you cannot see it, ask the lab if they have released it.
DCTS for PWSs: LT2
                                          19
February 2008

-------
DCTS for PWSs: L72                                 20                                     February 2008

-------
     How to Approve, Contest, or Return a Sample to the Lab
1.1   To approve, contest, or return a sample, search for the sample in the LT2 Data Collection System (see Section
     H, "How to Search for LT2 Samples").
1.2   Select the sample(s) you wish to review from the list of samples and select "Review Selected Samples" (see
     Figure 1).
Figure 1
REViE

•'u SELECTED SAMPLES DOWN: OAD SELECTED SAMPLES PRINT SEARCH RESULTS
yft
I

Sample Colteaton P*t
	 	 	 	
Samitte Coflcellttii-'Piite
'MfrHtJiMvatOaie

Pending Approval
" 0
D
D
h
h
h
VA1 234567
VA1 234567
VA1 234567
111
Nada T2
billietest2
"1
SP
2432
11/03/2006
11/02/2006
11/02/2006
11/08/2006
11/02/2006
11/02/2006
Returned to Lab
There are no samples currently associated with this status
Approved
D
h
VA1 234567
billietest!
1
::::: 10/19/2006 .\\ 1 10/19/2006
| Contested
There are no samples currently associated with this status
1.3   Use the pull down "Status" menu to change the status of a selected sample (see Figure 2).
                                                    Figure 2
                  C/ypfospondium - ZZTest la - DCla
                 T; submit Pending samples as appio.ed or contested or return "Fendm.1 samples to the lafc for correction change the sta
                 dfcp-do n menu Click the  5a,e Chanqes  link to complete the action I I  r in'  i'1 -i ' M (enarding each sample can be feu
                 scii'ihnq do n  Click the field name toi more information
                              Status
                                                                            Pending Approval
                              SYSTEM GENERATED CRYPTOSPORIDMMCALCULATIONS
                                   g ID (optional)
                              Sample collection point ID
                              Sanipje
                              Sample coliection date
                              Sample type jFiejd of HSS
                                                                         Nad Returned rc ^ab
                                                                         liadaTest 2
Sample Point
                                                                         1V02-'20GS
                                                                         Field
                                                        21
                           February 2008

-------
1.4  Select "Approved" to submit the sample to EPA, "Return to Lab" if the lab needs to edit the entry, or "Contested"
    if not in agreement with the lab. If you need to enter a comment, scroll down the page and click on "Add" (see
    Figure 3).
Figure 3
mtmmstiJlJ^-


B.SflJHB.te.
(3rk}!Iia' sample collection date
Lab resampfe explanation
PWS comments for lab
PWS comments for £P&/State
PWS flao explanation for EPA/State
EPA Ha

SUPPL
LABOR
FIELDS
Saropii
SaHioii

No


Add
Ada
rtj J ' 'If


& https://intranet. epa.gov/lfc2/textEditor .jsp?comrna v
Sav Cancel
https: //intranet. epa.gov/ |jl Internet - ;,; SSL



icheduied date
: me:
terthan 500
victim -•- iQ°0 of
elcl sample
n submitted


STEREO BY THE




10



1.5  Select "Save" at the bottom of the sample screen to save sample status. The next screen will be a confirmation
    of the change in sample status (see Figure 4). Select "View Samples" to search for new samples.
Figure 4

^H CfVDtosDorKJfum - ZZTest 1a - DC1a ^H

The following C'ypfospC''iC;w. samplss
Submitted To Sample ID Pl%
EPA and State ZZTest


were successfully submitted on 12>14 2007
S PKS Facility Sample Collection Poini
1a Nada Test 2 Sample Point

Sample Collection Date
11 .'02/2006

Status
Approved
/




DOTS for PWSs: LT2
22
February 2008

-------
DCTS for Public Water Systems
             Stage 2
?/EPA
  United States
  Environmental Protection
  Agency

-------

-------
                  DCTS for Public Water Systems: Stage 2

                                        Contents

   A. Step-by-Step Registration for DCTS for New CDX Users	1
   B. Step-by-Step Registration for DCTS for Current CDX Users	5
   C. How to Submit a 40/30 Certification Plan using the IDSE Tool	9
   D. How to Submit a Standard Monitoring Plan using the IDSE Tool	15
   E. How to Submit a System Specific Study (SSS) - Existing Monitoring Results using the IDSE Tool	19
   F. How to Submit a System Specific Study (SSS) - Hydraulic Modeling using the IDSE Tool	25
DCTS for PWSs: Stage 2                                                             February 2008

-------
DOTS for PWSs: Stage 2                                                                       February 2008

-------
        Steo-bv-Steo Registration for DOTS for New CDX Users
        (Steps A.1 - A. 17 need to be completed for registration. Once the password is setup, go to A. 19.)
A.1 Goto: http://www.epa.gov/cdx
A.2 Click on "Log-in to CDX" (on sidebar) - New screen will appear
A.3 Click on "Registration" (on sidebar) - New screen will appear
A.4 Read the Warning Notice and Privacy Statements
A.5 Click on "Click here to continue" - New screen will appear
A.6 Read the Terms and Conditions and click on "I Accept" - New screen will appear
A.7 Input a user's first and last name, user name (following recommended format), password (following recommended format)
and re-enter the password, a question that can be used in case you forget your password, and the answer to the question - New
screen will appear
A.8 Input the water system's name in the Organization Name field and all other requested information. Click on "Next" - New
screen will appear
CDX Registration: Add Program
A.9 Select "LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2)" (see Figure 1).
                                                Figure 1
                                          CDX Registration: Add Program
                                               Facility Registry System - Update Service (FRS-US):
                                                          Lead-Based Paint Activities (LEAD):
                                             LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2):
                                                         Ozone Depleting Substances (ODS):
                                                             Radionuclide NESHAPs (RAD):
                                           Resource Conservation and Recovery Act Site ID (RCRA):
                                                   Stormwater Notice of Intent (eNOI) (SWENOI):
                     Toxic Release Inventory Made Easy Web (Approved Pilot Submitters ONLY) (TRIMEweb):
                                           Toxic Substance Control Act - HaSD Form (TSCA-HASD):
                                                    Compliance Information Systems (VERIFY):
                                 Request Manufacturer Code for OTAQ Compliance (VERIFY MFR REG):
                                                    Water Contaminant Information Tool (WCIT):
A.10 Click on "Next" - New screen will appear
Complete Role Information -
A.11 Role is "Asubmitter" only option
A.12 Select "Standard" (This is CDX. This is not where you request DCTS Admin access.)
A.13 Input your water system's federal PWSID (i.e., WA5312345) in the ID field. If you don't know your PWSID please send an
e-mail to stage2mdbp@epa.gov.
A. 14 Submission method is "WEBFORM" (only option)
A. 15 Click on "Next"
A. 16 Read the  message
A. 17 Click on "Finished"
A.18 You should receive confirmation from "CDX Registration" [EPACDX@csc.com] within 24 hours of submitting your request.
Once you have received the e-mail confirming your CDX set-up, you can log into the DCTS.
Logging into the Data Collection and Tracking System (DOTS)
A. 19 Follow steps A. 1. and A.2.
A.20 Input your user name and password - This is the user name you choose for yourself when setting up your CDX account
(see Step A.7). Click "Login" - New screen will appear
A.21 Click "LT2: LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry" program (see
Figure 2) - New window will appear
DCTS for PWSs: Stage 2
February 2008

-------
Figure 2




Central Data Exchange- MyCDX
Welcome, Last Login:
Mr. John Smith Registered Since:
Recertification Date:
CDX Registration Status: Active
July 21, 2006
July 21, 2006
July 21, 2006
You have 0 new messages in your Inbox
Change System Edit Personal Edit Current
Password Information Account Profiles
AddNew
Employer Profile
Available Account Profiles:
• LT2: LT2 Data Collection. LT2/Slage 2 Tracking system, and IDSE Plan/Report Entry

SEE STEP
A.21.



  A.22 To submit your IDSE Plan electronically for compliance with the Stage 2 DBPR click on IDSE Plan/Report Entry (see
  Figure 3). This is the final registration step for DCTS users that need to comply with the Stage 2 DBPR requirements for
  only one water system.

  If you need access to multiple systems to complete multiple IDSE plans/reports or if you need  to comply with the LT2
  requirements, you must request access to the LT2 Data Collection System. To obtain access to the LT2 Data Collection
  System  you must contact your system's DCTS administrator.  If you do not know your system's DCTS administrator, e-mail
  your system's PWSID, water system name, state, and CDX user name to stage2mdbp@epa.gov.

  A.23 Once  access is granted to the LT2 Data Collection System click on the LT2 Data Collection System link that will
  appear above the IDSE Plan/Report Entry link (see Figure 3)
                                                     Figure 3
                     Systems
                      The system recognizes you as an approved user for the following applications, please select a system to launch...

                      LT2 Data Collection System
                      Launches the LT2 Data Collection System for the submission and review of samples

                      IDSE Plan/Report Entry
                      Launches iDSE Plan/Report Entry, which will lead you through filling out and submitting your IDSE Plan or Report
  A.24 Click on the "User Profile" icon
DCTS for PWSs: Stage 2
February 2008

-------
   A.25 Update information for First Name, Last Name, State, Phone Number, or E-mail Address if any are incorrect (see
   Figure 4)
                                                            Figure 4
                        User Profile
                        1 = Required Field


                        The following information is provided by CDX If you feel any of the information is incorrect, please access CDX to update/verify.
UserName •
*Fi?$i Name
*Lsst Name
* State
'"Pbon& Nuniiie?
"Emu'il Address
SmithJohn
John
Smith
UN
i 123) 456-7890
inhnsmith@somewhefe.com
                                                         Save and Continue   Exit Registration
  A.26 Click on "Save and Continue"
  A.27 Input your water system's federal PWSID (i.e., WA5312345) in the Organization Code field (see Figure 5)
  A.28 Click on "Lookup Organization" (see Figure 5)
                                                             Figure 5
                      Please enter your Organization ID and click "Lookup Organization." The "Lookup Organization" link will be replaced with a "Request
                      Access" link and an "Undo" link, If your correct organization is displayed, click "Request Access.." If you have incorrectly entered the
                      organization ID, click "Undo" and repeat the process. If you are an E. colt laboratory and your iab is missing from the list of organizations,
                      please click "E. coli Lab Registration."

                       you are an existing user and would like access to the IDSE Plan/Report entry. Enter the code for the desired PWS and select LT2 from
                      the system list. Otherwise, you should enter the PWSs organization code in the Program ID field when registering via CDX.
                                 E col Ldb Rt
                                                     Edit User information    Save anr! Contmuf   ^xtt Reqi'-tra*- o1'
  A.29 A new field "System Type" will appear; select "Both" (even if you only need access to one of the rules)
  A.30 Click on "Request Access"
  A.31 Click on "Save and  Continue"
  A.32 If you need to request access to additional systems, repeat steps A.27 through A.31.  Once you are finished, click on
  "Exit Registration."

  Once your user name has been authenticated by the DCTS administrator for your system,  you will be granted access to
  the data system for these additional system(s).
DOTS for PWSs: Stage 2
February 2008

-------
DCTS for PWSs: Stage 2                                            4                                                      February 2008

-------
        Steo-bv-Steo Registration for DCTS for Current CDX Users
        (Steps B.1 - B.6 need to be completed for registration. Once the password is setup, go to B.7.)
B.1. Log-in to the system using your CDX user name and password.
B.2. On the "MyCDX Screen" select "Edit Current Account Profiles" link.
B.3. Select "Add New Program."
B.4. Select "LT2ESWTR: LT2ESWTR, Stage 2 DBPR, and IDSE Plan/Report Entry" from the list of CDX applications (see
Figure 1).
                                                    Figure 1
                                                CDX Registration: Add Program
                                                       Lead-Based Paint Activities (LEAD)
                                                          Radionuclide NESHAPs (RAD)
                                            Resource Conservation and Recovery Act Site ID (RCRA): (
                                                  Stormwater Notice of Intent (eNOI) (SWENOI): '.. '
                                            Tosic Substance Control Act- HaSD Form (TSCA-HASD) •: .
                                                   Compliance Information Systems (VERIFY): >:.
                                     Request Manufacturer Code for OTAQ Compliance O-'ERIFY MFR REG) <"••
                                                   Water Contaminant Information Tool lyv'CIT) (


                                                                       i Next»
B.5. Choose your role from the drop down menu (see Figure 2).
                                                    Figure 2
                                            CDX Registration: Add Program IP
                       Use the TAB key to move from field to field. *  Rf.QUIRED fin.r»
                                                   Role: A SUBMITTER
                                Program ID Type:  Standard     ID:
                                       Submission Method: WEBFORM
                                                     FINISHED
B.6. Approved users will receive an e-mail confirming access to DCTS. Rejected users will receive an e-mail stating the reason
why access was denied. Only PWSs will be approved.
Logging into the Data Collection and Tracking System (DOTS}
B.7 Follow steps B.1 and B.2.
B.8 Input your user name and password - Click "Login" - New screen will appear
B.9 Click "LT2: LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry" program (see
Figure 3) - New window will appear
DCTS for PWSs: Stage 2
February 2008

-------
                                                  Figure 3
Centra
Welcome,
Mr. John Smith
CDX Registration Status: Active
Data Exchange- MyCDX
Last Login:
Registered Since:
Recertification Date:


July 21 , 2006
July 21 . 2006
July 21 , 2006
You have 0 new messages in your Inbox
Change System Edit Person
Password Informatior
al Edit Current
Account Profiles
Available Account Profiles:
• LT2: LT2 Data Collection. LT2/Stage 2 Tracking system, and IDSE Pian/Rep
Add New
Employer Profile
art Entry

SEE STEP
B.9.
  B.10 To submit your IDSE Plan electronically for compliance with the Stage 2 DBPR click on IDSE Plan/Report Entry (see
  Figure 4). This is the final registration step for DCTS users that need to comply with the Stage 2 DBPR requirements for
  only one water system.

  If you need access to multiple systems to complete multiple IDSE plans/reports or if you need to comply with the LT2
  requirements, you must request access to the LT2 Data Collection System. To obtain access to the LT2 Data Collection
  System you must contact your system's DCTS administrator. If you do not know your system's DCTS administrator, e-mail
  your system's PWSID, water system name, state, and CDX user name to stage2mdbp@epa.gov.
Figure 4
fa —
SEE STEP
B.11.
«s
SEE STEP
B.10.
"•"^
i f r
! ! •" { r )VV Of
i f i I f
Systems |
The system recognizes you as an approved user for the following applications, please select a system to launch...
LT2 Data Collection System
Launches the LT2 Data Collection System for the submission and review of samples
IDSE Plan/Report Entry
Launches IDSE Plan/Report Entry
r
which wiM !ead you through filling out and submitting your !DSE Plan or Report


  B.11 Once access is granted to the LT2 Data Collection System click on the LT2 Data Collection System link that will
  appear above the IDSE Plan/Report Entry link (see Figure 4)
  B.12 Click on the "User Profile" icon
  B.13 Update information for First Name, Last Name, State, Phone Number, or E-mail Address if any are incorrect (see
  Figure 5)
DCTS for PWSs: Stage 2
February 2008

-------
Figure 5

User Profile [
" = Required
The following
SEE
STEP
B.13.

-ie
infc
L
d
rmation is provided by CDX. If you feel any of the information is incorrect, please access CDX to update/verify.
Userfjame
"first terns-
~Li*s1 Ate/m-s
"Sfcw-
*Phon& Nanib&f
"£ma;/ Address
SmiihJohn
John
Smith
UN
"2Jl4«-7a""
,o— h^o,™^,,,,™
Ssve and Continue Exit Registration

   B.14 Click on "Save and Continue"
   B.15 Input your water system's federal  PWSID (i.e., WA5312345) in the Organization Code field (see Figure 6)
   B.16 Click on "Lookup Organization" (see Figure 6)
   B.17 A new field "System Type" will appear; select "Both" (even if you only need access to one of the rules)
                                                               Figure 6
                          Please enter your Organization ID and click "Lookup Organization." The "Lookup Organization" link will be replaced with a "Request
                          Access" link and an "Undo" link. If your correct organization is displayed, click "Request Access." If you have incorrectly entered the
                          organization ID. click "Undo" and repeat the process. If you are an E. coli laboratory and your lab is missing from the list of organizations,
                          please click "E. coli Lab Registration."

                          If you are an existing user and would like access to the IDSE Plan/Report entry. Enter the code for the desired PWS and select LT2 from
                          the system list. Otherwise, you should enter the PWSs organization code in the Program ID field when registering via CDX.
                            Of gamuts on Coda
                                                                                Lookup Organization
                                     E. coli Lab Registration    Edit User Information    Save and Continue   Exif Registration
   B.18 Click on "Request Access"
   B.19 Click on "Save and Continue"
   B.20 If you need to request access to additional systems, repeat steps B.15 through B.19. Once you are finished, click on
   "Exit Registration."

   Once your user name has been authenticated by the DCTS administrator for your system, you will be granted access to
   the data system for these additional system(s).
DCTS for PWSs: Stage 2
February 2008

-------
DCTSforPWSs:Sfage2                                          8                                                   February 2008

-------
 c.
How  to Submit a 40/30 Certification Plan using the  IDSE Tool
C.1   Log-in to CDX and click "LT2: LT2  Data Collection, LT2/Stage 2 Tracking System, and IDSE Plan/Report
       Entry." Click on "IDSE Plan/Report Entry" (see Figure 1).
                                                                  Figure 1
                         Systems
                         The system recognizes you as an approved user for the following applications, please select a system to launch..
                         IDSE Plan/Report Entry
                         Launches IDSE Plan/Report Entry, which will lead you through filling out and submitting your IDSE Plan or Report
C.2   You will arrive at the "IDSE Plan/Report Entry" page (See Figure 2).
                                                                  Figure 2
                                     Plan / Report fintty Home
                                      Welcome to the Plan/Report Entry Home page!

                                      Select the Plan or Report type von would itke to work on and click Go to Entry to begin
                                      If vou are not sure which Plan/Report applies to you aa.e?.^ a WjZ.afd that will assist you in determining your specif c requirements Thfe IOSE
                                      Aizard is a web-based smart survey too! requiring the Macromedia Authorware plug-m to assist PWSs in determining thetr IOSE requirements
                                      Download the free Macromedia's A^tnorware plug-in from macromedia com.

                                      Trte on-line entry portion tor the IDSE Reports wilt be available in the Fail of 2006. If you w; sh to work on vour Existing Monitoring Results IDSE
                                      Report or your IDSF Report for Modeling 3SS prior to when ii is available select the appropriate radio button and click "Go to Report
                                      Entry" (may take some time to ioadj The system wilt open a PDF form template m a new window The PDF templates were designed for the
                                      IDSE Too! - CD Version and  make several references to additional forms available via CD tf you requite the additional forms referenced to
                                      meet your required number of monitoring srtes. access :ne iOSFJ^ow.^ase to download the forms von need Alternatively, you can contact
                                      EPA at stage2mdbp@epa.gov to request these forms
                                      Note You wt!i need to install t
                                      Pruessmnal 7 0
                                      General Irtformatio
                                      PWS ID
                                      PWS Name
                                                                  i..O to access these forms Also you will not be able to save this form unless you have Adobe
                                        sctPisici Type

                                        40/3CS e«rtinc.:ation

                                        Standard (Wontton rig P!,*n

                                        System SpeLific. Stticiy Modeling

                                        System Specific: Study FxisliTifj Moiinunny Rt-
DC7S for PWSs: Stage 2
                                                                                                                     February 2008

-------
C.3  Select "40/30 Certification" from the IDSE Plan/Report Entry page and then click "Go to Plan Entry" (See Figure
     3).
                                                   Figure 3
                                 LJ 40/30 Certification
                                ^'^,^^«^8«SaBK^^
                                 '•-,.,•• StanaafoMonilormg Plan

                                 (J System Specific Study- Modeling

                                 w System Specific Study- Existing Monitoring Results


                                                      Goto Pkin Ei if I y
C.4  DCTS will pre-populate a new form with the available water system's information (see Figure 4). Review the
     information provided in the form. If any of the information displayed is incorrect and you are unable to change it,
     contact EPA at stage2mdbp@epa.gov.

C.5  By clicking on the "Certification Info," "Attachments," or "Preview/Submit" links on the top right you can move to
     different sections.

C.6  Select the "Save" button at the bottom of the page when you are done entering your information. Then click
     "Next" to move to the next section.
                                                  Figure 4
             4QI3Q Certification Entry
            I A. Siihinittee Information*
             Please review the information provided below, if you feel any of the information displayed is incorrect
            1 and you are unable to change it please contact your State or EPA representative.
                                            Certification Info
                                            Attachments
                                            Pi«view Submit
             PWS ID
             PWS Name
             PWS Address
             City

             State
DC1a
ZZTest 1 a
^address


:city

IDC v
C.7  EPA or your state may require you to submit additional information (e.g., Stage 1 DBPR compliance monitoring
     results, a distribution system schematic, or recommended Stage 2 DBPR compliance monitoring locations).
     Page 8 of this section shows the additional information required by each state.

C.8  Select the "Next" button at the bottom of the page (see Figure 5).
DCrs for PWSs: Stage 2
                   10
February 2008

-------
                                                      Figure 5
             4QJ3Q Certification Entry
             Attachments
             EPA or your state may require you to submit additional information listed below.
                 •  Stage 1 compliance monitoring results
                 •  A distribution system schematic:
                 *  Recommended Stage 2 compliance monitoring locations

             If the reviewer wants to request additional information or to have you conduct an IDSE, they will
             contact you. If you are contacted or would like to submit information for the areas listed above please
             use one of the following addresses:
             Mailing Address:                      E-mail Address:
                                     i < iM,>
                                     Attar •
                                                                                                i 'ml'
                                            pjtr
                                            Submit
              US EPA-IPMC
              PO Box 98
              Dayton, OH 45401-0098
stage2mdbp@epa.gov
                                            Iff"" I.  J  CANCEL.
C.9  In the "Preview/Submit" page you will have the chance to review the document before submitting. If you need to
      edit information use the links on the top right to move back to previous sections.
C.10 Select the form of signature you want to use to submit your 40/30 Certification (see Figure 6). You may either
      electronically sign your form to complete your official submission, or you may print the certification and sign by
      hand and then fax or mail in the signed copy. If you choose the second option your submission will not be
      marked complete until the hard copy signature is received by EPA.
C.11 Once the 40/30 Certification is completed, select "Generate PDF" and save the file for your records (see Figure
      6). You  must generate this file before the form is submitted.
C.12 Select "Submit" to submit the  completed 40/30 Certification to EPA. Please note that once you have submitted
      your 40/30 Certification to EPA you will not be able to make any changes. If you need to make a change to your
      40/30 Certification after it has been submitted  contact EPA at stage2mdbp@epa.gov.
                                                      Figure 6
                 Electronic Signature:
                 By selecting one of the two options below you are officially submitting your 40^30 Certification  Your
                 name and today's date will be recorded to the database but will not be displayed on the screen. If you
                 select Do not Sign Form your form will be submitted as Received-Incomplete and you will need to fax or
                 mail in a signed copy of your form.
                         Sign Foim: I hereby agree to electronically sign this form  I understand that by agreeing to
                         electronically sign this form I will be officially submitting this letter with my signature included.
                         Do not Sign Form: I do not wish to electronically sign my form. I understand that submitting
                         this form here will not fulfill my requirements and that I will have to fax or mail in a signed
                         copy of my certification letter.
                                               HBMIT GENERATE PDF
DOTS for PWSs: Stage 2
         11
February 2008

-------
C.13 Once you submit the plan, a new screen will appear with a confirmation number. Please print this page for your
      records (see Figure 7).
                                                       Figure 7
            IDSE Submission
            Confirmation Page
            Your Plan/Report was submitted successfully! Please print this page for your reference.
             Confirmation #

             Date Submitted:
                                                08/11/2006
            If you have selected sending by hardcopy in the Attachments section or wish to submit a hard copy version of your plan, report, or
            attachments in addition to electronically submitted files please mail or e-mail the files to one of the following addresses:
                                                       M.iilimj Address:

                                                        US EPA-IPMC
                                                          PO Box 98
                                                     Dayton, OH 45401-0098

                                                       E-mail Address:

                                                    stage2mdbp@epa.gov
                                                           Home
The next page provides state preferences on the additional information they are requesting from systems that submit
a 40/30 Certification.
DCTS for PWSs: Stage 2
12
February 2008

-------
                      State Preference Table for Stage 2 DBPR 40/30 Certification Supplemental Information
                                                                   (As of January 2007)

              Under the :5tgqe 2 DBPR, EPA or the ?tate may request additional information to be submitted by svsrerns to support a request for 40/30 Certification Such
              additional information can be Stage 1 Data, Recommended Stage 2 monitoring locations, ami system schematics The table below identifies which States are
              requesting additional material be sent with the request tor 40i'3u Certification  The checkmark indicates material that needs to be submitted.
Region
1
z
•3
4
5
6
7
8
9
10
State
CT
ME
MM
MA
Rl
VT
NJ
NY
PR-
DC •
DE
MD
PA
A'V
VA
AL
PL
GA
KY
MS
NC
SC
TN
lu
IN
Ml
MN
OH
Wl
AR
LA.
NM
OK
T;<
I A
KS
MO
NE
CO
MT
ND
SD
LIT
WY
Tribal
AZ
CA
HI
NV
GU
AS
Trust Ter
CNMI
AK
ID
OR
WA
Stage 1 Data



-»'
V

••I
•g
•J
v'


•-,'


,'
'1
•1
•1
'i
V

','
V
•,'
••1

V
I/



V




si







V







••j
V
••/
•/
Recommended
Stage 2 DBPR
Monitoring
Locations

\'

^
V
v


V

-------
DC7S for PWSs: Stage 2                              14                                     February 2008

-------
 D
How to Submit a Standard Monitoring Plan using  the IDSE  Tool
D.1   Log-in to CDX and click "LT2:  LT2 Data Collection, LT2/Stage 2 Tracking System, and IDSE Plan/Report
       Entry." Click on "IDSE Plan/Report Entry" (see  Figure 1).
                                                                   Figure 1
                         Systems.
                         The system recognizes you as an approved user for the following applications, please select a system to launch...
                         IDSE Plan/Report Entry
                         Launches IDSE Plan/Report Entry, which wiH lead you through filling out and submitting your SDSE Plan or Report
D.2   You will arrive at the "IDSE Plan/Report Entry"  page (See Figure 2).
                                                                  Figure 2
                                     Plan / Report Entry Home
                                    | Welcome to the Plan/Report Entry Home page!

                                     Select the Plan or Report type you woufd like to wont on and click Go to Entry to begin
                                     If you are not sure whtch Plan/Report applies to you accHSSAMiaid that will assist you in determining your specific requirements The iDSE
                                     Wizard is a web-based smart survey too! requiring the Macromedia Authorware plug-in to assist PVVSs m determining their iDSE requirements
                                     Download the free Macromedia's Ayincrwase plug-in from macromedia.com

                                     Ttie on-line entry portion for the !DSE Reports will be avaiiabie in tne Fal! cf 2006 If vou wish to work on your Existing Monitoring Results iDSE
                                     Report or your IDSF Reporf for Modeling SSS prior to when il is available select the appropriate radio button and click "Go to Report
                                     Entry" tmaytake some time to toad} The system w<\ open a PDF form template in a new window. The PDF templates were designed for the
                                     IDSE Tool - CD Version and make several references to additional forms available wa CD. if you require the addttionai forms referenced to
                                     meet your required number of monitoring siies access the ID.S.E.Hproe.rJscif? to download the forms you neecl ASternativety, you can contact
                                     EPA sti stage2mdbp@epa.gov to request these forms

                                     Mote You will need to install Adobe- Reade* 7.0 to access these forms. Also, you will not be able to save this form unless you have Adobe
                                     Professions! 7 0
                                     General Information
                                     PWS ID
                                     PVVS Name


                                     Schedule
                                     PIsuDue Date
                                     Report L/nr- fiats
                                                                   DC 1c.
                                                                   ZZlest 1c
                                     Seiect Pfan Type

                                     :'.'  40/30 Certification

                                      "  Standitrd MnnitoniKj Plan

                                     ••'.'• Systt'm Spf.'uhf Study  MocJelmg

                                        Sv*itt?rn Stit?n!(f. SftiOv - Fxisfmfj Monitoring
DC7S for PWSs: Stage 2
                                                            15
February 2008

-------
D.3  Select "Standard Monitoring Plan" from the IDSE Plan/Report Entry page and then click "Go to Plan Entry."
                                                 Figure  1
                               Select Plan Type
                                  Standard Monitoring Plan.
                                 ^^^^^sxammmmmmit^f^'*''**^
                                  System Specific Study - Modeling

                                  System Specific Study - Existing Monitoring Results


                                                Go to Plan Entry
D.4  DCTS will pre-populate a new form with the available water system's information (see Figure 2). Review the
     information provided in the form. If any of the information displayed is-incorrect and you are unable to change it,
     contact EPA at stage2mdbp@epa.gov.

D.5  By clicking on the links such as "General Information," "Peak Historical Mth & Schedule," or "Preview/Submit"
     on the top right you can move to the different sections.

D.6  Select the "Save" button at the bottom of the page when you are done entering your information. Then click
     "Next" to move to the next section. Repeat this step as you complete each section.
^^^•^^^^^••iHl^^^MHH^^^^Hi




• Standard Monitoring Plan Entry • • : .. •'• '^'. '•••• :':':;'^*^»•*s^JHteOIl•J
1. IDSE General Information
Please review the information
and you are unable to change
*PWS ID
*EWS Name
*PWS Address
*City
"State
"Population Served
*Svstem Type
*Soutce Water Type
*Buvinn / Selling

j/Genera' Innrmait&B.
•/ -'
provided below, if you feel any of the information displayed is incorrect •" II !P.V[ ....R«Li|MM.4Hi)*Hit* \
it please contact your State or EPA representative. + (|| ->t-i»>j tm'i Sid Mnti i SI*
Is/ Justifii ninn
DC1a ?V Yv\l HM4M. .liMtii «
ZZTestla . stliPUnle
actdress « Ml PI.IMHP I SM«j«- 1 ItBPP
	 S< he
1
:•::::-- 	 	 ^ f VII & VII! Schein.itk A,
cltV Att.KJiineMts /
/
DC v .Pi"viewS«lintit ,/
V j*
20460 ; *^v^. ^x^
110000 ^"•«*— •
NTNCWS
GU
\M/hnlp^alp R\/^tpm v



\
DCTS for PWSs: Stage 2
16
February 2008

-------
D.7  To submit a schematic in Section VII & VIII, select the "Browse" icon to the right of the schematic field and
     select the schematic from your files (acceptable file formats: .xls, .doc, .jpeg, .gif, .jpg, .txt, .wpd, and .pdf) (see
     Figure 3). You must submit a distribution system schematic with the standard monitoring plan. You can also
     upload additional attachments from this page. Please note that once you upload an attachment, you will not be
     able to remove the file, so make sure it is the correct one. If you do not have electronic attachments to submit
     you can send hardcopies of your attachments to the address listed, however the plan will not be marked as
     complete until the attachments are received.
D.8  Select the "Save" button at the bottom of the  page when you are done entering your information. Then click
     "Next" to move to the next section.
                                                  Figure 3
           Standard	Monitoring Plan Entry
           VII 8 VIII Schematic * Attachments
            Select Browse to locate the file you would like to attach to your plan. Click Save to upload your
            attachments. The following file types are acceptable formats for your attachments: .xls, .doc
            .gif. .jpg, .txt, .wpd, and .pdf. All systems must submit a Distribution System Schematic with their
            plan unless they have selected the option to send by hardcopy. P = required field)
                                      iicial ltitt> mil
                                            Browse...
D.9  In the "Preview/Submit" page you will have the chance to review the document before submitting. If you need to
     edit information use the links on the top right to move back to previous sections.
D.10 Once the plan is completed, select "Generate  PDF" and save the file for your records (see Figure 3). You must
     generate this file before the form is submitted.
D.11 Select "Submit" to submit the completed plan to EPA. Please note that once you have submitted your Standard
     Monitoring Plan to EPA you will not be able to make any changes. If you need to make a change to your
     Standard Monitoring Plan after it has been submitted contact EPA at stage2mdbp(a)epa.gov.
                                                  Figure 3
                   Sending Attachments by Mail
               Enter a description of the items that will be mailed.
                                                              «!** SUBMIT GENERATE PDF
DCTS for PWSs: Stage 2
           17
February 2008

-------
D.12 Once you submit the plan, a new screen will appear with a confirmation number. Please print this page for your
      records (see Figure 4).
                                                        Figure 4
            IDSE Submission
            Continuation Page
            Your Plan/ Report was submitted successfully! Please print this page for your reference.
             Confirmation #

             Date Submitted:
                                                 08/11/2006
            If you have selected sending by hardcopy in the Attachments section or wish to submit a hard copy version of your plan, report, or
            attachments in addition to electronically submitted files please mail or e-mail the files to one of the following addresses:
                                                         Mailiny Address:

                                                          US EPA-IPMC
                                                           PO Box 98
                                                      Dayton, OH 45401-0098

                                                         E-mail Address:

                                                      stage2mdbp@epa.gov
                                                             Home
DC7S for PWSs: Stage 2
18
February 2008

-------
          How to Submit a  System Specific Study (SSS) - Existing  Monitoring  Results
          using  the IDSE Tool
E.1   Log-in to CDX and click "LT2: LT2  Data Collection,  LT2/Stage 2 Tracking  System, and  IDSE Plan/Report
       Entry." Click on "IDSE Plan/Report Entry" (see Figure 1).
                                                                 Figure  1
                            The system recognizes you as an approved user for the following applications, please select a system to launch...
                            IDSE Plan/Report Entry
                            Launches !DSE Psan/Report Entry, whsch will iead you through fining out and submitting your iDSE Plan or Report
E.2   You will arrive at the "IDSE Plan/Report Entry" page (See Figure 2).
                                                                 Figure 2
                                     Welcome to the Plan/Report Entry Home page!

                                     Select the Plan or Report type you would iike to work on and click Go to Entrv to begin
                                     If you are not sure which PlaniReport applies to yui i      ; udthaf wrii assist you in determining your specie requirements ThetQSE
                                    ] Wizard is a web-based smart survey toof requiring the Macromedia Authorware piug-m to assist PWSs tn determining their IDSE requirements
                                     Download the free M&c_:_cn.K--qKi;;../\i;?'UjpA;fife plug-in from macromedia.corn

                                     The on-line entry portion for the IDSE Reports will be available in the Fall of 200G if you w;sh to work on your Existing Monitoring Results !DSE
                                     Report or your IUSE Report tor Modeling SSS prior to when ft is available, select the appropriate radio button and click "Go to Report
                                     Entry" (may take some time to load} The svslem wiii open a PDF form template in a new window. The PDF templates were designed for the
                                     IDSE Tool- CD Version and  make several Deferences to additional tormc available via CD If vou require the additional forms referenced to
                                     meet your required number ot monitoring sites, access the L ?_ f  u n* ^ iqe to download the forms you need. Alternatively, you can contact
                                     EPA at stage2mdbp@epa.gov to request these forms

                                     Note You will needtornstall AiK>M_B&d.td.XDtc access these forms Also you will nol be able to save this form unless you have Adobe
                                     Professional 7 0
                                     General I nf or ma tic
                                     PWS il i
                                     PWS Nat^tfj
                                     Schedule
                                     Plar, Hue Hal
                                     Repui-t Due
        Gchedute 2
        O4/O I ;'2O07
        O7 O1 2  ( Q
                                                                              Select Report Type

                                                                                 Standard Moniioring Rpptirt

                                                                              •   Sv^tem Spec (fie: Study Report Modefing
DC7S for PWSs: Stage 2
19
February 2008

-------
E.3  Select "System Specific Study - Existing Monitoring Results" from the IDSE Plan/Report Entry page and then
     click "Go to Plan Entry" (See Figure 3).
                                                 Figure 3
                              Select Plan Type

                               O 40/30 Certification

                               O Standard Monitoring Plan

                               O System:
                               1.'  System Specific Study - Existing Monitoring Results
                              '*•••»»!,>,
                                                 Go to Plan Er»tr
E.4  DCTS will pre-populate a new form with the available water system's information (see Figure 4). Review the
     information provided in the form. If any of the information displayed is incorrect and you are unable to change it,
     contact EPA at stage2mdbp@epa.gov.

E.5  By clicking on the links such as "General Information," "Certification of Data," or "Preview/Submit" on the top
     right you can move to different sections.

E.6  Select the "Save" button at the bottom of the page when you are done entering your information. Then click
     "Next" to move to the next section. Repeat this step as you complete each section.
DCTS forPWSs: Stage 2
20
February 2008

-------
Figure 4

*|xMnB«0f«^ '•; •" i'. ••••'•••• ••^^•}-^V^^.' t< IIIHt P"MI|1
P.irr A - Lf>c.itittii
ZZTest 1c
P -"! ss$ Honitoiii
DL V fMt,
20460 v'll '. will S hf.|.,«iiic * -'
400 . ' ^'.iMt lim-Mtt' /
pinio Pi -View Stllllnil ^T
L W •_! ^;^
SWP
Select : - :
C. PWS Operations
Residual Disinfectant TvPe Fl r.hinrmp fl r.hlnrammp<; D Ofhpr
Number of Disinfected
Sources
D. Contact Person
"Contact Name
Title
Phone Number
Fax
E-mail Address
3*
Surface GWUDI
Ground Purchased 1
John Doe
(555)555-5555 ext.
jdoe@watersystem . us|
'X««W!* S-'.'/E MEXT BACK CANCEL
E.7  To submit a schematic in Section VII & VIII, select the "Browse" icon to the right of the schematic field and
     select the schematic from your files (acceptable file formats: .xls, .doc, .jpeg, .gif, Jpg, .txt, .wpd, and .pdf) (see
     Figure 5). You must submit a distribution system schematic with the System Specific Study. You can also
     upload additional attachments from this page. Please note that once you upload an attachment, you will not be
     able to remove the file, so make sure it is the correct one. If you do not have electronic attachments to submit
     you can send hardcopies of your attachments to the address listed, however the plan will not be marked as
     complete until the attachments are received.

E.8  Select the "Save" button at the bottom of the page when you are done entering your information. Then click
     "Next" to move to the next section.
DC7S for PWSs: Stage 2
21
February 2008

-------
                                                    Figure 5
          Existing Monitoring Results System Specific Study (SSS) Entry
          VII S VIII Schematic & Attachments
           Select Browse to locate the file you would like to attach to your plan. Click Save to upload your  j
           attachments. The following file types are acceptable formats for your attachments: .xls, .doc, .jpef,
           .gif, .jpg, .txt, .wpd, and .pdf. All systems must submit a Distribution System Schematic with thejr
           plan unless they have selected the option to send by hardcopy. (* = required field)         |
           ^Distribution
           System Schematic


           Attachment Name:



           Attachment Name:
/I. t
                               l liit<>imii
                        IJ. SSS Regiiiieiiients    \
                        III, Peak .Histmical Month
                        IV, Prey, Monitoring Results
                              Part A - Location
                              P.artB...,Hetlio
-------
                                                             Figure 7
              IDSE Submission :•
              Confirmation Page
              Your Plan/Report was submitted successfully! Please print this page for your reference.
              Confirmation #
              Date Submitted:
 1
08/11/2006
              If you have selected sending by hardcopy in the Attachments section or wish to submit a hard copy version of your plan, report, or
              attachments in addition to electronically submitted tiles please mail or e-mail the files.to one of the following addresses:
                                                             M,iilin*i Address:

                                                              US EPA-IPMC
                                                                PO Box 98
                                                           Dayton, OH 45401-0098

                                                              E mail Address:

                                                          stage2mcibp@epa.gov

                                                                  HOIIKS
DOTS for PWSs: Stage 2
             23
February 2008

-------
DOTS for PWSs: Stage 2       -                        24                                      February 2008

-------
          How to Submit a System Specific Study (SSS) - Hydraulic Modeling  using the
          IDSE Tool
 F.1   Log-in to CDX and click "LT2: LT2 Data Collection, LT2/Stage 2 Tracking System, and IDSE Plan/Report
       Entry." Click on "IDSE Plan/Report Entry" (see Figure 1).
                                                                   Figure 1
                             Systems
                             The system recognizes you as an approved user for the following applications, please select a system to launch..
                             IDSE Plan/Report Entry
                             Launches iDSE Plan/Report Entry, which will lead you through filling out and submitting your IDSE Plan or Report
 F.2   You will arrive at the "IDSE Plan/Report Entry" page (See Figure 2).
                                                                   Figure  2
                                      Welcome to the Plan/Report Entry Home page!

                                      Select the Plan or Report type you would like to work on and click Go to Entry to begin
                                      tf you are not sire which Plan/Report applies to you nw-^AW-fMti that will assist you in determining your specific requirements The tHSF
                                      Wizard is a web-based smart survey tool requiring the Macromedia Authorware plug-in to assist PVVSs tn determining their IDSE requirements
                                      Download the free Macromedia'.;,' AUnoryvKre plug-in from marrornedia.com

                                      The online entry portion for the IDSE Reports wit! be available in the Fall of 2006 If you wish to work on your Existing Monitoring Results IDSE
                                      Report or your IDSh Report for Modeling SSS prior to when it is available, select the appropriate radio button and click "Go to Report
                                      Entry" (may lake some time to load} The system will open a PDF form template m a new window The PDF templates were designed for the
                                      IDSE Too! - CD Version and make several references to additional forms available via CD if you require the additional forms referenced to
                                      meet your required number of monitoring sites, access the I  ->_ Hu fte.cj.ageto download the forms you need. Alternatively, you can contact
                                      EPA at stage2m(3bp@epa gov to request these forms.
                                      Note You will need to install Adobe Resdo-j 7 0 tc access these forms Also you will not be able to save tn
                                      Professional? 0
                                                                                                          us form unless you have Adobe
                                      General Informatk
                                      PWS I ft
                                      PWS Narie


                                      Schedule
                                      Pinn Due Date
                                      Report Due Date
                                      Select Ptan Type

                                      •.. • 4Q;"«0 Certification

                                      f   Stanrtatd Monitoimcj Plan

                                      ^."  Svstern Specific Study - Modelinn

                                      '" "• Systen-; Spoof if: StiitJv - hxi sling Momttmng Resultr,
        Schedule 2
        O4/O1/7O07
        07 01 2UO
           Slandatd Monitoring Report

           Sv^tem Specific Study Report - Modeling

          • System Specific Study Report Cxistmg Mewwoniig Resutt'i
DOTS for PWSs: Stage 2
25
February 2008

-------
F.3  Select "System Specific Study - Modeling" from the IDSE Plan/Report Entry page and then click "Go to Plan
     Entry" (See Figure 3).
                                                Figure 3
                              Select Plan Type

                              O 40/30 Certification
                                 System Specific Study - Modeling
                                                         Monitoring Results
                                               Go to Ran Entry
F.4  DCTS will pre-populate a new form with the available water system's information (see Figure 4). Review the
     information provided in the form. If any of the information displayed is incorrect and you are unable to change it,
     contact EPA at stage2mdbp@epa.gov.

F.5  By clicking on the links such as "General Information," "Peak Mth for TTHM," or "Preview/Submit" on the top
     right you can move to  different sections.

F.6  Select the "Save" button at the bottom of the page when you are done entering your information. Then click
     "Next" to move to the next section. Repeat this step as you complete each section.
DC7S for PWSs: Stage 2
26
February 2008

-------
                                                      Figure 4
            Modeling Study Plan Entry
            I. IDSE General Information
           j Please review the information provided below, if you feel any of the information displayed is mcortp(\
           ! and you are unable to change it please contact your State or EPA representative.
           |
           I *PWS ID
            *PWS Name
            *PWS Address
            *City

            "State

           |*Zip

            "Population Served

            *System Type

            *Souice Water Type
            Number of Disinfected
            Sources

            D, Contact Person

            'Contact Name

            Title

            Phone Number

            Fax

            E-maif Address
  DC 1C
  ZZTest 1c

  iaddress



  city

  DC  v

  20460

  400

  CWS

  SWP

 Select
Surface

Ground


John Doe



{555)555-5555



jdoe@watersystem.us|



    SAVE NEXT  BACK CANCEL
[	: Other

 GWUDI

 Purchased  1
          ext.
                            II. IDSE Req
                            III, Mitt. Mo;!*! Requirement'
                                 P.iit A.
                                 P.tn 6.
                                 Part C.
                                 P.nt D,
                            I" Pt-il fill,  ft i TTHfl
                            V h  i*
                            vi phiih--in.itii &
                            AtttiidM-nr         /
F.7  To submit a schematic in Section VII & VIII, select the "Browse" icon to the right of the schematic field and
     select the schematic from your files (acceptable file formats: .xls, .doc, .jpeg, .gif, .jpg, .txt, .wpd, and .pdf) (see
     Figure 5). You must submit a distribution system schematic with the System Specific Study. You can also
     upload additional attachments from this page. Please note that once you upload an attachment, you will not be
     able to remove the file, so make sure it is the correct one. If you do not have electronic attachments to submit
     you can send hardcopies of your attachments to the address listed,  however the plan will not be marked as
     complete until the attachments are received.

F.8  Select the "Save" button at the bottom of the page when you are done entering your information. Then click
     "Next" to move to the next section.
DCTS for PWSs: Stage 2
                          27
                                                 February 2008

-------
                                                     Figure 5
             [Modeling Study Plan Entry
             VII & VIII Schematic & Attachments


             Select Browse to locate the tile you would like to attach to your plan. Click Save to upload your
             attachments. The following file types are acceptable formats for your attachments: .xis. .doc, jpeg
             .gif, .jpg, .txt, .wpd, and .pelf. All systems must submit a Distribution System Schematic with they
             plan unless they have selected the option to send by hardcopy. (* = required field)
             *Distribution
             System Schematic


             Attachment Name:
                           JUi.
                         Ill Mm Mod*
                             Pair A,
                             Pait B.
                         IV. Peak Mth. for TTHH
                         V. Modeling information
                         VI. Planned Stage 1 DBPR
                         W& Vill Schematic
F.9  In the "Preview/Submit" page you will have the chance to review the document before submitting. If you need to
     edit information use the links on the top right to move back to previous sections.

F.10 Once the plan is completed, select "Generate PDF" and save the file for your records (see Figure 6). You must
     generate this file before the form is submitted.
F.11 Select "Submit" to submit the completed plan to EPA. Please note that once you have submitted your System
     Specific Study to EPA you will not be able to make any changes. If you need to make a change to your System
     Specific Study after it has been submitted contact EPA at stage2mdbp@epa.gov.
                                                   Figure 6
                   Sending Attachments by Mail
               Enter a description of the items that will be mailed.
                                                                  SUBMIT GENERATE PDF
F.12 Once you submit the plan, a new screen will appear with a confirmation number. Please print this page for your
     records (see Figure 7).
DOTS for PWSs: Stage 2
28
February 2008

-------
                                                             Figure 7
              IDSE Submission
              Confirmation Page
              Your Plan / Report was submitted successfully! Please print this page for your reference
              Confirmation #

              Date Submitted
 1

08/11/2006
              If you have selected sending by hardcopy m the Attachments section or wish to submit a hard copy version of your plan, report, or
              attachments in addition to electronically  submitted files please mail or e-mail the files to one of the following addresses:
                                                             Mailing Address:

                                                              US EPA-IPMC
                                                                PO Box 98
                                                           Dayton, OH 45401-0098

                                                              E-mail Adthess:

                                                          stage2mdbp@epa.gov
                                                                  Home
DC7S for PWSs: Stage 2
             29
February 2008

-------
DOTS for PWSs: Stage 2                               30                                      February 2008

-------
    DCTS for Laboratories
United States
Environmental Protection
Agency

-------

-------
                              DCTS for Laboratories
                                       Contents

   A. Uploading Your Cryptosporidium or E. Co// Laboratory into DCTS	1
   B. Step-by-Step Registration for DCTS using CDX	3
   C. How to Create a New Sample	5
   D. How to Search for LT2 Samples	9
   E. How to View Sampling Schedules	11
DC7S for Laboratories                                                               February 2008

-------
DCTS for Laboratories                                                                             February 2008

-------
        Uploading Your Cryptosporidiurn or E. Coli Laboratory into DOTS

A.1  Cryptosporidium laboratories will need to provide a copy of their EPA approval letter to the IPMC via:
          >  Fax: 937-586-6557 or 513-552-1935
          >  Mail: Stage 2 DBPR & LT2ESWTR IPMC, P.O. Box 98, Dayton, OH 45401; or
          >  E-mail: stage2mdbp(a)epa.qov.
     Once EPA receives your information, they will contact you to fill out a lab registration form. After submitting your
     information you  should register with CDX (Refer to Part B).
A.2  E. coli laboratories certified by the states to conduct E. coli enumeration should submit a copy of their
     certification information to the IPMC via:
          >  Fax: 937-586-6557 or 513-552-1935
          >  Mail: Stage 2 DBPR & LT2ESWTR IPMC, P.O. Box 98, Dayton, OH 45401; or
          >  E-mail: stage2mdbp@epa.gov.
     It must be clear in the certification that your lab  is certified to do enumeration, and not just presence/absence,
     as required by the LT2ESWTR. Once EPA receives your information, they will contact you to fill out a lab
     registration form. After submitting your information you should register with CDX (Refer to Part B).
DOTS for Laboratories                                1                                      February 2008

-------
DOTS for Laboratories                                   2                                         February!

-------
  B.
Step-bv-Step Registration for DOTS using CDX (Steps B.1 - B.17 need to be
completed for registration. Once the password is setup, go to B.19.)
  B.1 Goto: http://www.epa.gov/cdx
  B.2 Click on "Log-in to CDX" (on sidebar) - New screen will appear
  B.3 Click on "Registration" (on sidebar) -New screen will appear
  B.4 Read the Warning Notice and Privacy Statements
  B.5 Click on "Click here to continue" - New screen will appear
  B.6 Read the Terms and Conditions and click on "I Accept" - New screen will appear
  B.7 Input a user's first and last name, user name (following recommended format), password (following recommended
  format) and re-enter the password, a question that can be used in case you forget your password, and the answer to the
  question - New screen will appear
  B.8 Input the water system's name in the Organization Name field and all other requested information. Click on "Next" -
  New screen will appear

  CDX Registration: Add Program
  B.9 Select "LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2)" (see Figure 1).
  B.10 Click on "Next" - New screen will appear
                                                  Figure 1
                                            CDX Registration: Add Program

                                                Facility Registry System - Update Service (FRS-US):

                                                           Lead-Based Paint Activities (LEAD):

                                               LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2):

                                                           Ozone Depleting Substances (ODS):

                                                              Radionuclide NESHAPs (RAD):

                                             Resource Conservation and Recovery Act Site ID (RCRA):

                                                    Stormwater Notice of Intent (eNOI) (SWENOI):

                        Toxic Release Inventory Made Easy Web (Approved Pilot Submitters ONLY) (TRIMEweb):

                                             Toxic Substance Control Act - HaSD Form (TSCA-HASD):

                                                      Compliance Information Systems (VERIFY):

                                   Request Manufacturer Code for OTAQ Compliance (VERIFY MFR REG):

                                                     Water Contaminant Information Tool (WCIT):
  Complete Role Information -
  B.11 Role is "Asubmitter" only option
  B.12 Select "Standard" (This is CDX. This is not where you request DCTS Admin access.)
  B.13 Input your ID Number in the ID field.
  B.14 Submission method is "WEBFORM" (only option)
  B.15 Click on "Next"
  B.16 Read the message
  B.17 Click on "Finished"
  B.18 You should receive confirmation from "CDX Registration" [EPACDX@csc.com] within 24 hours of submitting your
  request. Once you have received the e-mail confirming your CDX set-up, you can log into the DCTS.

  Logging into the Data Collection and Tracking System (DOTS)
  B.19 Follow steps B.1 and B.2.
  B.20 Input your user name and password - This is the user name you choose for yourself when setting up your CDX
  account (see Step B.7). Click "Login" - New screen will appear
  B.21 Click "LT2: LT2 Data Collection,  LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry" program (see
  Figure 2) - New window will appear
  If you need access to multiple systems, you must request access to the LT2 Data Collection  System. To obtain access to
  the LT2 Data Collection System you must contact your system's DCTS  administrator. If you do not know your system's
  DCTS administrator, e-mail your laboratory information and CDX user name to stage2mdbp@epa.gov.
  B.22 Once access is granted to the LT2 Data Collection System please click on the LT2 Data Collection System link.
DCTS for Laboratories
                                                                                                    February 2008

-------
  B.23 Click on the "User Profile" icon
  B.24 Update information for First Name, Last Name, State, Phone Number, or E-mail Address if any are incorrect (see
  Figure 2)
Figure 2

User Profile |
* = Required
The following
SEE
STEP
B.24

-ie
infc
/-
\
d
rmatton is provided by CDX. If you feel any of the information is incorrect, please access CDX to update/ verify.
UserNarne :
*F»rst Name
*l,8$t Wame
'State
*Phon(3 Number
*Emsii Address
SmitfiJohn
John
Smith
UN
(123)456-7890
johnsmitti@somewriere.com
Save and Continue Exit Registration

  B.25 Click on "Save and Continue"
  B.26 If you are a Cryptosporidium laboratory, input your ID number in the Organization Code field (see Figure 3).
  B.27 Click on "Lookup Organization" (see Figure 3)
  B.28 If you are an E. coli laboratory, click on "E. coli Lab Registration" (see Figure 3).
                                                            Figure 3
                      Please enter your Organization ID and click "Lookup Organization." The "Lookup Organization" link will be replaced with a "Request
                      Access" link and an "Undo" link. If your correct organization is displayed, click "Request Access." if you have incorrectly entered the
                      organization ID, click "Undo" and repeat the process. If you are an E. coli laboratory and your lab is missing from the list of organizations,
                      please click "£. co//Lab Registration."

                      If you are an existing user and would like access to the IDSE Plan/Report entry. Enter the code for the desired PWS and select LT2 from
                      the system list. Otherwise, you should enter the PWSs organization code in the Program ID field when registering via CDX.
                        Organization Code
                                                                             Lookup Organization
                                 E. CO// Lab Registration    Edit User information    Save and Continue  Exit Registration
  B.29 A new field "System Type" will appear; select "Both" (even if you only need access to one of the rules)
  B.30 Click on "Request Access"
  B.31 Click on "Save and Continue"
  B.32 If you need to request access to additional systems, repeat steps B.26 through B.30. Once you are finished, click on
  "Exit Registration."
  Once your user name has been authenticated by the DCTS administrator for your system, you will be granted access to
  the data system for these additional system(s).
DCTS for Laboratories
February 2008

-------
 c.
How to Create a New Sample
If you experience problems entering samples, email the Stage 2 Inbox at stage2mdbp@epa.gov. If you cannot see
your client, check with your PWS to verify that they selected you as the laboratory.
C.1   To create a new sample, select the "Create New Sample" icon <^Z  in the LT2 Data Collection system.
C.2   For Cryptosporidium samples select "Cryptosporidium" on the "Create New Sample" home page (see Figure
      1)-
                                                 Figure 1
                   To import data from your laboratory's information system, click "Upload Sample(s)." To enter data for a new
                   sample using wefo forms, select the analyte (and method type, for E. coli) and dick "Enter SampSe(s)"
                   (.) Cryptosporidium

                   O E. coii Select Method Type
                                                   ENTER SAMPLED   UPLOAD SAiPLEiS.
C.3   If you selected "Enter Sample(s)" then enter sample and system information. Select "Save" to retain
      information or "Clear Form" to start again (see Figure 2). If you selected "Upload Samples(s)" follow the
      instructions on the screen. A link is provided for help on creating an XML file.
Figure 2
Do not enter data for samples that did not meet QC requirements. You are acknowledging the following by entering Cryptosporidium
sample data into the LT2 Data Collection System: ail holding times for the sample were met; the sample was received by the laboratot
in acceptable condition: and results for the associated method blank, OPR, and positive and negative staining controls were acceptat
Enter data for up to four different samples. Click the field name for more informatio

i. * i <• ^ Cl*di Form %i
/ *
FIELDS COMMON TO ALL SAMPLES


Sample ID. (optionah
EWSJj)
PWS Nam«
PWS F-icilitv ID


New Sample
No v

- Please Select- v!

- Please Select- v!

New Sample
No v ;

- Please Select- ^

- Please Select- •*•

New Sample
NO v;

- Please Select- •*

- Please Select- v

New Sample
No v

:- Please Select- v

- Please Select- v

DOTS for Laboratories
                                                                                      February 2008

-------
C.4   For E. co// samples select "E. coir and the method type on the "Create New Sample" home page (see Figure
      1).
C.5   If you selected "Enter Sample(s)" then enter sample and system information. Select "Save" to retain
      information or "Clear Form" to start again (see Figure 3). If you selected "Upload Samples(s)" follow the
      instructions on the screen. A link is provided for help on creating an XML file.
Figure 3
Do not ente
into the LTi
received by
procedures
! data for samples that did not meet QC
Data Collection System: all holding am
the laboratory in acceptable condition;
specified in ths Manual for the Certifica
Enter data for the New Sample.
requirements. You are acknowledging the following by entering E. coll sample data
i incubation times and temperatures for the sample were met; the sample was
all method-specified QC requirements were met; and all QA/QC criteria and
ion of LabnratonesJ^ygiyjirjy Drinking Water (EPA $1$-B-.!, *••*£' ,.d.tt> If t* ffn* Cie.it Foiin %.
	 ^ r 	 — ^ife
FIELDS COMMON TO ALL SAMPLES *"*" ' -
Sample Status
Resainple
Sample ID {optional)

PWS ID

PWS Name

Pending Release
:NO v;

- Please Select- **


C.6   Review the sample information on the next screen (see Figure 4). The status of the sample is "Pending
      Release." At this point the sample has not been submitted to the PWS.
                                               Figure 4
C/ypfospor/d/ym-AnytownLab-VA1234567
Cas
Clic
;ulateti Sample- Results
'.. the field name for more information
SB.WS
Sample. ID {optional?
PWS ID
PWSJJIBS
PWS Facility ID
PWS Facility Name
Sample Collection Point ID
Sample Collection Point Name
§i*¥nnlf* r;oi!e?nt!f*ci 0*3^
Pending Release

DC1j
Zz Test 1j
TP1
Main St Treatment Plant
nefttestsample
snoppv
IP/nfi.'pno?

C.7   Samples that do no meet the LT2 requirements are flagged. There is an explanation of the flags at the bottom
      of the screen (see Figure 5).
C.8   Select "Edit sample(s)" to edit sample information (see Figure 5).
C.9   Select "Enter New Sample(s)" or "Logout" to save sample information without releasing it to the water system.
      When searching for samples (see Section D, "How to Search for LT2 Samples), this sample will appear under
      the heading "Pending Release."
DC7S for Laboratories
February 2008

-------
                                                   Figure 5
                             samele nor collected within - -2 days o* scheduled da:e
                             sample volume analvsis requirements not me:
C.10 To deliver sample(s) to the water system, -select the box under the sample(s) and select "Deliver Sample(s) to
      PWS" (see Figure 6).
                                                   Figure 6
! 1 i J_ 1 t
/ i uri !->! ^ i^ *p i ' " J -' . / '/


n


n
                       sample not collected ivithin +,-2 days of scneduled
                       Sample volume analysis requirements not met
                       The matrix spike volume analyzed is no: viitnin -••- i ~>a
                       the volume analyzed for the associated field sample
                       An associated E
a
*i
C.11  If you submit incorrect information to a water system, ask the water system to return the samples. You can
      then edit the samples and submit the corrected samples to the water system.
C.12  If you submit incorrect information to a water system, ask the water system to return the samples. Refer the
      system to 'DCTS for Public Water Systems: LT2. You can then edit the samples and submit the corrected
      samples to the water system.
DCTS for Laboratories
              February 2008

-------
DOTS for Laboratories                                   8                                         February 2008

-------
 D.
        How to Search for LT2 Samples
                                                                                in the LT2 Data Collection
D.1   To search for samples for a water system, select the "View Samples" icon
      system.
D.2   Select "Cryptosporidium" or "E. coir and set search parameters (see Figure 1). Select "Search Samples" to
      view a list of samples for the system.
                                                 Figure 1
                                Please enter as much data as pqssf ble to ft mit the search to a targeted set of results
                                   Large data retrievals can produce problems with the display of trie results.
                                 Ctyptosporidium
                                                • E. coli
                                                                         Select Method
CD PWS Inventory Data
D Status
D Lab Approval Date

Facility:
v Sampling Point:
V
w
Start MO/1 3/2006
End 11/13/2006

                D Sample Collection Date Start
                                                         End
D.3   Select the sample(s) for review and select "Edit/View Selected Samples" (see Figure 2).
Figure 2
E o n/vi EVV s ELECTED SAMPLES DC WN LOAD SELE CTE D SAM F

LI
BMTi %i>nrte JP
B»S
WKttcll*

lanMe Collection P«ptf

t«rt £
-------
DOTS for Laboratories                                   10                                        February 2008

-------
 E.
        How to View Sample Schedules
E.1   To view sample schedules for a water system, select the "Sample Dates" icon
      Collection system.
E.2   Select a date range or select the water system and facility (see Figure 1).
                                                                                          in the LT2 Data
                                                     Figure 1
            Sample Dates
              \t lew the PWS established sampling schedule by searching within a particular Date Range or Organization and then click
              "Submit" to disoiav the results.


b.Av f ,i.«. |t
'iit|,iinr iis lit
Sl.nt
PWS
; 3
-Please select-- v
ElMl
Facility
— i
-Please select- v
E.3    Scheduled sample dates will be displayed at the bottom of the screen (see Figure 2).
                                                    Figure 2
              View the PWS established sampling schedule by searching within a particular Date Range or Organization and then dick
              "Submit" to display the results.
o
Cv
D<«*» Rang*
Oi
-------
DOTS for Laboratories                                  12                                       February 2008

-------
      DCTS for States & EPA
&EPA
  United States
  Environmental Protection
  Agency

-------

-------
                              DCTS for States and  EPA
                                          Contents

LT2/Stage 2 Tracking System
   A.  How to Search for a Public Water System	1
   B.  How to Create and Assign a New CDS ID	5
   C.  How to View or Edit Public Water System Contact Information	7
   D.  How to Approve an Alternative Schedule	9
   E.  How to Upload a Submission Received from a Public Water System	11
   F.  How to View a Public Water System Submission	13
   G.  How to Generate a List of Received Submissions	15
   H.  How to Approve Submissions	17
   I.   How to Approve a Batch of Submissions	19
   J.  How to Add Notifications	21

LT2  Data Collection System

   K.  How to Approve DCTS Users (Administrative Users Only)	23
   L.  How to Search for a Public Water System's LT2 Samples  	25
   M.  How to View a Public Water System's LT2 Grandfathered  Data and Sampling Locations 	27
   N.  How to View a PWS's LT2 Sampling Dates	31

LT2 Data Collection System Reports

   O.  How to Generate a Report in the LT2 Data Collection System	33
   P.  How to Generate a Sample Tracking Report	35
   Q.  How to Generate a Sample Backlog Report	37
   R.  How to Generate a Sample History Report	39
   S.  How to Generate a PWS Schedule Submission Compliance Report	41
   T.  How to Generate a Binning Report	43
   U.  How to Generate a Missed and Re-Sampled Events Report	45
   V.  How to Generate a Grandfathered Data Report	47
   W.  How to Generate a Monitoring Waived Report	49
DCTS for States and EPA                                                                 February 2008

-------
   X.   How to Generate a PWS Sample Location Plan Compliance Report	51
   Y.   How to Generate a Sample Pair Incomplete Report	53
   Z.   How to Generate a PWS Facility Compliance Report	55
   AA. How to Generate a List of PWSs without Facilities	57
   BB. How to Generate a List of Users (EPA Only)	59
   CC. How to Generate a LT2 DCTS Usage Report (EPA Only)	61
DC7S for States and EPA                                                                   February 2008

-------
A.
How to Search for a Public Water System (PWS)
A.1  To search for a PWS select "PWS Maintenance" icon '•..__)  in the LT2/Stage 2 Tracking System, located on the
     left side of the screen.                              %

A.2  You can use a variety of criteria to search for a PWS. To search using a PWSID, for example, select the state
     and the PWSID of the water system you would like to find from the drop down menus and select "Search" (see
     Figure 1).  When searching for a PWS name you can type the name of the PWS, or part of the name.
F

^e*»*
r-.

C-,
r,
•--,-'
O


-
PWS Name
CDS ID
Letter Type
Notice Name
Region/State Code
0
D
a

a
a
a
PWS ID
Stage 2 Compliance Schedule
PWS Plan Status -Submission Type
Plan/Report Type
Submission Status
Approval Status
Triage Decision
Stage2 Rule Requirements
LT2 Rule Requirements
igure 1
~~'-*€::'d. if'Ct'-O'-S ££•:&'-, '


5-sie " _e'"e T,PH v
Eeie.* Nnce Name v
M v 2'E v * ' '
DEOrijTjC * -*>-""•"-•••
M ! V
. . ..
1 1 nr; n
-------
                                              Figure 2
           Searched for
           State  DE
           PWS Id- DE0000102
           Vss Waiver Search  false
                     false  ,
                VIEW/EPIT PROFILE
                                       VIEW NOTIFICATIONS
                                                                VIEW SUBMISSION STftTUS
.-•
' D

,'•; ' • PWS ttama
UPCC'UriTRY UA'1'.FACTIRED HOME COMMUNITY
'• ' \- '• ' . ' V-4*

DE0000102
; ;*Y-: :•- ,

9999
;v i -:
A.4  The PWS Search Tool can also be used to search for multiple water systems. For example, to search for all
     systems in Delaware with a Stage 2 Compliance Schedule 1 within a state, select DE from the state drop down
     menu (see Figure 3). Select "Compliance Schedule  1" from the Stage 2 Compliance Schedule drop down menu
     and select "Search."
Figure 3
F-^-i
1 ii-.e a&a:rea Pll'S sy seJecwo fro"' the fo:!or;-*g ses-ci' c~:e- a c^r c ~3 js'o1
f'"",
Vx''
O
•:*">
Q
©

PWS Name
CDS ID
Letter Type
Notice Name
Region/State Code
D
0
D

D
D
n
PWS ID
Stage 2 Compliance Schedule
PWS Plan Status -Submission Type
Plan/Report Type
Submission Status
Approval Status
Triage Decision
Stage2 Rule Requirements
LT2 Rute Requirements


Selec* _e::e-Tvps *>
Selec' f jcace flame v
All v 3E v ^S— «»>-
DEOOOOOO:- v
Ccmsliance Schedute -" v «*—*-
f.loni::ring Plan v
All v
Received v
•All v.
All v
All "
. All v |
D Include Closed Systems _*•»«»"«« w*»^
— "*" /" SEARCHyESET

A.5  This search will display all systems in Delaware with a Stage 2 Compliance Schedule 1 (see Figure 4). Select
     "Modify Search" to return to the search page.
DCTS for States and EPA
February 2008

-------
                                                     Figure 4
Searched for
State  DE
Maj-2 Cjni) Inn i-  ni|
                                  Compliance Schedule 1
                   VIEW/EDIT PROFILE
                               y!iW_N.OT!FICATIQNS
                                                                           VIEW SUBMISSION STATUS


D
D
D

' fwsmnn

AsTESIA(; ' "A"E^: C'"Jl.1PAr|v
UtilTEj ,VATER3E_A- A^E
WILMIMGTOn '.V.ATER DEPA^TfJEIJT
'
mas

DEOuOOoDi
DEnnHM-64
DE0000663

SUM

9999
4?1
9999

DC7S for States and EPA
                                                                                            February 2008

-------
DCTS for States and EPA                               4                                       February 2008

-------
B
How to Create and Assign a New CDS ID
B.1  Search for the PWS in the LT2/Stage 2 Tracking System.

B.2  Check the box next to each water system you would like to assign a new CDS ID and select "View/Edit Profile"
     (See Figure 1). If you are unable to get all the PWSs you want, click on any three PWS IDs. The PWSs you are
     looking for might be on different pages in the system.
                                                    Figure  1
                Searched for
                State BE
                Jt33e2 LGHpli?n:s Group  Compliance Schedule 1
                 s;' ai ri  I-eai;h fsise
                Ib=e1 5,=tem  false
                    VIEW EDIT PROFILE  '.';
                                     VIEW NOTIFICATIONS
                                                                VIEW SUBMISSION STATUS
                 J?
                  D
                  n"
                                                                   CECC 00584
                                                                   DE0000663
B.3  Select "Obtain New CDS ID" (see Figure 2).
                                                  Figure 2
        PWS Batch Update
                               Select Batch Update Type  Update PWS Profile
        To return to your previous search results click the "RETURN TO SEARCH RESULTS' hnK Please note that this
        to the beginning c? ycur search result list and you' previous selections on the 'esul: page vviH be 'emcve;
                                                                                   Oiuain New CDS 'D
\ P«S Hamv
ARTESIAN V.ATER COMPANV
UIIITED '. . ATER 3E-A. ARE
IJ 'IIIGTON WATER DEPARTf.V
,PWS ID
DE0000552
DEOODO:-54
DE00005': j
Retail
Pojiylalten
205000
'L'O.OO
4'J':'OD
CDS" ID
CiQClQ
47-
9999 :
PWS lypft
C "S v
Cv' ? V
C»VS v
CalcuiaSKd Conylianca
Sehe^yfe
Compliance Schedule J
Compliance Schedule *
Compliance Schedule i
DC7S for Sfafes and EPA
                                                                                           February 2008

-------
B.4  A new window will appear with a new CDS ID written in red (see Figure 3). You can now update the CDS ID for
     the water system(s) displayed in the table with this number (see Figure 3). It is recommended that you copy and
     paste the new number instead of entering it manually. Select the "Confirm Changes" link at the bottom of the
     table to review a list of all changes. It is important to use the number immediately. The number is not taken out
     of circulation until it is assigned to you in  DCTS. If you were not able to select all the PWSs in a CDS you can
     change the CDS in the PWS profile.

B.5  You are not required to use this number.  You can create a new number as long as another group is not using it.
                                                 Figure 3
                                             ,.
            f. https://intranet.epa.gov/lt2/nextCDSId.do

                   Your new CDS ID number is:
             Please enter this number ;n The CDS ID column
             To" any PWS you ivish to assign TO this CDS ID
                         %y Internet
                                 Select Batch Update Type  Update PWS Profile
           To return to you* previous search *esults click the'rRETURN TO SEARCH RESULTS" link Please note thai this will return vou
           to the beginning o? your search result list and you" previous selections on the result page will be removed
                                                                                     ONa-n »&v. C3S !D
' "' '• .'PWS n&me
ARTESIAN WATER COMPANY
'A'LMINGTON WATER DEPARTf.1
PYV'S ID ;
DE0000552
DE0000663
; RettMi ^
.; PojwWJfgn/jl
200000 1
-40000
CDS ID
105'600029
i05'600029
Typ«
C'.,|S ' v
.F'S V
Calculated Corfjiftanee
Fchfldup- sV
Compliance Schedule '
Compliance Schedule '
                                                                 RETURN TO SEARCH RESULTS
B.6  Select the "Edit" link on the confirmation screen to edit your changes or select "Save" to save the changes in
     DCTS (see Figure 4).
                                                  Figure 4
PWS Batch Update


PWS N»»e ,
ARTE3IAIJ WATER COMPANY
WILMINGTON WATER DEP^BBJStL
lifei}
DE0000552
DE0000863
Retail Populatiop
200000
140000
CDS ID
105160002S
105160002S
PwsTy^fi
C'A'S
cv, s
C«npliaiie« S«|h6dti!e
Compliance Schedule 1
Compliance Schedule 1
f" SAVE \ ' EDJT

DCTS for States and EPA
February 2008

-------
 c.
How to View or Edit Public Water System Contact Information
C.1  Search for the PWS in the LT2/Stage 2 Tracking System, PWS Maintenance Module.
C.2  Select the PWS name or check the box to the left of the PWS and select "View/Edit Profile" (see Figure 1).
                                              Figure 1
              VIEW/EDIT PROFILE
                               VIEW NOW ICATIONS
VIEW SUBMISSION STATUS
                    1 :: • -I '
	 "" 	 "
n


C«f,ljEII DISTRICT

PWS M
DE0000124

CftUi!
9999

C.3  Update or review information displayed in the PWS Profile page (see Figure 2). If any of the information
     displayed is incorrect and you are unable to change it contact EPA at stage2mdbp@epa.gov.
C.4  Select the "Save" button to store your changes.
                                              Figure 2
                      yiEl"JJSARCHJ?ilULJS   YLfWJJONTftCTS    Vjf WJWT1FICAT1ONS    VjEWJUBM!lSjON..SJAiyS

                          I            	   CE  i 24   	'
                                                  fi
DOTS for States and EPA
                                                                                  February 2008

-------
DCTS for States and EPA                               8                                      February 2008

-------
        How to Approve an Alternative Schedule


D.1  Search for the PWS in the LT2/Stage 2 Tracking System, PWS Maintenance Module.
D.2  Check the box next to the system and select "View/Edit Profile."
D.3  From the PWS Profile page, scroll down to find the tables entitled "Stage 2 Information" and "LT2 Information"
     (see Figure  1). Select the box for "Alternative Stage 2 Schedule Approved" or "Alternative LT2 Schedule
     Approved," as appropriate.
                                                 Figure 1
Stage 2 Rule
Requirements
Calculated Stage 2
Compliance Schedule
IDSE - Stage 2 Compliance
Monitoring
Compliance Schedule 4
D Remove Rule Requirements
EH Alternative Stage 2 Schedule Appro'
•ed
SAVE CANCEL
L-2RMl^^MitHn-^
L.T2 Conipf ioncE' S^'fi^cJuiB
Nine

D Femo e Fill? Refinements
[H Alternative LT2 Schedule Approved
SA"1 fj EL
D.4  Upon checking either "Alternative Stage 2 Schedule Approved" or "Alternative LT2 Schedule Approved", the
     table will expand (see Figure 2). Select an alternate schedule and complete the required fields. (Note: in order
     to save the schedule change in DCTS, you must provide an explanation for the alternative schedule.) To save
     the alternative schedule select "Save." Select "Cancel" to cancel your changes.
                                                Figure 2
Stage 2 Rule
Requirements
Calculated S
Compliance
tag® 2
Schedule
IDSE * Stage 2 Compliance
Monitoring
Compliance Schedule 4
EH Remc'.e Rule Requirements
E3 Alternative Stage 2 Schedule Approved

' jtn F i , i v
/" !tf~l kits t i
1 > !'l I >
you <,»!* r -> , fr r ,«, /> Jt^r HH . tvi- n nif >n . t S " wiulf- t^l
*•
fr JF ^
S i- Jlitt
* "-"'
n in*- ' " 1
'I , !< J J ^ '" '
:^ * ' *™£r-mm-n' z,
j^ r 
-------
DCTS for Sfafes and EPA                               10                                     February 2008

-------
       How to Upload a Submission Received from a Public Water System

E.1  Search for the PWS in the LT2/Stage 2 Tracking System, PWS Maintenance Module.
E.2  Check the box next to the PWS and select "View Submission Status" (see Figure 1).
                                              Figure 1
              VIEWiEDIT PROFILE
VIEW NOTIFICATIONS
VIEW SUBMISSION STATUS ?

E.3  Select the submission type form the drop down list (see Figure 2).
       a.  Monitoring Plan - To upload IDSE Plan submissions (e.g. 40/30 Certification, Standard Monitoring Plan,
          System Specific Study Plan, etc.).
       b.  IDSE Report - To upload IDSE Reports for a PWS that conducted Standard Monitoring or System
          Specific Study. The IDSE Report is due 3 months after sampling is required to be completed.
       c.  LT2 Submission - To upload LT2ESWTR source water monitoring or grandfather data.
                                              Figure 2
                       Submission Status--
                       Seiec: Submission Type
                                     jeer
DC7S for States and EPA
            11
                       February 2008

-------
E.4  Assign a plan type, submission status, date received, and approval status for the PWS submission (see Figure
     3). Select "Confirm" and then select "Upload" on the next screen. (Skip this step if documents were previously
     uploaded for this system and this information has already been populated.)
                                                    Figure 3
             Do not review LT2 Submissions until information for all facilities has been uploaded
                                                 RETURN TO PROFILE
-isn „)
[IP 3=1 V
~r • )»-
Jt- ItOl
;Seiect vi
Mlbt irsKi r« F
^eceiveo v
Appro dl virus
: Under Revle* v
"Date Received <$•
: '0^2007 	 3
Date Assigned lor
Review
	 I 	 ; 	 13
Plan Copied
i Select v
Assigned Reviewer
; Select v
Held By

Date Approved
minis
LSS: ^oa,fea o-- s, ^^—--^
( CONFIRM CANCEL
E.5  Assign a file type, enter a file name, and browse for the file (see Figure 4). You can select "Other" from the "File
     Type" drop down menu and create your own name for the file. Select "Upload Files" to attach files to the PWS
     profile document inventory. If you want to go back to the PWS profile without uploading, click "Return to Profile".
                                                      Figure 4
             Upload FRes
flc'r~ O'se^ec: O&6r ar.a er,;e'a d.sior^ r,ame
a"sc'-"€:r,;s ro a Pla'/Repc--: a: fre sa^is n^e as :
                                                                         -rsc'sre C>'-CK :•"£ UPLOAD !-nLt:S »'W.
                                                                     '^ P'a"/RspQ-t ^p:oa<3 so ihs! fre a'tachments a--e
                                                                                    6 a S eC  l,  oTie SS!6Ct

File Type
File Location
r,ip 35 v
OfiS a'e D ' P3 A - Browse... ) «*«»««
Enter File Name -«^-..-MW.
&3&XK'-.

File Type
File Location
"P-SM mnimn'ri
|" Browse... J
Enter File Name

_^."-— ~ ^ ^^— " — — *-^
f UPLOAD FILES 1 «<— — f RETURN TO PROFILE j «|-««-,™»
•x .^/ V. I-7
DOTS for States and EPA
                     12
February 2008

-------
       How to View a Public Water System Submission

F.1  Search for the PWS in the LT2/Stage2 Tracking System, PWS Maintenance Module.
F.2  Check the box next to the system and select "View/Edit Profile."
F.3  All documents uploaded for the PWS will be displayed at the bottom of the page in the "Document Inventory"
     section (see Figure 1). Select the file name to view the file.
          •  The IDSE Report provides the system's recommendations for where and at what frequency Stage 2
             DBPR compliance monitoring will be conducted and is submitted 3 months after Standard Monitoring
             or a System Specific Study is required to be completed.
          •  The Monitoring Plan shows documents submitted by the system in compliance with the IDSE
             requirements of VSS Waiver, 40/30 Certification, Standard Monitoring, or System Specific Study.
          •  The LT2 Submission shows information submitted by the PWS  in compliance with the LT2ESWTR
             requirements.
                                               Figure 1
           Below is an inventory cf all documents submitted by this PVV'b  Click on the hyperlinked document name to vie
           the actual document
           Submission Type
           IDSE Report
           Monitoring Plan
                                   [IP • •-.'   I
                                   Ii*- '  i   »i „  i-m Jii-MTiaiic
                                   •^"d hMifn  _- -. j 11
                 03-28-2007
                 03-28/2007
                 03/28-2007
                 03-'28/2007
                 03-28-'2007
                 10-05-2007
           LT2 Submission
                                   in i-n T
                                   _TZ -%an pi"- -   a [
   nematic
UV10/2007
01'10-2007
05'23/2uu7
05/23 2007
F.4  It is recommended that you print all files to ensure you have all the information for submission review.
     Reviewers may upload review checklists, approval letters, recommendation letters, phone logs, and any other
     document that would support review documents.
DC7S for States and EPA
13
                       February 2008

-------
DOTS for States and EPA                               14                                      February 2008

-------
 G.
How to Generate a List of Received Submissions
G.1  In the LT2/Stage2 Tracking System, select your state or EPA Region. Choose the type of submission you would
     like to search for under the "Submission Status" drop down menu (see Figure 1).
Figure 1



{J


r\
<"-:>

PWS Name
COS ID
Letter Type
Notice Name
	
Region/State Code
D
D
0

n
n
n
PWS ID
Stage 2 Compliance Schedule
PWS Plan Status -Submission Type
Plan/Report Type
Submission Status
Approval Status
Triage Decision
Stage2 Rule Requirements
LT2 Rule Requirements


•Selec" _e::e~T',t:e v
ieiec: N.?:ice Name v
AH v DE v
~FinnfiO;v- v

All ^
I i:nr: ing Plan v'
All v
Received - Complete v:
- L :

G.2 Select "Search." The next screen will display a list of results (see Figure 2). This search is based on data found
    in the submission status field. If the information for the PWS is not correct then the search will not contain the
    correct results.
^^^H Figure 2 ^^^1

VIEW/EDIT PROFILE VIEW NOTIFICATIONS VIEW SUBMISSION STATUS
" *; -^ it -


n
n
n
n

•>•}„ '*. ' ' ' • " - '"'•"„ '
ARTESIAN .','ATE=; COMPANY
SOUTH BETHANY
UNITED 'A'ATER DELAWARE
••••••U.WIGTON "-'ATE=. DEPARTMENT

f
DE0000552
DEOOA0323
DEUUUUo64
DE00006S3


9?99
472
471
S99S



DC7S for Sfates and EPA
                                          15
February 2008

-------
DCTS for States and EPA                               16                                      February 2008

-------
H.
How to Approve Submissions
H.1  Search for the PWS in the LT2/Stage2 Tracking System.

H.2  Check the box next to the PWS and select "View Submission Status."

H.3  Select the submission type from the drop down menu (see Figure 1).
                                               Figure 1
H.4  Assign a plan type, submission status, approval status (select "Approved" to approve the plan), date received,
     and date approved (see Figure 2) and select "Confirm". If the plan was previously updated to DCTS, you will
     only have to change the approval status to "Approved" and enter the date approved.
                                                Figure 2
          Do not review LT2 Submissions until information for all facilities has been uploaded
                                             RETURN TO PROFILE
          Monitoring Plan
'Plan Typelir
: MP-40/30 v
I n«3Ci?£?
Decision
Select v i
* Submission Status ~tt
\ Received - Complete v
'Approval Status ix
Approved v
Utst^1 H^L^! et I
— ir,,r ^J
Dor H MrniH f>.r
-f
Hl^'i ' > t if- 1
Selei * v
M^"IC)« t»U "»,t-f
Sf-JHC' V
He! I 3i>

L)afa MI p.v/»» 1
•2M20CT ~|
L3?'' 7~*C'd< >*•£•£? C'"< ?00^-f'1^-'?y *4 •t? ?^ 0 .'";. 5'aC > '^^^^^m^,^
,x CONFIRM CANCEL
DCTS for Sfates and EPX\
                                            17
February 2008

-------
H.5  On the next screen, review all information entered in the previous step. Select "Edit" to correct any information.
     Select "Save" to approve the submission, as shown in Figure 3. Note that this screen is going to look slightly
     different if the system has not already submitted plan information. If the system has not entered any previous
     information for the Plan Type selected you will only see SAVE/UPLOAD and EDIT as the 2 options (not SAVE,
     UPLOAD, CANCEL, and EDIT as shown below). Note: Selecting "Confirm" (Step H.3) and "Upload" (Step H.4)
     does not save the information. Before uploading you will also need to click "Save" twice and then go to upload.
                                                 Figure 3
            Submission Status
            Monitoring Plan
'Plan Type
MP-40.30
Triage Decision

'Submission Status
Received - Complete
Assigned Reviewer

"Date Received
12--13 200?
Date Assigned for Review
12':13>2GQ?
Plan Copied

'Approval Status
Approved
Held By

Date Approved
12.-~1-i.-2C07
Lasi moated or 2007-0*- -<5 <4. '2 2^<}g^^fgffmjS^s'~~"~ ~ra*™w»««*^jt^
*V~ SAVE UPLOAD CANCEL EDIT ,_J»
            Submission History
              Document Type       Submission Status
              	1	j
              User Name	[ModiHecii Date.	j
                                              RETURN TO PROFILE
DOTS for States and EPA
18
February 2008

-------
      How to Approve a Batch of Submissions
 1.1   Search for the PWSs in the LT2/Stage2 Tracking System.
 1.2   Check the box next to each PWS for which you would like to approve a submission and select "View
     Submission Status" (see Figure 1).
Figure 1
V
^ ^^K^*"" " i"*~' ' ~*BiW°''*°fe~-V.V.^ ;
EW/EDIT PROFILE VIEW NOTIFICATIONS """" 'X VIEW SUBMISSION STATUS*'!

\
D
,-,, *, LJ
rj
n

PWS ?Jame
AMtSlVi '.'Alt'" ''J', If ANY
SOUTH BETHANY
UNITED 'A'ATER DE.A\VA^E
WILMINGTON WATER DEPARTMENT


' -—- -.-. ^^. .-^f!":'i . ., .
mst..i
DE0000552-
DEOOA0323
DE0000564
DEOOOOG63

gBJM |
9999
4^2 1
471
9999


 1.3  Complete all of the following fields (see Figure 2) and select "Continue."
           a.  Plan Type
           b.  Submission Status
           c.  Date  Received
           d.  Plan Copied
           e.  Triage Decision
                                                   Figure 2
                                   Select Batch Update T 11-  U-.Ja'e P i SutPi S^rns v
                                   Select Submissicn T |,=   \!(  ni*:nn: Piati v

            To "etu-n to your previous search 'esulis click :he 'RETLRN TO SEARCH RESULTS" link  Please note that this *ill return you
            the Deciinning Q' your search result list and you* previous selections on the result page vM be removed
            The Batch Submission p'ocess does not support L.T2 Submissions
•P^|»fiBe-PWSID
UNITED y>/ATER
DELA'A'ARE-DEOOOOEB4
SOUTH BETHAfJY-
DEOOA0323
* Plaii T^p-e
MP-5M v
MP^V,),^ v
1 SubaisioB Status
Deceived - Ccmpiete v
^eteiveo - Comple'e v
* Received
09 26 200': 3
no 27 2fi'"r ~ 1
— U
P an Cop;,&d
Seleir v
Selef v
Tiiape Decisior
Ccmpie- ^
5eiec' «
DC7S for Sfafes and EP/\
19
                                                                                                  February 2008

-------
1.4   Complete all of the following fields (see Figure 3) and select "Confirm."
          a.  Assigned Reviewer
          b.  Date Assigned for Review
          c.  Approval Status
          d.  Date Approved
Figure 3


PWS
UNITED
WATER
DELAY-ARE-
DE0000564
SOUTH
BETH AIT,
DEOO»0323
Plan
TIP*
MP-
3M
MF
Sf.l
«>;- ***>$
Triage
pecMoti
Complex
„*•"""""••
•
R*¥ie^»r ~
Region; v
^egirnl *
*«&,
H r.ONFIRM 1
"-«»««»«««*!!!*<^
for
fttflaw
OS 05 2007 -_oj
D& o: :oo~ ]jj
;
Approved v
App'e/ed v
' #< J ^
;
-0.05,200? -7;
"OD52JO- %
EDJI

1.5   On the next screen, review all information entered in the previous step. Select "Edit" to correct any information.
     Select "Save" to approve the batch of submissions.
DOTS for States and EPA
20
February 2008

-------
J.
How to Add Notifications
J.1  Search for the PWS in the LT2/Stage2 Tracking System.

J.2  Check the box next to the PWS and select "View Notifications" (see Figure 1).
                                                     Figure  1
               VIEW/EDIT PROFILE
                                          VIEW NOTIFICATIONS
                                                                         VIEW SUBMISSION STATUS
V
D

,
MARION EJEUEUTA^Y


OR4 193754

„ CMM
9999

J.3  Read the dialog box (see Figure 2) and select "OK" or "Cancel" as appropriate.
                                                  Figure 2

                     It is recommended that you perform batch notifocations per State and Compliance Schedule. Please ensure you have
                     performed a search on state and compliance schedule before you continue, Do you want to include all PWSs from
                     your search results (up to 500) in your batch update? If yes, dick OK. If you prefer to enter notifications ONLY for
                     the PWSs you selected, dick Cancel to continue,
                                                          Cancel
J.4  Select "Add New Notice" (see Figure 3). In the section, "Add New Notice" only letters that were sent will be
     listed. The actual files that contain the template of the letter should be uploaded in the Document Inventory.









Figure 3

f^S«0Mfieatta ;«,,.<:: , ;. % / '•- , ., ; : •••..•••'.•
Click the hyperlinked Notice flame to edit information for a particular notice To add a new notice for this PWS die
at the bottom of the page
• . Notice flame -ID LeMaf'Tjpe Notice Sens Bate J Description | FtteM««"
[The'e a'e no nonces ns:e;l
Return to PWS Profile Return to PWS Results / AdcJ fi<-/,- >'i->i,c«'t *

V--...-™^i,^-.-'-x


••- ; ; ,:.:,,**.;
<. the Add Notice link
'"'?«« Bate •'{
|












DOTS for States and EPA
                                                  21
February 2008

-------
J.5  In the "Notice Name Field" choose "Other" from the drop down list and enter a name in the box (see Figure 4).
     (If you plan to use the same notice in the future, add your two letter state abbreviation to the notice name so
     that you can find it again.) Complete the information in the form. Be sure to include a description of the notice.
J.6  Select "Save and Continue" at the bottom of the screen.
                                                 Figure 4
              " = Required Field

              Please emerthe following information regarding this notice
'Notice Name
•LrtterType
'Notice' Sent Date
Received by PWS Dais
Returned Dare
'Description
File Name
File Dale
Entry Dare
Ifeer Hame
Please select avaiiatie iT?"ces v -^n™
' c*he
nfjaai v
: Id
: -Vj
~A
:
'maximum 200 cha'acte's

(1 	 ; 	 '. 	 : 	 ~ i 	 ^
Oct 5 2007
qonder02 gender
                                 RETURN TO HOTiFICATiQN USI
J.7  If you want to add a batch of notifications, check the box next to each PWS for which you would like to add a
     notification and select "View Notifications" (see Figure 5).
Figure 5





VIEW/EDIT PROFILE VIEW NOTIFICATIONS^! VIEW SUBMISSION STATUS
mmmm


D
+ El
» 0
.D

>i**>'*^^

':*'.'• , PWS mam .

ARTESIAN WATER COMPANY
SOUTH BETHANY
UNITED WATER DELAWARE
WILMINGTON WATER DEPARTMENT
"Sri „ ' 'if; ; ' - z~ ": : *
-^:.=f.
pwsi«
DE0000552
DEOOA0323
DE0000564
DE0000663
',' "".
cp^ri"
9999
472
471
9999
3 ? '? I


Note: The DCTS only tracks here the file name and date. The DCTS does not save here the actual notification file.
To save the file upload it to the submission status page.
DC7S for States and EPA
22
February 2008

-------
 K.
How to Approve DOTS Users (Administrative Users Only)
K.1  Each state or EPA Region has an administrative user. The administrative user is responsible for granting
     access to DCTS to other users (called standard users). The administrative user of each water system must be
     registered before other users can access the DCTS.

K.2  Enter the "LT2 Data  Collection System" (see Figure 1).
                                              Figure 1

        LT2 Data Collection System
        Launches the LT2 Data Coliec
        LT2/Stage2. Tracking System
        Launches the LT2> Stage 2 Tracking System for compliance tracking, notification tracking, and reports
K.3  Select your organization (state or EPA Region) (see Figure 2).

K.4  Select "continue."
                                              Figure 2
                 Se-ee* :*e or
K.5  From the tool bar to the left select the "Update Users" icon,
K.6  A list of users will be displayed on the next page (see Figure 3). The status of all new users is "Pending" until
     approved by the administrative user. Change the status of a new user to accept the user. Remember to select
     "Submit Changes" to save all updates to the user page.
DCTS for States and EPA
                                         23
February 2008

-------
                                                                  Figure 3
            PWS -ZZTest1c-DC1c

            You are listed Ai$ti
-------
       How to Search fora Public Water System's LT2 Samples
L.1  Enter the "LT2 Data Collection System."
L.2  Select your organization (state or EPA Region).

L.3  From the toolbar located on the left of the screen, select "View Sample" icon.
L.4  Select "Cryptosporidium"or"E. coir (see Figure 1). Select the state, PWS, and facility (if PWS has multiple
     facilities) from the drop down menu. You can also select Lab, Sample Status, PWS Review Dates, or Sample
     Collection Date. Select "Search Samples" to view a list of the samples that match your criteria.

     States and EPA will only be able to see the samples that have been released by the PWS, or that have elapsed
     past the reporting due date.
     DCTS defaults to the checked "PWS Review Date" selection, you need to uncheck this if you do not what to
     search on "PWS Review Date."
1










^^HH




0PWr In'.entcry Data
D Lab
D Status
0 PWS Review Date
D Sample Collection Date

Figure 1

Please enter as much data 3$ possible to limit the search IB a targeted s«t of results.
targe date retrievals can produce problems wild th* display «f the re;?':!,*?
A
U'-, CZOSCC' £•../>"• •• L CO *C --'--••-• --( ~* - »•"*
State '.^ v PVV5 MA' 047000 v Facility v
: ' V
V
Start 09- j 3 200" End "00:2JJT
Start En;!
- .,. ._ ,FL.: as











L.5  Samples will be displayed in five categories (see Figure 2): Approved, Contested, EPA Agrees, EPA Disagrees,
     and Not Reviewed. To review a sample, check the box next to each sample(s) and select "Review Selected
     Samples."
L.6  Select "Change Search Options" to revise search criteria.
DCTS for States and EPA
25
February 2008

-------
                                                                   Figure 2
                Displaying samples 1 to 2 of 2 total samples matching the above search criteria Pieast stlert  am| les ti it  u    il I III >- tt  P   <_r
                modify the search criteria above to narrovsr youi  choices You can sort the data by clicl in on th-  olumn hedJmjs  r 311 n a  is  i| t
                four samples of the same analyte'method by clicking the appropriate check boxes and then rh  I m or the  Re IP   ^am| IP' Iml  If i
                comment is associated with the sample a notepad icon vvill appear to the left of the Simp I- 1C  Ittnp samj i- r -> re sam[ IP h^^h marl
                will appear as the background in the sample collection date cell To print the search r^ult  JisjJa e I un thr  " iPen  htk thi-  Print
                Search  Results" link For best results  set your layout orientation tc landscape
PMS    j PWS Facffi»
                                                                                                               1 .PWj
                                                                   Approved
                  C]   AF649S5    GAQ0001  GA0550003     202A
                                                                     12C72CiCT
                                                                   Contested
                 There are no samples currently associated with this status
                                                                                                04;12/2007
                                                                   EPA Agrees
                                                                 EPA Disagrees
                 There are no samples currently associated with this status
                                                                  Not Reviewed
                                        ntlv associated >.-Yith this status
DCTS for States and EPA
                            26
February 2008

-------
 M.
How to View a PWS's LT2 Grandfathered Data and Sampling Locations
M.1  Enter the "LT2 Data Collection System."
M.2  Select your organization (state or EPA Region).
M.3  From the toolbar located on the left of the screen, select "Submit GF Sample & Location" icon.
M.4  Select the state, PWS, and facility (see Figure 1).
M.5  Select "View."
                                              Figure 1
    ^•'BSSS se'ec; a .'-ac-'.rv 5-~£ C'-CK / •£'.-V.
                  State
                  PWS
                  Facility
                 OH
                 Om'026-2 - CINCINNATI PUBJC WATE^ SYSTEM
                     - CINCINNATI P'-.VS ML.E^ P^AIJT
M.6  The grandfathered data and sampling plan will appear below (see Figure 2). Select "View Submission Tracking"
     to view all submissions for the PWS to date. You can update the data if the information is incorrect. Remember
     to select "Save" if making any changes.
DOTS for States and EPA
                                         27
February 2008

-------
                                                                Figure 2
             P's3S& seise: a Fad!;?/ ana c  c,<   tli'.
State
PWS
Facility
OH v
OH I/ 026 '2 -CltlCiriNA
TP' -CINCINNATI P'. S
Tl
M
PIJBJC . ,ATE^. SYSTEM v
„£=, P_ANT ^
- IE-:

                Currently editing ; CINCINNATI PWS MILLER PLANT - TP1
                1,     PWS intends to submit grandfathered data
                       Notice of Intent to Grandfather        ,,,^
                       submitted
                       View Intent to Grandfather Form
                   ,    Date EPA. received  Intent to Grandfather
                       Form !mm/dd
-------
M.7 Select from the list either "LT2-Grandfathered Data" or LT2-Sample Location/Schematic" to see the submission
     history.
M.8 Select "Return" to return to previous page.
                                                      Figure 3
                                                        RETURN
              LT2 Submission
i'DQCUfW." ""V(,
LT2-Sample Location/Schematic v i
Select
| LT2-Grandfathered Data
^ LT2-Sarnple Location/Schematic
N/A
! 	
'Submission Status
Received *
..si Status
Approved "
'Date Received
06/06/2006
for Review
06/06/2006
Plf- Copied
Y :vj
Assigned
Reviewer
I EPA HQ v
Held By
IPMC
Date Approved
06/06/2006
              [Last modified on 2006-06-06 20.31.37.0 by gonder02 gondet
                                                   CONFIRM CANCEL
              Submission History
| Document Type
| LT2-Sample Location/Schematic
[a2J3arTpieJ£Cj^^^
Submission Status
Received
Approval Status
Approved
Received | Approved
User Name
gonderQ2 gonder
gonder02 gonder
Modified Date
2006-06-06 20.27' 150
2006-06-06 20-28 48.0
              Follow-up Contact

                [Date
                                  Select
                                                         User Name
                                                                                   Assigned To
                                                         Notes
                                                         SAVE
| Date
!_____

Purpose


Motes


Status
N/A
N/A
User Name
Jeff Butensky
Jeff Butenskv
Assigned To


                                                        RETURN
DC7S for States and EPA
29
February 2008

-------
DOTS for States and EPA                               30                                      February 2008

-------
N.
How to  View a PWS's LT2 Sampling Dates
N.1  Enter the "LT2 Data Collection System."
N.2  Select your organization (state or EPA Region).

N.3  From the toolbar located on the left of the screen, select "Sample Dates" icon,

N.4  Select the PWS and facility (see Figure 1).

N.5  Select the frequency for which you want to enter sample dates (e.g., individual, weekly, monthly, etc.) for each
      facility (see Figure 1).
                                                           Figure 1
               Setecf the facility you would like to view/enter sampling dates
                         billietestl
                         ZZTest 1a-DC1a
                            Individual Dale Entry - one date at a time
                            Weekly Date Entry - recurrence pattern for a specific weekday

                            Monthly Date Entry - recurrence pattern for specific day of a month
                            Copy Dates - copy existing sampling schedule to another facility
              LT2 sampling schedules must be established and saved in the system prior to the regulatory deadline for your system. After this date, this
              sampling schedule lunction will not be automatically submitted to EPA Requests to change sampling schedules after this date must be
              submitted to EPA in writing
               Individual Date Entry
                               Month
                                            Day
                                                   Year
                     Click the Save Sampling Date button after making your selection to display the dates


                         Please note that the system does not check for holidays or weekends
                      You must manually verify the sampling dates and make the appropriate changes
                             Save Ssnifjling Dale \y?

                          Remove Sampling Date  jjrf
                                            Remove All Dates t5f
                                                                                 Sampling Dates
                                                                         iJuly 14,2006- Friday'
                                                                         i August 18. 2006 - Friday
                                                                         | September 15, 2006 - Friday
                                                                         i October 13, 2006 - Friday
                                                                         iNovember 17, 2006 - Friday
                                                                         1 December 15, 2006 - Friday
                                                                         I January 19, 2007 - Friday
                                                                         I February 16, 2007 - Friday
                                                                         i March 16. 2007-Friday
                                                                         j April 13. 2007-Friday
                                                                         jMay 18, 2007-Friday
                                                                         i June 15, 2007 -Friday
                                                                               To modify the abcve information select the desired date
                                                                              use the buttons to the left to remove or edit the date To v
                                                                              pnnt the above schedule, click 'View-1 Print Sampling Date
N.6  Select "View/Print Sampling Dates" to view or print all of the sampling dates.
DOTS for States and EPA
                                                       31
February 2008

-------
DOTS for States and EPA                               32                                      February 2008

-------
 o.
How to Generate a Report in the LT2 Data Collection System
O.1  Enter the "LT2 Data Collection System."
O.2  Select your organization (state or EPA Region).

O.3  From the toolbar located on the left of the screen, select "Reports" icon.

O.4  The next screen displays a list of reports available (see Figure 1). These reports include:

           a.  Sample Tracking
           b.  Sample Backlog
           c.  Sample History
           d.  PWS Schedule Submission Compliance
           e.  Binning Reports
           f.  Missed and Re-Sampled Events
           g.  Grandfathered Data
           h.  Monitoring Waived
           i.  PWS Sample Location Plan Compliance
           j.  Sample Pair Incomplete
           k.  PWS Facility Compliance
           I.  PWS List without facilities
           m. List of  Users (EPA only, not shown in Figure 1)
           n.  LT2 Data Collection System Usage (EPA only, not shown in Figure 1)
                                                  Figure 1
             Displays the number of sample results submitted and reviewed
             .Saj;oj>j_e,,l;li5toj3(
             Displays sample historv
             Displays a list of PWSs that intend to ivai-.s monitoring
            I
      .....
    Displays all samples that do not have a complete pair icrypto and E cell for the same date and sampling point;

            '      i
    C j I   ? li  f F   Fa ! t H t  at have not submitted a valid sample schedule Grsndfathered samples or Sample Location Plan

      /         til
    Th  it| rrt I | la      ri| I ait facilities wtiere the PVVS has yet to errter facility information
DOTS for States and EPA
                                              33
February 2008

-------
DCTS for States and EPA                               34                                       February 2008

-------
        How to Generate a Sample Tracking Report


P.1  To generate a sample tracking report, select the "Reports" icon in the "LT2 Data Collection System."

P.2  Select "Sample Tracking" from the list of reports.
P.3  This report displays the number of sample results submitted and reviewed in the state/Region. This summary
     table will show the total number of sample results submitted/reviewed for each week. The table will also indicate
     if the samples are from the laboratory or the PWS or if the samples are Cryptosporidium samples or E.coli
     samples. Only samples that have been submitted and reviewed by either the Laboratory or the PWS will be
     displayed. All samples that are under review will not be displayed, unless they are past the deadline.
P.4  Select the printer icon at the top right corner of the screen to print the report.
                                                Figure 1
             Vie-,v sample data ti.,ii
                                         to
                                         Organization
                                      PWS
                                      Laboratory
                                      FWS
                                      Laboratory
                                      PW;
                                      Laboratory
                                      Laboratory
                                      PWS
                                      Laboratory
                                                               Sample Results Submitted/Reviewed
                                                          Total
                                                         11
                                                                                       E. col!
                                                                                     10
P.5  Select the sample dates in blue to view the sample tracking report (see Figure 1).
P.6  To change the date range of the sample tracking reports, select the calendar icon to the left of the current date
     range.
P.7  Select the desired date range and then select "Update Report."
DOTS for States and EPA
35
February 2008

-------
P.8  The sample tracking report will display all sample results from all states for the specified week (see Figure 2).
Pr9  Select "Return to Summary Listing" to return to the summary table.
P. 10 Select the printer icon in the top right corner of the screen to print the report.
Figure 2

^| Reports: Sample Tracking : • :;i: "•';>: ;:': y ; . • : • •. ; |

Return to Sumrnarv Lisrinq •<— >
7
he :=".:€ eetov ffls^avs safe's 'SSt.'Js for We iveek cf '2/23-200' - '2/29/20C
Organization
' Type
Laboratory
Organization Name
Altoona '»"VVTP Laboratory
American Water
Ana-Lab Corporation
Analytical Services
Anytime
Anytovvn Lab
Appomattox River Water Authority
BioVir Laboratories Inc
Castaic Lake Water Agency
CH Diagnostic & Consulting Service Inc
CH Diagnostic and Consulting Services
City of Durham Water and Wasteivster Lab
City of Pickens
City cf Round Rock Environmental Services Laboratory-
City of Salisbury
City of Santa Barbara - Water Resources Laboratories
•'^a
AH&HK'*tf**
/
Organization
!0
PA00931
IL00023
TX00063
VT00003
05624
VA1 234557
VA00005
CA01401
CA01160
C001020e
C001020
3765S
39005
2460003E
37618
CA.00364
Sample ^e^ulcs
Subrnirted^Reviewed
"otaj
7
1
6
29
1
1
1
2
2
^
8
6
1
3
1
1

C ryptospctrtdium
Q
1
0
24
0
1
0
2
ij
0
8
0
0
0
G
Q
E, colt
•j
n
6
5
1
0
1
0
2
6
0
6
1
3
1
1

*
^
*
/
DCTS for Sfates and EPA
36
February 2008

-------
 Q.
How to Generate a Sample Backlog Report
Q.I  To generate a sample backlog report, select the "Reports" icon in the "LT2 Data Collection System."

Q.2  Select "Sample Backlog" from the list of reports.

Q.3  The sample backlog report displays the displays the number of sample results pending laboratory approval and
     PWS review in the state/Region (see Figure 1). One table displays all samples that have been pending
     laboratory approval for more than one week. Another table displays all samples that have been pending PWS
     review for more than two weeks. The laboratories and PWSs are identified by name, ID number, and
     compliance group (PWS only).
Q.4  Select the printer icon in the top right corner of the screen to print the report.
                                              Figure 1
                Avon Lake VVTP Laboratory
                Erv.ironmpnlsl Associates


ANN ARBOR
AQUA ILLINOIS-VERMILION COUNTY
AQUA OHIO - MENTOR
AURORA


7557S5
TS6760
77SS25
T/inQfi-!
— _; 	



3
j-

•t \ "
«f 4
8
£.
2
1
P'f Kf'St [ °f!K'
i * > os*>u'u!j/f">
3
2
0
1
-.,«•
? i>
5
Q
2
0
DOT'S for States and EPA
                                          37
February 2008

-------
DOTS for States and EPA                               38                                      February 2008

-------
 R.
How to Generate a Sample History Report
R.1  To generate a sample history report, select the "Reports" icon in the "LT2 Data Collection System."
R.2  Select "Sample History" from the list of reports.
R.3  Select the laboratory from the pull down menu, enter a range of sample collection dates, and select "Update
     Report" (See Figure 1). You can narrow your search by entering the sample ID, but this is not required to view
     the sample  history report.
                                                 Figure 1

                                   -v^-	
R.4  The results are organized by PWSID. The report includes the Sample ID, analyte (Cryptosporidium or E.coli),
     collection date, and status of each set of samples collected by the laboratory (see Figure 2)..In the status
     column, the current status is displayed first, followed by the sample review history.
R.5  Select the printer icon in the top right corner of the screen to print the report.
                                               Figure 2
               Reports: Sample History
                fcnergy Labciat re
                                                                     iafc approved 0'.-22;'20C'7
DC7S for States and EPA
                                            39
February 2008

-------
DCTS for States and EPA                               40                                      February 2008

-------
 s.
How to Generate a PWS Schedule Submission Compliance Report
S.1  To generate a PWS schedule submission compliance report, select the "Reports" icon in the "LT2 Data
     Collection System."
S.2  Select "PWS Schedule Submission Compliance Report" from the list of reports.

S.3  This report displays the number of active facilities for each PWS in the state/Region that have not submitted a
     complete sample schedule to the LT2 Data Collection System. The report lists non-compliance facilities,
     organized by their PWSID (see Figure 1). You can narrow your search by selecting a compliance group ID.
S.4  Select the printer icon in the top right corner of the screen to print the report.
                                              Figure 1
              Reports: PWS Schedule Sytenissren Comptianee

                             PWS
                     1 - xxnnnnnnn
               Svstem 1 - xxnnnnnnn
               Svstem 1 - XXOOOOOOO
               System 2-XX0000001
               System 3 - XX0000002
                                           Non-compliant Facilities
                                                 Citv of
                                                P^ANT 001
                                                Treatment Plant
                                                PLANT OOi
Compliance Group
DOTS for States and EPA
                                           41
                 February 2008

-------
DOTS for States and EPA                               42              •                         February 2008

-------
        How to Generate a Binning Report


T.1  To generate a binning report, select the "Reports" icon in the "LT2 Data Collection System."
T.2  Select "Binning Reports" from the list of reports.
T.3  The binning report displays a list of PWS facilities within the state/Region with current calculated
     Cryptosporidium bin values of greater than 0.075 oocysts/L (see Figure 1). The report table is organized by
     PWSID and includes the total samples and calculation method for each facility.
T.4  To generate a binning report for a specific PWS, enter the PWSID in the field at the top of the screen and select
     "Search."
T.5  Select the printer icon in the top right corner of the  screen to print the report.
                                                    Figure  1
              By default the P'A'i facilities •.-.•itlrn your State ,vith current calculated C--,::[ospo-d:u^ bin values of at least 0 075 oocysts-L are
              displayed beiov.  The links below -AI|| alloA you to download this information in a comma-separated value i'C8V; file that can be imported
              to a spreadsheet or display or download the current calculated bin '.Blues for all PWS; facilities in the LT2 Data Collection System  Using
              the search function abc.e you also may search for a facility for a specific PWS in your State
              Please see the notes beicv. the table regarding bin value calculations
PWS

System 1 - XXOOOOOOO
System 1 - XXOOOOOOO
System 2 - XX0000001
Facility Name

TP#5
TREATMENT
PLANT #1
TREATMENT
PLANT *2
Total1*"
Samples
H£i
Ii24
14124
Cam^LCsSlSSBSOdlMSlMB.
CojicgElBllififl
0 1148
0 125
0.15
Calculation
Method
Roiling Annual
Average
Rolling Annual
Average
Rolling Annual
Average
T.6  To view the current, calculated Cryptosporidium bin values for all PWSs within the state/Region, select the link
     "Display the current, calculated bin concentrations of all PWS facilities" (see Figure 1).
      Note: Until all sample results have been submitted, the binning values are calculated using "0 oocysts/L" for
      samples for which results have not been submitted. As a result, the bin values for some facilities may increase
      in the future, if oocysts are detected in subsequent samples.
T.7  To view all samples used to calculate the Cryptosporidium bin value, select the blue number in the Sample
     Dates column of the table (see Figure 1). The sample drilldown (see Figure 2) lists the collection date and
     concentration of all samples used in the value calculation (see Figure 2). The current bin concentration and the
     calculation method are reported at the top of the screen. Select the printer icon in the top right corner of the
     screen to print the report and "Return to Binning Report" to return to the previous screen.
DOTS for States and EPA
43
February 2008

-------
              Reports: Sample Driildowrt ;
                           131834
                           186992
                           194475
              BfilMQJSJi!IMlU19.B.fijLSIt
                                                            Figure  2
                                                            - 'o'- PWS Plant # 1 forXXOOOOOOO
                                                          Collection Pate
                                                    2006-11-15
                                                    2007-11-14
                                                                              00
T.8  The "Download the PWS facilities with current, calculated bin concentrations of at least 0.075 oocysts/L" and
      "Download the current,  calculated bin concentrations of all PWS facilities" links (see Figure 1) will allow you to
      download this information in a comma-separated value (CSV) file. This file can be imported to a spreadsheet or
      display (see Figure 3).
                                                             Figure  3
                                  Do you want to open ot cave this file?
                  PWS ID
                 By default the PWS
                 displayed below Th
                 to a spreadsheet or
                 the search function
                      Display the
                      Download ti
                      Download t!
   Name: Bin075_PWS.csv
   Type: Microsoft Office Excel Comma Separated Values Fife
   From: intrariet.epa.gov
White files from the Internet can be useful, some files can potentially
Harm your computer. If you do not trust the source, do not open or
save IHs file. What's the risk?
n values of at least 0 075 oocystS'i. are
iparated value i'CSVi tile that can be imported
:ies in the LT2 Dats Collection System Using
it e

concentrations of at leasi 0.075 c-ocys£s>ft>
', least 0.075 oocysts'L.
                 Please see the notes below the table regarding bin value calculations
DOTS for States and EPA
                           44
                                   February 2008

-------
 u.
How to Generate a Missed and Re-Sampled Events Report
U.1  To generate a missed and re-sampled events report, select the "Reports" icon in the "LT2 Data Collection
     System."

U.2  Select "Missed and Re-Sampled Events Report" from the list of reports.

U.3  This report will show all PWSs in the state/Region that have missed one sampling event and/or re-sampled in
     the previous month (see Figure 1). A sampling event is considered to be missed if a sample was not collected
     for a date designated on the sample schedule the PWS submitted to the LT2 Data Collection System (to view a
     PWS's sampling plan see Section N, How to View a Public Water System's LT2 Grandfather Data and
     Sampling Plan).
                                               Figure 1
             Reports: Missed and Re-sampled Events
PWS
Hissed
Sampling
Date
Range
Sample
Submittal
Date
Range


From to
V
From ' 2'T)y:2007 to 0' ••'09/2005 *§.—«««
	 • 	
f VIEW/ *!<*-— «*
PWS
System 1 XXOOOOOOO

System 2 - XX0000001
Facility
TP#5

Reservoir
Sample lype
/-.,- ~,,~.^,,(.,.,.J „,

E co.'.
Missed
Sampling Cats



Sampff-
SubtniUal Date
12 1220CT

12.' 11. '2007
Date Re-sample
Collected
12Ml'20rtT

12^28.^007
U.4  Use the drop down menu to select to view missed and re-sampled events for a particular PWS (see Figure 1).
     To view samples for a different time period, change the sample submittal date range and select "View." Select
     the printer icon to the right of the search box to print the report.
DOTS for States and EPA
                                          45
February 2008

-------
DOTS for States and EPA                               46                                      February 2008

-------
 V.
How to Generate a Grandfathered Data Report
V.1  To generate a grandfathered data report, select the "Reports" icon in the "LT2 Data Collection System."

V.2  Select "Grandfathered Data" from the list of reports.
V.3  The grandfathered data report is organized by PWSID (see Figure 1). The report displays the number of
     samples each PWS within the state/Region plans to grandfather. The report also includes the date the
     grandfathered data was uploaded to DCTS and the number of additional samples. Narrow your search by
     selecting a compliance group from the drop down menu.
V.4  Select the printer icon in the top right corner of the screen to print the report.
                                               Figure 1
         Reports: Grandtathered Data

- •?*£**"
PWS
System 1 - XXOOOOOOO
System 2 - XX0000001
a C* a

TP 1
TP#5
TP1
TP#5
/

J^T;;^
4
4
11
11
H '<1lt [ »'
jampl>-
Slll'ftf T*f
TH
Yes
Yes
Yes
Compliance Group «
4:
Nuril^r >
M 1 fl'u.1 \t
21
20
13

flpf iO 3!
"^ft- 4




I v 4-%
'....".'..^
^nm
ir 13 ni
07r13'06
07.-13/06
0? 12;06

DCTS for States and EPA
                                           47
February 2008

-------
DC7S for States and EPA                               48                                      February 2008

-------
 w.
How to Generate a Monitoring Waived Report
W.1  To generate a monitoring waived report, select the "Reports" icon in the "LT2 Data Collection System."
W.2  Select "Monitoring Waived" from the list of reports.
W.3  This report displays all PWSs in the state/Region that indicated they will provide full treatment by the treatment
     compliance date and are therefore exempt from monitoring.
W.4  Select the printer icon in the top right corner of the screen to print the report.
                                              Figure  1
       PWS Facilities that Have Waived Monitorin
PWS
System 1 - XXOOOOOOO
Svstem 2 - XX0000001
Svstem 3 - XX0000002
Facility
TREATMENT PLANT
TREATMENT PLANT ST 1
Water Purification Facilitv
TREATMENT PLANT
DC7S for States and EPA
                                         49
February 2008

-------
DOTS for States and EPA                               50                                      February 2008

-------
X.
How to Generate a PWS Sample Location Plan Compliance Report
X.1  To generate a PWS sample location plan compliance report, select the "Reports" icon in the "LT2 Data
     Collection System."
X.2  Select "PWS Sample Location Plan Compliance Report" from the list of reports.
X.3  This report displays the status of the PWS sample location plans submitted to the LT2 Data Collection System
     for the state/Region (see Figure 1). The report also indicates the PWSs that have not submitted a sample
     location plan. Narrow your search by selecting a status from the drop down menu.
X.4  Select the printer icon in the top right corner of the screen to print the report.
                                              Figure 1
          Reports: Sample Location Plan Compliance
                                                               Status
                                                                   --.eceivec: - "evev.ed
                                                                    xecei.'eo - uncle' ~evie.'.
                                                                    No' Deceived

Svstprn 3 -
Svstpm 4 —


Svstern fi -
PWS
xxnnnonn?
xxnnnnrm
xxoonoofw

xxoooonns _ 	 	 	
Facility 1 Status
ADDI30N-EVANS WTP (Received - under revie*
GOOSE CREEK WTP Received - under revie*
CORBAl IS WATER TP Rprpjvpd - under review

North Anna Intake Hot Received
DOTS for States and EPA
                                           51
February 2008

-------
DC7S for States and EPA                               52                                      February 2008

-------
       How to Generate a Sample Pair Incomplete Report
Y.1  To generate a PWS sample pair incomplete report, select the "Reports" icon in the "LT2 Data Collection
     System."
Y.2  Select "Sample Pair Incomplete" from the list of reports.
Y.3  This report displays all samples in the state/Region that do not have a complete pair (i.e., they do not have both
     a Cryptosporidium and E.coli sample for the same date and sampling point; see Figure 1). The report is
     organized by PWS and indicates which sample type is missing.
Y.4  Select the printer icon in the top right corner of the screen to print the report.
                                              Figure 1
PWS
System 4 -
XXOUOOOUo
System 5 -
XX0000004
System 6 -
XX0000005












PWS Contact
KIM FORTf JER noemail@epa go', 999-

JOHN DOOLEY noemaihgepa go', 999-
999-9999
JOEL D LEDBETTER noemail@epa gcv
QC5Q_'~|UC)_CjCjCjU












Lab
Lab 1

Labi
Lab 2













is* Anatyte
«*. ... ,
Hissing
Cryptosporidium
Cryptosporidium
Cryptosporidium
Cryptosporidium

e coli
8 coli
e coli
e coli
e coli
e coli
e coli
e coli
e coli
e coli
e coli
e coli
S7op!e
294
293
671"
344

o44
844
844
844
844
844
844
844
344
844
344
844
a no It
Dite
10--05'2006
10/09.-2006
11.-' 20 '2003
10-17/2005
f 0
1U-1fc/2UUo
12.:13-'2006
O1.-'16'2007
02.-:19:2007
O3.'19'2007
04.'16-'2007
06-:18:'2007
05'21/2007
07<'16/2Q07
09'17,'2007
11'19/2007
12/17/200"
DOTS for States and EPA
53
February 2008

-------
DOTS for States and EPA                               54                                      February 2008

-------
       How to Generate a PWS Facility Compliance Report

Z.1  To generate a PWS facility compliance report, select the "Reports" icon in the "LT2 Data Collection System.
Z.2  Select "PWS Facility Compliance Report" from the list of reports.
Z.3  This report displays a list of PWS facilities within the state/Region that have not submitted a valid sample
     schedule, grandfathered samples, or a sample location plan (see Figure 1).
Z.4  Select the printer icon in the top right corner of the screen to print the report.
                                              Figure 1
         Reports: PWS Facility Compliance
PWS
System 4 - XX0000003
System 5 - XX0000004
Facility
TP1
TP#5
Water Purification
Facility
TP1 1
System 6 - XX0000005 TP 1
Sample Schedule .'
Grandfathered Data
tic
IJC
MC
tic

Sample Location
ric
rjc
nc
tic
NC
DOTS for States and EPA
55
February 2008

-------
DCTS for States and EPA                               56                                      February 2008

-------
AA
How to Generate a List ofPWSs without Facilities
AA.1 To generate a list of PWSs without facilities, select the "Reports" icon in the "LT2 Data Collection System."
AA.2 Select "PWS List without Facilities" from the list of reports.
AA.SThis report displays a list of facilities in the state/Region that may be non-compliant and have yet to enter facility
     information (see Figure 1).
AA.4 Select the printer icon in the top right corner of the screen to print the report.
                                               Figure  1
PWS
System 6 - XX0000005
System 7 - XX0000006
Compliance Groyp
^
4
DOTS for Sfafes and EP/A
                                       57
February 2008

-------
DCTS for States and EPA                             58                                   February 2008

-------
            How to Generate a List of Users (EPA Only)
BB.1 To generate a list of users, select the "Reports" icon in the "LT2 Data Collection System."
BB.2 Select "List of Users" from the list of reports.
BB.SThe report displays a list of all approved DCTS users (see Figure 1). To narrow your search, use the drop down
     menu to select a user category.
BB.4 Select the printer icon in the top right corner of the screen to print the report.
                                              Figure 1
Select an organization type to vie--, a list of users If your organization type has a significant amount of organizations and
the report will span mulitple pages Use the navigation arrows at the top of the report to access the additional pages
Display users for
State v
E PA 	 " """ 	 ' " 	 	 	 	 "
:PVVS
.Laboratory - Cryptosporidium
Ladcratory - E cell
^aboratory - Cryptospondium and E coli
Organization
Last Name, First Name
» > ' !r
User Name
Rote
Avoawa



gonder gonder02
McClimans William
Ramsey James
A'aSKo



Ciralskv Philip
gonder gonder02
Lane Donald
GOMDER02
WILLIAMMCCLIMANS
JIMRAMSEY
State Us«r
State User
State User

CITYOFLATHROF
GONDER02
WATERLOG
PENDING
State User
PENDING
Are-car, satr.ca

gonder gcnder02
Arizona


Abounader Starr
Abounader Starr
GONDER02
State Usar

STARR8S9
ABOUNADER
State User
State User
Status

ACTIVE
ACTIVE
ACTIVE

STATUS_MOT_SET
ACTIVE
PENDING

ACTIVE

££I!^L________
ACTIVE
DCTS for States and EPA
59
February 2008

-------
DCTS for States and EPA                               60                                      February 2008

-------
 cc.
How to Generate a LT2 DOTS Usage Report (EPA Only)
CC.ITo'generate a LT2 DCTS usage report, select the "Reports" icon in the "LT2 Data Collection System."

CC.2Select "LT2 Data Collection System Usage" from the list of reports.

CC.SThis report displays the number of organizations in the Region that have accessed the LT2 Data Collection
     System, as well as those organizations that have not used the system (see Figure 1). The report is organized
     into four categories: laboratories, PWSs, States, and EPA Users. To view a complete list of the users that did
     not access DCTS in the designated time from select the category name (in blue text). To narrow the search to a
     specific time from, change the start date and select "Update Report."

CC.4Select the printer icon in the top right corner of the screen to print the report.
                                             Figure 1
        Reports: LT2 Data Collection System Usage
         Viev'/ access information from
             •   415 _abcra:ories
             .  175'BPWSs
             •    59 States
             «   132 EPA Use's
DOTS for States and EPA
                                     61
February 2008

-------
DCTS for States and EPA                               62                                      February 2008

-------

-------
Recycled/Recyclable • Printed on 100% Postconsumer, Process Chlorine Free Recycled Paper
                      that has been manufactured with Wind Power

-------