Hello! We store multiple alt IDs to assist in matching and deduping when loading records. We typically have IDs from our student/admissions system, student/financial aid, athletics ticketing, HR system, patient system, and a few others. (we have 11 active types.)
What is frustrating is that we have to append a suffix (eg: -A for athletics or -H for HR) because we can't seem to be able to have IDs with the same value, even though they are a different type. So a 7-character ID of 1234567 of Athletic type, can't exist if there is a 1234567 of HR type.
This creates problems for our users if they are trying to load a selection using the alt lookup Id, which happens a lot more than you would think. They have to manipulate the ID column, concatenate etc to get the “right” ID type - and we've even further complicated things because we added an additional appendage for our Athletic Ids of -001 or -002 because households share the same IDs.
How does everyone else deal with this??