Citation closed criteria

[inghamn]

The criteria I used for setting code_cases to closed was not matching people's expectations. The new criteria will likely contain a cut-off date. Citations older than a certain date would be considered closed, no matter what the statuses say.

[inghamn]

Once it's been "Sent to Legal", the legal actions we can consider closed are:

• Uncollectable
• Admin Void
• Undeliverable
• Recalled

We also think, If it's been "Sent to Legal" and there's no legal status, then anything older than 3 years can be considered closed.

[inghamn]

For stuff that hasn't been "Sent to Legal", we can consider it closed if:

    select id
    from citations
    where  status in ('WARNING', 'VOID', 'ADMIN VOID')
    or (status in ('PAID', 'UNCOLLECTABLE')
        and complied_status in ('Complied', 'Abated'))