Superfund State Contract (SSC) Qlik Dashboard

The Region 6 Superfund State Contract (SSC) Qlik dashboard consolidates details for open SSCs with our five states: Arkansas, Louisiana, New Mexico, Oklahoma, and Texas. Information is separate into six pages: SSC SED Details, Amendments, SSC Disbursements, TR1 Activity (State Collected Cost Share), SSC State Credits, and Final Financial Reconciliation. To help identify the possible need for an amendment, the SSC SED Detail page includes the current cost estimate for each SSC and the cumulative EPA remedial expenditures. The contract remedial cost estimate is highlighted yellow when expenditures are within 10 percent and red when expenditures have exceeded the contract cost estimate. The dashboard includes state cost share (TR1 funds) collection details. It shows what SSCs are in the amendment process, state credit approved totals from cost packages received, and SSCs in the final financial reconciliation process for administrative closures.

How to Instructions: The Status (Active, Closed, Inactive) and State (ADEQ, LDEQ, NMED, ODEQ, TCEQ) boxes on the top are filter options. The right side and bottom have scroll bars to see the remainder of the page. Above the column titles are links to the other pages. Click column title to sort and some columns have a search icon. Right click in the body of the page to Export data to an Excel spreadsheet or PDF.