| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||
2 | ||||||||||||||||||||||||||
3 | ||||||||||||||||||||||||||
4 | ||||||||||||||||||||||||||
5 | Complete Distribution System Materials Inventory (CDSMI): Line-by-Line Inventory | |||||||||||||||||||||||||
6 | ||||||||||||||||||||||||||
7 | Authorization Language | 2018 revisions to the Michigan Safe Drinking Water Act, 1976 PA 399, as amended, requires that water supplies develop and maintain a CDSMI. Pursuant to Rule 325.11604(c)(ii), the CDSMI must be submitted to the Michigan Department of Environment, Great Lakes, and Energy (EGLE). Federal rule 40 CFR § Part 141.84(a) also requires submission of an inventory by October 16, 2024. To meet both state and federal requirements, the CDSMI must be submitted to EGLE by October 16, 2024. | ||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||
9 | PWSID: | The Public Water System Identification (PWSID) is a combination of MI00 plus the water supply’s 5-digit Water Supply Serial Number (WSSN). For example, if the WSSN is 01234, the PWSID is MI0001234). | ||||||||||||||||||||||||
10 | ||||||||||||||||||||||||||
11 | Service Lines Categories | |||||||||||||||||||||||||
12 | Any Portion Contains Lead: | Any portion of a service line that is made of lead or any lead pigtail, lead gooseneck, or other lead fitting that is connected to the service line, or both. In short, any service line that contains any lead. | ||||||||||||||||||||||||
13 | Galvanized Previously Connected to Lead (GPCL): | A galvanized service line that WAS previously connected to a lead service line, gooseneck, or pigtail, or if the system is unable to demonstrate that the galvanized line was never downstream of lead piping. If a galvanized line is still connected to lead, it is considered a lead service line and must be counted in the category above. Note: Under the recently promulgated federal Lead and Copper Rule Revisions, service lines in this category are referred to as “galvanized requiring replacement (GRR).” | ||||||||||||||||||||||||
14 | Non-Lead: | Contains neither lead nor GPCL. This category may include service lines of unknown material if they are known not to contain lead or GPCL. If there is a possibility the service line contains lead or GPCL, but the material is unknown, it should be categorized as lead status unknown. | ||||||||||||||||||||||||
15 | Lead Status Unknown: | The service line material is not known to be lead or GPCL and there is not enough evidence to support material classification. | ||||||||||||||||||||||||
16 | ||||||||||||||||||||||||||
17 | Inventory Spreadsheets Required Fields: | |||||||||||||||||||||||||
18 | General Instructions | Each row in this worksheet represents one service line. Use additional lines and "Unique Identifier" if there are multiple service lines for one address. The worksheet includes required and optional elements; the columns from Column A to P are required, while Column Q to AQ are optional, as noted in Row 8 of the Inventory Worksheet. Water supplies may not customize the required section; water systems may customize the optional section. Instructions below (from number 1 to 7) provide necessary information to complete the Inventory Worksheet. Additional relevant instructions on how to complete each of the required columns are provided in Row 11. | ||||||||||||||||||||||||
19 | 1 | Physical Address: Specify the location of the building and subsequent service line (From Column A to Column D). Provide additional information in (Column E) if there are multiple service lines for one address and a unique idenfier is necessary. | ||||||||||||||||||||||||
20 | 2 | Basis of Material Classification: Select from a drop down for each cell (Gooseneck (Column F) , System-Owned Portion (Column H), and Customer-Owned Portion (Column J)). | ||||||||||||||||||||||||
21 | 3 | Service Line Material Classification: Select from a drop down for each cell (Gooseneck (Column G), System-Owned Portion (Column I), and Customer-Owned Portion (Column K)). | ||||||||||||||||||||||||
22 | 4 | Select if lead was present in either the Gooseneck (Column G) or System-Owned Portion (Column I). In Column L, Note: Water supplies should not select "No" if unable to demonstrate that the galvanized line was never downstream of lead piping. | ||||||||||||||||||||||||
23 | 5 | The water supply must keep the documentation of denied access to the interior of the building (e.g., the date of the denial, to whom the denial was communicated, and the denial itself in writing (R.1604(C) (iii)). In Column O, water supplies that encountered denial of access must provide the date of denial. | ||||||||||||||||||||||||
24 | 6 | Columns (from Column Q to AQ) are considered optional and, although strongly encouraged, are not required for the final submittal. | ||||||||||||||||||||||||
25 | 7 | Manufactured Housing Community (MHC) connections to units (risers) are considered service lines, therefore MHCs should fill out this entire Inventory Worksheet. Use the same materials for the system-owned and customer-owned columns (Columns I and K) | ||||||||||||||||||||||||
26 | ||||||||||||||||||||||||||
27 | Submit Form to the Michigan Department of Environment, Great Lakes, and Energy (EGLE) | |||||||||||||||||||||||||
28 | Submission of line-by-line inventory | Submit the completed line-by-line inventory (as described in the CDSMI Submission Memo) to EGLE via upload to the Michigan Environmental Health and Drinking Water Information System (MiEHDWIS) or via email to your local district office no later than October 16, 2024. If you need this information in an alternate format, contact EGLE-Accessibility@Michigan.gov or call 800-662-9278. | ||||||||||||||||||||||||
29 | ||||||||||||||||||||||||||
30 | ||||||||||||||||||||||||||
31 | Freedom of Information Act | This inventory template and its contents are subject to the Freedom of Information Act and may be released to the public. | ||||||||||||||||||||||||
32 | ||||||||||||||||||||||||||
33 | EGLE does not discriminate on the basis of race, sex, religion, age, national origin, color, marital status, disability, political beliefs, height, weight, genetic information, or sexual orientation in the administration of any of its programs or activities, and prohibits intimidation and retaliation, as required by applicable laws and regulations. | |||||||||||||||||||||||||
34 | ||||||||||||||||||||||||||
35 | Questions or concerns should be directed to the Nondiscrimination Compliance Coordinator at EGLE-NondiscriminationCC@Michigan.gov or 517-249-0906. | |||||||||||||||||||||||||
36 | ||||||||||||||||||||||||||
37 | EQP5865 (Rev. 04/2024) | |||||||||||||||||||||||||
38 | ||||||||||||||||||||||||||
39 | ||||||||||||||||||||||||||
40 | ||||||||||||||||||||||||||
41 | ||||||||||||||||||||||||||
42 | ||||||||||||||||||||||||||
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 |