recruiting information systems: making the data accessible a case study from the university of new...
TRANSCRIPT
![Page 1: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/1.jpg)
Recruiting Information Recruiting Information Systems: Making the Data Systems: Making the Data
AccessibleAccessible
A Case Study from the A Case Study from the University of New OrleansUniversity of New Orleans
Management of Student Management of Student Information SystemsInformation Systems
July 16 – 19, 2000July 16 – 19, 2000
![Page 2: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/2.jpg)
Paul M. WeiserPaul M. WeiserAssistant to the Dean forAssistant to the Dean forInformation ProcessingInformation Processing
University of New OrleansUniversity of New Orleans
[email protected]@uno.edu
![Page 3: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/3.jpg)
Chapter 1
Setting the Stage
![Page 4: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/4.jpg)
University of New Orleans•Louisiana’s urban university-195 acres on Lake Pontchartrain
•Member of the Louisiana State University System
•16,000 students (12,000 undergraduates and 4,000 graduates)
•44 undergraduate programs, 34 master’s and 10 doctoral
•Primarily a commuter school (81% from N.O. metro area)
•Recruiting efforts increased for out of state students
![Page 5: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/5.jpg)
![Page 6: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/6.jpg)
Current Legacy System for Student Current Legacy System for Student Academic Records, Admissions, and Academic Records, Admissions, and Recruiting:Recruiting:
•Online since 1988•IMS Hierarchical Database (homegrown)•Runs on IBM 3270 Mainframe•Text-based user interface•Coming Soon: PeopleSoft (campus wide)
![Page 7: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/7.jpg)
![Page 8: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/8.jpg)
![Page 9: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/9.jpg)
Query: To Convert Data into Meaningful Query: To Convert Data into Meaningful Information. UNO – Centralized Query Information. UNO – Centralized Query System:System:
•All run by Office of Registrar or Admissions•Using Computer Associates “EARL”•EARL: Text-based, very similar to COBOL•Delivery Truck
![Page 10: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/10.jpg)
![Page 11: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/11.jpg)
![Page 12: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/12.jpg)
![Page 13: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/13.jpg)
•Select one student and view all contacts•2 options: Detail or Summary
Recruiters can:
![Page 14: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/14.jpg)
Chapter 2
The Problem Explained
![Page 15: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/15.jpg)
•Driven by contact codes and dates•All contact activity is stored•Began storing contacts in 1995•Current contact flatfile > 1.8M
Current Recruiting Information System:
![Page 16: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/16.jpg)
![Page 17: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/17.jpg)
![Page 18: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/18.jpg)
Recruiters cannot:
•Extract information based on a specific contact•Analyze geo-demographic patterns and trends•Create adhoc queries•Access information while on the road•Evaluate the Success of their Efforts ($$$$)
![Page 19: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/19.jpg)
Chapter 3
The First Solution
![Page 20: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/20.jpg)
Solution #1
Give Recruiters Access to ContactData on the Mainframe
![Page 21: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/21.jpg)
![Page 22: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/22.jpg)
![Page 23: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/23.jpg)
Need a System that is:
•Easy to use•Graphical•Portable•Able to be shared•Flexible•Cost Effective (i.e. cheap)
![Page 24: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/24.jpg)
Chapter 4
The Second Solution
![Page 26: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/26.jpg)
![Page 27: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/27.jpg)
![Page 28: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/28.jpg)
![Page 29: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/29.jpg)
•Select prospects based on any field•Specific value or range of values•Can provide detail and summary info.•Information can be shared with others•Seamless integration into other apps•Easily upgradeable / updateable•Flexible presentation of information•Easily placed on laptop for travel•Gives control of information to end user•Cost effective
![Page 30: Recruiting Information Systems: Making the Data Accessible A Case Study from the University of New Orleans Management of Student Information Systems July](https://reader036.vdocuments.us/reader036/viewer/2022070415/5697c00a1a28abf838cc7caf/html5/thumbnails/30.jpg)
•I.T. staff creates ASCII file from IBM mainframe•Import into MS-Access using pre-defined delims•Recruiters use data at their own discretion•Fresh data easily imported
Recipe for Converting Data into Information: