MKG logo
Login

How does the 'Employee Hour Balances' dashboard work?

The standard dashboard 'Employee Hour Balances' provides insight into employees' hours balances. You use it to analyze accumulated hours, corrections, and changes per employee, department, and operation.

 

General Function

The Employee Hour Balances dashboard displays all hour balances of your employees and all registered hours of the active fiscal year. You can adjust the displayed data by filtering on department/employee and/or period.

 

Target Audience

  • Controllers
  • Management

 

Where in MKG?

  1. Open the module My Company.
  2. If the dashboard is not shown immediately: click the hamburger menu
    at the top right of the toolbar and select the option 'Forms' » 'Dashboard'.
  3. Click the Views button
    and select Employee Hour Balances (8012).

 

Main Components

  • Overview of total hour balances per employee.
  • Analysis of the composition of hour balances per operation.
  • Insight into opening balance, overtime, undertime, and corrections.
  • Filters on period, department, and employee.
  • Comparison of totals and underlying changes.

 

Display and Usage

The selected fiscal year is displayed at the top. Additionally, you can filter by period, department, and employee. The dashboard contains an overview of total hour balances per employee and a detailed view showing the composition of these balances per operation. This allows you to quickly see how an employee's hour balance is composed.

 


 

Technical Explanation

 

Primary Data Source

  • Hour Balance (t_employee_hours_balance)

Indirectly Consulted Data Sources

  • Employees (medw), Departments (afdl), Operations (bwrk), Periods (peri)

Dashboard Filters

  • Filter on period via calculated field Period.
  • Filter on department via calculated field Department.
  • Filter on employee via field _desc_medw_num.
  • The period selection shows only values for which Period is not empty.

Calculated Fields

  • Spacer: used as a separator field in the pivot table view.
    Calculation: contains an empty text value.
  • Department: shows the employee's department.
    Calculation: uses medw_num.afdl_num.afdl_naam and shows a default text when no department is present.
  • Period: shows the period description.
    Calculation: uses peri_oms and shows "Year corrections" when peri_num = 14.
  • Operation: determines the sort order of operations.
    Calculation: uses the absolute value of bwrk_num.
  • 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 is explained in How to set up 'My Dashboards'