20210621 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

Discussion 

Questions about campusid have been posted in the covid_19 vaccine slack channel.  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 - Tedi Tehrani is waiting for response from ETS.

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 graduates 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)

Question: 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)

Answer:

• CampusID is used to login to the patient portal.
• If a patient record does not have a CampusID they cannot login to the portal as that patient.
• It also denotes which patient record is the primary active patient record if a patient has a Student and an Employee record.
• If we combine a patient record's PHI with an Employee record this would constitute HIPAA, which we are working to avoid.

Follow Up: In the dataset there are 8,912 rows for which isEmployee == "True" and UCSBCampusID == null. A lot of them are retired/terminated/student employees. But I found about 50 that I think are active employees (per UCPath) and have no campus ID (per the dataset). A few random examples are:

• 10035388 (Joaquin Becerra) - deactivated since 1/4, student account active
• 10071106 (Edward Lee) - deactivated since 1/4
• 10204179 (Jonah Seif) - deactivated since 1/4, student account active
• 10202011 (Aimee Hanna) - deactivated since 1/4
• 10035959 (Keri Bradford) - deactivated since 1/4, student account active
• 10073844 (Angela Cantu) - deactivated since 1/4

I have not looked at isStudent == "True" UCSBCampusID == null at all.

When an employee account is deactivated typically the student account is the active account. Give that there are 300,000+ patient accounts and we just added employees not every one of these is correct. We wait for the student/employee to contact us to resolve conflicts.

Question: 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)

Answer: I do not know what AF10000271 and AF10000549 are. They are not patient accounts in PnC?

Follow Up: There's an extra zero in the patient numbers. Both are in PnC: AF1000271 and AF1000549

Answer: Correct, these look to be rooms. We are not able to say "which accounts brought into the system are not people".

Question: What happens when a student graduates and starts working at UCSB?  Ann Crawford (Unlicensed) - Ask Mark Mcgilvray (Unlicensed)

Answer: See the answer above, e.g., we wait for the employee to let us know that they are no longer a student.