20210624 PBI Vaccine Compliance Reports
- Ann Crawford (Unlicensed)
- Tedi Tehrani
Owned by Ann Crawford (Unlicensed)
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 | ||
| 10 | review new data set https://app.powerbi.com/groups/8d270e62-be42-48e5-b0db-f2ab22b67d89/list dataset_CovidVaccineCompliance2, with all the vaccines, uses academic quarter and has the testing attributes which includes housing info. | ||
| 10 |
| ||
Discussion
Which quarters are the students registered for needs to be added to the dataset.
The current population will be based on registered quarter and employee must have campusid
Employee taking a class will be a student.
What happens to the campusid on a patient row after an employee stops taking classes?
When a student graduates and is hired full time. The problems associated with a second row are:
- campusid is on the student row so when the login they are considered a student.
- The vaccination row is tied to the patient id for the student so the person (new employee) will not show up as vaccinated. Also true for testing and positives. - E.g. Keri Bradford she is no longer a student but her vaccination is associated with her student id.
Action Items
- Work to clean up vaccinations Ann Crawford (Unlicensed)
- Add all vaccinations when Joseph Chanson gives access to table in pnc Ann Crawford (Unlicensed)
- Update report using new people attributes
- Research how to get data from UC Path for work title and department for Primary Job Tedi Tehrani
- Get CAIR and portal data into the dataflows Ann Crawford (Unlicensed)
- Brain storm report requirements WRT return to campus - All
- Remove (junk) after last name to allow searching.
- 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)