Hi Nadya,

I have TaxCalc application for the property. Basically, each property has a StateUse code and we have Usage table, each StateUse code has UseGrp code. So depending on UseGrp (Commerical/Resedential/Exempt) we calculate tax on a property. There is a table called TaxRate which has rates for each town for this FY (Commercial, Resedential and several additional rates [district rates]).

This is similar to one approach I have considered, adding another table and abstracting the calculation one level further. Luckily, I have a window of time available to look at different methods. Thanks for your input.