ABCDEFGHIJKLMNOPQRSTUVWXZ
1
Lead Service Line (LSL) Inventory Field descriptions
2
3
Black Font required for inventory and must be populated
4
Blue font - Useful for tap monitoring location determination - OPTIONAL
5
Green font - Good information for water system to know - OPTIONAL
6
Purple font - results are calculated by the spreadsheet using previous inputs. Do not edit.
7
8
LCRR - Lead and Copper Rule Revision (published January 15, 2021)
9
10
Fields on Inventory Tab
11
these are required for inventory submission
12
Field NameDescription
13
PWS IDOR41##### - no letters at the end
14
PWS nameWater system name
15
Operator(s) submitting reportName of person(s) submitting report
16
Date completedDate completed
17
Service line Site IDThis is determined by and is for the water system to track records. While every effort should be made to not have this change between submittals, circumstances may dictate that it does. For example, if account number is used it might change when customer ID changes (or the meter is changed).
18
Location Identifier
(Required for Lead and GRR status only - optional for other service lines)		This field is required when the service line status is Lead or GRR (galvanized requiring replacement) but optional for all others and is a description of the physical location of the service line. This can be the address but can also be another description (for example "2nd line east from intersection of 5th and Main" or latitude/longitude coordinates).
19
Service line current materialSee drop down for choices by selecting cells on inventory sheet. See green (optional data) section if you want to record additional information
20
If galvanized, was upstream material ever lead?See descriptions below
21
Service line material identification methodMethod used to identify the service line material. See descriptions below. Choose from drop down on inventory sheet.
22
Water system main material & sizewhat kind of pipe is the water main supplying the service line. Include size if desired as well
23
Service line sizepipe diameter
24
Year (or range) service line installedWhat year (or range of years) was the service line installed? If repairs or partial replacement include the oldest year - include other years if desired.
25
Water system notesOptional field for water system to make notes if desired.
26
LSL statusThis will auto-populate based on previous answers. A running summary is also provided at the top. If error, review information causing error.
27
28
Fields on Tap sample locations tab
29
This tab is optional but available for determination of sample locations
30
31
Location on Inventory (if entered in inventory column B - this is automatic based on result in next column)Do not edit on tap sample locations tab. This is pulling data from inventory tab based on the results in next item.
32
Service line Site ID (must match from column A on inventory)This needs to perfectly match one of the service lines ID's from the inventory.
33
collection location Identify the sample sites within the building. This tab is designed to help track which sample locations can be used for your pool of available sample locations under LCRR.
34
Type of faucetType of faucet for this monitoring location. See descriptions below. Choose from drop down on monitoring location sheet.
35
Connector material to water main (i.e. goosenecks)If possible, identify if the type of material used for the short piece of pipe that connects the water main to the service line. See descriptions below. Choose from drop down on inventory sheet.
36
Interior plumbingThis is the type of pipes inside the building and for this collection location. See drop down on monitoring location sheet for choices.
37
Is there POE/POU treatment?Point of entry (POE)/Point of use (POU) - does this sample location have any treatment present making it non-representative of water at other locations? Ex. a filter for this sink.
38
Water system notesOptional field for water system to make notes if desired.
39
LSL status from inventoryThis is automatic based on value supplied in Service line site ID and corresponding value on inventory sheet.
40
Testing site tier levelUsed to identify which sites to use in tap monitoring. US EPA may make changes to this criteria but this determination is based on the LCRR criteria as currently written.
41
42
Descriptions for select field options
43
44
Current service line material definitions
45
Leadlead pipe
46
Galvanized (Iron or Steel)A pipe with a galvanized coating to service water. Pipe material under coating does not make a difference.
47
Non-lead - Coppercopper pipe
48
Non-lead - PlasticAny plastic pipe. More details on the type of plastic can be recorded in the notes section.
49
Non-lead - OtherMaterial other than those listed. Suggested you record the material in notes section.
50
Non-lead - unk - post 1985The material is unknown but records show that it was installed after December 31, 1985.
51
UnknownUnknown material
52
53
Upstream service line material ever lead
54
YesUpstream is or was lead while current service line in place
55
NoRecords indicate lead never used while current service line in place. This often includes piping directly from the well or storage tank.
56
UnknownInsufficient information on previous materials while current service line in place
57
NA - not galvanizedDetermination is only needed when service line is galvanized.
58
59
Service line material identification method definitions
60
Records onlyReviewed paper or electronic records.
61
On site inspection onlyOn site inspection of the pipe material.
62
Both records and inspectionBoth records and on site inspection were used.
63
64
65
66
Type of faucet
67
drinking fountainAny faucet dedicated to providing water for consumption including water bottle filling stations.
68
bathroom sinkSink in a bathroom setting including locker rooms.
69
kitchen/handwashing sinkAny sink outside a bathroom that is reasonably able to provide water that will be used for drinking. Examples include kitchen, break room or class room sinks
70
Not allowed locations for LCR testing
71
mop sink/hose bibSinks or water supply at lower levels unlikely to be used for drinking water. Examples include janitorial closets or hose connections. Note: these locations should NOT be used for LCR testing.
72
Non-potableA service line not used for potable water. (Ex. fire suppression or irrigation use only)
73
74
Connector type definitions
75
Lead
76
Previously Lead
77
Non-lead
78
N/AWater system does not have water mains. The service line comes directly from water source or storage.
79
Unknown
80
81
Interior plumbing types
82
Lead
83
Copper
84
Copper w/Lead solder
85
CPVC
86
Pex
87
Galvanized
88
OtherAnything not listed before. Recommend to include in water system notes.
89
UnknownUnknown material
90
91
92
93
94
95
96
97
98
99
100