the assessment system works on a township cycle, not a municipal cycle, so some municipalities might have some PINs in one assessment stage and other PINs in a different stage.
Possible solution
I think the best way around this is to add an additional column on the assessment_roll version indicating, for each municipality, for the year & stage, the percentage of its PINs that have passed through that year & stage.
The ideal behavior of this "percent complete" column would be if the percent indicator had "memory." For example:
if a multi-township muni like Chicago had fully passed through the 2023 certified stage but only 50% of its PINs had reached the 2023 bor stage, then the percentage indicator would say 100% when year = 2023 and stage = assessor certified, and 50% when year = 2023 and stage = bor.
and, because in this scenario 2022 is complete, then for all 3 stages, the percent complete would be 100%.
In reporting, we currently have vw_assessment_roll and vw_top_5 for townships. I'd like to create two similar separate views for municipalities.
Use case
Complication: Assessment cycles
the assessment system works on a township cycle, not a municipal cycle, so some municipalities might have some PINs in one assessment stage and other PINs in a different stage.
Possible solution
I think the best way around this is to add an additional column on the assessment_roll version indicating, for each municipality, for the year & stage, the percentage of its PINs that have passed through that year & stage.
The ideal behavior of this "percent complete" column would be if the percent indicator had "memory." For example: