ABCDEFGHIJKLMNOPQRSTUVWXYZ
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
Field NameDescription
9
PWS IDOR41##### - no letters at the end
10
PWS nameWater system name
11
Operator(s) submitting reportName of person(s) submitting report
12
Date completedDate completed
13
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).
14
Location Identifier
(conditionally required)		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).
15
 -- Note: The service line is broken up into 2 sections: upstream of the meter (commonly called the public side) and downstream of the meter to the building inlet (commonly called the private side). If there are not 2 different sections (such as a single owner), choose which is more accurate (public or private) and enter "Not (PWS/customer) owned" on the other.
16
Water system owned 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
17
Customer owned 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
18
If customer service line is galvanized, was upstream service line material ever lead?See descriptions below (rows 46-49)
19
Service line material identification method - Water system or customerMethod used to identify the service line material. See descriptions below. Choose from drop down on inventory sheet.
20
Service type for connectionType of building this connection serves. See descriptions below. Choose from drop down on inventory sheet.
21
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.
22
Interior plumbingThis is the type of pipes inside the building. See drop down on inventory sheet for choices.
23
Is there POE/POU treatment?Point of entry (POE)/Point of use (POU) - does this service line have any additional premise treatment present making it non-representative of the water system? Ex. a home water softener system
24
Water system main material & size
what kind of pipe is the water main supplying the service line. Include size if desired as well
25
Water system service line sizepipe diameter
26
Customer service line sizepipe diameter
27
Year (or range) water system or customer owned service line installedWhat year (or range of years) was the service line installed? The 2 portions can be different so there are separate columns for reach. If a section has multiple years it is recommended that you use oldest year of any portion of that section.
28
Water system notesOptional field for water system to make notes if desired.
29
LSL statusThis will auto-populate based on previous answers. A running summary is also provided at the top. If error, review information causing error.
30
Testing site tier level (TBD)Placeholder for future enhancement that will help identify sites to use in tap monitoring. US EPA may make changes to this criteria in the next few years so this is not yet developed.
31
32
Descriptions for select field options
33
34
Current service line material definitions
35
Leadlead pipe
36
Galvanized (Iron or Steel)A pipe with a galvanized coating to service water. Pipe material under coating does not make a difference.
37
Non-lead - Coppercopper pipe
38
Non-lead - PlasticAny plastic pipe. More details on the type of plastic can be recorded in the notes section.
39
Non-lead - OtherMaterial other than those listed. Suggested you record the material in notes section.
40
Non-lead - Not specifiedExact pipe material is not provided. Also use this for non-lead determinations using the statistical approach when location was not inspected.
41
Non-lead - 2+ inches Service line diameter is 2 inches or greater. There are no known lead pipes in this category.
42
Non-lead - unk - post 1985The material is unknown but records show that it was installed after December 31, 1985.
43
UnknownUnknown material
44
Not PWS ownedUse on public water system service line when the customer owns the entire service line from the water main to the building.
45
Not customer ownedUse on customer service line when the water system owns the entire service line from the water main to the building.
46
47
Upstream service line material ever lead
48
YesUpstream is or was lead while current customer service line in place
49
NoRecords indicate lead never used while current customer service line in place
50
UnknownInsufficient information on previous materials while current customer service line in place
51
NA - not galvanizedDetermination is only needed when customer service line is galvanized.
52
53
Service line material identification method definitions
54
Records onlyReviewed paper or electronic records.
55
On site inspection onlyOn site inspection of the pipe material.
56
Both records and inspectionBoth records and on site inspection were used.
57
Customer dataCustomer provides evidence of material type that is acceptable to the water system.
58
Statistical - inspected Identifies a randomly selected service line that was physically inspected as part of the statistical review
59
Statistical - not inspectedUse of a statistical analysis method for determining likelihood of lead service lines.
60
61
Community Service type definitions
62
Single familyDesignated single family living unit (per zoning code).
63
Multi familyMultiple family living units at connection. (Ex. apartments, townhomes, etc.)
64
School/daycare The connection is a registered day care or school regulated by the Department of Education.
65
Other/non-residentialNot a residence or school/daycare. This can be a worksite or location where potable water would reasonably be obtained including public drinking fountains or bathrooms (ex. Park).
66
Non-potableA service line not used for potable water. (Ex. fire suppression or irrigation use only) This does not include fire hydrants.
67
68
Connector type definitions
69
Lead
70
Previously Lead
71
Non-lead
72
Unknown
73
74
Interior plumbing types
75
Lead
76
Copper
77
CPVC
78
Pex
79
Galvanized
80
OtherAnything not listed before. Recommend to include in water system notes.
81
UnknownUnknown material
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100