the show must go on · 2020. 5. 12. · the show must go on: how to react & respond to...
TRANSCRIPT
![Page 1: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/1.jpg)
The Show Must Go On: How to React & Respond to Personnel
Changes in IRYgnacio Lopez III, Vyas Krishnamurthy
University of HoustonMarch 3rd, 2020
![Page 2: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/2.jpg)
Overview
• Background• Loss of Personnel• Recovery Plan• Key Points of Planning in other IR Offices• Conclusion
![Page 3: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/3.jpg)
University of Houston• Flagship of the University of Houston system
• 16 colleges• Medical School starting Fall 2020• 250+ undergraduate, graduate and professional programs
• Fall 2019 Enrollment: 46,148 • FY 2019 Degrees: 10,568
![Page 4: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/4.jpg)
Institutional Research
• 5 staff members, 2 research assistants
Provost
Institutional Research and Effectiveness
Institutional Research and Information Management
IE Assessment & Accreditation
![Page 5: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/5.jpg)
TAIR 2019 Presentation – CB Flow Chart
![Page 6: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/6.jpg)
TAIR 2019 Presentation – Things I Wish I Knew (Better)
• “Go To” people when personnel changes are made
![Page 7: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/7.jpg)
Loss of Personnel
• Summer 2019• Assistant Director • Senior Research Analyst
![Page 8: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/8.jpg)
Effects
![Page 9: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/9.jpg)
Transactional Tables
Records and enrollment
Curriculum Management
Student Admissions
Campus Community
TSI Maintenance
HRMS
Curriculum Management
Transactional Tables
DATA EXTRACT PROCESSES
Enrollments Extract EditPers Student Extract EditStudent History Extract
Students (001)
Class Data ExtractClass Instructor Extract Edit
Enrollments Extract EditInter-Institutional Class Xchg
Student History Extract
Classes (004)
Class Data Extract EditEnrollments Extract Edit Building & Room
(005)
Class Data ExtractClass Instructor Extract Edit
Enrollments Extract EditStudent History Extract
Grades (00S)
DATA EXTRACT PROCESSES
Job Extract EditPers Faculty Extract Edit
Class Data ExtractClass Instructor Extract
Faculty (008)
Enrollments Extract EditPers Student Extract EditStudent History Extract
End of Semester (0E1)
Reporting Table Load
![Page 10: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/10.jpg)
Recovery Plan
• Junior Personnel Perspective
• Senior Personnel Perspective
![Page 11: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/11.jpg)
Recovery Plan (Junior)
• Create direct communications with other offices• Office of University Registrar (OUR)• Admissions
• Undergraduate • Graduate• International
• Graduate Program/Student Records• Various College Department Personnel
• Assist new office personnel in other offices• Understanding IR processes
![Page 12: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/12.jpg)
Transactional Tables
Records and enrollment
Curriculum Management
Student Admissions
Campus Community
TSI Maintenance
HRMS
Curriculum Management
Transactional Tables
DATA EXTRACT PROCESSES
Enrollments Extract EditPers Student Extract EditStudent History Extract
Students (001)
Class Data ExtractClass Instructor Extract Edit
Enrollments Extract EditInter-Institutional Class Xchg
Student History Extract
Classes (004)
Class Data Extract EditEnrollments Extract Edit Building & Room
(005)
Class Data ExtractClass Instructor Extract Edit
Enrollments Extract EditStudent History Extract
Grades (00S)
DATA EXTRACT PROCESSES
Job Extract EditPers Faculty Extract Edit
Class Data ExtractClass Instructor Extract
Faculty (008)
Enrollments Extract EditPers Student Extract EditStudent History Extract
End of Semester (0E1)
Reporting Table Load
![Page 13: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/13.jpg)
Recovery Plan (Junior)
• Assist new office personnel in other offices• Understanding IR processes
• Improve work flow methods• Implement accountability
• IR SharePoint Task List• Bi‐Weekly Work Activities
![Page 14: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/14.jpg)
UH IR SharePoint Task List
![Page 15: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/15.jpg)
Bi‐Weekly Work Activity Updates
![Page 16: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/16.jpg)
Recovery Plan (Junior)
• Assist new office personnel in other offices• Understanding IR processes
• Improve work flow methods• Implement accountability
• IR SharePoint Task List• Bi‐Weekly Work Activities
• Identify what needs improvement• Expand knowledge base
• Query usage in Peoplesoft• Deeper knowledge of data in CB tables/reports
![Page 17: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/17.jpg)
UH PeopleSoft Query Manager
![Page 18: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/18.jpg)
UH Pers Student Extract Table
![Page 19: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/19.jpg)
UH Enrollments Extract Table
![Page 20: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/20.jpg)
UH Student History Table
![Page 21: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/21.jpg)
UH CB001 Table
![Page 22: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/22.jpg)
Recovery Plan (Senior)• Responsibilities
• Pre July 2019:• CB9 Graduation, Graduation Surveys• Graduation and Retention• Financial Aid Reporting• Data Requests • Data Warehouse• Web content• IT management
• Post July 2019:• CB8 Faculty, Faculty Surveys• PeopleSoft Query Training
![Page 23: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/23.jpg)
CB8 Faculty Process
• CB8 Process flow• Understand HR data• Faculty Tenure data• Error Correction• Faculty Surveys
![Page 24: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/24.jpg)
Query Training• Class Length
• Fifteen hours• 5 consecutive days, 3 hours per day
• Participants• Users wanting access to be able to write queries in the PeopleSoft student module
• Frequency• 3 times a year (spring, summer, fall)
• Uses Training Database• Partner with IT
![Page 25: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/25.jpg)
Query Training Outline
I: Query Fundamentals
II: Basic PeopleSoft Query Writing
III: Advanced PeopleSoft Query Writing
Appendix: Sample SQL Functions, Troubleshooting Queries, New
Functionality, Assessment Exercises
![Page 26: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/26.jpg)
Reporting Tables
![Page 27: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/27.jpg)
Recovery Plan (Senior)• Assist new office personnel
• Understanding data and processes• Catch up to speed• Establish working relationships• Tableau
• Sharing • Responsibilities• Projects
• Best practices• IT structure
• Data server Management and Backups• Computers: setup, add to network, software
![Page 28: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/28.jpg)
Recovery Plan (Senior)• Change of personnel in other offices
• Financial Aid• Registrar
• Director of Institutional Effectiveness & Accreditation • Left UH Feb 2020• SACS work
![Page 29: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/29.jpg)
Key Points of Planning (Junior)
• Communication• Knowing as many personnel in other offices• Asking questions to better learn processes
• Documentation• Error logs for corrections each semester• Email lists updated each semester for office contacts
• Better self‐assessment of office role/contribution
• Development of skill set• Involvement in trainings, courses, and conferences
![Page 30: The Show Must Go On · 2020. 5. 12. · The Show Must Go On: How to React & Respond to Personnel Changes in IR Ygnacio Lopez III, Vyas Krishnamurthy University of Houston March 3rd,](https://reader034.vdocuments.us/reader034/viewer/2022051902/5ff25090c8d78467c30b8587/html5/thumbnails/30.jpg)
Key Points of Planning (Senior)
• Transition• Work done by staff who is leaving• Identify who take overs and training
• Documentation• Processes/Steps/Errors• Include details
• One person should not do and know all• Knowledge transfer/share