ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Information and Instructions
2
Name your inventory as LSLI_NYPWSID#. For example:
LSLI_NY1234567
3
Lead Service Line Inventory Template Workbook
4
• The Service Line Inventory Template is to be filled out with one row for each service line.
5
• Columns with headings in blue are required or mandatory entries to be considered complete.
6
• Headers with an ⓘ symbol will display additional information if clicked on.
7
• The options for all drop down response columns are listed below.
8
Inventory Summary Workbook
9
• Do not fill out Section III, "Summary of Inventory." The section will be automatically filled based on information provided in the LSL Template workbook.
10
11
TabsDescription
12
Service Line Inventory TemplateTo be filled out with service line information
13
Inventory Summary FormSummary of data from Service Line Inventory Worksheet
14
15
Public-side Service Line Information Keys
16
Lead Gooseneck, Pigtail or Connector Currently Present?Current Public Side SL MaterialWas Public SL Material Ever Previously Lead?Public SL Material Verification MethodPublic SL Size
17
YesLead including lead-lined galvanizedYesRecordsUpto 1"
18
NoCopperNoField Inspection1" < SL ≤ 1.5"
19
UnknownGalvanizedUnknownExcavation1.5" < SL ≤ 2"
20
PlasticSequential Samplinglarger than 2"
21
Known OtherStatistical Analysis/Predictive Modelunknown
22
Unknown but could be leadOther
23
Unknown but unlikely leadNot Verified
24
Unknown
25
26
Customer Side Service Line Information Keys
27
Customer SL MaterialCustomer SL Material Verification MethodLead Solder Present?Building TypePOU or POE Treatment Present?Customer SL Size
28
Lead including lead-lined galvanizedRecordsYesSingle FamilyYesUpto 1"
29
CopperField InspectionNoMulti FamilyNo1" < SL ≤ 1.5"
30
GalvanizedCustomer Identification with Photo or Other VerificationUnknownSchool or ChildcareUnknown1.5" < SL ≤ 2"
31
PlasticExcavationBusinesslarger than 2"
32
Known OtherSequential SamplingOther including Multiuseunknown
33
Unknown but could be leadStatistical Analysis/Predictive Model
34
Unknown but unlikely leadOther
35
UnknownNot Verified
36
37
Entire Service Line Inventory Categories
38
SL Category
39
Lead
40
GSLRR
41
Non-Lead
42
Unknown - Lead Status Unknown
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100