amy icon indicating copy to clipboard operation
amy copied to clipboard

Ensure rollover memberships reference the most recent membership

Open maneesha opened this issue 2 years ago • 4 comments

If we roll over a membership, we should have some verification that it is rolling over from the most recent membership.
For example, suppose membership ABC had one term that went 2019-06-01 to 2020-06-01 and an other that goes from 2020-06-01 to 2021-06-01. If we try to do a roll over from the 2019-2020 membership to create a 2021-2022 membership, then we should get a warning that an intermediate membership exists. The membership should be compared by both the name and the main organization.

I'm not sure what the best logic would be to apply this warning, so putting this out here for consideration.

maneesha avatar Nov 19 '21 14:11 maneesha

Is it currently possible to again roll over an already rolled over membership? If yes, then this is an issue because it's not supported by the database design. We only keep track of the single "rolled-over-to" membership.

In case of the warning, we could generate a warning box on top of the "roll over" form.

pbanaszkiewicz avatar Nov 28 '21 13:11 pbanaszkiewicz

A membership should be rolled over only once.

The example I refer to above is when we have a 2019-2020 membership and a 2020-2021 membership, but the second one wasn't created as a rollover since we didn't have the feature then.

A warning box at the top of the form would work.

maneesha avatar Nov 29 '21 14:11 maneesha

Wouldn't it be simpler to produce an administrative job (script) to find all unconnected memberships from consecutive years and then connect them? And then leverage mechanisms preventing multiple roll overs?

I guess it wouldn't prevent users from entering new (disconnected) memberships for organisation X...

Well, my final thought is that it's tricky to accurately tell that user is entering data for membership that may already exist in the system. What if it's a consortium which changed by only one member organisation? What if there's a slip between memberships and there are a few days "in books" without membership coverage?

We may want to discuss this on Friday's call.

pbanaszkiewicz avatar Nov 29 '21 18:11 pbanaszkiewicz

If we complete #2101 then this is low/non-prioirty.

maneesha avatar Dec 03 '21 20:12 maneesha