California Environmental Reporting System (CERS)

Determining Unified Program Element Regulated Facility Count (June 24, 2016)

Question: How to determine the number of regulated facilities by Unified Program Element?

Answer: Find the count of regulated facilities for a Unified Program element by using the appropriate search criteria indicated below.

Program Element Search Criteria
HMRRP Reporting Requirement for submittal element ‘Hazardous Materials Inventory’ is set to ‘applicable’ or ‘always applicable’
UST Reporting Requirement for submittal element ‘Underground Storage Tanks’ is set to ‘applicable’ or ‘always applicable’
Haz Waste Generator Business Activities question (field 9) set to ‘YES” on the most recent ‘Accepted’ submittal in the selected date range. This is because there is no reporting requirement for this program element.
Haz Waste RCRA LQG Business Activities question (field 14a) set to ‘YES” on the most recent ‘Accepted’ submittal in the selected date range. This is because there is no reporting requirement for this program element.
Haz Waste Recycler Reporting Requirement for submittal element ‘Recyclable Materials Report’ is set to ‘applicable’ or ‘always applicable’
PBR, CA, CE Reporting Requirement for submittal element ‘Tiered Permitting’ is set to ‘applicable’ or ‘always applicable’
APSA Reporting Requirement for submittal element ‘Aboveground Petroleum Storage Tank Act’ is set to ‘applicable’ or ‘always applicable’
CalARP Reporting Requirement for submittal element ‘California Accidental Release Program’ is set to ‘applicable’ or ‘always applicable’
Household Haz Waste Business Activities question (field 14b) set to ‘YES” on the most recent ‘Accepted’ submittal in the selected date range. This is because there is no reporting requirement for this program element.
  1. For searches that rely on a submittal element use the Facility Search feature.
    1. Select the appropriate submittal element as indicated above
    2. Set the Reporting Requirement to ‘Applicable + Always Applicable’
    3. Leave the Last Submittal Date Range blank.

      Screenshot of the Facility Search feature that rely on a submittal element, setting the Reporting Requirement to ‘Applicable + Always Applicable’ and leaving the Last Submittal Date Range blank
    4. The results screen displays the number of regulated facilities for the selected UPA.

      5. Screenshot of the results screen displaying the number of regulated facilities for the selected UPA
    5. Note that the UPA may change the facility reporting requirement at any time to include or exclude it from a program element.
    6. Using the Facility Search feature, find the facility
    7. Select the ‘Reporting Requirements’ link
    8. (It’s always a good idea to review the instructions…)
    9. Select the ‘Change’ button
    10. Set the desired submittal element to the desired setting and select the ‘Save Changes’ button. Note that this may also be a good time to set the ‘Next Due Date’.

      Screenshot of selecting the ‘Reporting Requirements’ link after finding a facility
      Screenshot of instructions and selecting the ‘Change’ button

      Screenshot of setting the desired submittal element to the desired setting and select the ‘Save Changes’ button. Note that this may also be a good time to set the ‘Next Due Date’
  2. For a search that relies on a ‘yes’ response to a Business Activities question (Hazardous Waste Generator, Hazardous Waste LQG, and Household Hazardous Waste) use the Facility Search feature to find ALL regulated facilities in the UPA jurisdiction.
    1. Set the Submittal Element to ‘Facility Information’
    2. Set the Reporting Requirement to ‘Applicable and Always Applicable’
    3. Leave the Last Submittal Date Range blank
      Screenshot of using the Facility Search feature to find ALL regulated facilities in the UPA jurisdiction. Setting the Submittal Element to ‘Facility Information’ and setting the Reporting Requirement to 'Applicable and Always Applicable’
    4. The results page provides a list of all facilities within the selected jurisdiction that are required to submit at least the facility information submittal element.
      Screenshot of selection ‘Export to Excel (Details)’
  3. Select the ‘Export to Excel (Details)
  4. Sort the table by the desired Program Element
    1. To sort, either remove the top two rows of the spreadsheet and select all of the table or highlight all of the table except rows one and two
    2. Select the appropriate sort parameter
    3. Set the order from Z to A
    4. Count the number of ‘Y’ responses, minus the number of header rows. This is your count of regulated facilities for the selected Unified Program Element
      Screenshot of setting the appropriate parameter

      Screenshot of setting the order from Z to A

      Screenshot of counting the number of “Y” responses, minus the number of header rows
    5. Note: If the resulting count is not correct, the facility will need to make a new submittal with the correct responses to the business activities questions.