Information Quality in an Emergency Notification System UCCSC Wednesday, June 17, 2009 1:30-2:30pm, 1003 Giedt Hall Rev 3
Slide 2Welcome! Presentations Marian Sherrin Eric Goodman Audience Campus Alert System Status Statistics Collection Experience with Data Quality
Slide 3Agenda Data Quality Fundamentals Building Data Quality Into the Project Data Flows & Design Decisions Required Results Comparison to different Campuses Questions and Answers
Slide 4Data Quality Fundamentals Keep the Goal in Mind!
Slide 5Building DQ into the Project Team Structure VC Student Affairs as colleague assisted with process and correspondence. We thought that it was critical to concentrate on Staff/Faculty and Students independently Chair: VC Vani Co Chairs: Chris Gaylord/Doug Hartline Project Mgr: Marian Sherrin Chair: Biz Lead: Tech Lead: C:Marian Sherrin B:Alma Sifuentes T:Greg Gaither C: Naomi Gunther B:Cathy Schoenfeld/Nancy Degnan T: Bob Oberg C:Chris Gaylord B:Chris Gaylord C: Ed Titus T: Ed Titus/John Rudd C: Jim Burns Keep the Goal in Mind!
Slide 6Must Haves Set Data Quality Goals Early Keep the Goal in Mind!
Slide 7Desired Phase 1 Phase 1 Phase 1 NOT Req for Phase 1 NOT Req for Phase 1 Keep the Goal in Mind!
Slide 8High Level Project Timeline 3/21/08 4/2/08 6/1/08 7/1/08 July'08 July/Aug'08 Sept'08 Jan'09 May'09 T - 2 T - 1 T0 T1 T2 T3 T4 T6 Student data gathered Charge Letter Student and Non-University Contact Information gathered with Fall Registration #2 Test of EOC and DOC Coverage #2 Campus Communication to Request for extra contact data Project Proposal Approved Campus Implementation Schedule Modifications made to AIS (if necessary) Intercept July AIS Release New Student Orientation Contract Start date #1 Campus Communication incorporates demand to refresh registry & CruzAlert Opt In Page for Staff & Faculty Project Charter Approved Student information compulsory for Winter'09 Phase 1 information transmitted to WARN #3Test of ability of email and cell SMS Required to enhance information quality properties: Accuracy Timeliness Validity Returning Student Communication Request for extra contact data #1 Test capacity of office phone frameworks Great chance to get to new understudies and their folks. New understudy mobile phone fulfillment 85%! (returning understudies 4%) Returning understudy fulfillment rate increments from 4% to 98% (Cell – 83%, Landline 63%) (2% Opt Out) Keep the Goal in Mind!
Slide 9Student Screens Students pick kind of telephone Breaking into 3 boxes will help with legitimacy, however organize case has helped Students must approve data every year Opt-out ability was new
Slide 10Staff/Faculty Screens
Slide 11Staff/Faculty Screens Pre-populated with Name, Cruzmail address, and office telephone You can change your office telephone (without affecting catalog information) or include a moment one under Additional Phone Add your Cell telephone for SMS/Text messages Home number might be utilized for grounds terminations Add an email on the off chance that CruzMail is out of administration
Slide 12Data Flow Pinnacle Phone New: Campus Phones & Resident Hall Phones W.A.R.N. Communicate RA Duty Phones New: RA Duty Phone AIS New: Opt Out Flag New Extracts: All Phones All Work All Home All Cell WARN INCONNECT Currently Existed: Status & Data Identity Manager (likewise CruzMail ROO) CruzAlert Oracle Table PPS W.A.R.N. Summon Only utilized excellent information: Employee Status Academic HR New: RA Group Online Directory Student Housing
Slide 13Major Design Decisions Student Workers – Count as understudies Resident Advisors (RA) – Used SHO versus PPS CTO Codes RA Duty Phones – Manually stack every year Separations From work – Exclude by means of PPS Graduation – Exclude by means of AIS Dropping out, exchanging – Exclude through AIS Leaves, Sabbaticals, Temporary Assignments – Exclude Summer Sessions/Non-degree – Include by means of AIS Emeritus – Include (some still live on grounds) Sundry – Include (email just) Visitors/Conferences – Include in Phase 2 – New Process Parents – excluded in Phase 1 (understudies could utilize nearby telephone)
Slide 14Key Actions Taken
Slide 15Completeness Actions From W.A.R.N. Summon daily Annual Load All Campus Phones Office Reception Hall Classroom Residence Halls RA/CRE Duty Phones
Slide 16UCSC Results May 2009 Campus Population: 19,850 Active Students -15,590 Employees -4,260 Staff - 3,240 Faculty - 1,020 *100% secured by WARN Broadcast list covering ALL grounds telephones.
Slide 17Emergency Notification System Status (UC grounds)
Slide 18Methods & Results Methods Mandatory with Opt Out Opt In Hybrid UCSC Choice – Hybrid Mandatory for UC "possessed" records/gadgets UCSC Email UCSC Networked Phones Student Residence Phones Mandatory with Opt Out Student telephone contact by means of either: Cell/Mobile We make to WARN SMS Local Landline Employee Personal Data - Opt In Specific Office Phones Personal Cell telephone We make WARN SMS Home/Alternate Phone Personal Email
Slide 19Methods & Results Methods Mandatory with Opt Out Opt In Hybrid UCSC Choice – Hybrid Mandatory for UC "claimed" accounts/gadgets UCSC Email UCSC Networked Phones Student Residence Phones Mandatory with Opt Out Student telephone contact through either: Cell/Mobile We make to WARN SMS Local Landline Employee Personal Data - Opt In Specific Office Phones Personal Cell telephone We make WARN SMS Home/Alternate Phone Personal Email (1) 71% of staff/workforce particular telephones in W.A.R.N. Charge 100% of grounds telephones in W.A.R.N. Communicate (2) Percent of aggregate populace, not simply staff/workforce. (3) Source: UCR Larry L. Sautter Award Application, 2008 (4) Launch was April 2009.
Slide 20Key Takeaways Understand Data Quality Fundamentals Build Data Quality Into the Project Keep the End in Mind Teams Goals Schedule Make the Right DQ Decisions Measure Results Continuously Improve
Slide 21Q&A
Slide 22Reference Sources Larry P. English , Improving Data Warehouse and Business Information Quality , John Wiley & Sons, Inc., New York, NY. 1999 DOD Guidelines on Data Quality Management (Summary), ~1997 http://www.tricare.mil/ocfo/_docs/DoDGuidelinesOnDataQualityManagement.pdf Larry McGrath & Joel Nylander, UC Riverside Application for 2008 Larry L. Sautter Award, 2008
Slide 23Presenter/Contributor Biographies Marian Sherrin New to the University of California, Santa Cruz, in 2008. She was the Data Quality Manager for Intel's Supply Chain Network from 1999-2005. Eric Goodman Joined the University of California, Santa Cruz in 1990. For as far back as quite a while has been the venture administrator of UCSC's Identity Management framework.
SPONSORS
SPONSORS
SPONSORS