Page Comparison

Date/Time/Location

...

Discussion 

• Published dataset dataset_CovidVaccineCompliance5 in development  that uses the Registration dataflow in power bi to get registered student information; API for employees that show active employees with Job codes and job class. 
• Students with a  reg status of registered are registered for a given quarter.  Students with a reg status of blank and classification of New; will are likely to register and will be included in the vaccination analysis for the next quarter. 
• Show active employees only. If an employee has multiple jobs only one will be shown as determined by the nondeterministic filter in the dataflow.  All ClassCode 5's (student employees) are removed from the data flow for active employees.
There is an issue with using the academic date on the immunization table.  The current design assumes that vaccination is the fact table but people may be the fact. We want to count people and slice by the various attributes. Number of vaccinations can be an attribute of a person.Brian Shively hard coded a csv that maps department codes to department names.  This can be replaced by a control point  dataflow that Tedi Tehrani shared and the database below.
• The academic calendar has a bug in quarter from current. 
• We can only see current housing.  Need to see who is coming in the fall.
• We may need to generate a report that will show vaccination rates over time. 
• Ann Crawford (Unlicensed) will meet with @joe house to review the impact of two patient ids per person
• Control Point - Dataflow:
  • let
    #"Data Flow" = "Data Warehouse",
    #"Entity Name" = "Control Point",
    Source = PowerBI.Dataflows(null),
    #"FilteredWorkspace" = Table.SelectRows(Source, each ([workspaceName] = WorkspaceFilter)),
    #"Removed Other Columns" = Table.SelectColumns(#"FilteredWorkspace",{"Data"}),
    #"Expanded Data" = Table.ExpandTableColumn(#"Removed Other Columns", "Data", {"dataflowId", "dataflowName", "dataflowDescription", "Tags", "Data", "ItemKind", "ItemName", "IsLeaf"}, {"dataflowId", "dataflowName", "dataflowDescription", "Tags", "Data.1", "ItemKind", "ItemName", "IsLeaf"}),
    #"FilteredDataFlow" = Table.SelectRows(#"Expanded Data", each ([dataflowName] = #"Data Flow")),
    #"ExpandedData1" = Table.ExpandTableColumn(#"FilteredDataFlow", "Data.1", {"entity", "dataCategory", "Data", "Tags", "ItemKind", "ItemName", "IsLeaf"}, {"entity", "dataCategory", "Data", "Tags.1", "ItemKind.1", "ItemName.1", "IsLeaf.1"}),
    #"FilteredEntity" = Table.SelectRows(#"ExpandedData1", each ([entity] = #"Entity Name")),
    Data = #"FilteredEntity"{0}[Data],
    #"Renamed Columns" = Table.RenameColumns(#"Data",{{"Cluster Codes", "Cluster Codes 1"}, {"Cluster Name", "Cluster Name 1"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each ([cp2_code] = "VCST") and ([Department Code] <> "EOPA" and [Department Code] <> "EOPB" and [Department Code] <> "EOPC" and [Department Code] <> "EOPI" and [Department Code] <> "SIST")),
    #"Renamed Columns1" = Table.RenameColumns(#"Filtered Rows",{{"Cluster Codes 1", "Cluster Code"}, {"Cluster Name 1", "Cluster Name"}})
    in
    #"Renamed Columns1"

Action Items

•  Research how to get data from UC Path for work title and department for Primary Job Tedi Tehrani
•  Create control point workflow in public Ann Crawford (Unlicensed)
•  Correct academic calendar Quarter from current in academic calendar workflow Ann Crawford (Unlicensed)
•  Brain storm report requirements WRT return to campus   - All
•  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) Are emeriti included in the faculty count? Ann Crawford (Unlicensed) - yes this shows with the job title
•  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. - got this from the 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
•  Need a vaccination source dimension: UCSB, CAIR, Self Ann Crawford (Unlicensed)
•  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) - this will not define the UCSB populations

...