F. 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).

Systeme I

The system recognizes you as an approved user for the following applications, please select a system to launch.

IDSE Plar/Report Entry
j.aunches 1DSE Plan/Report Enuy. which will |

14 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

IDSE TOOLS. Plan / Report Entry Home

Welcome to the Plan/Report Entry Home page!

Select the Plan o Report type you would ike to work on and click Go to Entry to begin
It you are not sure which Plan’Report apntes to you acm a wziatd that wil assist you in determeung yaur specific requirements The INSF
Wizards a web-based smart survey lao! requinng the Macromedia Authorware plugin to assist PWSs in determining their IDSE requre:nents
Download the tree ¥ecrcmeria's Aumongare plugin from mactomeda.com

‘The onne entry portion forthe IOSE Reports wll be available un the Fall of 2006 if you w'sh to work on your Existing Monstonng Resuts IDSE
Report of your IDSt: Report for Modeing SSS prot to when i 1s available. select the appropriate radio button and cick "Go to Repo

Entry” (may lake some time to load} The system wil open a PDF form template in a new window The PDF templates were designed for he
IDSE Too! - CD Version and make several “eterenices to additional forms available via CD ff you segue fhe addtional forms referenced ta
‘meet your required number of monitoring sites. access the JUS Home nage te downoad the forms you need, Alemnatwely. you can Contact
EPA at slage2micbp@epa gov to request these forms,

Note You will need io install Auoke Reader 7 to access these forms. Also you wll not be able to save ts form unless you have Adobe
Professional 7 0

General information:

Pwo pete
PWS Name ZZ Tes8 te

enedule veneaute 2
Pian Dye Dare 0412007

Report Due Date 07012009

Requrements: Summary Sets

Specie nSeuCHON Foe systems im icbures, Mictaytin, Ones ane Wesson
‘Select Pian Type Select Report Tyne
40710 Geran Standard Merstonng Repost
© Standard Momtonng Plan System Specific Study Report - Modeling
© System Specitic Study - Models Sysiom Specitic Study Report Erasing Monitoring Results

Ssyst0m Specific Study Hsing Montonng Resut

Sate Pian Ente: Goto Report Betry

DCTS for PWSs: Stage 2 25 February 2008


R How to Generate a Sample History Report
a

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.

Reports: Sample History

Laboratory

| &

Sample 1D

Sample
Cotteetion | *2
Date

U datel ‘
Repon| 2 S|

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.

Reports: Sample History

Laboratory

Sample i

Sample
Collection
Bate

+208/2008

Update!
‘Report

Analyte

Status

DCTS for States and EPA

39

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 ail 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

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.

PWS - ZZTest te -DC1e

You are listed Aitininistsatos for this organization,

Your user role is PWS.

The following people have requested permission ta 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

Jong a

First Name Last Hame LT Status Aduiinistrarot
Sarah Bahrman PWS ov Delete
gonder2 gonder PWS oy ¢ Delete
Harry Pending ¥ <jma Delete

DCTS for PWSs: LT2

17

February 2008


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


P 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.

‘View sample data from *2°0 | Update Report

jtted: 40 samples were submitted by laboratories betwee
amples and 16 & coi samples

were revened by PY

sean

Reports: Sample Tracking

Ser

007 and 01-08-2008 This total value aa

between 12508-2007 and 01/08°2008 This total value includes 11

D

Sample Results Submitted/Reviewed
Toral Cryptosporidium E. coli
0 ig i)
0 a a
0 ¢ 10
4 7 0
Laboratory 2 2 2
Ps 2 1 1
Laborator, o i D
FP 2 A @
20 % 1
4 3 1
é 3 2

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.”

DCTS for States and EPA 35

February 2008


DCTS for Laboratories February 2008


E How to View Sample Schedules
=

—.1 To view sample schedules for a water system, select the “Sample Dates” icon in the LT2 Data

Collection system.
E.2 Select a date range or select the water system and facility (see Figure 1).

Sample Dates

View the PWS established sampling schedule by searching within a particular Date Range or Organization and then click
ee to dispiay the resuits.

Date Range Start mi) End i Submit

Ouganization PWS | -Please select- v Facility --Please select-- +

E.3. Scheduled sample dates will be displayed at the bottom of the screen (see Figure 2).

View the PWS established sampling schedule by searching within @ particular Date Range or Organization and then click
“Submit” to display the results

© [Bate Range Stat End “a Submit

© [Osganization pws | ZZTest 1a . Facility — | billietest1 v

Sampling Schedule

est la, biltietestt
o7na2006 Guess
08/18/2006

09/15/2006

10/13/2006

1117/2006

12/15/2006

DCTS for Laboratories 11 February 2008


User Profile I
Te tetowng imo rowed by COX. yu te any he nema © coat, plase sce COK I updtoeny
SE |) Firman om
STEP i
B.13. | “State UN
| [Phone Number res aire
| Vast Aarose rer
XN Save 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)

Piease enter your Organization ID and click "Lookup Organization.” The "Lookup Organization” link will be replaced with a "Request
JAccess" link and an "Undo" ink. If your correct organization 16 displayed, cick “Request Access.” if you have incorrectly entered the

Jorganization 1D, click “Undo” and repeat the process. If you are an E- coillaboratory and your lab is missing ftom the lst ot organizations,
please click "E. cob Lab Registration."

you are an exsting user and would ike accass to the IDSE Pla/Report entry. Enter the code for the desired PWS and select LT2 rom
the system list, Otherwise. you should enter the PWSs organization code in the Program ID field when registering via COX

Gi SEE
Organization Code SEE STEP =
ee, B15 Lookup Organization eu

E.coli Lal 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


PWS Plant # 1 for Xx0000000 *

Return to Binning Report

ample Number Collection Date

oncentration

172100

2007-12-17

Return to Binning Report

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).

Reports: PWS Bir File Download

Do you want to open of save this file?
PWS 1D ar &

Name: Bin075_PWS.csv
“a Type: Microsoft Office Excel Comma Separated Values Fle
From: intranet.epa.gov

By default. the Pyy' n values of at least 6 075 oceysts'L are
displayed below Th parated value iCSY) file that can be imported
to a spreadsheet or ies in the LT2 Cats Collection System Using

the search function Open Save Cancel
+ Display the
ety White fes from the Ineinet can be uselu, some fles can potentay

+ Download tH hhaim your compute. If you do not tust the source. donot open orf 2ast.0.075 oocystsit.
« Download save tis fle, Whats the tsk?

Please see the notes below the table regarding bin value calculations

DCTS for States and EPA 44 February 2008


DCTS for States and EPA 50 February 2008


C.4 For €E. coli samples select “E. coli’ 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.

Do not enter data for samples that did not meet QC requirements. You are acknowledging the following by entering E. coli sample data

into the LT2 Data Collection System: all holding and incubation times and temperatures for the sample were met, the sample was
received by the laboratory in acceptable condition; all method-specified QC requirements were met, and all QA/OC criteria and
procedures specified in the Manual for the Certification of Laboratories ing Drinking Water (EPA £15.

Save H Jretere fT Clear Foun "Oy
FIELDS COMMON To ALL SAMPLES =

Sample Status Pending Release
Resample (Nov

Sample ID (optional
Pws ID - Please Select- ¥

PWS Name

Enter data for the New Sample. omen id

Tt!) were followed,

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.

(Cryptosporidium - Anytown Lab - VA1234567
Caiculated Sampie Results

[Click the field name fer mere information

Status : Pending Release
PWS 1D JOC 1p

PWS Name 22 Test tj

PWS Facility 0 TPA

[PWS Facility Name Main St_ Treatment Plant
Sample Collection Point nentestsample

‘Sample Collection Point Name [snoppy

Samnle Collection Nate AP HAIN?

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.”

DCTS for Laboratories 6

February 2008




! How to Approve a Batch of Submissions
o

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
VIEW/EDIT PROFILE VIEW NOTIFICATIONS / SUBMISSION S$

"rm sensacarn

Oo
a DE0ANI23 472
iz DEg0N0S64

| feuinston DEGO0N63

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

Select Batch Update Type Update PS Submissions ¥ YyE\

elect Submission Type Monitoring Plan ¥

previous search «
the pecinning of your search re

RETURN TC SEARCH RESULTS" link Please note that this will
* PrevicUS Selections on the result page all be removed

The Batch Submission process does not suppot LT2 Submissions

Puls tame PWSI0 [Pian type | - “Submission Satis] Dato Received! [Pian Copied] triage Decisior
UNITED WATER = = commie oe D006 mcaee
DELAWARE-DEooonses | MP-SM _ ¥| Receiveo - Complete v 0926/2008 Tel Select v | Complex ¥
eT ay,

Seat Hy MP.giL. » | Received - Complese v Selec: v | Select

aera

DCTS for States and EPA 19 February 2008


B Step-by-Step 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).
‘DX Renistration: Add Promram

Lead-Based Paint Activities (LEAD)

T2 L72, Stage 2, and |OSE PlaniReport Entry (LT2)

rsaianistide NESTAPS RAD)
Resourve Consewabon and Recovery Act Site IC) RCRA)

Stormvzater Nouice of Intent (ENG (SENON)
Tosi Substance Contol Act- HaSD Form (TSCAHASCD

Compliance Information Systems (VERIFY). &

Request Manufacturer Code for OTAG Compliance VERIFY MFR REG)

\vvater Contaminant information Taal ovcIn).

B.5. Choose your role from the drop down menu (see Figure 2).

DX Registration: Add Program ID

AED PIE

Use the TAB key to move from field to fleld. * = ff

Role. ASUBMTTER ©

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.

ing i ‘ollection and king System (DC
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 5 February 2008


DCTS for PWSs: Stage 2 30 February 2008


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


A -by- Regi: ion for DCTS for New CDX Us:
.

Steps A.1 - A.17 need to be completed for registration. Once the password is setup, go to A.19.

A.1 Go to: 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. Read the Terms and Conditions and click on “| 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).

igure
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): “ *
SEE STEP Ozone Depleting Substances (ODS):

Ag. Radionuclide NESHAPs (RAD):

Resource Conservation and Recovery Act Site ID (RCRA): ">

Stormwater Notice of Intent (eNO!) (SWENO!): * 7
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.

L he D Collecti 1T ing S (DCTS
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 1 February 2008


DCTS for Laboratories

Contents
Uploading Your Cryptosporidium or E. Coli Laboratory into DCTS ........c.cccccesceesetesteceeeeeseeteteesesessenseeeateecieee T
Step-by-Step Registration for DCTS using CDX ........cccccccccsee cc cces cece eecceececeeseseseseessseeseseseseseseeeeceneneeeceeeeneiey 3
How to Create a New Sample .........c..ccccccsscseseseecseseestessnessansnsescseeesesteecsssesssneenssessecsussesssneseecsseneussessanseneicen 5

How to Search for LT2 Samples...

m9 90 7 >

How to View Sampling Schedules

DCTS for Laboratories February 2008


_ 14 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

7 Saar Oa
Type ee a *Aggrvol Sits | pacts

UNITED :

cenvare.str [Complex | Region’ ¥ Tal) Approved Te | 40:08:2007 Ta

DED000564

SOUTH ig ; -

BETHANY. [oi Regions v | 96032007 TI) Approved wv | 108 al

ceveanse3 [5M

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.

DCTS for States and EPA 20 February 2008


DCTS for States and EPA 42 . February 2008


40130 Certification Ent
Attachments:
EBA or your state may require you to submit additional information listed below

+ Stage 1 compliance monitoring results
+ Adistrioution system schematic

» Attachments e
| Preview Subuiit t

+ Recommended Stage 2 compliance monitoring lacatians
If the reviewer wants to request additional information or to have you conduct an INSE, they will f
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:
US EPA-IPMC stage2mdbp@epa gov
PO Box 98

Dayton, OH 45401-0098

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.qov.

Electronic Signature:
By selecting one of the two options below you are officially submitting your 40/30 Certification. Your
name and taday's date will be recorded to the database but will not be displayed an 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 Form: | hereby agree to electronically sign this form. | understand that by agreeing to
electronically sign this form | will be officially submitting this letter with my signature included

Do not Sign Form: | do not wish to electronically sign my form. | understand that submitting
this form here will not fulfill my requirements and that | will have to fax or mail in a signed

copy of my certification letter,

DCTS for PWSs: Stage 2 11 February 2008


Comehan:

VIEW/EDIT PROFILE VIEW NOTIFICATIONS VIEW SUBMISSION STATUS

lojoja

DCTS for States and EPA 3 February 2008


DCTS for PWSs:LT2 February 2008


Contents

DCTS for Public Water Systems: LT2

A. Step-by-Step Registration for DCTS for New CDX US6?S ........:cccesecseseeteesecsesseeeseaseeeereanssnesnesseeneeeneeee |
B. Step-by-Step Registration for DCTS for Current CDX USCrs....ccccessceseesesecseesseesseessesseesresseessesseesseesd
C. How to Add a Facility and Sampling Points to a Public Water System 0... cccesessesesseeseetesteseeeesseeneeeee 9
D. How to Enter Sample Schedules

E. How to Enter Other LT2ESWTR Dat: 13
F. How to Identify Contracted Labs (Administrative Users Only

G. How to Approve Standard Users (Administrative Users Only)...........c:cesessesssesecsecsessessesseseesneeneeersneeers 17
H. How to Search for LT2 Samples.......cecceccccccsssescessseseeceeecseseseseseseecevesessnsesnsneneseacecsessssscesenesaneesesesesneees 19
1. How to Approve, Contest, or Return a Sample to the Lab .......c ccc eeeeseceeseeesneenessensseeseseesesneaeneen 21

DCTS for Public Water Systems: Stage 2

A. Step-by-Step Registration for DCTS for New CDX Use? ....ccccsecsseessecssessseesecsseesseeeseessessneesseeasersneeesecsnss 1
B. Step-by-Step Registration for DCTS for Current CDX Users .......eccscsssesseeseeseesseeseeseeeeceeeseesseneeaneareeneenees 5
C. How to Submit a 40/30 Certification Plan using the IDSE Tool... eeseeseessessesenneeeeeeeneareneene 9
D. How to Submit a Standard Monitoring Plan using the IDSE To0)............ceeccesseesesreseeeeeseeseeseeeseeneeneeee 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... wed

DCTS for Laboratories

A. Uploading Your Cryptosporidium or E. Coli Laboratory into DCTS

B. Step-by-Step Registration for DCTS using CDX

C. How to Create a New Sample

D. How to Search for LT2 Samples.......c.ccscssesssesseesecsecsessesseesessssssssessucsessssessussuceseenrsaessessesessaesseaneansaeenennses 9
E. How to View Sampling Schedules ..........c.ccssesseseeseeseessececsesnesneeseeseesessesseesesenesuesnessesieeaeaneaneeeeseeeeteneense 11


DCTS for PWSs: Stage 2 8 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 anew sample, select the “Create New Sample” con in the LT2 Data Collection system.

C.2 For Cryptosporidium samples select “Cryptosporidium” on the “Create New Sample” home page (see Figure
1). .

To impor data from your jaboratory's information system, click “Upload Sarnple(s)." To enter data for ¢ new
sample using web fons, select the anaite (and method type, for E. colli] and click "Enter Sample(s).”

{

© Cryptosporidium

& cof Select Method Type v eocovammname = EATER SAMPLES; UPLOAD SAMPLE(S)

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. .

Do not enter data for samples that did not meet QC requirements. You are acknowledging the following by entering Cryptosporidium
sarnple data into the LT2 Data Collection System: ail holding times for the sample were met; the sarnple was received by the laborator

in acceptable condition; and resuits for the associated method blank, OPR. and positive and negative staining controls were acceptat
(EPA Method 4 3

. Se ganna.
Enter data for up to four different samples. Click the field name for more information. ¢ Save @ Cleat Foun cs
[FIELDS COMMON TO ALL SAMPLES man
‘Sample Status New Sample New Sample New Sample New Sample
Resample No Nov No v No»
Sample ID ioptienal
pws 1D ~Please Select- » | - Please Select- » | - Please Select- v _| - Please Select- »
PWS Name

S Fa iD - Please Select- | - Please Select- ~ | - Please Select- ~ | - Please Select- v

DCTS for Laboratories 5

February 2008




DS
ye Tare,
. .

F- 2a

3 WZ :
<

%

% o

oy, Ss
fay prove

816B08001

Step-by-Step Guide to the
Data Collection and Tracking
System (DCTS)


PWS -ZZTest 1c -DCtc

You are listed Administi ater for this organization,

Your user role is PYYS.

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

Submit Change:

First Name Last Name 172 Starus Adiinisnator
Sarah Bahrman PWS oy Delete
gonder02 gonder PWS ov Delete
Harry Jong | Pending ¥  <Gemesnn C Delete

DCTS for States and EPA

24

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.

randiathered Data

Compliance Group

&

——
Additonal Humber of EPA 2

PWS Facility | Number of Sample Additional Approvals Upload

amples te GF] Samp ‘ Date

ubmittal Samples Date

System 1— Xx0000000 | TP 1 4 Yes 20 Or 1308

TP #5 n Yes 20 0713508

System 2— xxo000001 | TP 4 1 Ves rr 71306

TP #5 7 Yes 171208

DCTS for States and EPA 47

February 2008


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:

e 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.

e 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.gow/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 stage2mdpbWepa.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:
WWww.cpa.govs ‘safewate:

isinfection/stage2/pdfs/contacts_stage2_compliancehelp.pdf

A list of contacts by state for the LT2ESWTR is available at
www.epa.gov/safewater/disinfection/It2/compliance.html

Also the following EPA contacts can provide further support

Region 1 - Region 6 —
Adrienne Harris |harris.adrienne@epa.gov Nancy Ho & ho.nancy@epa.gov
Mark McCasland |mccasiand.mark@epa.gov
Region 2 - Region 7 ~
Michael Lowy _|lowy.michael@epa.gov Doug Brune & brune.doug@epa.gov
Monica Wurtz wurtz.monica@epa.gov
Region 3 — Region 8 —
Nick Tymchenko | tymchenko.nick@epa.gov Robert Clement |clement.robert@epa.gov
Region 4 — Region 9 -
Robert Burns & |burns.robert@epa.gov Jason gambatese jason@ epa.gov
Amy Newbold —|newbold.amy@epa.gov Gambatese
Region 5 - Region 10 -
Miguel De! Toral |deltoral.miguel@epa.gov Wendy Marshall | marshall.wendy@epa.gov



L How to Search for a 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. Oo
&

L.4 Select “Cryptosporidium” or “E. coli’ (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.”

Please enter as much daia as possible to limit the search to a targeted set of results.
Large data retrievals can produce problems with the display of the

©

EJPWS inventory Data [State MA ¥ pws MATO47000-V Facility ¥
C1 Lat we

(2 Status v

EE) Pus Review Date Stat 0

(1) Sample Collection Date] Start

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


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).

Resample

io

Qriginal sample coltection date

ab resample explanation

PWS comments for lab ago
° ANS commer 21 ii Aga
PWS flag explanation for EPA/State Add oe ed
(gpa sipont
AAPWS flag explanation for EPAJState
& https:/jintranet.epa govik2jtextEditor.jsp?comma Yo
cheduied

‘SUPPL

LaBor

FIELD Save

Samph
Sampighttpsilfintranet.epa.gov! @ Internet Pe!

me:

athin =i 19% oF
eld sample
Hn submitted:

TERED BY THE

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.

Gryptosporidium - ZZTest 1a - DC1a

The following Grystessoriciuim samples were successfully submitted on 12/14-2007

Submitted To | Sample 1D | PWS

PWS Facility

Sample Collection Point_| Sample Collection Date

Status

EPA and State Test 1a

Hada Test 2

[Sample Point 11°02:2008

Approved

A

&

DCTS for PWSs: LT2

22

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.

Searched fer

VIEW NOTIFICATIONS

Wy SUBMISSION STATUS

[=
im

B.3 Select “Obtain New CDS ID” (see Figure 2).

Profile

lect Batch Update Type Update ©
click the “RETURN TO SE

~ VIEW
LTS’ kink Please
esult page will be “er

i
eonaleon |
ARTESIAN WATER COMPANY — | DEO: 200000 ooge + | Compliance Schedule *
UNITED WATER DELAWARE DE|000s64 | *09000 a7? y | Compliance Schedule * |
WILMINGTON WATER DEPAR TH] DEI00 9909 CWS —_¥ | Compliance Schedute * |)
DCTS for States and EPA 5 February 2008


X. How to Generate a PWS Sample Location Plan Compliance Report

Y. How to Generate a Sample Pair Incomplete Report

Z. How to Generate a PWS Facility Compliance Report 55
AA. How to Generate a List of PWSs without Facilities

BB. How to Generate a List of Users (EPA Only) ........cccccccceceessescseseseneesnsesceeseneessseseeetasaeseeaseesecaeaeseeataeseeaeeeeeatere 59
CC. How to Generate a LT2 DCTS Usage Report (EPA Only) .......:ccccccesssessessecscsesseeesesessseeesessesasecsesenessesasevase 61

DCTS for States and EPA February 2008


DCTS for PWSs: LT2 4 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).

Select Plan Type
( 40/30 Certification
Standard Monitoring Plan

System Specific Study - Modelin
meee (2) System Specific Study - Existing Monitoring Results

Go to Plan Entry

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 for PWSs: Stage 2 20 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.)

De not review LT2 Submissions unti! information for all facilities has been uploaded

RETURN TO PROFILE

[Plan Type ¥ |Submission Status ¥& ‘Date Received ye [Plan Copied Held By
“MPSS ov] Recevea v [7005-2007 “J | select v
Triage ba * Date Assigned for . oi
Decision Approval Status Review Assigned Reviewer |Date Approved
Select ov | Under Review ¥ “= | Select ov : |
CONFIRM PANCEL
=

* Required Fieid

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 Files

€ UPLOAD &:
‘oad so that

The name selected
Other from the dros do’

File Type MP-VSS © JEnter File Name —_
File Location OtiswaterDWPOWA 4( Browse.) “oe

File Type LP-SM v Enter File Name _

File Location _ (Browse. |

a UPLOAD FILES p) <a (seme To prone po

—— ieee

DCTS for States and EPA 12 February 2008


Flags E |
iResample tic
Griginal Sample Collection Dare
sample Explanation
CHECK THE BOX 10 DELIVER SAMPLE(S) TO PIS fil

aly Sis requ
ke sample was spiked »

d field samph
been submited

An associated € ¢cli sample nas ac

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).

|Resample Expianation
CHECK THE BOX 7O DELIVER SAMPLE(S) TO PWS swung |] Go

4 is é
, 5

5
c wer Sampieis] to OWS time

eee

nin = 70% oF 4

get Hi
> Ine volume analyzed * eld sample fence fH
E [An associated E coll sample has not heen submited

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 7 February 2008


eS

Central Data Exchange-MyCDX

Welcome, Last Login: July 21, 2006 |
Mr. John Smith Registered Since: July 21, 2006 4
Recertification Date: July 21, 2006

CDX Registration Status: Active

You have 0 new messages in your inbox

Change System Edit Personal Edit Current Add New
Password Information Account Profiles Employer Profile

Available Account Profiles:

© LT2:LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry

SEE STEP
A2t.

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.

lf 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

ne flow of

ye

SEE STEP Systems I
A23. :

The system recognizes you as an approved user for the following applications, please select a system to launch.

“seetel 12 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 fead you through filling out and submitting your IDSE Plan or Report

SEE STEP —P
A22,

A.24 Click.on the “User Profile” icon

DCTS for PWSs: Stage 2 2 February 2008


DCTS for PWSs: Stage 2 14 February 2008


O How to Generate a Report in the LT2 Data Collection System

0.1 Enter the “LT2 Data Collection System.”
0.2 Select your organization (state or EPA Region).
0.3 From the toolbar located on the left of the screen, select “Reports” icon. S

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

Sample Tracking
Sample Backlog
Sample History
PWS Schedule Submission Compliance
Binning Reports
Missed and Re-Sampled Events
Grandfathered Data
Monitoring Waived
PWS Sample Location Plan Compliance
Sample Pair Incomplete
PWS Facility Compliance
PWS List without facilities
. List of Users (EPA only, not shown in Figure 1) -
LT2 Data Collection System Usage (EPA only, not shown in Figure 1)

BgrcAT Ose a0C9

of sample results submitted and reviewed

mple Backlog
Eispioys the number of sample resus pending laborater, approval and PWS revs.

Sample History
Displays sample histor,

PWS Schedule Subr:
Cisplays the number
System

active facilities

for ea

ing Reports
Cispiays @ hist of P'S facilities with Crvotosocra..7: bin values of greater than 9 078 cocysts L

te. Sampled Events
3 a list of PV¥Ss that have missed a sampling date andor submitted a re-sample

‘intending te submit grandfathered data

itoring Waived
jays a list of PY¥Ss that intend te wate monitoring

$8:
Cisplays a list of sample igcation rians by Status

imple Pair incomplete
Displays all samples that do not hae a complete pair icrypte and E coli for the same date and sampling pomt;

ews Fac ili Compliance
Cis oe

ist waithour fs
15 non compliant facilities whers the P

has yet to enter facility information

h PWS that have not submitted a complete sample schedule to the LT2 Data Collection

Facilities that have not submitted a valid sample schedule Grandfathered samples of Sample Location Plan

DCTS for States and EPA 33

February 2008


E 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

Syste:

The system recognizes you as an approved user for the following applications, please select a system (0 launch.

IDSE Plan/Report Entry
Launches IDSE Pian/Report Entry, which will lead you through filling out and submitung your IDSE Plan or Report

E.2 You will arrive at the “IDSE Plan/Report Entry” page (See Figure 2).

Figure 2
Baers

4p reonet Welcome to the PI ort Entry Home page!
Enuy

Select ne Plan ot Report type you would ike to work on and click Go to Entry to begr
you are net sure which Plan Report apples to you ars a yz thal wil assist you m determining your specifc requuternents: The IDSE

Lhe Wizatd sa web-based smart joo! vequiring Be Macromedia Auharware piug.in to assist PWSs in determining their IDSE requirements
Dowinad me foe bars Alunvate plain rom mactotneda cam

. “The on.tne etry portion for the !OSE Reports vallbe available in the Fa of 2006 you wsh to work on your Ensting Morutonng Resuis IDSE
Report or you IDSE Report for Modeing SSS por to when i 16 avarlable, select the appropniate radio button and cick "Go to Repo

Entry” (may fake some bme to toad) The system wil open a PDF form template n a new window. The PDF templates were designed for he

IDSE Tool- CD Version and make several -eferences to additional forms available via CD. yourequute the additional forms referenced to

‘Meet your required number of monitoring sites. access ‘he ILS Hos. page to downioad the forms youneed. Aermatwely. you can contact

EPA at stage2mdbp@depa gov to request these forms

Note You wil need to instal Auobe Haste
Professional 70

J tc access these forms Also. you will nol be able to save this form unless you have Adobe

pws bere
PWS Nats EZ to 1
scheause Senedule 2
Pian Due Date 94012007
Report Lue Uate 97.01:2008
salar Mer
Recuivoments: Summary Sheets system 2p (vesting Monteong,

mest abet fs SSE yada, AEN C88
Select Pign Type Select Report Type
4030 Gernticanon Standard Montonng Repost
Stunlaid Mantoring Plan System Specike Stunly Report Modeling
System Specitic Study Modeling System Spaciie’ Study Reper . Encuag Mantaning Resa:

species Study. Cxsting Muntoneng Result

GetaPien Eniey Gato Report erty,

DCTS for PWSs: Stage 2 19 February 2008


DCTS for States and EPA 54 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

gout

[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

D.2 You will arrive at the “IDSE Plan/Report Entry” page (See Figure 2).

SE TOOLS

law Revert

Ener

Helo

Figure 2

Plan / Report Entry Home

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 begn
#¥you are not sure which Plan’Report apptes to you aucss a wizatc that wil assist you in determining your specific requirements The IOSE
Wieard is a weo-based smar survey tool requring the Maciomed-a Authorware plugin to assist PWSs in determining their IDSE requrements
Dowload the free Macromedia s Auinotwate plug-in rom macromedia com

‘The on.tine entry portion for the IDSE Reports willbe avaiable m te Fal of 2006 if vou wish to work on your Existing Mforutonna Resuts IDSE
Renort or your IDSF Report for Modeling SSS prior to when iis available. select the aparonmiate radko button and cick "Go to Report

Entry” ray take some time to joad) The system wil open a PDF form template ina new window. The POF templates were designed for the
IDSE Too! - CD Version and make several references to additional forms available via CD. f you require the additionai forms referenced te.
meet your required number of monitoring sites. access the INSE Home, 22:8 to downkoad the forms you need Aternatvely, vou can contact
EPA a: stage2ndop@epa gov to request these forms

Note’ You wil need to instal Adohe Reader 7
Professional 70

Dp access these forms, Also. you wit nt be able to save this form unless you have Adobe

pore
PWS Manne 2zlest 1c
Sehectle ene aule 2
Plan Due Date 040012007
Report Due fate 0770122008
ewan fat
Requirement Sumerany Shoots, mi Specie Slo (Emehing Marstons evade 0 Mowing

reficstan

en, Me etluclzons tor Systm lAAAND, Mchigan, cme age
Select Plan Type Select Report Type,
40:90 Certticavon Standarel rv
Standard Mantonng Pian ©. System Specie

Systm Speuie Siudy Modeling System Spwcitic Study Report - FxIsng Monrtosiog Resuts
Siysinrn Sipecitic Study - Bysting Montoning Resu,

cote Pian enix, G9.39. Report Box

DCTS for PWSs: Stage 2

15

February 2008


DCTS for Laboratories 10 February 2008


DCTS for States and EPA 4 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).

[Systems I

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 toad 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 Entry Home

Welcome to the Pian/Report Entry Home page!

‘Select the Pian of Report type vou would tke to work on and cick Go to Entry to begin
you are not sure which Plan’Report apotes to you accoss a wzsid that wil assist you in determining your specifc requirements The IOSE
\Wieard is a web-based smart survey tool requinng the Macromecta Authorware plugin to assist PWSs in determining their IOSE requrements
Downioad the tree Niacromedia’s Autnonware pkxpsn ftom macromedia com,

‘The on.ine entry portion for the IDSE Reports wil be avaiable in the Fall of 2005. yau w'sh ta work on vou" Existing Monstoring Results IOSE
Report or your IDSF Report for Madeiing SSS prior fo when its available. select the appropiate: radio button and click "Go to Report

Enicy" (may take some time to ioad) The systema wil open @ POF farm tempiate in a new window The POF templates were designed for the
IDSE Tool - GD Version and make several references to additional forms availabie via CD. If you require the additional torms referenced to
meet your required qumber of momionng sites, access the |NST Home page to dawnload the forms vou need Atematvely, you can contact
EPA al stage2mdup@epa gov to request these forms

Note. You wil need to instal Adobe Re
Pro'essional 70

ito access these forms Also, you wil not be able to save this form unless you have Adobe

‘General information

Pwsit pete
PWS Name zziest 1
Scheaute eneanas 2
Pian Due Date a01-2007
Repon Hue Date r02008
anes tonite bee
Resaremenrs Suminary Shvets sting Rébotig Rersute  feut

ouch suchen tr ystems mindhans, Moctigan, to, ati a
Select Plan Tyne Select Report Tyee

49/90 Contdication ‘Standard Montoting Report

Standard Blontaning Pan System Specie Study Report - Modiebng

System Speci Study Modeling Syste Specke Study Report beng Montoning Rests

Siystem Specie Study Fastin Moratotng Rests

Ge te Plan entry Gow RevonGeny.

DCTS for PWSs: Stage 2 9 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).

Reports: Missed and Re-sampied Events.

bos | Dee SETS!

Missed
Sampling
. [Date
Range

Sample
Subminal
Date
Range

(3)
mI

PWS Facility

Hissed
Sampling Date

Sampie
Submittal Date

Date Re-sample
Coltected

System 1 — XX0000000 | TP#5

12/12/2007

12/13/2007

System 2 — Xx0000001 | Reservoir

42:11/2007

12:28:2007

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.

DCTS for States and EPA

45

February 2008


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.

LT2 Submission

“Date Received [Plan Copies [Held By
osrosi2006. | . fipue

[Document Type ~T*submissian Status

swe) LT2-Sample Location/Schematic ~|| Received ~ |e
{Select eS , :
| LT2-Grandfathered Data $ Date Assigned ssigned
|12-Sample Location/Schematié ft Status for Review Reviewer _|Pate Approved
06/06/2008 | gap tq | 96/06/2008

<

| WA ~ Approved =| =

| Last modified on 2006.06.06 20.31.37.0 by gonder02_gonder
CONFIRM CANCEL

Submission History

[Document Type [Submission Status [Approval Status [User Name Mocified Date
LI2-Sample LocationSchematic __|Receved ‘Approved gonderG2 gonder [2006.06.08 20.27 150,
LT2-Sample Locaton'Schematic _ [Received Approved gonder02 gonder _|2006.06-08 20 28 48 0

Follow-up Contact

[Date ~__ [Status - User Name Assigned To

ima Select ¥

Purpose Notes
[Date Purpose Notes Status ‘(UserName —==———sdfAssignedTo

| = |NA Jeff Butensky
| WA Jeff Butensky _

February 2008

DCTS for States and EPA 29


DCTS for States and EPA 38 February 2008


T. How to Generate a Binning Report
=

T.1
T.2
T.3

T.4

T.5

T.6

T.7

To generate a binning report, select the “Reports” icon in the “LT2 Data Collection System.”
Select “Binning Reports” from the list of reports.

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.

To generate a binning report for a specific PWS, enter the PWSID in the field at the top of the screen and select
“Search.”

Select the printer icon in the top right corner of the screen to print the report.

‘Reports: PWS Binning Report

[pws 0 | ones I

vith current calculated
wu to download this informatiot
nload the current calculated bin .slues for all
‘ay search for a facility fe

By default. the

in be imported

Pieage see the notes beiow the table regarding bin value calculations

PWS Facifity Name Total®] Curent Cyeptosporidium Bin | Cateulation
Samples Concentration Method

System 1 — XX0000000 TP#S O48 Rolling Annual
Average

System 1 — XX0000000 TREAT Ald 6.125 Rolling Annual
PLANT Average

System 2 — XX0000001 TREATI jaded G4e Rolling Annual
PLANT #2 Average

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 "O 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.

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.

DCTS for States and EPA 43 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 usc 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 necd to submit sampling schedules and sampling
locations, approve sample results, and work with the laboratories conducting their
Cryptosporidium and E. coli 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.


C C How to Generate a LT2 DCTS Usage Report (EPA Only)
.

CC.1To'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.3This 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.

Reports: LT2 Data Collection System Usage

f Update Report 5 See a

07:04-2003

DCTS for States and EPA 61 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.

> = Required Field

Please enter the following infomation -egarding this notice

Please select available notices 4 tw
‘Notice Name

‘Letter Type Official oy

“Notice Sent Date

Received hy PWS Date

Retumed Date

“Description
Smasimum 290 char

File Name

File Date . “=
Eniry Date Oct s 2007
User Hame gender02 gender

RETURN TO NOTIFICATION LIST SAVE AND CONTINUE 9 <a

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).

. MIEW/EDIT PROFILE VIEW SUBMISSION STATUS
ee, Pus ame . ee i ae Tae g f

ee ae 2 ics ae eee
(1 [ARTESIAN WATER COMPANY
w——p [©] [SOUTH BETHANY DEGOANS23
+ UNITED WATER DELAWARE: DEon00s64 471
oO i DECo00sE3 9599
he oe fee

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.

DCTS for States and EPA 22 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).

Confirmat
Your Plan / Report was submitted successfully! Please print this page for your reference

Confirmation # A
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:

Mailing Address:
US EPA-IPMC

PO Box 98
Dayton, OH 45401-0098

E-mail Address:

stage2mdbp@epa.gov

Heme

DCTS for PWSs: Stage 2 18 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).

72 Supmissicn

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.

Fi

Do not review LT2 Submissions until infermaticn fer all facilities has been upleeded
RETURN TO PROFILE

Monitoring Plan

‘Pian Type% |’ Submission Status ¥ Date Received & [Plan Copied Held By
MP-40/30__v | Received - Complete vy fizc32007 Tal | Select v
Triage ‘Approval Status ¥% pas Assigned for assigned Reviewer [Date Approved

¥. | Approved v m3 Select ov 12:14:2007 =}

G08 BOOTOE-G 45.72.27 O by Stacy pero

{ CONFIRM €ANCEL
* Required Fieia
17 February 2008

DCTS for States and EPA


DCTS for PWSs: LT2 18 February 2008


E.4. Select the “Save” button at the bottom of each screen (see Figure 3) to store your changes.

Note: Stage 1 Data (.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 @ 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 POF file

+ Sample location plan/schematic
+ ANotice of Intent ta Provide Maximum Treatment (submit you intend ta waive monitoring and proceed ta BIN 4 classification)
+ Aplan of action for uncovered finished reservoirs (must be submitted to EPA within three years of rule promulgation)

DCTS for PWSs:LT2 14 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).

VIEW/EDIT PROFILE VIEW NOTIFICATIONS <Gee VIEW SUBMISSION STATUS

JON ELEME:

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

| Windows Internet Explorer.
|

Its 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 PW3s from
your search results (up to 500) in your batch update? IF yes, click OK. IF you prefer to enter notifications ONLY For
the PWSs you selected, click Cancel to continue.

(cra)

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.

PWS Notification Records for - SAND HILL ACRES

Click the hyperlinked Notice Name to edit information for a particular notice To add a new notice fer this PV. ck the Add Notice link
at the bottom of the page

[{Noticettame io] Lettertype [| Wotice SeniDate |” “Descnpiion | Fieclame” |“ PiieDate
[There are no novices is

Return to PWS Profile Return to PWS Results

DCTS for States and EPA 21 February 2008


DCTS for PWSs: Stage 2 February 2008


N

How to View a PWS’s LT2 Sampling Dates

N.1 Enter the “LT2 Data Collection System.”

N.2
N.3
N4
NS

Select your organization (state or EPA Region).
From the toolbar located on the left of the screen, select “Sample Dates” icon.
Select the PWS and facility (see Figure 1).
Select the frequency for which you want to enter sample dates (e.g., individual, weekly, monthly, etc.) for each

facility (see Figure 1).

Select the facility you would like to viewlenter sampling dates

Pws

Z2Test 1a-DC1a

Facility

billietest1 ¥

[Method

© Individual Date Entry - one date at a ime

“> Weekly Date Entry - recurrence pattem for a specific weekday

<> Monthly Date Entry - recurrence pattem 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 function wall not be automatically subrutted to EPA, Requests to change sampling schedules after this date must be
submitied to EPA in writing

Click the Save Sampling De

‘individual Date Entry

Month v Day ¥ Year +

button after making your selection to display the dates

Please nete that the system does not check for holidays or weekends,

You must manually very the samping dates and make the appropnate changes

Save Sampling Date <@
Remove Sampling Date Tf

Edit Sampling Dave
Remove All Dates {iif

Sampling Dates
July 14, 2006 - Friday “
August 18. 2006 - Friday
September 15, 2006 - Friday
October 13, 2006 - Friday
November 17, 2006 - Friday
December 15, 2006 - Friday
January 19, 2007 - Friday
February 16, 2007 - Friday
March 16. 2007 - Friday
| April 13, 2007 - Friday
May 18, 2007 - Friday
(dune 15, 2007 - Friday a

To modify the aboxe information. select the desired date
use the buttons to the left 10 remove or edit the date, To v
cchedule, click "View:Pnint Sampling Date

ret

«q A
aa iewPrint Sampling Dates gt! eam

*ronseanntmnenr
Save and Exit

N.6 Select “View/Print Sampling Dates’ to view or print all of the sampling dates.

DCTS for States and EPA 31

February 2008


DCTS for States and EPA 52 February 2008


DCTS for PWSs: Stage 2 - 24 February 2008


State OH ¥
PWS | OH3-02672 - CINCINNATI PUBLIC WATER SYSTEM ee in
Facility | TP - CINCINNATI PY/S MILLER PLANT ¥

Currently editing : CINCINNATI PWS MILLER PLANT - TP1
1. PWS intends to submit grandfathered data

Notice of Intent to Grandfather Yes
submitted "

View Intent te Grandfather Fo:

Date EPA received Intent to Grandfather agsoaopg5 =a
b 06/29/2008 ‘a
© Borm immiddeyyyy)

Number of grandfathered samples to be 75
e 72

submitted ———
g Date range grandfathered samples te be

submittedimm/dd yy star 91.972002 eng 7226/2004

© PAS intends te submit additional samples

f Number of additional samples to be
submitted

4G Urload grandiathered data se, | Biowbe)
Please ensure the PVyS ID and facility name are in the files you upload

“Note. All grandfathered data must be submitted to EPA (via email or mail) either in MS Excel spreadsheet ( xls! or text file
{tat} format Do not submit files in the xmi file format that is used in the lab sample upload module

Sending hardcopy grandfather data by o
mail

2. EPA receipt of sample jocation plan Received - under revi

a Upload sample location plan (Browse)

Please ensure the PS ID and facility name are in the files you upload

Sending sample location plan'schematic by

mail
3. EPA review of sample schedule Received - under review ¥
14, PWS intends to waive monitoring and o

* proceed to BIN 4 classification

Date EPA received Intent to i
Monitoring immvdd

5, PWS has uncovered finished reservoirs Oo

a Uncovered finished reser-oirs Add a Reservoir

Note Stage 1 Data (ie TTHM and HAAS data} will not be dynamically loaded inte 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 manitering data should
continue to be transferred to the Agency through SDWWIS or another State database or through the nermal mechanism that
States employ :

ipmission Tracking

DCTS for States and EPA 28 February 2008


DCTS for Laboratories 8 February 2008


DCTS for PWSs: LT2 20 February 2008


DCTS for States and EPA 10 February 2008


A Step-by-Step Registration for DCTS for New CDX Users

Steps A.1 - A.17 need to be completed for registration. Once th: word is setup, go to A.19.

A.1 Go to: http://Awww.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. Read the Terms and Conditions and click on “| 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: A
A.9 Select “LT2: LT2, Stage 2, and IDSE Plan/Report Entry (LT2)” (see 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): °°
SEE STEP ‘Ozone Depleting Substances (ODS):

Ad. Radionuclide NESHAPs (RAD):

Resource Conservation and Recovery Act Site ID (RCRA)

Stormwater Notice of intent (eNO!) (SWENO!)

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.

L jing into th Hlecti i T:

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 1 February 2008


D How to Search for LT2 Samples
a

D.1__To search for samples for a water system, select the “View Samples’ icon Onin the LT2 Data Collection
system.

D.2 Select “Cryptosporidium” or “E. coli’ and set search parameters (see Figure 1). Select “Search Samples” to
view a list of samples for the system.

Plaase enter as much data as possible to limit the search to a targeted set of results,
Lerge data retrievals can produce problems with the display of the results.

someone Cryptosporidium — © & coll YY Select Method

CIPWS Inventory Data Facility: ~ Sampling Point ¥
CO Status »

[2] Lab Approval Date Stan 10/13/2006 Eng 11/13/2006

C] Sample Collection Date} Start End

D3

§ TER SAMPLES Boy
soumiem | ews | pws aca

oO sig iN DCth TP1 SPI 11/08/2006 11/08/2006 GONDERO2

Pending Release

ome | Of KN focth| ter SP1 10/16/2006 10/13/2006 DARINDAL

Returned by PWS
[There are no samples currently associated with this status,

| Delivered to PWS
oO IN OCtv TP SP 1106/2006, 11/06/2006 GONDERO2

D.4 Water systems will not be able to see samples under “Pending Release.” They will only be able to see
samples under “Delivered to PWS” and “Returned to Lab.”

DCTS for Laboratories 9 February 2008


DCTS for States and EPA
Contents

LT2/Stage 2 Tracking System

A.

roOmmooD

o>

How to Search for a Public Water System .

How to Create and Assign a New CDS ID.

How to View or Edit Public Water System Contact Information ...........:.ccccccsseeseseteseeeteeccssssssseeeeeeceteeseesenteeees 7
How to Approve an Alternative Schedule 9
How to Upload a Submission Received from a Public Water System. .........cccccessceseseercesesesesseasetsesteeseeeees V1
How to View a Public Water System Submission ...........:cccseeseseseesesteeeeeesseeseetenescerneeneeeesrsesatecssseneasseass TO.

How to Generate a List of Received Submissions

How to Approve Submissions .

How to Approve a Batch of Submissions
How to Add Notifications 0... cece ccccccceeseseenesessenesenesssnensssencseseaencsesesssusuenesssssssnsrenesesssnsseacssansneseseasaeentees 241

LT2 Data Collection System

K.
L.

M.
N.

How to Approve DCTS Users (Administrative Users OMMy) oe eeseeeee eect eee e ee eeeeeeee

How to Search for a Public Water System’s LT2 Samples
How to View a Public Water System's LT2 Grandfathered Data and Sampling Locations
How to View a PWS’s LT2 Sampling Dates

LT2 Data Collection System Reports

S<cHwADDO

How to Generate a Report in the LT2 Data Collection System
How to Generate a Sample Tracking Report ..
How to Generate a Sample Backlog Report ..
How to Generate a Sample History Report...

How to Generate a PWS Schedule Submission Compliance Report.
How to Generate a Binning Report 2.0... ccccceceseesesencesesssceseeeeseeaeseneensvassenenenseesacesseeeeesecaeeeteneeeesaseeeneees
How to Generate a Missed and Re-Sampled Events Report
How to Generate a Grandfathered Data Report.

How to Generate a Monitoring Waived Report..

DCTS for States and EPA February 2008


DCTS for Public Water Systems:
LT2

“EPA

United States
Environmental Protection
Agency


M How to View a PWS’s LT2 Grandfathered Data and Sampling Locations
a

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. ee
M.4 Select the state, PWS, and facility (see Figure 1).

M.5 Select “View.”

and cick Wei
commode | State OH y

vomewat> 1 PWS OH3702672 - CINCINNATI PUBLIC “VATER SYSTEM ¥

wet |Facility | TP7 - CINCINIATI Pv'S MILLER PLANT ¥

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.

DCTS for States and EPA 27 February 2008


DCTS for States & EPA

EPA

United States
Environmental Protection
Agency


K. How to Approve DCTS 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).

LT2 Data Collection System “===

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

LT2'Stage2 Tracking System

Launches the L72 Stage 2 Tracking System for compliance tacking, notification wacking. and reperts

K.3 Select your organization (state or EPA Region) (see Figure 2).
K.4_ Select “continue.”

Ee ~ <———
[Region * - 07+

(Region 5

‘Region 2-02

Nu GOH TINUE —

K.5 From the tool bar to the left select the “Update Users” icon. é ha]
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


DCTS for States and EPA 8 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).

Select Plan Type
~) 40/30 Certification
_’ Standard Monitoring Plan

2 System Specific Study - Modeling

- Existing Monitoring Results

Go to Plan 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.

DCTS for PWSs: Stage 2 26 February 2008


Figure 5

Existing Monitoring Results System Specific Study (SSS) Entry
VII & Vill Schematic & Attachments

General Information

IL SSS Requirements
Select Browse to locate the file you would like to attach to your plan. Click Save to upload your Hl Peak Historical Month
attachments. The following file types are acceptable formats for your attachments: xls, doc, jpeg, 1V. Prev. Monitoring Results
aif, jpg, txt, .wpd, and .pdf. All systems must submit a Distribution System Schematic with thgt tA -Lacatio
plan unless they have selected the option to send by hardcopy. ("= required field) ! Part A-Lacation
i Part B Method
"Distribution —S Pat ¢ - TTHM
System Schematic (Browse... J Part D - HAAS.
7 *~ V. Cettification of Bata |
Attachment Name: VI. Proposed SSS Monitorin
bates
oe \ WIA Vill Schematic &
Attachment Name: \\) Attachments
- (Browse. | \ Quest Sh

E.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.

E.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.

E.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.

Sending Attachments by Mail
Enter a description of the items that will be mailed

9, SUBMIT GENERATE PDF

E.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).

DCTS for PWSs: Stage 2 22 February 2008


Please enter the following information for the Favitity
PWS Facility ID : *
Facility Name —_ ee 7 +

vow

Facility Status

Eacility Type v
Water Type

Filtered Yes Yoox

Cour system has na separate facility IDs

* Required Field

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).

Please entet/review the following information for the Sainpie Collection Point, which is telated to the above Facility.
Sample Collection Point

uu Name

(our system has no separate sample paint IDs

$ = INSERT NEW SAMPLING POINT
oom INSERT OSITE POINT

(for samples comprised of water collected from multiple source:

After you have completed this information please remember to enter 2 sample schedule thdecefleat® 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.

DCTS for PWSs: LT2 10 February 2008


State Preference Table for Stage 2 DBPR 40/30 Certification Supplemental Information

(As of January 2007)

Under ine Stage 2 DBP, EPA or the
Jitiona! information can be! Stage 1 Ceta, Recommended
requesting adaional matenal be sent with the request tar

abe may request additonal information te be submitted by systems to support a request for 40080
age 2 monitoring lycabons, and systern schematics The t
20 Cemfication. The checkmark indicates maten al that needs to be submrted,

tification Such
love identities which

States are

Recommended
Region | State Stage 1 Data Meenonng ‘System Schematic Comments
Locations
ct
ME q q v
1 NE 5
Ma 7 T
El 7 v v
7 ¥ 7
7
2 v
Z ¥ v
¥ v v “
a wo
FS a v y
Ww
T t 7
q T
q v
Y v
4 T 5
q v
v v ¥
q u y 7
qv a ¥
q v 4
5 Y Y 7
a q y
iu Ei ci
6
v v
7
NE.
8 SD
OT
wi
Tribal
; lage 1 dota nct requred t
Ae v ‘ u previously submitted
TA
HE
NV
GU
EX
Tst Ter
CN
Ai 7 v
10 i T 7
OR i ¥
WA 7 7
DCTS for PWSs: Stage 2 13 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.

D8
“Next” to move to the next section.

Figure 3

Standard Monitoring Plan Entry
VII & VIII Schematic & Attachments

attachments. The following file types are acceptable formats for your attachments
gif, jpg, txt, .wpd, and .pdf. All systems must submit a Distribution System Sch
plan unless they have selected the option to send by hardcopy. ( = required field)

“Distribution

System Schematic Browse. KN
Attachment Name
Browse. |

Select Browse to locate the file you would like to attach to your plan. Click Save to upload your

Select the “Save” button at the bottom of the page when you are done entering your information. Then click

j ‘
f iy Std. Mntry Site |
xls, doc, jped
yematic with wel

Amchments
\ Preview Submit

Nw

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 change:

s. If you need to make a change to your

Standard Monitoring Plan after it has been submitted contact EPA at stage2mdbp@epa.gov.

Sending Attachments by Mail
Enter a description of the items that will be mailed

ce

comely SUBMIT GENERATE PDF

DCTS for PWSs: Stage 2 17

February 2008


DCTS for Laboratories 12 February 2008


DCTS for States and EPA 58 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.

Reports: Sampie Location Plan Compliance

Status} All

PWS Status

Svstem 3 — xxnnnnnn?
Svstem 4 — xxannnnn3a

Svstem 5 — xxonn0nn4
Svster 6 —XxN00NNNS _

Received - under review

Received - under review

nder review
8 oo North Anna intake Hot Received

DCTS for States and EPA 51 February 2008


B Step-by-Step 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).
‘DX Registration: Add Program

Leay-Based Paint Activites (LEAD)

> CTF

Stage 2, and IOSE Plan/Report Entry (LT2)
HaaionacTdE NESTAPS AD)

Resource Conservation and Recovery Ac\ Site ID (RORA)
Stormwater Notice of Intent (ehOb (SWENOH)
Toxle Substance Contiol Act- HaSD Form (TSCA'HASD)

Compliance Information Systems (VERIFY)

Request Manufacturer Cade for OTAD Compliance (VERIFY MFR RES

Water Contaminant (nformation Toot CIT)

(New>”

B.5. Choose your role from the drop down menu (see Figure 2).

CDX Registration: Add Program [D

Use the TAB key to move from field to field. * ~ &2 QUIRED FIELD

Role. ASUBMITTER |

Program ID Type: Standard ID. *

Submission Method: WEBFORM

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.

ing i lection and Ti ing System (DCT:
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: LT2 5 February 2008


y. 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.

Reports: Sample Pair incompiete
par
a neomp'ete 35: issota =.
A
pws PWS Contact Lab MA fraive | Sample celtention
9 Date
| System 4 — Kid FORTHER noemail@epa go. 99% | Lab 1 Cryptospondium [2s4 [19082006
ikl FOR
XX0000003 soeeses Cryptosperdun 10:09°2006
System 5 — -|Lab 1 Cryptospendium: 14/20/2003
xx0000004
System 6 — Lab 2 ‘Cryptosporidium {844 4017/2008
Xx0000005 2 coll B44 10-16-2008
2 call ass [1218/2006
€ coll B44 0116/2007
@ coll Bas __(fozag 2007
@ col eas [og 1g 2007
fe col eat [ose 2007,
fe coli ass [aseia.2007,
fe coli B44 05/21/2007
fe col aaa a7
fe coli aay fawir2007
fe coli asi [vii9:2007
fe eali aay [iai72007

DCTS for States and EPA 53 February 2008


Existing Monitoring Results System Specific Study (SSS} Entry

1, IDSE General Information

Please review the information provided below, if you feel any of the information displayed is incorrect / Hl. SSS Requirements
and you ate unable to change it please contact your State or EPA representative Ill, Peak Historical Month \

IV. Prev. Monitoring Result:

“PWSID pete j Part A. Location
ie WS ve iTrest Ie | Patt B . Method \
ess 5
" aridress / Part ¢ . TTHM
| Pant D HAAS |
*City city \ V. Certification of Data
4 Vi. Proposed SSS Monitorin
“State po | tins 1 i
“Zp 20460 A. Vil & VIM Schematic &
"Population Served 400 Ye iinet
*Systern Type CWS: Paview Submit

ater Type Swe
“Buying ‘ Selling a
Relationships Select

C. PWS Operations

Residual Qisiniectam Type — £2 Chionne £) Chioramines [— Other

Number of Disinfected Surface Swunl

Sources Ground Purchased 1
D. Contact Person

“Contact Name John Doe

Title

Phone Number (855) 555-5555 ext
Fax

E-mail Address jdoe@watersystem.us|

| somemenii> save NEXT BACK CANCEL

—.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.

DCTS for PWSs: Stage 2 21 February 2008


~ DCTS for States and EPA

LT2/Stage 2 Tracking System

>

Hr rommonp

How to Search for a Public Water System ............0-cscsessessesseeseesesseeseesesececsresecaveneeseenesuesnesneeisssseeeceneenees 1
How to Create and Assign a New CDS ID... eccecessesscssesseesessesreseceesseesssnesucneesesaesnesacsueaeeseesneaeeneeneenees 5
How to View or Edit Public Water System Contact Information .........c:ccscsssesseesessesseeseeteeneseestencencensenees 7
How to Approve an Alternative Schedule.........sccccccecsssssssssessecesessssessessesseersarsarsstsansaesneeasseeesateneeeseeeed 9

How to Upload a Submission Received from a Public Water System.
How to View a Public Water System Submission

How to Generate a List of Received Submissions

How to Approve Submissions
How to Approve a Batch of Submissions...........ccccssecsesseesseersecsseeseeereesessseeseessecssessesseessecsseeseeeaeensessnees 19
How to Add Notifications .........cccscessessssseesseessesseessseseessecsseesseessesssneeseesseesesssessnesseesesseeneeseeeseesueesiess 21

LT2 Data Collection System

K.

L.
M.
N.

How to Approve DCTS Users (Administrative Users Only) .....c:sccsssessessesesesssessseeseestesseessetsessneesnesneese 23

How to Search for a Public Water System’s LT2 Samples
How to View a Public Water System’s LT2 Grandfathered Data and Sampling Locations
How to View a PWS’s LT2 Sampling Dates

LT2 Data Collection System Reports

2<cn"% 7070

How to Generate a Report in the LT2.Data Collection System ..........cccccssssessseseseeseesseeeeseeeeeeeeeensseees 33
How to Generate a Sample Tracking Report..........c.cccecseesseeseeseseseceescseseeeeesnesessenssssneessseseeeaesneaeeren 35
How to Generate a Sample Backlog Report.............cccccecsssessesesesseseseeneseseenenessseesceesesesssesseseseeneaseeseenen 37

How to Generate a Sample History Report
How to Generate a PWS Schedule Submission Compliance Report

How to Generate a Binning Report
How to Generate a Missed and Re-Sampled Events Report ..........sc:ssssssessessesseecsecsnseseesseessesseeseceneessees 45
How to Generate a Grandfathered Data Report .........csecsssessssssessesseseesesscsscsecsnsanenesnsaneenssnssnsateareneeneeneeed AT
How to Generate a Monitoring Waived Report ............ccsceecsesseseesessesseeesessecsecsessesnesnceerensenesesseeereneeneaed 49


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)

User Profile

+ = Required Field

he folowing information is provided by COX. f you fee! any of the information is incorrect, please access CDX to update verity

‘Save and Gontinue 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).

B.29 A new field “System Type” will appear; select “Both” (even if you only need access to one of the rules)

Figure 3

Please enter your Organization ID and click "Lookup Organization.” The "Lookup Organization” link will be replaced with a "Request
JAccess" link and an "Undo" link. If your correct organization is displayed, click "Request Access." I you have incorrectly entered the

Jorganization ID, click "Undo" and repeat the process, If you are an E. coli laboratory and your lab is missing from the list of organizations, |7

please click “E. coli Lab Registration.”

1" 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 |e

ine system list. Otherwise, you should enter the PWSs organization code in the Program ID field when registering via COX.

Organization Code SEE STEP
~~, en

E.colilab Registration Edit User Information Save and Continue Exit Registration

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.”

UserName [one
First Nano one
SEE Last Name Ss 4
STEP
B24 "State UN
Phone Number ae ere
“Email Address prareeconewnae com

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


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 Oo in the LT2 Data Collection
system, located on the left side of the screen. ®&

H.3 Select “Cryptosporidium” or “E. coli’ 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.”

"Please err es much data as possibleto limit the search to @ targelad Set of results.
Large data retrievals can produce problems with the display of the results.

semeee (> Cryptosporidium << & coll © Select Method

CIPWS Inventory Data Facility ~ Sampling Point. ¥
CO Status v

Lab Approval Date Stat 10/13/2006 _ End 11/13/2006

(2 Sample Collection Bate] Start End

o

¥

SEAR

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 Laboratories 2 February ‘


DCTS for States and EPA 62 February 2008


IDSE Submission

Confirmation Page
‘Your Plan / Report was submitted successfully! Please print this page for your reference

Confirmation # 1

Date Submitted. 08/11/2006

f you have selected sending by hardcopy in the Attachments section ot 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:

US EPAIPMC
PO Box 98
Dayton, OH 45401-0098

E-mail Address:

stage2mdbp@epa.gov
Home

DCTS for PWSs: Stage 2 29 February 2008


Individual Date Entry
i

: Sampling Dates
July 14, 2006 - Friday *

Month Day ¥ Year v _*l ‘August 18, 2006 - Friday

September 15, 2006 - Friday

Cdk the Save Sampling Date button ater making your selection fo display the dates Oetober 19, 2008- Fray

Please note that the system does not check for holidays or meekends.

‘You must manually veity the sampling dates and make the approptiate changes. January 19, 2007 - Friday

February 16, 2007 - Friday
March 16, 2007 - Friday

April 13, 2007 - Friday

May 18, 2007 - Friday

June 15, 2007 - Friday ye

To modity the above information, select the desired date and
use the buttons to the left to remove or edit the date. To view
oF print the above schedule, clide"ViewPrint Sampling Dates*

+
somcenip — Save Sampling Date
semen Remove Sampling Date (7

to the left
Edit Sampling Bate &

View Pr

npling Dates
Remove All Dates EP

Save anil Exit

DCTS for PWSs: LT2

12

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) :

User Profile

+ = Required Field

The following information is provided by CDX. If you feel any of the information is incorrect, please access CDX to updateiverity

UserName [Sean

irst Name

SEE “Lest Name es
STEP
A, “State w
payer
fp

*Emait Address rhanihgisoneatire com

:
|
|

J

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
JAccess' link and an “Undo” link. if your correct organization is displayed. click "Request Access." If you have incorrectly entered the
Jorganization ID. click “Undo” and repeat the process. if you are an E. coli laboratory and your lab is missing (rom the list of organizations,

please click "E. co Lab Registration.”

if you are an existing user and would like access to the IDSE Pian/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 COX.

SEE

Organization Code SEE STEP fad
~~ A27. Lookup Organization wh

E.coli Lab Registration Edit User Information Save and Continue Exit Registration

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: Stage 2 3 February 2008


‘Your Plan ¢ Report was submitted successfully! Please print this page for your reference

Confirmation # 1
Date Submitted 8/1 1/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:

Mailing Address:

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

E-mail Address:

stage2mdbp@epa gov

DCTS for PWSs: Stage 2 23 February 2008


F. 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 4 in the LT2
Data Collection system, which is located on the left side of the screen. =

F.4_ Select “Cryptosporidium” or “E. coli” 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.”

There ate no labs associated with your organization

Please select the contracting labs for your PWS. Select the type of lab you are looking for (either Cryptosporidium or E. cof 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 you
the first listing associated with that letter

“in 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

Whar type of fab ate you searching tor? ©) Cryptosporiaium ©) & eof anus
For what state? Aly me

AILS ABCOEE
Add [=
seed (1) [American Water - IL00028
Ol fAnaly

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 States and EPA 60 February 2008


B.4_ Anew 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.

ne

 hitps:#intranet.epa.gov/ll2/nextCDSId.d..
6, https: /fintranet.epa.gov/tt2/nextCDSId.do

ise

ID number is:

Your new CI

Please enter this number in the COS 1D column
for any PVYS you wish to assign 0 this CDS ID

close

© Internet

To retun to your previous search
to the beginning of your search resul

Select Batch Update Type Update PAS Profle

+ Wiew

click the "RETURN TO SEARCH RESULTS’ link Please note that this will return you
{and your previous selections on the result page will be removed

bia 2 CDS ID

Be 5 a a __ Retail Calculate Hance |
eae ae
ARTESIAN WATER COMPANY | 9E0000652 _| 200000 _ Compliance Schedule +
WILMINGTON WATER DEPARTHM| DE0000863 _| 740000 Compiiance Schedule + |

m= CONFIRA CHANGES

RETURN TO SEARCH RESULTS

B.6 Select the “Edit
DCTS (see Figure 4).

PWS Batch Update

link on the confirmation screen to edit your changes or select “Save” to save the changes in

[ Compliance |

ARTESIAN WATER COMPANY

200000

1051600029

Compliance Schedule 4

MYILMINGTON WATER DEPABIMENT [DEGOO0663

140000

1051600025

Compliance Schedule 1

¢ SAVE )

DCTS for States and EPA

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).

ee
" 0/30 Certification =?

tandard Monitoring Plan
System Specific Study - Modeling

. System Specific Study - Existing Monitoring Results

Go te Plan Entry

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. tf 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.

40130 Certification Entry
A. Submittee Information*

Certification info

Please review the information provided below, if you feel any of the information displayed is incorrect 5 Attachments
and you are unable to change it please contact your State or EPA representative Preview: Submit

PWS ID DCta
PWS Name ZZTest ta

PWS Address address

City city
State oC 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).

DCTS for PWSs: Stage 2 10 February 2008


A How to Search for a Public Water System (PWS)
=

A.1_ To search for a PWS select “PWS Maintenance” icon

left side of the screen.

Orn the LT2/Stage 2 Tracking System, located on the

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 fora PWS name you can type the name of the PWS, or part of the name.

PWS Name

CDS 1D

© {Letter Type

Oo

Notice Name

v

© |Region/State Code

(@ |Pws 1p

Oo

Stage 2 Compliance Schedule

Al ¥

im

PWS Plan Status -Submission Type

Alonits:

Plan/Report Type

AL v

Submission Status

Ret

Approval Status Al v

(| Triage Decision All v

(J |Stage2 Rule Requirements All _ v
(] |L¥2 Rule Requirements All v

(1 Include Closed Systems

A.3_ If the system is in DCTS, the name, PWSID, and CDS ID will be displayed in a table (see Figure 2). Check the
box next to the system name and select “View/Edit Profile” (or simply double-click the system name) to view the
system's profile. Select “Modify Search” to return to the home page.

DCTS for States and EPA

February 2008


Figure 5

Madeling Study Plan Entry

VIL & Vill Schematic & Attachments ane
HL. 1D: equirem

Select Browse to locate the file you would like to attach to your plan. Click Save to upload your Ml. Min, Model Requirement
attachments. The following file types are acceptable formats for your attachments: .xls, doc, jpeg, Part A.

gif, jpg, txt, wpd, and .pdf. All systems must submit a Distribution System Schematic with thei Pant B.

plan unless they have selected the option to send by hardcopy. (* = required field) Pan¢

Pan bh.
*Distributi ——, Part D.
System Schematic (Browse. J Peak Mth, for TTHHM
We V. Modeling infermation
~ \ eumsonnae Planned Stage 1 DBPR

Va & Vil Schematic &
ee

Attachment Name:

Browse.

ea

—

F.9 Inthe “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.

Sending Attachments by Mail
Enter a description of the items that will be mailed

women 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).

DCTS for PWSs: Stage 2 28 February 2008


Searched for
State DE
PAS Id DEDO

VIEW/EDIT PROFILE

VIEW NOTIFICATIONS

VIEW SUBMISSION STATUS

PWS ia

DEQOGO 102

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.”

© |PWS Name

© |cpsip

© |Letter Type Select Letter Type ¥

© |Notice Name Select Hotce ame ¥

a

Region!State Code

All DE vem

OD |pwsip

DEDGON002 ¥

Stage 2 Compliance Schedule

Compliance Schedule « v=

(2 [Pws Plan Status -Submission Type

Monitoring Pian

Plan/Report Type All v

Submission Status Recelved - v

Approval Status All v
(1 JTriage Decision All

(1 |Stage2 Rule Requirements

All

( |LT2 Rule Requirements

All

1 Include Closed Systems

—P sa

RCH “BESET

ee

A5 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


Q How to Generate a Sample Backlog Report
=

Qi
Q2
Qs

Select “Sample Backlog’ from the list of reports.
The sample backlog report displays the displays the number of sample results pending laboratory approval and

To generate a sample backlog report, select the “Reports” icon in the “LT2 Data Collection System.”

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).

Q4

Select the printer icon in the top right corner of the screen to print the report.

mae

Laboratory Name

sults Pending Revi

Fotal

iypiosporidiain

Anytime

samples and $1 = co! samples

oy 169 sample results have been pending PAYS rea

for moe than tio weeks This total value inclu

sccm PAS Name

PWSID

Compliance Group 1D
Tacal

Sample Resuits Pending Review"

Cryptosporidium

ANN AR

ATLL

ERIILION COUNTY

MENTOR

DCTS for States and EPA

37

February 2008


DCTS for States and EPA 40 February 2008


DCTS for Public Water Systems:
Stage 2

ai
Secale

ant ey X

ees ;
parser,

EPA

United States
Environmental Protection
Agency


DCTS for Public Water Systems: LT2

How to Search for LT2 Samples

Contents
A. Step-by-Step Registration for DCTS for New CDX USEPS ..........c.ccceccceseeteteeeesesteseseeeeceneessestensneteieetsteeceeeeeee T
B. Step-by-Step Registration for DCTS for Current CDX USePS .........ccesccccececseseeneeeesseetetensserssneresesesesteeeecsetieeses
C. How to Add a Facility and Sampling Points to a Public Water System............ccccscceteees ie eeteeeteteeeteteeeeeees D
D. How to Enter Sample Schedules....
E. How to Enter Other LT2ESWTR Data
F. How to Identify Contracted Labs (Administrative Users Onlly).............:.:ccccccceeeseseseeeeeessseeeeteeeeseseeeeiteneretees 15,
G. How to Approve Standard Users (Administrative Users Only) ...........:cc:eccccsceccesnesescsnensseesseenenesersensseesnenses fe 17
H.
1

How to Approve, Contest, or Return a Sample to the Lab.

DCTS for PWSs: LT2 February 2008


Zz 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.

There are 5 facilities across 3 PV/Ss in non-compliance

pws . Facility Gaimple Schedule sample Location
System 4 — XX0000003 TP1 Ne Ne
TP #5 Ne He
System 5 — XX0000004 | Water Purification Ne ne
| Facility
TP 1 ue ue
System 6 — XX0000005 iP Ne
DCTS for States and EPA 55 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).

Confim:
Your Plan / Report was submitted successfully! Please print this page for your reference.

Confirmation # 1
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:

Mailing Address:
US EPA-IPMC

PO Box 98
Dayton, OH 45401-0098

E-mail Address:

stage2madbp@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




Central Data Exchange-MyCDX

Welcome, Last Login: July 21, 2006
Mr, John Smith Registered Since: July 21. 2008
Recertification Date: July 21, 2006

CDX Registration Status: Active

You have 0 new messages in your Inbox

Change System Edit Personal Edit Current Add New
Password Information Account Profiles Employer Profile

Available Account Profiles:

‘© 72: LTZ Data Collection, LT2/Stage 2 Tracking system, and IDSE Pian/Report Entry

SEE STEP
Ba.

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.

lf 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.

Logout

SEE STEP Systems.
B.
The system recognizes you as an approved user for the following applications, please select a system to launch.

“alr lection System

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

|IDSE Plan/Repart Entry
Launches IDSE Plan/Report Entry, which will lead you through filling out and submitting your IDSE Plan or Report

| SEESTEP: aeons”
| B10 |

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 6 . February 2008


P.8 The sample tracking report will display all sample results from all states for the specified week (see Figure 2).

P:9 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.

Return to

The t

Summary Listing <<

Reports: Sample Tracking

=

Sample Results

Organization Organization Name Organization Submitted/Reviewed
Total] Cryptosporidium |. colt

Laboratory Altoona VTP Laboratory PA00931 7 ig 7
American Vater 109023 1 1 0

Ana-Lab Corporation TxOOGE3 6 0 &

Analytical Services T0002 23 24 5

Anytime 4 1 Yi 4

Anytown Lab VA1234567 1 1 0

Appomattox River Water Authorit 00005 1 0 4

BioVvir Laboratories Inc. CADIAOT 2 2 a

Castaic Lake \YYater Agency A160 2 C 2

CH Diagnostic & Consulting Serice Inc 001020e 5 c €

CH Diagnostic and Consulting Senices 001020 3 id 0

City of Durham Vater and Vyvastewater Lab 6 a 5

City of Pickens 1 0 1

City of Round Rock Enaronmental Serices Laboratory 3 0 3

City of Salisbury 1 6 1

City of Santa Barbara - Vater Resources Laboratones: 1 0 1

DCTS for States and EPA

36

February 2008


D 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@epa.gov with your proposed sample schedule, PWSID, water system name, and state.

in the LT2 Data

D.1 To enter sample schedules for your water system, select the “Sample Dates” icon
Collection system, which is located on the left side of the screen.

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).

Select the facility you would like to viewenter sampling dates for in the drop-down menu below. Next, select one of the methods below
enterfedit dates for when the.samples will be collected Once the sample dates are saved, and agpear in the sampling dates list box, t
are available for EPA review

Facility | ostetestt v

Method #) ©) Intlvidual Date Entry - one date at a time
<>) Weekly Date Entry - recurrence pattem for a specific weekday
> Menthly Date Entry - recurrence pattem for specific day of a month

© Copy 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


Central Data Exchange-MyCDX

Welcome, Last Login: July 21, 2006
Mr, John Smith Registered Since: July 21, 2006
. Recertification Date: July 21, 2006

CDX Registration Status: Active

You have 0 new messages in your Inbox

Change System Edit Personal Edit Current Add New
Password Information Account Profiles Employer Profile

Available Account Profiles:

¢ LT2: LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Repor Entry

SEE STEP
BO.

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.

Systems I

The system recognizes you as an approved user for the following applications, please select a system to launch.

“ssl r2 pata collection System

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

IDSE PlaniReport Entry
Launches IDSE Plan/Report Entry, which will lead you through filling out and submitting your IDSE Plan or Report

| SEE STEP —T
B10. |

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 6 February 2008


x

AA.
BB.
ce.

How to Generate a PWS Sample Location Plan Compliance Report

How to Generate a Sample Pair Incomplete Report..
How to Generate a PWS Facility Compliance Report .
How to Generate a List of PWSs without Facilities.
How to Generate a List of Users (EPA Only)
How to Gencrate a LT2 DCTS Usage Report (EPA Only) .......::ccccecesesecsesseseesesressssssssssssseneeseenensed 61


DCTS for States and EPA 48 February 2008


Displaying samples 1 to 2 of 2 total samples matching the above search criteria Please select samples that you wauld like to view or
modify the search enteria above te narrow your choices You can sort the data by clicking on the column headings. You may stew up to
four samples of the same analyte’methad by clicking the sppropriate chack boxes and then clicking on the “Rew:

comment is associated with the sample a notepad icon will appear to the left of the Sampls ID If the sample is a re-sample hash marks
will appear as tl

‘ackground in the sample collection date cell To print the search results displayed on this screen click the “Print
Search Results” link For best results set your layout onentation te landscape

Sample Coljection Point

Samples’ link ifa

Approved
moment | AF 64995 2024 | 2028 [__ ssiog:2007 42/07/2007
Contested
O | arasan 21a | | 0412-2007 42/07/2007
EPA Agrees
‘are no samples currently associated with this status

EPA Disagrees

There are no samples currently associated with this status

Not Reviewed

ly associated vath this status

DCTS for States and EPA

26

February 2008


um or E. Coli Laboratory into DCTS

A Uploading Your Cryptospori
oe

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@epa.gov.

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).

DCTS for Laboratories 1 February 2008


DCTS for PWSs: LT2 16 February 2008


B B 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.3 The 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.

Reports: List of Users

Display users for

5 .
EI
PWS

Laboratory - Ceypiospovidium

ponidium and Ecol

elect an organization type to wes a list of users If your organization type has
the report sull span muhtple pages Use the navigation arams at the top of the re

port te ac

amount of organizations and users

\

ess the additional pages

Organization [Last Name, First Hame [User Name [Role [status
4°89 |
gonder GONDERG State User [ACTIVE
MeClimans Yvilliam AAALLIALA UIMANS State User [ACTIVE
Ramsey James JIMRAL Y State User JACTIVE

AlasKe
Ciralsky Philip SITYOFLATHROE PENDING |STATUS_HOT_SET
gonder gonderl2 SOnDERGZ State User [ACTIVE
Lane Donald NYATERLOS PENOING [PENDIG
[acnder gondert2 GONDERG2 State User [ACTI

Aszena
[Abounader Starr STARRGGS State User [ACTIVE
‘Abounader Starr ABOUNADER State User [ACTIVE

DCTS for States and EPA 59 February 2008


Figure 2

Central Data Exchange -MyCDX

Welcome, Last Login: July 21, 2006
Mr. John Smith Registered Since: July 21, 2006
Recertification Date: July 21, 2006

CDx Registration Status: Active

You have 0 new messages in your Inbox

Change System Edit Personal Edit Current Add New
Password Information Account Profiles Employer Profile

Available Account Profiles:

* £12: LT2 Data Collection, LT2/Stage 2 Tracking system, and IDSE Plan/Report Entry

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

i

SEE STEP Systems I
A.23.

Logout

The system recognizes you as an approved user for the following applications, please select a system to launch.

1.12 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 wil! fead you through filling out and submitting your IDSE Plan or Report

SEE STEP
A22,

A.24 Click on the “User Profile” icon

DCTS for PWSs: LT2 2 . February 2008


A A How to Generate a List of PWSs without Facilities
=

AA.1To 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.3 This 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.

Reports: PWSs without Facilities

PWS

Compliance Group

System 6 — XX0000005

System 7 — XX0000006

roe aay

DCTS for States and EPA

57

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).

Pending Approval
emcee, [7] i VA1234567 m1 2 11/08/2006 1108/2006
Oo A VA1234567 Nada T2 SP 11/02/2006 1102/2006
o fs VAI234567 billietest2 2432 11/02/2006, 1102/2006.
Returned to Lab
‘There are no samples currently associated with this status
| Approved
oO N VA1234567 billietest1 1 101972006 10/49/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).

Return to Search Screen

a.e Changas link to camplete the action |
n Click the field name for more information

Cryptosporidium - ZZTest 1a -DC1a

regarding each sampie can

saveithocges

Status

SYSTEM GENERATED CRYPTOSPORIDIUM CALCULATIONS

E

“Pending Sa

Sample ID {optional)

PWS facility 1D

Tae Retumed 20 Lab

roval v esac:

PWS facility Name

Na

da Test 2

Sampie collection point t

Se

Sample collection point Name

Sampie Point

Sample collection date

1

02-2008

Sample type (Field or MS)

Field

Sample volume analyzed (.)

10

be fou

DCTS for PWSs: LT2

21

February 2008


DCTS for States and EPA 14 February 2008


DCTS for States and EPA 56 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).

ae
VIEW/EDIT PROFILE VIEW NOTIFICATIONS VIEW SUBMISSION STATUS

—

CEoI0N12Z4

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.

VIEW SEARCH RESULTS VIEW CONTACTS —-VIEW. NOTIFICATIONS. VIEW SUBMISSION STATUS

BEpoDoI24
TDISTRICT

4750

‘9988

7109S LITTLE CREEK ROAD

in
ft

IE mail cares

emimente Hotes

faoustiog Care

DCTS for States and EPA 7 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)

User Profile I
+ = Required Field
The following information is provided by CDX. If you feel any of the information is incorrect, please access DX to update/verity. |
| [Username even
“First Name: on
SEE “Last Name Somat
STEP
A25, || [State un
| “Email Actaress varingmumemare rare
= 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)

A.29 A new field “System Type” will appear; select “Both” (even if you only need access to one of the rules)

Piease enter your Organization iD and click "Lookup Organization ” The "Lookup Organization’ link will be replaced with a "Request

JAccess' link and an "Undo" link. if your correct organization is displayed, click "Request Access." If you have incorreclly entered the
organization 1D. 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. col Lab Registralion *

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 (T2 from J
the system list. Otherwise, you should enter the PWSs organization code in the Program ID field when reaistering via CDX.

‘SEE

Organization Code SEE STEP oe
— Az. Lookup Organization wee

E.coli Lab Registration Edit User Information Save and Continue Exit Registration

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

r these additional system(s).

DCTS for PWSs: LT2

February 2008


F. 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.

e 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.

e 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.

e The LT2 Submission shows information submitted by the PWS in compliance with the LTZ2ESWTR

requirements. ~

the actual document

Document Inventory

Below is an inventor, of all documents submitted by this PYYS Click on the hyperlinked document name to view

Submission Type

[b2cument Type [bate Received

[version =

IDSE Report

Monitoring Plan

03-28-2007

03-28-2007

LT2 Submission

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.

DCTS for States and EPA

13

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.

Monitoring Pian

RETURN TO PROFILE

Submission Statu:

’Plan Type “Submission Status “Date Received Plan Copied Held By
P4030 Received - Complete 42.13.2007
Triage Decision _ [Assigned Reviewer : “Approval Status [Date Approved
Approved 42/14:2007
Last mogified on
DIT,
Submission History
Document Type Submission Stats Approval Staws [UserName [Modified Date

RETURN TO PROFILE

DCTS for States and EPA

18

February 2008


DCTS for States and EPA 34 February 2008


DCTS for Laboratories

SEPA

United States
Environmental Protection
Agency


B -by-Step Registration for DCTS using CDX 1 - B.17. to be
« completed for registration. Once the password is setup, go to B.19.)

B.1 Go to: 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 “| 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 Pian/Report Entry (LT2): “*
SEE STEP Ozone Depleting Substances (ODS):

Bg Radionuclide NESHAPs (RAD):

Resource Conservation and Recovery Act Site ID (RCRA): *

Stormwater Notice of intent (eNO!) (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 int ta Collection and Tracking System (DCT:

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

\f 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 3 February 2008


DCTS for PWSs: LT2 8 February 2008


G How to Generate a List of Received Submissions
.

G.1 Inthe 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).

<> [PWS Name

CDSID

Letter Type

Notice Name

Region/State Code

(2) [PWS ID DEDOND002 ¥

(0 |Stage 2 Compliance Schedule All v

PWS Plan Status -Submission Type Monitoring Plan v
Plan/Réport Type All v

Submission Status

Approval Status

[5 |Triage Decision

(2 |Stage2 Rule Requirements

(J {LT2 Rule Requirements

(J Include Closed Systems

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. .

MEW/EDIT PROFILE NEW NOTIFICA: VIEW SUBMISSION STATUS

9e95
472

474

UNITED
HT

OOjoO]o

DCTS for States and EPA 15 February 2008


E 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 Fee
in the LT2 Data Collection system, which is located on the left side of the screen.

E.2 Select a facility (see Figure 1).

GF Data & pling Plan

Please select a Facility and click WIEW.

[Faciiy Ges Treament Panty [ve]

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

PWS intends to submit grandfathered data
4. Notice of intent to Grandtather submitted [J

View intent ty Grandiathec Foun

Date EPA received Intent to Grandtather Form
bate EPA tee This field cannot be edited by a PWS
Number of grandtathered samples to be submitted

Date range grandfathered samples to be
4 submittedimmiddiyyy) Start End
¢. PWS intends o submit additional samples oO
t. Number of additional samples to be submitted
9. Upload grandtathered data 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 ot mail) either in MS Excel spreadsheet (>) or text file te format. Do not submit
files in the 2m! file format that is used in the lab sample upload module
Sending hardcopy giandtather data by mail oO

2. EPAreceipt of sample location plan. Not Received

[ Browse... |

Upload sample location plan |
Please ensure the PWS ID and facility name are in the files you upload

b. Sending sample location planischematic by mail [_]

3. EPAreview of sample schedule Not Received

PWS intends to waive monitoring and proceedte BIN [~]
4 classification

Date EPA received Intent to Waive Monitoring

(mmiadtyyyy) This field cannot be edited by a PWS

6. PWS has uncovered finished reservoirs No

a Uncovered finished reservoirs

DCTS for PWSs: LT2 13 February 2008


D.3 Select “Standard Monitoring Plan” from the IDSE Plan/Report Entry page and then click “Go to Plan Entry.”

Select Plan Type

- Standard Monitoring Plan

~ System Specific Study - Modeling
<> System Specific Study - Existing Monitoring Results

Goto 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.

Standard Monitoring Plan Entry
1. IDSE General Information

Please review the information provided below, if you feel any of the information displayed is incorrect,
and you are unable to change it please contact your State or EPA representative

1. IDSE Requirements
UL Selecting Std.
IV. Justification:

“BAYS If DCla

V. Peak Historical Mth &

Ziest 1a Schedule

“PWS Address ‘address Stage 1 DBP!
Schedule
VI & VI Schematic &

*City city Attachments

*State oc v Preview*Subimit

“Zip “20460

*Popylation Served 110000

“System Type NTNCWS

“Source Water Type cu

“Buying / Selling Whniesale Svstem

DCTS for PWSs: Stage 2 16 February 2008


E 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).

MEVUEDIT PROFILE VIEW NOTIFICATIONS oom, VIEW SUBMISSION STATUS /
- eenrnenons por set att

=

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.

Submission Status --

© ow Select Submssion Type

DCTS for States and EPA 11 February 2008


DCTS for Public Water Systems: Stage 2

Contents
Step-by-Step Registration for DCTS for New CDX USEPS ........cccccccseseeseeeeeesecseeeeeeeeeeseenesenecesistetenecseseeseanenanes 1
Step-by-Step Registration for DCTS for Current CDX USers .0.........cceescsecceceeeececsceeeeeeeseeesceeceeecseeeseneseeneseneeeae 5
How to Submit a 40/30 Certification Plan using the IDSE TOO! ...........cceceececeteseseeneeeeeeseeeeetesstestsnsnensesseeeeeee D

How to Submit a Standard Monitoring Plan using the IDSE Tool

How to Submit a System Specific Study (SSS) — Existing Monitoring Results using the IDSE Too!
How to Submit a System Specific Study (SSS) — Hydraulic Modeling using the IDSE Tool

TMmTMOO D>

DCTS for PWSs: Stage 2 February 2008


W. How to Generate a Monitoring Waived Report
a

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.

Reports: Monitoring Waived

PWS Facilities that Have Waived Monitoring

PWS

Facility

System 1 - XX0000000

TREATMENT PLANT

TREATMENT PLANT ST 4

Svstem 2 — XX0000001

Water Purification Facilitv

Svstem 3 — XX0000002

TREATMENT PLANT

DCTS for States and EPA

49

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.agov.

Facility and Sampling Point Information

Click on the facility or sampling point name to edit the associated information.
a om
veowowes (ADD FACILITY/SAMPLING POINT,”

Coogan

D Name aus | Type 2

TP | Treatment Plant Active SP Sample Point
a ADD FACILITY/SAMPLING POIN

<<

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)
Facility Name: e.g., South Treatment Plant

Facility Status: Whether the facility is currently Active, Inactive, or only used Seasonally.
Facility Type: Refers to where you will take your LT2 samples: TP - treatment plant; IN - source intake
Water Type:

gags

e 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?

DCTS for PWSs: LT2 9 February 2008


C_ PWS Operations

Residual Disinfectant Type

Number of Disinfected
Sources

D. Contact Person

*Contact Name
Tithe
Phone Number
Fax

E-mail Address

Modeling Study Plan Ent

©] Chlonne [7] Chloramines [~ Other

Surface GWUDI
Ground Purchased
John Doe

(655) 855-5655

Jdoe@watersystem.us|

soma SAVE NEXT BACK CANCEL

Please review the information provided below, if you feel any of the information displayed is incorregt

AC -VIEB VIE Schematic &

“S€ftachments vA

and you are unable to change it please contact your State or EPA representative /
“PWS ID oleae
“EWS Name Zest 1c |

address l

“City city ‘
*State pe
“Lip 20460

| *Bopulation Served 400

| "System Type cws
*Souee Water Type Swe

Select y

1

ext

General information

IL IDSE Requirements: \
IIL Min, Model Requirement
Pat \
Par B. \
Parte,
Pant BD.

iV. Peak Mth. for TTHM
V. Modeling Information,
VI. Planned Stage 1B

PRevigw Submit

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


DCTS for States and EPA 46 February 2008


DCTS for States and EPA 30 February 2008


DCTS for States and EPA 32 February 2008




D 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.

Stage 2 Rule IDSE + Stage 2 Compliance a
Requirements Meniter C] Remove Rule Requirements

Calculated Stage 2
Compliance Schedule

(I Alternative St chedule Approved

LT2 Information

L72 Rule Requirements Nene Co Remave Rule Requirements
LT2 Compliance Schedule ‘te (CO Alternative LT2 Schedule Approved

SAVE CANS

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

s je 2 Rule IDS| je 2 Compliance
Requirements 5 4 (1 Remove Rule Requirements

Caiculated Sti

Compliance Schedule [©2MPliance Schedule 4 [ Altemative Stage 2 Schedule Approved

Enter/Modify your selections for an Alternative Stage 2 Compliance Schedule below.

~ “Tilodified By: ‘4
Alternative Stage 2 | Select Schedule Modified On: a
Compliance Schedule Compliance Schedule 3 ~ [oe ae ant .
— Comments Inse + commen a’
— here vd

DCTS for States and EPA 9 February 2008


DCTS for PWSs: Stage 2 4 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.

Reports: PWS Schedule Submission Compliance

PWS Hon-compliant Facilities Compliance Group
Svstem 1 — xxonn0nnn Citv of 2
‘Svstem 1 — XxonnANN0 PLANT_007 2

System 1 ~ XX0000000.

Treatment Plant

System 2 — XX0000001

PLANT_007_002_002

System 3 — XX0000002

PLANT_007

wpope

DCTS for States and EPA

a

February 2008


DCTS for States and EPA 16 February 2008


lUser Profite

} = Required Field

The following information is provided by CDX. If you feel any of the information is incorrect, please access CDX to update/venity,

First Name pen
SEE “Last Name nn
STEP
Bua %

“Phone Number

“Eni Ratross romeremersagey
L

Save 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)

Please enter your Organization ID and click "Lookup Organization.” The "Lookup Organization” ink will be replaced with a "Request
JAccess" link and an "Undo" fink, f your correct organization 1s displayed, click "Request Access.” If you have incorrectly entered the

Jorganization ID. click "Undo" and repeat the process. If you are an E. coiflaboratory and your lab is missing from the list of organizations,
lease click “E. col Lab Ragistration.~

ir you are an existing user and would ke access to the IDSE Plan'Report entry, Enter the code for the desired PWS and select LT2 from

tie system lst, Otherwise. you should enter the PWSs organization code mn the Program ID field when registering via COX

Organization Code SEE STEP
“Ge, B15

E.coliLab Registration Edit User information

Lookup Organization

Save and Continue Exit Registration

SEE
STEP
B16

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