Data Services Landing Page

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 
• Intro meeting

Expected Preparation

Agenda

Discussion 

Requirements

• Development will be in the campus tenant
• Need to slice on ethnicity, student year, greek, housing, patient sex and trends on vaccinations
• Reports will be based on the testing compliance deep dive individual report plus a summary report 

Created a prototype dataset in https://app.powerbi.com/groups/8d270e62-be42-48e5-b0db-f2ab22b67d89/list dataset is called dataset_CovidVaccineCompliance - this has only UCSB administered vaccines.

Added Student Class to the people dataflow

We will meet each day 4:30 -5:00 for updates

Reviewed the CAIR XML PncRegdb.dbo.[tblImmunizationRegistryResponse].responseXML - it looks like the vaccine code is from here https://www.cdc.gov/vaccines/programs/iis/COVID-19-related-codes.html

<Immunizations>
<Immunization>
<VaccineCode>207</VaccineCode>
<VaccineName>COVID-19, mRNA,LNP-S,PF, 100 mcg/0.5 mL</VaccineName>
<AdministrationDate>2021-04-10T00:00:00.0000000</AdministrationDate>
<CompletionStatus>CP</CompletionStatus>
<AdministrationNotes>00</AdministrationNotes>
</Immunization>
<Immunization>
<VaccineCode>207</VaccineCode>
<VaccineName>COVID-19, mRNA,LNP-S,PF, 100 mcg/0.5 mL</VaccineName>
<AdministrationDate>2021-05-07T00:00:00.0000000</AdministrationDate>
<CompletionStatus>CP</CompletionStatus>
<AdministrationNotes>00</AdministrationNotes>
</Immunization>
</Immunizations>

Action Items

• Create first prototype @david Sanders
• Get CAIR and portal data into the dataflows