Information Quality in an Emergency Notification System

Presentation Transcript

Information Quality in an Emergency Notification System UCCSC Wednesday, June 17, 2009 1:30-2:30pm, 1003 Giedt Hall Rev 3

Welcome! Presentations Marian Sherrin Eric Goodman Audience Campus Alert System Status Statistics Collection Experience with Data Quality

Agenda Data Quality Fundamentals Building Data Quality Into the Project Data Flows & Design Decisions Required Results Comparison to different Campuses Questions and Answers

Data Quality Fundamentals Keep the Goal in Mind!

Building 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!

Must Haves Set Data Quality Goals Early Keep the Goal in Mind!

Desired Phase 1 Phase 1 Phase 1 NOT Req for Phase 1 NOT Req for Phase 1 Keep the Goal in Mind!

High 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!

Student 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

Staff/Faculty Screens

Staff/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

Data 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

Major 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)

Key Actions Taken

Completeness Actions From W.A.R.N. Summon daily Annual Load All Campus Phones Office Reception Hall Classroom Residence Halls RA/CRE Duty Phones

UCSC 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.

Emergency Notification System Status (UC grounds)

Methods & 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

Methods & 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.

Key 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

Q&A

Reference 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

Presenter/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.