DEQ Surcharge Report

Visible Parameters:

• Start_date
• End_date
• Audit_mode select either ‘Yes’ or ‘No’

Hidden Parameters:

• DEQ surcharge fee amount (default is $100)
• Agency id

Filters:

• Only Onsite records can appear in the report.
• No Point of Sale transactions are included in the report.
• If a record has a surcharge fee or a surcharge eligible¹ fee with a payment applied, void payment applied or refund applied action between the start and end dates (inclusively), it will be included in the report.
• For each record in the report all surcharge and surcharge eligible fees with payment applied, void payment applied or refund applied actions that occurred on or before the report end date are collected.

Assumptions:

• This report does not filter for payment methods. If a surcharge eligible fee was paid with ‘Credit Memo’, ‘Fee Waiver’, ‘Write Off’ or ‘Billed’ it still counts as an activity and the surcharge should be collected.
• If any portion of the fee is paid after a refund, it counts as an activity and the surcharge should be collected. (To get around this if the agency has a refund processing fee, the entire surcharge eligible fee should be refunded and the refund processing fee should be collected.)

There are four sections in the report:

• Heading
  • Includes start and end dates, DEQ surcharge fee amount and ‘Report run in Audit Mode’ if Audit mode = ‘Yes’
• Activity summary
  • For each surcharge category², the number of activities and the calculated surcharge fees (number of activities * DEQ surcharge fee amount)
  • Report total for activities and calculated surcharge fees
• Authorizations resulting in permits
  • If the report is run in Audit Mode and there are authorizations that resulted in permits, the authorization record numbers and date the ASI field ‘Authorization resulted in Permit’ was updated will be listed
  • If there were authorizations that resulted in permits, the total count of those records is listed
  • If no authorizations resulted in permits then a message ‘No authorizations resulted in permits’ is shown.
• Details
  • The details section is shown when Audit Mode = ‘Yes’
  • Records are shown in record number order
  • For each record, the application status and application status date are shown.
  • Each DEQ surcharge eligible fee and DEQ surcharge fee that has an action of ‘Payment Applied’, ‘Void Payment Applied’ and ‘Refund Applied’ before the report end date is shown.
  • The total fee amount is displayed
  • For DEQ surcharge eligible fees the surcharge category² is shown
  • Amounts are subtotaled to the action, payment method and previous⁴or current amount³ categories
  • For each surcharge eligible fee either a 1, 0 , or -1 is displayed (these numbers are added for each surcharge category to get an activity count)
    • If the current amount > 0 and the previous amount = 0 then that fee represents 1 activity in the surcharge category.
    • If the current amount < 0 and the previous amount > 0 and the current amount + the previous amount = 0, that fee represents -1 activity in the surcharge category (ie a fee was added before the reporting period and voided during the reporting period – which means the running sum of that activity should be decreased by 1).
    • For all other cases the fee represents 0 activity in the surcharge category.
  • Surcharge fees totals appear at the end of the details section if the total is not 0:
    • Collected during the reporting period (payment method is not ‘Credit Memo’, ‘Fee Waiver’, ‘Write Off’ or ‘Billed’)
    • Uncollected during the reporting period (payment method is ‘Credit Memo’, ‘Fee Waiver’, ‘Write Off’, or ‘Billed’)
    • Collected before the reporting period (payment method is not ‘Credit Memo’, ‘Fee Waiver’, ‘Write Off’ or ‘Billed’)
    • Uncollected before the reporting period (payment method is ‘Credit Memo’, ‘Fee Waiver’, ‘Write Off’, or ‘Billed’)

Definitions

1. Fees are surcharge eligible if the fee subgroup includes ‘DEQ’.
2. Surcharge categories are defined by a code appearing in the subgroup:
   1. ‘ONS01’ as 'Residential Site Evaluation'
   2. ‘ONS02’ as ‘Commercial Site Evaluation’
   3. ‘ONS03’ as ‘Existing Systems Site Evaluation’
   4. ‘ONS04’ as ‘Construction – Installation Permit Standard Systems’
   5. ‘ONS05’ as ‘Construction – Installation Permit Capping Fill Systems’
   6. ‘ONS06’ as ‘Construction – Installation Permit Pressure Distribution Systems’
   7. ‘ONS07’ as ‘Construction – Installation Permit Sand Filter Systems’
   8. ‘ONS08’ as ‘Construction – Installation Permit ATT (Alternative Treatment Technology) Systems’
   9. ‘ONS09’ as ‘Construction – Installation Permit RGF (Recirculating Gravel Filter) Systems’
   10. ‘ONS10’ as ‘Construction – Installation Permit Other Alternative Systems’
   11. ‘ONS11’ as ‘Construction – Installation Permit Holding Tanks'
   12. ‘ONS12’ as ‘Major Alteration'
   13. ‘ONS13’ as ‘Minor Alteration'
   14. ‘ONS14’ as 'Single Family (Major) Repair'
   15. ‘ONS15’ as 'Single Family (Minor) Repair'
   16. ‘ONS16’ as 'Commercial (Major) Repair'
   17. ‘ONS17’ as 'Commercial (Minor) Repair'
   18. ‘ONS18’ as 'Permit Renewal, Reinstatement, Transfer with field visit'
   19. ‘ONS19’ as ‘Permit Renewal, Reinstatement, Transfer with no field visit'
   20. ‘ONS20’ as ‘Authorization Notice with field visit'
   21. ‘ONS21’ as ‘Authorization Notice with no field visit'
   22. ‘ONS22’ as ‘DEQ only activities’
   23. If a surcharge eligible fee does not have an ‘ONS’ code it is shown as unclassified in the report.
3. ‘Current Amount’: the payment applied, void payment applied or refund applied action happened between the start and end dates inclusively.
4. ‘Previous Amount’: the payment applied, void payment applied ore refund applied action happened before the start date.