duplicate records waiting for the banner update kay turpin western carolina university
DESCRIPTION
DUPLICATE RECORDS Waiting for the Banner Update Kay Turpin Western Carolina University. Western Carolina University. GWAPP Abolish PIDM Problems. MABUG. You’re excited Your functional users are excited Your IT folks are excited Let’s get this thing installed and running!. - PowerPoint PPT PresentationTRANSCRIPT
DUPLICATE RECORDSWaiting for the Banner Update
Kay TurpinWestern Carolina University
Western Carolina University
MABUG
GWAPPAbolish PIDMProblems
You’re excited
Your functional users are excited
Your IT folks are excited
Let’s get this thing installed and running!
Yeah, sometime in 2011. I can’t wait!
Pssstt! Heard SunGard was
including GWAPP in Banner soon.
WHERE DOES THIS LEAVE YOU?
Students
Employees
Donors
Did you think ahead?installed GWAPP
cleaned-up data BEFORE migrating to Banner
systematically eliminate all evidence of duplicates as they appear in the system
What we did & are doing
during 2009, identified possible duplicates in system and decided each one’s fatecontinue to run weekly reports on possible duplicates which functional users address and determine fate
Information from 2009 and weekly reports to be used to delete records from the system once GWAPP is available
Common Matching workshop for users enhanced common matching on application imports
New duplicates greatly reduced; most caught early
PIDM WCU ID SSN last first dob action person/date/other info
920nnnnn1 Bent N. 1992/10/08 Liz N. UG data moved
920nnnnn2 Bent-DUP N. 1992/10/08 delete
920nnnnn1 Guess M. 1976/08/31 Donna W. HR data moved
920nnnnn2 Wise-DUP M. 1976/08/31 delete unable to remove SSN
920nnnnn1 Allen-DUP P. 1962/11/07 data moved? Matt B. GR
920nnnnn2 Jones P. 1962/11/07
920nnnnn1 Reading-DUP M. 1992/12/10 delete Liz. N. UG data moved
920nnnnn2 Readling M. 1992/12/10
920nnnnn1 West A. 1974/08/03 Matt B. GR
920nnnnn2 Nichols-DUP A. 1974/08/03 data moved?
920nnnnn1 Jones T. 1992/10/08 Liz N. UG
920nnnnn2 Wilson J. 1992/11/13 2 people; ssn removed
What we did & are doing
during 2009, identified possible duplicates in system and decided each one’s fatecontinue to run weekly reports on possible duplicates which functional users address and determine fate
Information from 2009 and weekly reports to be used to delete records from the system once GWAPP is available
Common Matching workshop for users enhanced common matching on application imports
New duplicates greatly reduced; most caught early
Sharing Time
What are you doing?QuestionsCommentsSuggestions
Contact Information:Kay TurpinInstitutional Planning & EffectivenessWestern Carolina [email protected]
This presentation available atplanning.wcu.edu under ‘OIPE Staff Presentations’