19GE5026Q0035-Attachment-2-Employee-Statistics.pdf

PDF 461 KB Posted

Attached to
Health Insurance Services for Locally Employed Staff at U.S. Mission Portugal
Solicitation number
19GE5026Q0035
Issued by

About this file

This is an employee health insurance claims report from Allianz covering the period of July 1, 2025 to June 30, 2026, with comparative data from three prior fiscal years.

The report tracks 214 ensured personnel (comprising 92 employees, 48 spouses, and 74 children) with total claims of €708,981.19 against premiums of €403,355.82, yielding a loss ratio of 175.77%. Hospitalization represents the largest cost category at €193,924.25 (27.4% of total claims), followed by outpatient care at €192,722.78 (27.2%), dental/oral medicine at €91,895.91 (13.0%), and medication at €24,220.48 (3.4%). Network utilization rates vary by service type, ranging from 0.5% for medication to 100% for birth coverage. The top 10 highest-cost medical procedures include hospitalization and surgery (€2,870.37 average cost), normal birth and second pregnancy (€2,710.91), and chemotherapy/radiotherapy (€2,032.27). Personnel utilization of online services stands at 93.5%, with medical orientation consultations accounting for 64.04% of online service usage. General and family medicine represents the most frequently accessed specialty at 66.67%, followed by dermatology at 16.67%. The report shows a declining trend in ensured personnel from 278 in 2023-2024 to 214 in the current period.

View the file

Other files

Show all 12

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

EMPLOYEE STATISTICS AND CLAIMS REPORTS

Data provided by Allianz claims report processed until June 2026

07/01/2025 to 06/30/2026 07/01/2024 to 06/30/2025 07/01/2023 to 06/30/2024 07/01/2022 to 06/30/2023

Nº of ensured personnel 214 251 278 254 Employee 92 107 122 113 Spouse 48 58 64 57 Children 74 86 92 84 Other 0 0 0 0

07/01/2025 to 06/30/2026 07/01/2024 to 06/30/2025 07/01/2023 to 06/30/2024 07/01/2022 to 06/30/2023

Cost | % Network | %Cob Cost | % Network | %Cob Cost | % Network | %Cob Cost | % Network | %Cob Hospitalization 193,924.25€ | 97.4% | 27,4% Birth 2,710.91€ | 100% | 0.4% Outpatient Care 192,722.78€ | 79,6% | 27.2% Medication 24,220.48€ | 0.5% | 3.4% Prosthetics & Orthotics 24,013.49€ | 61.0% | 3.4% Dental/Oral Medicine 91,895.91€ | 61.3% | 13.0% Assistance & Subsidies - | - | 0.0% Consultation & Diagnostic Tests - | - | 0.0% Authorization 179,492.37 € Total 708,981.19 € Premium 403,355.82 € Racio* 175.77%

*Estimated profitability considering management costs.

Claims Historical Per Coverage

Distribuition of Personnel by Relation

# SBU - HEALTH

07/01/2025 to 06/30/2026 07/01/2024 to 06/30/2025 07/01/2023 to 06/30/2024 07/01/2022 to 06/30/2023

Cost | % Network | %Cob Cost | % Network | %Cob Cost | % Network | %Cob Cost | % Network | %Cob E Hospitalization 51,296.53€ | 97.9% | 22.9%60,711.51€ | 99.2% | 30.5% M Birth - | - | 0.0% P Outpatient Care 99,334.44€ | 84.5% | 44.3% L Medication 9,327.44€ | 1.4% |4.2% O Prosthetics & Orthotics 10,487.41€ | 66.0% | 4.7% Y Dental/Oral Medicine 53,746.74€ | 51.1% |24.0% E Assistance & Subsidies - | - | 0.0% 24.73 E Consultation & Diagnostic Tests - | - | 0.0% - | - | 0.0% - | - | 0.0%

Hospitalization S Birth P Outpatient Care O Medication U Prosthetics & Orthotics S Dental/Oral Medicine E Assistance & Subsidies - | - | 0.0% - | - | 0.0%

Consultation & Diagnostic Tests - | - | 0.0% - | - | 0.0% - | - | 0.0%

C Hospitalization H Birth - | - | 0.0% - | - | 0.0% - | - | 0.0% I Outpatient Care L Medication D Prosthetics & Orthotics R Dental/Oral Medicine E Assistance & Subsidies - | - | 0.0% - | - | 0.0% N Consultation & Diagnostic Tests - | - | 0.0% - | - | 0.0% - | - | 0.0%

Claims History Per Coverage and Relationship

Count € Cost Designation Average Cost

Hospitalization and Surgery Normal Birth and second pregnancy

Quimiotherapy / Radiotherapy EAD / Nuclear Medicine

EAD / Endoscopic Gastro. with anestesia Dental prosthetics

EAD - MRI

Ocular Lenses

EAD - CAT Scan Dental

Count € Cost Designation Top 10 Average Cost per Sub-Coverage: Previous year

Average Cost

Top 10 Average Cost per Sub-Coverage: Current year

Count € Cost Designation

Hospitalization and Surgery Normal Birth and second pregnancy

Count € Cost Quimiotherapy / Radiotherapy Average Cost EAD / Nuclear Medicine

EAD / Endoscopic Gastro. with anestesia Dental prosthetics

EAD - MRI

Ocular Lenses

EAD - CAT Scan Dental

Count € Cost Designation

Catheter ablation for atrial fibrillation Foraminectomy + Ext.

Hospital consumables

Unilateral Cataract Inter-surgical Prosthetics

Floor of room of 251 Dystocic delivery - CO

AMBU floor of room Floor of room of 101

LAP Surgical KIT

Average Cost Top 10 Average Cost per Medical act: Current year

Top 10 Average Cost per Sub-Coverage: Previous year Average Cost

Count € Cost Designation

Catheter ablation for atrial fibrillation Foraminectomy + Ext.

Hospital consumables Unilateral Cataract

Inter-surgical Prosthetics Floor of room of 251

Dystocic delivery - CO AMBU floor of room

Floor of room of 101 LAP Surgical KIT

Online Usage No Usage

Average Cost

Service Indicators

Top 10 Average Cost per Medical act: Previous year

Medical Orientation Travelers Consultation

House Consultations Pediatrics

General & Family Medicine Dermatology Ophthalmology Pulmonology Urologie

Top 5 Specialities

Percentage of Usage - Online Services

File details come from the government source that posted it. Updated .