20210629 PBI Vaccine Compliance Reports

Owned by Ann Crawford (Unlicensed)
Last updated: Aug 14, 2023 by Tedi Tehrani
2 min read

Date/Time/Location

Date
  
Time4:30-5:00
Locationhttps://ucsb.zoom.us/j/88564639975?pwd=SVFyZ1U4cjFRUjFHdmpKRGZvQ0ZNdz09

Attendees

AttendeePresentNotes
@brian Shively(tick)
@David Sanders(tick) 
Tedi Tehrani(tick)
Ann Crawford (Unlicensed)

(tick)






Meeting Goals and Expected Preparation

Goals

  • Create compliance reports on Covid Vaccinations 
  • Review new dataset 

Expected Preparation

review return to campus  conditions


Agenda

TimeTopicOwnerNotes and Details
10 minstatus updates and review - see comments in previous pages 

20

Comments from with Dr. Skirpkus in the noon meeting  

  1. Set Target to 75% instead of 80%
  2. Are emeriti included in the faculty count?
  3. Clarify Class level definitions
  4. 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.
  5. Campus housing, athlete, greek need a single click (Yes/No) page and a deep dive page into the types of housing, greek, sport.
  6. Table listing people in the numbers is not needed
  7. Need to list in progress, not started and fully vaccinated as measures
  8. Staff and Student are mutually exclusive. If a person is both, use student
  9. Need a vaccination source dimension: UCSB, CAIR, Self
  10. Possibly need to know the status of the CAIR query (no data, ambiguous, success)










Discussion 


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)
  • Set Target to 75% instead of 80% - done
  • 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
  • Staff and Student are mutually exclusive. If a person is both, use student
  • Need a vaccination source dimension: UCSB, CAIR, Self
  • 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)
  • Update employee feed to find the separated or check with Mark Mcgilvray (Unlicensed) how are employees deactivated?  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 (smile)).