I have come across an issue that I am sure has plagued others before. Way back in the heady days of 7.5 being implemented the business made a decision to opt out of a numerical ID system for our Person and User ID records. Instead we opted for <First Initial><Surname> e.g. NTAYLOR.
The problem we have is that one of our users got married and now the Person ID and User ID do not reflect her now taken name and has asked if we can update the Person ID/User ID to correctly reflect her new surname. As these are somewhat key fields within the system I am pretty sure there isn’t a standard way of achieving this as it would need to flush the entire system to update everything that was ever posted with these ID’s.
If anyone knows of a way how to do this or (for the IFS employees) if a data fix exists for this kind of change it would be interesting to know!
Best answer by ntaylorView original