Alumni Records

1
Alumni Records Information Systems

• Alumni Database Maintenance Management
• Development Need-to-Know Meeting
• June 9, 2008

2
Alumni Records Information Systems
The Mission!
403 Table Types
255,000 Records
48 Record types 13 Record Status
29 Address Types 5 Address Status
gt500 Data Elements
Accurate, consistent, maintainable

• Active Home Addresses 79,564
• Active Business Addresses 35,449
• Active Home Email Addresses 31,921
• Active Business Email Addresses 17,015
• Home Address Changes Last 12 Mos. 24,203 (30)
• Active Primary Employment Records 45,011
• How Many gt 5 Years Old 29,619

3.5 people entering biographical data on these
records 70 people responsible for
biographical data on these records
3
Alumni Records Information Systems
Sources Daily Updates Dev Offices/ers Gifts WebSi
te Lost Searches Individual
Mass Mailings Letters Newsletters
Magazines Clippings Email Listserves Volunteers
Chapters Boards Events Class
Notes Reunions
4
Alumni Records Information Systems
Tools Employed Alumni Finder ACS Online
Community Lost Search Data Service Clipping
Services Phon-a-thon Reports Listserves CASS on
Bulk Mail Status Update Report from
Registrar Phone Appends
Procedures Audits Lost Alumni Lost
Yesterday Lost-alumni-l On Line Community
Updates Automated Manual Address Correction
System Automated Manual Listserves Bounce
Comparison Phone Coding Cell Coding Email
Coding
Difficulties Email Voluntary, volatile Phone
Voluntary, volatile Employment Voluntary Home -
Involuntary
5
Alumni Records Information Systems

• alumni.records_at_wm.edu