This is to populate the province_username_filters table, to only show some province data based on username in Superset
This needs to be updated whenever users need to see different provinces than they currently do, or new users are added
The table must be cleared before running this process group. Improvement: do this automatically when running the process group

Create initial PAV tables, Populate initial organization levels

These generally can be ignored; they are only necessary if the database needs to be re-created

Superset DB

Need to keep track of the views stored in the PAV database, as they are what Superset uses to build its tables, charts and dashboards
- dhis2_antigens_mv - for Coverage (Cobertura)
- dhis2_vaccine_breakage_mv - for Utilization (Utilização) and Breakage (Quebra)
- trimestral_reports_mb_mv and trimestral_reports_ce_mv - for Community Engagement (Envolvimento Comunitário)
- selv_country_stockout_mv, selv_province_stockout_mv, selv_district_stockout_mv_v4 - for Stockout (Ruptura)
  - Improvement?: might be able to consolidate these views into one, but it might affect performance
- redrec_mv_v2 - for RED/REC
- esistafe_mv - for HSS
- combined_data_mv - this was created to have one view with all of the data, but it may not be necessary
  - Improvement?: might be better to create this combined view in Superset, rather than in the db, as if any underlying views need to be dropped/re-created, this one also needs to be dropped and re-created
  - Or we might do away with the combined view altogether, and just use individual views
Many views have field usernames which allow filtering of data by user, and time_slice, which allow filtering by quarterly periods

Each dashboard, Central and Provincial, have their own filter boxes
Filter box has periodo, which allows looking at historical time slices (last full month, last full quarter, last full semester, last full three quarters, year-to-date), which is what the time_slice field is for in each view
All charts in Provincial dashboard filters by current username, so that the user only sees their own province data. Some users are supposed to see all provinces, so their usernames are in the usernames field for all rows
Improvement: there are many tables and charts that are unused–they need to be removed
Improvement: not much work has been done for the RED/REC tab and the HSS tab and separate dashboard, due to lack of test data–these will need to be worked on