20210617 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 report
Expected Preparation
Agenda
Time | Topic | Owner | Notes and Details |
---|---|---|---|
60 | Review report and issues | All | |
Discussion
Brian and David reviewed prototype report this has only UCSB administered vaccines. Report shows vaccinated
There are lots of duplicates since employees who are also students have two patient records
Valid people should have a value in campusid
Need work title and department from UC path, it is currently coming from the Qualtrics survey
CASE reg.class_Level
WHEN 'SR' THEN 'Senior'
WHEN 'JR' THEN 'Junior'
WHEN 'SO' THEN 'Sophomore'
WHEN 'FR' THEN 'Freshman'
WHEN 'SB' THEN 'Second BA'
WHEN 'LM' THEN 'Limited'
WHEN 'MA' THEN 'Master''s'
WHEN 'P1' THEN 'Doctoral'
WHEN 'P2' THEN 'Doctoral'
WHEN 'P3' THEN 'Doctoral'
WHEN 'PF' THEN 'Professional'
WHEN 'UC' THEN 'Unclassified'
ELSE 'none'
END
Action Items
- Create first prototype @david Sanders and @Brian Shively
- Normalize the class attribute as shown above - may use shorter codes than the full name displayed in the case statement above - @david Sanders and @Brian Shively
- What happens when a student gradates and starts working at UCSB? Ann Crawford (Unlicensed) - Ask Mark Mcgilvray (Unlicensed)
- Ask Mark Mcgilvray (Unlicensed) what to do about blank campus ids and how do we know what records should have the id. Why are so many blank? Campus id will be used to determine valid people Ann Crawford (Unlicensed)
- Request a confluence account for Brian and David Tedi Tehrani
- Ask Mark Mcgilvray (Unlicensed) about the AFF that are not people like AF10000271, and AF10000549 these are rooms and they are in UC Path Ann Crawford (Unlicensed)
- 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)