Tracks absence rate and long term absences (bris de service) among students

Deployment

tag:absenteeismnew in v0.11.0

Databases

The gpi database must be linked to the project. Please refer to the linking a database section for more information about how to link a database.

Marts

The following marts must be enabled for the dashboard to work. Please refer to the enabling a mart section for more information about how to enable a mart.

  • educ_serv

Dbt project specification

Update your cssxx_store/dbt_project.yml file with the following snippet

# cssXX.data.store/dbt_project.yml
models:
  core_dashboards_store:
    marts:
      educ_serv:
        +enabled: True
    dashboards:
      educ_serv:
        absenteeism:
          +enabled: True
    interfaces:
      gpi:
        +enabled: True

RLS

Both the report_filters and the report_bris_de_service table expose both id_eco and eco variables as RLS hook. All report table but report_bris_de_serve depends on the report_filters table, so by adding RLS to the report_filters table, all the other tables will be filtered accordingly.

Table of Contents