Am I right to suppose that starting to move solicitors/workers out of T_METUSER is a step on the way to keying users on an integer id so that the text ids will be editable?
In the meantime I have a user who has changed their name through marriage and would like that reflected in their user id.
My thought would be to create a brand new user, then go through and update all solicitation references to the old user to point to the new user. I'd lose a direct connection to things like the audit trail, but I don't think there would be any other issues, right? I'm assuming I can do direct updates on the solicitation tables...
table_name ref_count
T_CONTRIBUTION 1974
T_ORDER 771
T_SOLICITATION 947
T_SPECIAL_ACTIVITY 8454
TX_SOL_TASK 123
Crickets? Has no one ever had to change a user id in T_METUSER to accommodate a name change?