20210630 PBI Vaccine Compliance Reports
Date/Time/Location
Attendees
Attendee | Present | Notes |
---|---|---|
@brian Shively | ||
@David Sanders | ||
Tedi Tehrani | ||
Ann Crawford (Unlicensed) | ||
Meeting Goals and Expected Preparation
Goals
- Create compliance reports on Covid Vaccinations
- Review new dataset
Expected Preparation
review return to campus conditions
Agenda
Time | Topic | Owner | Notes and Details |
---|---|---|---|
10 min | status updates and review - see comments in previous pages | ||
20 | How to identify UCSB population given 2 ids for many people. 357733 - patients in PncRegDB.dbo.tblpatient 19173 - patients in PncRegDB.dbo.tblpatient | all | |
Discussion
First make reports then identify errors to see if significant.
- Registered students for current and next quarter are the priority
- Active staff is second priority - this will be all rows with a campus id that are not deactivated
Action Items
- Research how to get data from UC Path for work title and department for Primary Job Tedi Tehrani
- Brain storm report requirements WRT return to campus - All
- Define the scope of the issue associated with having two patient ids for the same person. How many people? How many work at UCSB and also were a student? How many have events associated with two different ids? Ann Crawford (Unlicensed)
- Are emeriti included in the faculty count? Ann Crawford (Unlicensed)
- Clarify Class level definitions (ask mike) Ann Crawford (Unlicensed)
- UCPATH needs to be the source for job title and department. Need to check with Josh Andersen and Mark Mcgilvray (Unlicensed) on the status of the UCPATH data. Is there an API? Possible to get it from API.
- Campus housing, athlete, greek need a single click (Yes/No) page and a deep dive page into the types of housing, greek, sport.
- Need to list in progress, not started and fully vaccinated as measures
- Need a vaccination source dimension: UCSB, CAIR, Self Ann Crawford (Unlicensed)
- Possibly need to know the status of the CAIR query (no data, ambiguous, success)
- Investigate the query in compliance for UCSB population Ann Crawford (Unlicensed)
- Employees that were active students were deactivated in a batch in January 2021. They are not deactivated as a rule in the Employee feed (we do not deactivate an employee or student when they separate). Students that are not longer students and become only employees are handled on a case by case basis (that's two ).