We have a situation with our teacher records in Tessitura. It has come to our attention that (for whatever reason) they are set up in OI format with both N1 and N2 being used for the teacher's name under our HCO constituency. That's right, instead of the school name being N1 and N2 being the teacher's name, it's in both.
Our concern is how to prepare these records for the migration with minimal consternation. Any suggestions?
Anyone?
Thanks, Tessiturians.
We've also found a number of irregularities in our account data. This seems like a great time to attack these systematically.
I wonder what the best end result would be - keep the same constituent type and update the N1 to the school name? Or make the accounts individual types? I guess that would depend on how you want them to look after the v11 migration. Is the school connected to the teacher in some other way, like an association? If you've got an association, changing the accounts to indiv's and making the n2 the n1 might be the right way to go. You could do that easily enough with a sql update.