« New Race/Ethnicity | Main | Web Registration Changes »
January 29, 2010
SPBPERS record cleanup
While I was running the conversion script, I ran into several problems that caused the script to abort. It seems that we have lots of bad data in our spbpers table (general person table). I've been working with the Banner Team to get these cleaned up.These are some of the problems I've ran into so far...
Invalid legacy code: spaces were inserted into spbpers_lgcy_code
Invalid religion code: spaces were inserted into spbpers_relg_code
Invalid deceased indicator: deceased date was entered but deceased indicator was not checked.
Invalid citizen code for employees: several records where spbpers_citz_code was null.
Invalid birth date: several records where the spbpers_birth date was prior to 1900.
Invalid pidms: several records where the person did not have a pidm in spriden.
Posted by soukupm at January 29, 2010 1:57 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)