MKG logo
Login

How does the 'Emergency List' dashboard work?

The standard dashboard 'Emergency List' provides an overview of employees available during emergencies. You use it to quickly see which employees are present and which individuals hold a first aid (EHBO) or emergency response (BHV) certification.

 

General Function

Through the Emergency List dashboard, you can immediately see who is present and where everyone is located in case of an emergency. The dashboard displays all employees registered on the Shop Floor.

 

Target Audience

  • Executive Board
  • Management

 

Where in MKG?

  1. Open the My Company module.
  2. If the dashboard is not displayed immediately: click the hamburger
    at the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
  3. Click the Views button
    and select Emergency List (8013).

 

Main Components

  • Overview of employees with name and department.
  • Insight into first aid (EHBO) qualifications.
  • Insight into emergency response (BHV) qualifications.
  • Display of presence or absence.
  • Filter for active employees.

 

Display and Usage

The dashboard shows per employee the personnel number, name, department, first aid status, emergency response status, and current presence. This allows you to quickly determine which employees are available during emergencies and which individuals can be deployed for assistance.

 

Parameters

  • ActieveMedewerkers: determines whether only active employees are shown. Default value: true.

 


 

Technical Explanation

 

Primary Data Sources

  • Employees (medw), Employee Work Schedule (t_roster)

Indirectly Consulted Data Sources

  • Departments (afdl)

Data Source Filtering

  • A filter is active on the data source medw: medw_actief In (True, ?ActieveMedewerkers).
  • This means that depending on the parameter ActieveMedewerkers, only active employees or all employees are included.

Calculated Fields

  • EHBO: indicates whether an employee has a first aid certification.
    Calculation: displays "Yes" when medw_ehbo = true, otherwise "No".
  • BHV: indicates whether an employee has an emergency response certification.
    Calculation: displays "Yes" when medw_bhv = true, otherwise "No".
  • Status: indicates whether an employee is present or absent.
    Calculation: displays "Present" when t_aanwezig = true, otherwise "Absent".
  • Active: used for sorting the employee list.
    Calculation: gives value 2 when t_actieve_bewerking = "Absent", otherwise value 1.
  • Name<: shows the full name of the employee.
    Calculation: combines medw_naam and medw_voornaam into one text field.
  • MKGDataDashboardTitle: contains a dashboard title.
    Calculation: contains an empty text value.

 

Adding to 'My Dashboards'

Do you use this dashboard regularly? Add it to My Dashboards and make this module available from the MKG Homepage. This way you create your own cockpit from the data in your database. How to add dashboards can be read in How to set up 'My Dashboards'