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
\!
y'
•j
\(
V
J
J
-
-------
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 !->! Cxi 1 <(M*I i
i i* K ~r!F '<. O ')F_i> ^ 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
------- |