Python Licensing Tax Automation Script

I need a Python script that links directly to my existing SQL Server database, fetches WS-GROSS-RECEIPTS, and returns the correct WS-LIC-TAX for each record. The core rule is simple—multiply gross receipts by 0.005—yet the script must recognise when a licence falls under a “Flat Fee” category. In those cases, and whenever receipts sit below the defined threshold, the percentage is bypassed in favour of the fixed minimum (currently $200.00, held in a constants section you will expose for easy updates). Police Fund licence types keep their prevailing 0.5 % rate.

Multiple licence types will flow through the same routine, so the code should evaluate the type field, decide which calculation path applies, and write the resulting tax back to the database (or return it as a data frame if that is cleaner for you).

Key expectations
• Clean, well-commented Python (3.x) with a clear constants/config block
• Reliable connection logic for SQL Server (I already use SQL Server Management Studio; pyodbc or a similar driver is fine)
• Error handling for missing receipts, unknown licence codes, and DB connectivity issues
• A brief README or inline usage notes so I can run and adapt the script quickly

If you have questions about edge cases—especially around licence series 42—let me know and I’ll clarify before you dive in.