Medical Checkup Reporting

Overview

The Medical Checkup Reporting menu displays complete reports regarding employee medical checkups (MCU) within the company. This feature allows you to monitor MCU statistics, view checkup result lists, and analyze MCU summaries by project.

Page Navigation

The Medical Checkup Reporting page is located in the following menu: Dashboard » Reporting » Medical Checkup

Medical Checkup Statistics

At the top of the page, a summary of MCU statistics is displayed in card format:

Tabs Navigation

There are several tabs for viewing MCU data:

Filter Options

Search Bar

A search column is available to easily find MCU data based on:

• Employee name
• Employee Code
• Provider
• Location
• Doctor

Checkup List Table

Table Structure

Checkup List Table Data

Pagination: Rows per page: 15 | 1–9 of 9

Summary by Project Table

Summary Table Structure

Summary Table Data

Expiring Soon Tab

The Expiring Soon tab displays MCUs that will expire in the near future.

Filter Days

Days: 30 Checkups expiring within the next 30 days

Setting for the number of days to filter MCUs that will expire (default: 30 days).

Expiring Soon Table

No data for this period (0-0 of 0)

Expiring Soon Tab Features

MCU Result Status

MCU Validity Status

Data Analysis

From Statistics:

• Total Checkups: 1 employee with multiple records
• Active: 1 (all records are still valid)
• Warning: 0
• Expiring Soon: 0
• Expired: 0

From Summary by Project (Project 6900B181220100):

• Total Employees: 1
• Active MCU: 1
• Fit: 1 (all results Fit)
• Unfit: 0
• Fit with Notes: 0
• Pending: 0

Interpretation:

• Employee Muhammad Jahidin has 9 MCU records
• All MCU results are Fit
• All MCUs are still valid (none expired)
• No MCUs require special attention (Warning/Expiring Soon)

Other Features

Columns

Click the Columns button to configure which columns appear in the table:

Available columns:

• No
• Employee Code
• Employee Name
• Title
• Checkup Date
• Valid Until
• Doctor
• Location
• Provider
• Status
• Project Code
• Created Date
• Updated Date

Filters

Click the Filters button to filter data based on:

Filter by:

• Status (Fit, Unfit, Fit with Notes, Pending)
• Validity Period (Active, Warning, Expiring Soon, Expired)
• Provider
• Location
• Doctor
• Project Code
• Date Range (Checkup Date, Valid Until)

Export

Click the Export button to export table data to the following formats:

Usage Tips

1. Monitor Validity Period - Pay attention to the Expiring Soon tab to know which MCUs need to be rescheduled.
2. Filter by Status - Use the Status filter to focus on employees with Unfit or Fit with Notes results.
3. Check Providers - Analyze which providers are most frequently used to evaluate service quality.
4. Review Summary by Project - Look at the project summary to ensure all employees in the project have valid MCUs.
5. Export Data - Export reports for audit purposes or reporting to management.
6. Pay Attention to Multiple Records - One employee can have multiple MCU records (see example: 9 records for Muhammad Jahidin).
7. Use Date Range - Filter by Checkup Date Range to view MCUs within a specific period.

Common Scenarios

Scenario 1: Monthly MCU Review

At the beginning of each month, conduct an MCU review:

1. Open the Expiring Soon tab
2. Set Days = 30 or 60
3. View the list of employees who need to redo their MCU
4. Schedule MCUs for them

Scenario 2: Check Employees with Unfit Results

To monitor employee health:

1. Filter Status = Unfit
2. View the list of employees with unfit results
3. Follow up with HR or management

Scenario 3: Per Project Report

For project management needs:

1. Open the Summary by Project tab
2. Export data to Excel
3. Create a distribution chart of MCU status per project
4. Identify projects with many expired MCUs

Troubleshooting

Data Does Not Appear

• Check year and month filters
• Ensure the selected tab is correct
• Refresh the page
• Check internet connection

Numbers Don't Match

• Verify the filter period
• Check data consistency in the Medical Checkup menu
• Ensure there is no duplicate data

Days Until Expiration is Incorrect

• Check date format (dd/mm/yyyy)
• Ensure Valid Until is filled correctly
• Check server timezone

Export Failed

• Ensure there is no popup blocker
• Limit the amount of data if too large
• Try CSV format if Excel is problematic

Expiring Soon Tab is Empty

• Check the Days setting (might be too small)
• Ensure there are MCUs with validity periods within that range
• Try expanding the day range

Integration with Related Menus

Medical Checkup Management

Data comes from the Medical Checkup Management menu.

Employee Database

Employee information is integrated with Employee Database.

Project Management

Project summaries are related to Project Management.

Health Insurance

MCU data is used for Health Insurance claims.

Next Steps

• Medical Checkup Management
• Employee Database
• Project Management
• Health Insurance