Page Banner

Petroleum Restoration Program Reports

STCM Database Queries

  • Contractor Performance Evaluation Summary Report - (Contractor Performance Scores)
    This report returns detailed and summary information for each Contractor Performance Evaluation (CPE) based on the Contract Number or Contractor Identification Number.  User can query all performance evaluation data or has the option to limit the data to a date range.
  • Contractor Scoped Work Status Report - (Invoice Status Report)
    This report provides a comprehensive overview of information, stored by cleanup contractor, related to Cleanup Work Issued. This does not match the encumbrance balance for the RCI calculations. Please refer to the Work Assignment Process and RCI for the associated business rules.
  • Encumbrance Balance Report - (RCI Encumbrance Balance)
    This report provides a detail or summary of the encumbrance balance. In order to show only the encumbrance balance utilizing the calculation business rules of the RCI, set the RCI Exclusion Flag filter to "Exclusion Flag = N".
  • Petroleum Cleanup Funding CAP To Date Report - (CAP To Date Report)
    This report is offered as a TOOL to assist in determining the total amounts encumbered from the Inland Protection Trust Fund for DEP registered facilities with one or more eligible discharges.
    • The amounts are at the facility level only and not associated with a particular discharge.
    • These data have NOT been 100 percent verified, MAY contain errors and omissions, and should NOT be used for official purposes without a complete file review and database reconciliation.
    • The Total Amount Encumbered Towards the CAP exclude costs encumbered in association with the Limited Source Removal Initiative in Conjunction with an Early Underground Storage Tank Upgrade (Funding Priority 2J), Innovative Technology (Funding Priority 2W), or Environmental Forensic Site Investigation and Other Technical Support Services Contract (FTSS) which are not applicable to cleanup funding CAPs. 

STCM Database Monthly Reports

The following reports are updated monthly. The last update was November 14, 2018 unless otherwise noted.

Files are available for download by district. The common field in each file is the facility identification number. Discharge information and task information must be linked by facility identification numbers and by discharge identification numbers.

  • Contaminated Facilities List
    The Contaminated Facilities report provides the facility ID, facility type, score, rank, operator information, owner information, as well as latitude and longitudeI information, for facilities that currently have contamination. This report does not include discharges that are not required for 62-780 or discharges that already have been cleaned up.
  • Contaminated Media
    The Contaminated Media report provides the discharge date, combined discharge information, discharge cleanup status, site manager information, score, and contaminated media information for all facilities that have ever had contamination. This report includes discharges that are not required for 62-780 as well as discharges that already have been cleaned up.
  • Contractors Assigned to Work Orders
    The Contractors Assigned to Work Orders report lists facilities with at least one discharge that requires cleanup per the 62-780 rule where cleanup is not yet complete. The report lists the contractor who is assigned to perform cleanup activities at the facility on the most recently issued Pre-approval Work Order or Task Assignment.
  • Discharge Cleanup Summary
    The Discharge Cleanup Summary report provides the discharge date, combined discharge information, and the discharge cleanup status for all discharges that have ever had contamination. This report includes discharges that are not required for 62-770 as well as discharges that already have been cleaned up.
  • Historical Contaminated Facilities List
    The Contaminated Facilities report provides the facility ID, facility type, score, rank, operator information, owner information, as well as latitude and longitude information, for all facilities that have ever had contamination. This report includes discharges that are not required for 62-780 as well as discharges that already have been cleaned up.
  • Historical Owner Information (by county) - September 10, 2018
    The Historical Owner Information Report provides current and historical facility and responsible party contact information, facility location (latitude/longitude and section/township/range), facility rank, and score for all facilities.
  • Petroleum Cleanup PCT Facility Score Report
    The PCT Facility Score Report provides facility ID, highest current score, facility name, facility status, facility type, facility location, current facility contact information and current primary responsible party contact information for facilities that currently have at least one discharge in Active Cleanup or Awaiting Cleanup.
  • Petroleum Cleanup Program Eligibility
    The Program Eligibility report provides the discharge date, combined discharge information, discharge cleanup status, all eligibility status information, site manager information, score and rank information for all discharges that have ever had contamination. This report includes discharges that are not required for 62-780 as well as discharges that already have been cleaned up.
    • Providing all eligibility status information may produce multiple records per discharge.
  • Task Information - September 10, 2018
    The Task Information report provides the discharge date, combined discharge information, discharge cleanup status, site manager information, score, and SR, SA, RAP and RA task information for all discharges that have ever had contamination. This report includes discharges that are not required for 62-780 as well as discharges that already have been cleaned up.

Commonly Requested Reports (Excel)


STCM Database Codes List


Return to: Database Reports & Site Files webpage.

Return to:  SOP Site Manager Guide page.

Share:          
Last Modified:
December 11, 2018 - 1:59pm

Some content on this site is saved in an alternative format. The following icons link to free Reader/Viewer software:
PDF: | Word: | Excel: