[From Swee]
I have encountered problem when I did a update_banner_id_changes. We
should NOT assign a bogus ods_id to some of the secretaries who do not
have an entries in the ODS.
We assigned a bogus ods_id='1' to 'a' (WS secretary). When I
updated Spring 2008 data, the ods_id=1 have been assigned in the ODS.
Therefore, 'a' had overwritten with 'b'. So, 'b' become the staff role for WS. I have removed 'b' from the
Admin_and_staff table.
We also had assigned two more bogus ods_id to the following secretarys:
700000 'c'
700001 'd'
To solve it:
1.) Add the secretary into the banner, so that they will have a unique
person_uid. I have talked to Judy from ODS, and she said she will
bring that up in the upcoming banner meeting.
2.) If the charset of person.ods_id is varchar, then the bogus ods_id
should start with 'CAFE-' to avoid the collision of the same ods_id.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment