Link to Lead/Copper inventory Sheet
USE LSLI SHEET TO COPY AND PASTE DATA FROM ‘Detailed Inventory’ SHEET FROM TCEQ-20943
Detailed Inventory
Add detailed service line information using the webform or Excel Template. Recommendations if using Excel Template:
1) Save a copy of the workbook to your hard drive or network drive. Consider adding the system PWS ID or other system identifier to the file name (e.g., Inventory Template_TX0000000) and indicating in the file name if this is the “initial” inventory or “update1”, “update2”, etc.
2) Each row in this worksheet represents one service line connecting the water main to the customer’s plumbing. The worksheet is organized into sections:
– Location Information
– System-Owned Portion
– Customer-Owned Portion
– Other Potential Sources of Lead
– Additional Information to Assign Tap Monitoring Tiering
– Lead Service Line Replacement (LSLR)
3) Columns with aqua shading are required by the EPA LCRR. As explained in more detail on each field, entries for each field can either be selected from a dropdown menu or will require manual entry.
