elplatt
Key sanity audit reports
I love that seltzer allows an individual user to have multiple keys, but the loose association between users and keys makes discrepancies less obvious. I would like to have reports which tell me:
Members who have multiple active keys.
Members in good standing who have zero active keys.
Members in good standing who have zero key records of any kind (active, expired, not active yet).
Keys not associated with a member. (Is that even possible? I hope not!)
Thanks!
Another useful report: Lapsed members (not in good standing) whose keys don't have an end-date recorded. Or whose end-date is not in the past.
Also a key-exceptions list which would be the above plus slots which show two entries, i.e., any slot that has two keys assigned to it.
