PHACDataHub / data-mesh-ref-impl

Data Mesh Reference Implementation with standalone example use cases
Apache License 2.0
6 stars 3 forks source link

[DEV] PT and Federated Analytics Queries #65

Closed nghia71 closed 9 months ago

nghia71 commented 9 months ago

As a developer, I want to deploy and test pre-designed dashboards on PT and Federal Analytics Platform

The deployment of the queries must be automated once the clusters are up and running.

Currently 9 different queries are defined in three groups:

  1. (Focus) Federated Analytics group - mainly for Surveillance Programs:
    • FAR/FAS_1:
      • COVIDVaccinationStatusRequest - Request for COVID vaccination status by a number of CVXs, within a period of time, and based on the number of doses depending on vaccine type.
      • COVIDVaccinationStatusResponse - COVID vaccination status showing quantities (count, percent) for each of statuses of COVID vaccinated patients per zip code.
    • FAR/FAS_2:
      • YoungChildrenMissingScheduleRequest - Request for information about young children missing required/recommended vaccination schedule for a number of specified vaccines.
      • YoungChildrenMissingScheduleResponse - The number of patients missing scheduled vaccines together with a set of (key - vaccine code, value - number of patients missed) pairs is provided per zip code.
    • FAR/FAS_3:
      • AverageDistanceForVaccineRequest - Request for information average distance to travel to get some of specified vaccines.
      • AverageDistanceForVaccineResponse - The average distance to travel based on the zip code of patients' address to the vaccine administering organizations.
    • FAR/FAS_4:
      • VaccinationByOrganizationRequest - Request for vaccination count by organizations for patients coming from the same zip code.
      • VaccinationByOrganizationResponse - The number of vaccinations by an organization for patients coming from the same zip code.
    • FAR/FAS_5:
      • VaccinationRecordStreamRequest - Request for stream of vaccination records with detailed information.
      • VaccinationRecordStreamResponse - Vaccination record stream, each record contain information about the patient, the vaccine, and its administration by an organization.
  2. Key Indicators group - mainly for decision makers:
    • FAR/FAS_6:
      • PatientConditionRequest - Request for patient conditions as a key indicator.
      • PatientConditionResponse - Distribution of top 100 conditions (other than medication review due or screening for employment).
    • FAR/FAS_7:
      • ReasonForMedicationRequest - Request for information on medication prescribed. Only for the ones that are specifically noted.
      • ReasonForMedicationResponse - Distribution of top 100 reasons for medication (only the ones are specifically noted.)
    • FAR/FAS_8:
      • ProcedurePerformedRequest - Request for performed procedures by organizations.
      • ProcedurePerformedResponse - Distribution of top 100 procedures performed by organization.
  3. Research Indicators group - mainly for domain researchers:
    • FAR/FAS_9:
      • YoungChildrenMissingScheduleExtendedRequest - Request for additional information about young children missing required/recommended vaccination schedule for a number of specified vaccines.
      • YoungChildrenMissingScheduleExtendedResponse - The number of patients missing scheduled vaccines together with a set of (key: vaccine code, value: number of patients missed) pairs is provided per zip code. In addition, a list of organizations, some of which visited by the patients, provide the same vaccines missed by these patients.