20210617 PBI Vaccine Compliance Reports

Date/Time/Location

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 report 

Expected Preparation



Agenda

TimeTopicOwnerNotes and Details
60Review 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