...
Users with an O365 or Eliapps account can delete it, and users with one type of account can get the other. So you can transition between Type 1 and 3, or 2 and 3. This is a delicate process because IIQ cannot directly move a field like ProxyAddresses from a User object to a Contact object in a single transaction (as would be possible with database SQL). This is, however, a manual process and is outside the scope of the current design.
There are 555 Primary Email Aliases in the Alias table where the MAILBOX is "first.last@connect.yale.edu" instead of "netid@connect.yale.edu". These have to be fixed for the new code to work.
There is bad data in the Alias table which will have to be cleaned up. For example, some O365 users have a MAILBOX value that is not "Netid@connect.yale.edu" and alternate names for that MAILBOX have to be changed to the proper value in order for the grouping to work correctly. Bad data that represents aliases to mailboxes that no longer exist may or may not be cleaned out (the mail would have bounced before and will bounce after, although the exact way it bounces may change).
...