Spotlight Overview

1. Click on Community Water, under Program Areas

2. Select CWS Spotlight

   Open

   

   CWS Spotlight located under Community Water

3. The following five CWS Spotlight cards will appear:

   1. Priority Surveys: A list of priority Sanity Surveys that are due within the next 180 days.

      1. Only pulls SNSV and L2SS visit types from SDWIS

      2. >90 days late - Critical Priority - Red pill

      3. 1-90 days late - High Priority - Yellow pill

      4. Next Visit Due within 90 days - Medium Priority - Blue pill

   2. Open Deficiencies: A detailed list of unresolved deficiencies from SDWIS site visits.

   3. Open Violations: A detailed list of unresolved SDWIS violations or violations that have not yet been returned to compliance and designated with a taken SOX enforcement action.

      1. Pulls status codes of ‘P = Preliminary' and 'V = Validated’

   4. Tier 1/2 Violations without Public Notice: A detailed list of violations without public notice in SDWIS or violations that have not yet been marked with a taken SIF enforcement action (card not aware of dates in the Public Notice section of SDWIS).

   5. Open Compliance Schedules: A detailed list of unresolved SDWIS Compliance Schedules Activities. Unresolved means no achieved date is entered in SDWIS.

4. The search results for each of the CWS Spotlight cards are listed below the cards and under the text Filter bar. To change the search results displayed, simply click on a different CWS Spotlight card or the ellipsis menu (…) next to the currently chosen CWS Spotlight card name.

   Open

   

   The ellipsis menu allows you to view the search results for the Spotlight card of your choosing.

Filtering the Spotlight

Using the Filter Icon

1. Click on the Filter icon () on the right, above the Open Compliance Schedules card to open the Spotlight Filter dialog.

2. Select a field, Districts or Schedule Type and begin typing to search the list. The fields are multi-select, so click on each option in the list that you want included in a single filter.

   1. The Districts selections include districts and subdistricts. Selecting the higher level District (Ex: DISTRICT 1) allows you to make one selection to include results for all the subdistricts (DISTRICT 11, DISTRICT 12, DISTRICT 13, DISTRICT 14).

      Open

      

      DISTRICT 1 District Filter search includes DISTRICT 11, DISTRICT 12, DISTRICT 13, DISTRICT 14 results.

   2. The Schedule Type selections include SDWIS Compliance Schedule Types and updates only the Open Compliance Schedules card. The fields support multi-selection.

3. Select Apply Filter to create a Custom Filter. The CWS Spotlight will updated to show the results that match your filter(s). The Customer Filter can be removed by clicking the next to the the Custom Filter chip at the top of the CWS Spotlight screen or by clicking the Filter icon again and updating the Spotlight Filter selections.

4. Click Set as My Default and the list will be filtered to match and the filter selections will become your default, so you can exclude Districts or Schedules Types you don’t oversee.

   1. Setting your default filter is not required, it is just convenience if you have specific districts/subdistricts that you commonly use.

Using the Filter Bar

1. The text Filter bar can be used to further narrow down the items in the list of each card.

   1. Examples: maybe you only care about things coming due in “2025” or maybe you only want to see “3A” Violation Types.

2. In the text Filter field, type in your filter criteria and then click enter on your keyboard or Filter button at the end of the text field. The list will update to show results that match the text filter.

   Open

   

   CWS Spotlight Text Filter for 2025 Priority Surveys (Next Visit Due column serach)

Open

CWS Spotlight Text Filter for 3A Open Violations

Additional Spotlight Features

1. Search results can be downloaded/exported to open in Microsoft Excel by clicking the Export icon () located above the search results on the right. Exported results can be a helpful reference during site visits.

   1. Once in Excel, you can further filter the list with Excel’s filtering functions.

      Open

      

      Excel Filtering of CWS Spotlight data to look for Type 27 Open Violations.

2. Hovering over the Public Water Supply ID will display a small copy icon right beside the number. Clicking on that icon will copy the last seven digits to the clipboard. This is a convenience shortcut. MiEHDWIS cannot open SDWIS, but if you have SDWIS open, you can paste directly into the Water System No. search field of the Water System Search page.

   Open

   

3. Click on the Supply Name in the search results to open the Entity Overview for that water supply.