Paid Claims 24-25.xls

XLS spreadsheet 153 KB Posted

Attached to
Medical and life insurance services
Solicitation number
Not on record
Issued by

About this file

This is a Paid Claims Summary Report for medical and life insurance services provided to American Embassy personnel under multiple policy numbers for the period of November 1, 2024 through October 31, 2025. The report documents claims data in Egyptian Pounds (EGP) across six distinct policies (4031201001, 4031201002, 4031201003, 4031202001, 4031202002, and 4031204001-4031204003), with a combined total of EGP 51.6 million claimed and EGP 39.3 million approved for payment.

The claims are categorized by service type including outpatient care (optical examinations, investigations, physiotherapy, medicines, surgeries, and doctor visits), inpatient services (anesthesia, intensive care, investigations, room and board, medicines, surgeries, and initial visits), dental procedures (crowns, extractions, fillings, gum treatment, endodontics, and examinations), maternity benefits (abortion, normal delivery, and caesarian sections), and other services (checkups and vaccinations). Total paid claims across all policies amounted to EGP 39,320,507.04 (Policy 4031201001), EGP 57,350,292.42 (Policy 4031201002), EGP 4,467,385.30 (Policy 4031201003), EGP 2,538,929.91 (Policy 4031202001), EGP 2,317,205.45 (Policy 4031202002), and EGP 9,072,034.87 combined for the USAID-related policies (4031204001-4031204003). The report reflects claim denials, co-insurance payments, and co-payment amounts applied across all benefit categories, with no deductibles applied to any claims during this period.

View the file

Other files

File Type Posted
Paid Claims 22-23.xls XLS spreadsheet
Attachment A (QA).pdf PDF
SF30 Solicitation mod (QA and due date ext).pdf PDF
Paid Claims 23-24.xls XLS spreadsheet

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

Sheet1

PaidClaims - Summary Report
Policy :4031201001Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOECOptical-ExaminationEGP3,150.003,150.00880.000.00630.000.002,520.00
BOINOutpatient - InvestigationsEGP8,547,861.315,946,732.393,53317,8090.000.006,534.50522.505,939,675.39
BOLCOptical-LensesEGP6,500.006,500.00220.000.001,300.000.005,200.00
BOPTPhysiotherapyEGP1,883,456.711,619,342.715523,1150.000.0012,092.000.001,607,250.71
BORXOutpatient - MedicineEGP15,773,837.2314,377,551.6612,234102,7100.000.002,874,067.332,260.5711,501,223.76
BOSCOptical-Spectacles (eye glasses full)EGP248,743.80242,868.8052520.000.0048,573.7614,367.04179,928.00
BOSPOutpatient - Surgeries/ProceduresEGP1,065,653.19789,948.353806940.000.002,576.000.00787,372.35
BOSTOutpatient - Services/TreatmentsEGP1,956,337.651,689,820.591,27510,1220.000.0011,400.32246,651.791,431,768.48
BOVFOutpatient - Followup Dr VisitEGP8,170.007,996.0066660.000.000.000.007,996.00
BOVIOutpatient - Initial Dr VisitEGP2,047,951.541,792,672.576,7866,8710.000.0018,815.402,230.001,771,627.17
BPOCOptical-Contact LensesEGP26,000.0019,500.00330.000.003,900.005,800.009,800.00
BPOEOptical-ExaminationEGP39,229.4230,099.971621620.000.000.000.0030,099.97
BPOSOptical-SpectaclesEGP1,378,359.841,064,320.201721700.000.00212,864.0479,663.76771,792.40
1.OutpatientTOTALS :EGP32,985,250.6927,590,503.2425,225141,7840.000.003,192,753.35351,495.6624,046,254.23
2.Inpatient
BIANInpatient - AnesthetistEGP650,007.70477,837.871031660.000.000.000.00477,837.87
BICUInpatient - Intensive Care UnitEGP403,714.00237,867.9528620.000.000.000.00237,867.95
BIINInpatient - InvestigationsEGP1,154,041.20820,081.671301800.000.000.000.00820,081.67
BIRBInpatient - Room & BoardEGP702,851.34424,352.071362240.000.000.000.00424,352.07
BIRXInpatient - MedicineEGP656,678.00646,796.421772290.000.000.000.00646,796.42
BISPInpatient - Surgeries/ProceduresEGP5,480,842.054,192,435.191564010.000.000.000.004,192,435.19
BISTInpatient - Services/TreatmentsEGP6,659,207.146,076,413.841981,2190.000.000.0021,670.546,054,743.30
BIVIInpatient - Initial Dr VisitEGP586,504.61419,652.371575280.000.000.000.00419,652.37
2.InpatientTOTALS :EGP16,293,846.0413,295,437.381,0853,0080.000.000.0021,670.5413,273,766.84
3.Other Services
BNCACheckup - AdultEGP771.00771.00330.000.00154.200.00616.80
BNCVCheckup - VaccinationEGP20,538.0020,538.00690.000.004,107.600.0016,430.40
BNNCNot Covered BenefitsEGP23,024.7923,024.792900.000.000.0023,024.790.00
3.Other ServicesTOTALS :EGP44,333.7944,333.7938120.000.004,261.8023,024.7917,047.20
4.Maternity
BMACMaternity-AbortionEGP66,317.0655,622.03842720.000.000.000.0055,622.03
BMDCMaternity-Normal DeliveryEGP700.00700.00110.000.000.000.00700.00
Policy :4031201001Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
BMSCMaternity-Caesarian SectionEGP226,295.08202,823.408530.000.000.0029,472.00173,351.40
4.MaternityTOTALS :EGP293,312.14259,145.43933260.000.000.0029,472.00229,673.43
5.Dental
BDCPDental-Crown-PPOEGP927,571.80889,200.803146240.000.000.0077,117.19812,083.61
BDDPDental-Dentures & Bridges-PPOEGP7,000.007,000.00220.000.000.000.007,000.00
BDEPDental-Extraction-PPOEGP62,672.3954,952.39871040.000.000.00290.0054,662.39
BDFPDental-Filling-PPOEGP400,159.00372,355.004357850.000.000.0011,320.00361,035.00
BDGPDental-Gum Treatment-Periodenti-PPOEGP132,838.50121,942.002634250.000.000.002,620.00119,322.00
BDMPDental-Medicine-PPOEGP3,701.153,656.5914200.000.00731.310.002,925.28
BDNPDental-Endodontic-PPOEGP360,710.00335,648.002693870.000.000.0028,062.00307,586.00
BDOPDental-Other Service-PPOEGP2,548.002,548.00100.000.000.002,548.000.00
BDVPDental-Visit-Examination-PPOEGP49,370.2645,317.505195190.000.000.00596.0044,721.50
BDXPDental-X-Ray-Panaramic-PPOEGP50,509.3346,207.563117270.000.000.001,778.0044,429.56
5.DentalTOTALS :EGP1,997,080.431,878,827.842,2153,5930.000.00731.31124,331.191,753,765.34
Policy :4031201001TOTALS :EGP51,613,823.0943,068,247.6828,656148,7230.000.003,197,746.46549,994.1839,320,507.04
Policy :4031201002Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOECOptical-ExaminationEGP6,000.006,000.0017170.000.001,200.000.004,800.00
BOINOutpatient - InvestigationsEGP12,998,638.339,026,937.646,45829,6380.000.0015,500.8917,133.738,994,303.02
BOLCOptical-LensesEGP6,252.006,252.00330.000.001,250.400.005,001.60
BOPTPhysiotherapyEGP2,004,507.031,770,439.555173,7100.000.0022,522.04735.001,747,182.51
BORXOutpatient - MedicineEGP15,861,799.0914,505,575.4918,479125,8920.000.002,887,892.786,608.6711,611,074.04
BOSCOptical-Spectacles (eye glasses full)EGP370,454.80364,405.8092890.000.0072,881.1615,465.44276,059.20
BOSPOutpatient - Surgeries/ProceduresEGP1,022,049.13698,418.654471,0930.000.0018,239.200.00680,179.45
BOSTOutpatient - Services/TreatmentsEGP3,067,787.472,646,481.142,61918,1060.000.0016,905.50657,214.681,972,360.96
BOVFOutpatient - Followup Dr VisitEGP11,675.0011,583.0090900.000.000.000.0011,583.00
BOVIOutpatient - Initial Dr VisitEGP4,126,720.853,673,285.6514,89615,1940.000.0044,851.277,591.003,620,843.38
BPOCOptical-Contact LensesEGP3,000.002,250.00110.000.00450.000.001,800.00
BPOEOptical-ExaminationEGP75,898.5758,304.002602610.000.000.000.0058,304.00
BPOSOptical-SpectaclesEGP2,550,767.911,973,954.353413370.000.00394,790.8780,388.681,498,774.80
1.OutpatientTOTALS :EGP42,105,550.1834,743,887.2744,220194,4310.000.003,476,484.11785,137.2030,482,265.96
2.Inpatient
BIANInpatient - AnesthetistEGP851,022.37644,487.181672040.000.000.000.00644,487.18
BICUInpatient - Intensive Care UnitEGP817,556.57536,109.04572090.000.000.004,192.65531,916.39
BIINInpatient - InvestigationsEGP2,663,455.721,878,901.353065020.000.000.000.001,878,901.35
BIRBInpatient - Room & BoardEGP1,967,457.911,172,312.223716840.000.000.000.001,172,312.22
BIRXInpatient - MedicineEGP2,511,013.122,473,963.204315290.000.000.00246.822,473,716.38
BISPInpatient - Surgeries/ProceduresEGP5,921,259.074,722,997.392684890.000.000.000.004,722,997.39
BISTInpatient - Services/TreatmentsEGP8,660,808.638,010,647.934982,7580.000.000.0050,442.727,960,205.21
BIVIInpatient - Initial Dr VisitEGP1,421,035.501,126,864.944081,6580.000.000.000.001,126,864.94
2.InpatientTOTALS :EGP24,813,608.8920,566,283.252,5067,0330.000.000.0054,882.1920,511,401.06
3.Other Services
BNCVCheckup - VaccinationEGP181,416.00181,416.001111290.000.0036,283.200.00145,132.80
BNNCNot Covered BenefitsEGP95,238.1695,238.166200.000.000.0095,238.160.00
3.Other ServicesTOTALS :EGP276,654.16276,654.161731290.000.0036,283.2095,238.16145,132.80
4.Maternity
BMACMaternity-AbortionEGP609,227.47516,998.966692,2030.000.000.003,434.21513,564.75
BMCCMaternity-ComplicationsEGP96,019.4681,041.996220.000.000.000.0081,041.99
BMDCMaternity-Normal DeliveryEGP251,337.93223,920.66241150.000.000.00963.00222,957.66
Policy :4031201002Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
BMSCMaternity-Caesarian SectionEGP1,057,164.49885,638.66413040.000.000.0028,576.00857,062.66
4.MaternityTOTALS :EGP2,013,749.351,707,600.277402,6430.000.000.0032,973.211,674,627.06
5.Dental
BDCPDental-Crown-PPOEGP1,478,070.801,418,310.804961,0560.000.000.00143,551.001,274,759.80
BDEPDental-Extraction-PPOEGP178,014.55167,149.632775410.000.000.0018,273.36148,876.27
BDFPDental-Filling-PPOEGP871,200.70827,548.029111,8410.000.000.0017,817.00809,731.02
BDGPDental-Gum Treatment-Periodenti-PPOEGP188,330.70177,212.023867450.000.000.004,330.00172,882.02
BDLPDental-Prophylaxis-PPOEGP144.00144.00100.000.000.00144.000.00
BDMPDental-Medicine-PPOEGP5,856.505,721.5025310.000.001,144.300.004,577.20
BDNPDental-Endodontic-PPOEGP737,616.33693,039.006061,0530.000.000.0060,861.01632,177.99
BDOPDental-Other Service-PPOEGP4,300.004,300.00400.000.000.004,300.000.00
BDRPDental-Orthodontic-PPOEGP1,411,415.001,311,442.0072900.000.000.0014,700.001,296,742.00
BDVCDental-Visit-Examination-CashEGP115.00115.00110.000.000.00114.001.00
BDVPDental-Visit-Examination-PPOEGP103,839.0098,533.651,1671,3210.000.000.00792.0097,741.65
BDXCDental-X-Ray-Panaramic-CashEGP500.00350.00110.000.000.00349.001.00
BDXPDental-X-Ray-Panaramic-PPOEGP116,726.66102,300.516731,5480.000.000.002,924.9299,375.59
5.DentalTOTALS :EGP5,096,129.244,806,166.134,6208,2280.000.001,144.30268,156.294,536,865.54
7.Psychiatric
BPMCMaternity-ComplicationsEGP600.00600.00100.000.000.00600.000.00
BPVCPsychiatric-Dr VisitEGP1,100.001,100.00100.000.000.001,100.000.00
7.PsychiatricTOTALS :EGP1,700.001,700.00200.000.000.001,700.000.00
Policy :4031201002TOTALS :EGP74,307,391.8262,102,291.0852,261212,4630.000.003,513,911.611,238,087.0557,350,292.42
Policy :4031201003Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOINOutpatient - InvestigationsEGP132,390.2081,874.82322330.000.00441.000.0081,433.82
BOPTPhysiotherapyEGP19,950.0019,950.006830.000.002,910.000.0017,040.00
BORXOutpatient - MedicineEGP398,914.81366,485.27451,3870.000.0073,189.650.00293,295.62
BOSPOutpatient - Surgeries/ProceduresEGP2,700.001,485.00440.000.000.000.001,485.00
BOSTOutpatient - Services/TreatmentsEGP16,664.3014,290.85142150.000.00261.000.0014,029.85
BOVIOutpatient - Initial Dr VisitEGP14,749.7514,582.6947490.000.00513.000.0014,069.69
BPOSOptical-SpectaclesEGP8,150.006,520.00110.000.001,304.00216.005,000.00
1.OutpatientTOTALS :EGP593,519.06505,188.631491,9720.000.0078,618.65216.00426,353.98
2.Inpatient
BIANInpatient - AnesthetistEGP53,730.7540,617.818120.000.000.000.0040,617.81
BICUInpatient - Intensive Care UnitEGP320,075.20204,506.1810560.000.000.000.00204,506.18
BIINInpatient - InvestigationsEGP605,409.87427,084.5220570.000.000.000.00427,084.52
BIRBInpatient - Room & BoardEGP143,940.0063,811.4711320.000.000.000.0063,811.47
BIRXInpatient - MedicineEGP341,925.84341,513.3821330.000.000.000.00341,513.38
BISPInpatient - Surgeries/ProceduresEGP657,061.71555,136.5313340.000.000.000.00555,136.53
BISTInpatient - Services/TreatmentsEGP2,374,966.822,286,762.46241980.000.000.0064,274.022,222,488.44
BIVIInpatient - Initial Dr VisitEGP255,782.11185,872.99202110.000.000.000.00185,872.99
2.InpatientTOTALS :EGP4,752,892.304,105,305.341276330.000.000.0064,274.024,041,031.32
3.Other Services
BNNCNot Covered BenefitsEGP104,400.00104,400.00100.000.000.00104,400.000.00
3.Other ServicesTOTALS :EGP104,400.00104,400.00100.000.000.00104,400.000.00
Policy :4031201003TOTALS :EGP5,450,811.364,714,893.972772,6050.000.0078,618.65168,890.024,467,385.30
Policy :4031202001Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOECOptical-ExaminationEGP1,630.001,630.00330.000.00326.000.001,304.00
BOINOutpatient - InvestigationsEGP481,196.51336,247.491739430.000.000.000.00336,247.49
BOLCOptical-LensesEGP320.00320.00110.000.0064.000.00256.00
BOPTPhysiotherapyEGP29,190.0025,230.0010320.000.000.000.0025,230.00
BORXOutpatient - MedicineEGP789,789.32711,203.765314,9870.000.00142,115.190.00569,088.57
BOSCOptical-Spectacles (eye glasses full)EGP24,149.4724,149.47330.000.004,829.894,319.5815,000.00
BOSPOutpatient - Surgeries/ProceduresEGP21,830.0017,936.757120.000.00140.000.0017,796.75
BOSTOutpatient - Services/TreatmentsEGP68,208.4560,758.20456690.000.000.0012,793.7447,964.46
BOVIOutpatient - Initial Dr VisitEGP100,627.8477,412.032612630.000.00680.000.0076,732.03
BPOEOptical-ExaminationEGP1,070.001,070.00220.000.000.000.001,070.00
BPOSOptical-SpectaclesEGP84,076.2565,946.00980.000.0013,189.2015,596.8037,160.00
1.OutpatientTOTALS :EGP1,602,087.841,321,903.701,0456,9230.000.00161,344.2832,710.121,127,849.30
2.Inpatient
BIANInpatient - AnesthetistEGP71,301.2556,809.7611140.000.000.000.0056,809.76
BICUInpatient - Intensive Care UnitEGP58,992.0040,654.803120.000.000.000.0040,654.80
BIINInpatient - InvestigationsEGP197,748.00131,194.9013160.000.000.000.00131,194.90
BIRBInpatient - Room & BoardEGP39,927.7527,955.5811120.000.000.000.0027,955.58
BIRXInpatient - MedicineEGP110,661.41110,645.3715160.000.000.000.00110,645.37
BISPInpatient - Surgeries/ProceduresEGP313,522.46252,280.3315220.000.000.000.00252,280.33
BISTInpatient - Services/TreatmentsEGP874,234.39732,929.22181000.000.000.000.00732,929.22
BIVIInpatient - Initial Dr VisitEGP26,726.5022,415.6512270.000.000.000.0022,415.65
2.InpatientTOTALS :EGP1,693,113.761,374,885.61982190.000.000.000.001,374,885.61
3.Other Services
BNCACheckup - AdultEGP277.00277.00110.000.0055.400.00221.60
BNNCNot Covered BenefitsEGP219.01219.01600.000.000.00219.010.00
3.Other ServicesTOTALS :EGP496.01496.01710.000.0055.40219.01221.60
5.Dental
BDCPDental-Crown-PPOEGP13,806.0013,806.00360.000.000.000.0013,806.00
BDEPDental-Extraction-PPOEGP2,950.002,950.00660.000.000.000.002,950.00
BDFPDental-Filling-PPOEGP5,550.005,450.009130.000.000.000.005,450.00
BDGPDental-Gum Treatment-Periodenti-PPOEGP2,500.002,300.00680.000.000.000.002,300.00
BDMPDental-Medicine-PPOEGP198.00198.00110.000.0039.600.00158.40
Policy :4031202001Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
BDNPDental-Endodontic-PPOEGP9,860.008,598.00670.000.000.000.008,598.00
BDVPDental-Visit-Examination-PPOEGP1,490.001,330.0013130.000.000.000.001,330.00
BDXPDental-X-Ray-Panaramic-PPOEGP1,481.001,381.009190.000.000.000.001,381.00
5.DentalTOTALS :EGP37,835.0036,013.0053730.000.0039.600.0035,973.40
Policy :4031202001TOTALS :EGP3,333,532.612,733,298.321,2037,2160.000.00161,439.2832,929.132,538,929.91
Policy :4031202002Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOECOptical-ExaminationEGP600.00600.00110.000.00120.000.00480.00
BOINOutpatient - InvestigationsEGP494,508.33349,518.192009390.000.001,085.201,749.00346,683.99
BOLCOptical-LensesEGP320.00320.00110.000.0064.00256.000.00
BOPTPhysiotherapyEGP42,465.0039,644.2517590.000.000.000.0039,644.25
BORXOutpatient - MedicineEGP677,645.90614,662.845164,5890.000.00122,888.130.00491,774.71
BOSCOptical-Spectacles (eye glasses full)EGP2,125.002,125.00210.000.00425.000.001,700.00
BOSPOutpatient - Surgeries/ProceduresEGP46,315.0022,960.9020280.000.000.000.0022,960.90
BOSTOutpatient - Services/TreatmentsEGP68,075.3957,057.40585750.000.00371.204,257.8052,428.40
BOVIOutpatient - Initial Dr VisitEGP148,122.84113,488.033953990.000.001,814.000.00111,674.03
BPOCOptical-Contact LensesEGP4,125.003,093.75110.000.00618.752,275.00200.00
BPOEOptical-ExaminationEGP959.00659.40550.000.000.000.00659.40
BPOSOptical-SpectaclesEGP65,100.0049,233.001080.000.009,846.60382.4039,004.00
1.OutpatientTOTALS :EGP1,550,361.461,253,362.761,2266,6060.000.00137,232.888,920.201,107,209.68
2.Inpatient
BIANInpatient - AnesthetistEGP65,371.5850,746.4710120.000.000.000.0050,746.47
BICUInpatient - Intensive Care UnitEGP25,410.0012,577.95130.000.000.000.0012,577.95
BIINInpatient - InvestigationsEGP149,071.48108,066.8711200.000.000.000.00108,066.87
BIRBInpatient - Room & BoardEGP89,477.5265,407.1510220.000.000.000.0065,407.15
BIRXInpatient - MedicineEGP51,666.0051,629.5012120.000.000.000.0051,629.50
BISPInpatient - Surgeries/ProceduresEGP483,669.85393,827.5014250.000.000.000.00393,827.50
BISTInpatient - Services/TreatmentsEGP456,357.72404,369.5212850.000.000.000.00404,369.52
BIVIInpatient - Initial Dr VisitEGP32,981.6730,602.639270.000.000.000.0030,602.63
2.InpatientTOTALS :EGP1,354,005.821,117,227.59792060.000.000.000.001,117,227.59
3.Other Services
BNNCNot Covered BenefitsEGP227.00227.00400.000.000.00227.000.00
3.Other ServicesTOTALS :EGP227.00227.00400.000.000.00227.000.00
4.Maternity
BMACMaternity-AbortionEGP4,951.753,324.18250.000.000.000.003,324.18
4.MaternityTOTALS :EGP4,951.753,324.18250.000.000.000.003,324.18
5.Dental
BDCPDental-Crown-PPOEGP34,274.0030,774.0016230.000.000.000.0030,774.00
Policy :4031202002Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
BDEPDental-Extraction-PPOEGP7,400.006,400.008130.000.000.000.006,400.00
BDFPDental-Filling-PPOEGP23,840.0022,150.0023490.000.000.000.0022,150.00
BDGPDental-Gum Treatment-Periodenti-PPOEGP7,400.006,860.0014240.000.000.000.006,860.00
BDMPDental-Medicine-PPOEGP695.00695.00330.000.00139.000.00556.00
BDNPDental-Endodontic-PPOEGP19,770.0017,580.0016220.000.000.000.0017,580.00
BDVPDental-Visit-Examination-PPOEGP2,670.002,390.0028290.000.000.000.002,390.00
BDXPDental-X-Ray-Panaramic-PPOEGP2,820.002,734.0016410.000.000.000.002,734.00
5.DentalTOTALS :EGP98,869.0089,583.001242040.000.00139.000.0089,444.00
Policy :4031202002TOTALS :EGP3,008,415.032,463,724.531,4357,0210.000.00137,371.889,147.202,317,205.45
Policy :4031203001Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOINOutpatient - InvestigationsEGP80,351.1051,524.52321550.000.001,006.000.0050,518.52
BOPTPhysiotherapyEGP14,520.0011,490.007700.000.000.000.0011,490.00
BORXOutpatient - MedicineEGP154,109.81138,902.131178240.000.0027,780.520.00111,121.61
BOSPOutpatient - Surgeries/ProceduresEGP4,105.333,204.00340.000.000.000.003,204.00
BOSTOutpatient - Services/TreatmentsEGP23,535.6716,295.1712610.000.000.00800.7815,494.39
BOVIOutpatient - Initial Dr VisitEGP10,065.5010,065.5040400.000.0044.000.0010,021.50
BPOEOptical-ExaminationEGP120.00120.00220.000.000.000.00120.00
BPOSOptical-SpectaclesEGP10,500.008,400.00220.000.001,680.000.006,720.00
1.OutpatientTOTALS :EGP297,307.41240,001.322151,1580.000.0030,510.52800.78208,690.02
2.Inpatient
BIANInpatient - AnesthetistEGP8,687.506,515.63130.000.000.000.006,515.63
BIINInpatient - InvestigationsEGP12,264.657,358.79340.000.000.000.007,358.79
BIRBInpatient - Room & BoardEGP12,825.005,698.83330.000.000.000.005,698.83
BIRXInpatient - MedicineEGP5,645.235,645.23330.000.000.000.005,645.23
BISPInpatient - Surgeries/ProceduresEGP71,712.5053,784.38260.000.000.000.0053,784.38
BISTInpatient - Services/TreatmentsEGP121,179.89118,457.013140.000.000.000.00118,457.01
BIVIInpatient - Initial Dr VisitEGP4,247.003,185.25340.000.000.000.003,185.25
2.InpatientTOTALS :EGP236,561.77200,645.1218370.000.000.000.00200,645.12
Policy :4031203001TOTALS :EGP533,869.18440,646.442331,1950.000.0030,510.52800.78409,335.14
Policy :4031203002Desc:AMERICAN EMBASSYIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOINOutpatient - InvestigationsEGP80,967.6250,572.51291340.000.000.000.0050,572.51
BORXOutpatient - MedicineEGP77,395.3369,559.72896210.000.0013,882.450.0055,677.27
BOSPOutpatient - Surgeries/ProceduresEGP1,200.00900.00120.000.000.000.00900.00
BOSTOutpatient - Services/TreatmentsEGP6,939.326,729.326570.000.000.000.006,729.32
BOVIOutpatient - Initial Dr VisitEGP13,637.0013,357.0070700.000.0024.000.0013,333.00
BPOSOptical-SpectaclesEGP10,800.008,640.00220.000.001,728.000.006,912.00
1.OutpatientTOTALS :EGP190,939.27149,758.551978860.000.0015,634.450.00134,124.10
2.Inpatient
BICUInpatient - Intensive Care UnitEGP47,500.0038,000.002190.000.000.000.0038,000.00
BIINInpatient - InvestigationsEGP23,185.0018,548.00240.000.000.000.0018,548.00
BIRXInpatient - MedicineEGP106,860.13106,860.131100.000.000.000.00106,860.13
BISTInpatient - Services/TreatmentsEGP115,328.16109,452.662340.000.000.000.00109,452.66
BIVIInpatient - Initial Dr VisitEGP32,375.0025,660.002540.000.000.000.0025,660.00
2.InpatientTOTALS :EGP325,248.29298,520.7991210.000.000.000.00298,520.79
4.Maternity
BMACMaternity-AbortionEGP700.58532.58140.000.000.000.00532.58
BMDCMaternity-Normal DeliveryEGP34,888.5123,950.112170.000.000.000.0023,950.11
4.MaternityTOTALS :EGP35,589.0924,482.693210.000.000.000.0024,482.69
5.Dental
BDEPDental-Extraction-PPOEGP650.00580.00220.000.000.000.00580.00
BDGPDental-Gum Treatment-Periodenti-PPOEGP850.00850.00140.000.000.000.00850.00
BDMPDental-Medicine-PPOEGP128.00128.00110.000.0025.600.00102.40
BDRPDental-Orthodontic-PPOEGP18,000.0018,000.00120.000.000.000.0018,000.00
BDVPDental-Visit-Examination-PPOEGP280.00260.00330.000.000.000.00260.00
5.DentalTOTALS :EGP19,908.0019,818.008120.000.0025.600.0019,792.40
Policy :4031203002TOTALS :EGP571,684.65492,580.032171,0400.000.0015,660.050.00476,919.98
Policy :4031204001Desc:AMERICAN EMBASSY USAIDIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOECOptical-ExaminationEGP3,800.003,800.00770.000.00760.000.003,040.00
BOINOutpatient - InvestigationsEGP972,342.57752,359.924402,3360.000.0013,464.840.00738,895.08
BOLCOptical-LensesEGP25,457.5025,457.50880.000.005,091.502,200.0018,166.00
BOPTPhysiotherapyEGP264,952.00239,031.50775690.000.0017,000.000.00222,031.50
BORXOutpatient - MedicineEGP1,617,236.361,489,011.071,1057,4840.000.00297,802.190.001,191,208.88
BOSCOptical-Spectacles (eye glasses full)EGP164,030.00163,530.0033330.000.0032,706.0023,744.00107,080.00
BOSPOutpatient - Surgeries/ProceduresEGP74,158.1961,375.0034390.000.004,023.730.0057,351.27
BOSTOutpatient - Services/TreatmentsEGP203,147.26183,663.931257250.000.001,905.9068,359.40113,398.63
BOVIOutpatient - Initial Dr VisitEGP226,693.38196,191.525605680.000.0011,967.80260.00183,963.72
BPOCOptical-Contact LensesEGP4,100.003,075.00110.000.00615.000.002,460.00
BPOEOptical-ExaminationEGP2,490.001,951.6011110.000.000.000.001,951.60
BPOSOptical-SpectaclesEGP174,417.00134,499.8520200.000.0026,899.9721,259.1286,340.76
1.OutpatientTOTALS :EGP3,732,824.263,253,946.892,42111,8010.000.00412,236.93115,822.522,725,887.44
2.Inpatient
BIANInpatient - AnesthetistEGP66,551.5953,959.3614170.000.000.000.0053,959.36
BICUInpatient - Intensive Care UnitEGP46,750.0025,245.00260.000.000.000.0025,245.00
BIINInpatient - InvestigationsEGP193,724.67134,072.1017300.000.000.000.00134,072.10
BIRBInpatient - Room & BoardEGP75,929.6746,553.3424300.000.000.000.0046,553.34
BIRXInpatient - MedicineEGP49,999.5048,091.1024270.000.000.000.0048,091.10
BISPInpatient - Surgeries/ProceduresEGP463,301.00360,642.8323410.000.000.000.00360,642.83
BISTInpatient - Services/TreatmentsEGP596,251.82553,914.80331650.000.000.002,200.20551,714.60
BIVIInpatient - Initial Dr VisitEGP56,396.4747,675.4622590.000.000.000.0047,675.46
2.InpatientTOTALS :EGP1,548,904.721,270,153.991593740.000.000.002,200.201,267,953.79
3.Other Services
BNNCNot Covered BenefitsEGP16,445.0216,445.02600.000.000.0016,445.020.00
3.Other ServicesTOTALS :EGP16,445.0216,445.02600.000.000.0016,445.020.00
4.Maternity
BMACMaternity-AbortionEGP28,906.5028,825.7216410.000.000.000.0028,825.72
BMCCMaternity-ComplicationsEGP246.00228.02120.000.000.000.00228.02
BMDCMaternity-Normal DeliveryEGP9,910.009,910.00110.000.000.000.009,910.00
BMSCMaternity-Caesarian SectionEGP117,004.1692,378.003170.000.000.000.0092,378.00
Policy :4031204001Desc:AMERICAN EMBASSY USAIDIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
4.MaternityTOTALS :EGP156,066.66131,341.7421610.000.000.000.00131,341.74
5.Dental
BDCPDental-Crown-PPOEGP194,835.00162,308.0043580.000.000.0037,938.40124,369.60
BDEPDental-Extraction-PPOEGP24,800.0017,720.0013170.000.000.002,350.0015,370.00
BDFPDental-Filling-PPOEGP194,590.00156,092.00771320.000.000.0042,360.00113,732.00
BDGPDental-Gum Treatment-Periodenti-PPOEGP49,694.0041,086.0048570.000.000.002,694.4038,391.60
BDMPDental-Medicine-PPOEGP2,063.182,063.18880.000.00412.640.001,650.54
BDNPDental-Endodontic-PPOEGP112,375.0089,702.0035480.000.000.0012,996.0076,706.00
BDOPDental-Other Service-PPOEGP9,800.009,800.00400.000.000.009,800.000.00
BDVPDental-Visit-Examination-PPOEGP13,305.0010,995.0054550.000.000.001,510.009,485.00
BDXPDental-X-Ray-Panaramic-PPOEGP13,511.0011,384.0042850.000.000.001,050.0010,334.00
5.DentalTOTALS :EGP614,973.18501,150.183244600.000.00412.64110,698.80390,038.74
Policy :4031204001TOTALS :EGP6,069,213.845,173,037.822,93112,6960.000.00412,649.57245,166.544,515,221.71
Policy :4031204002Desc:AMERICAN EMBASSY USAIDIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOECOptical-ExaminationEGP5,050.005,050.0010100.000.001,010.000.004,040.00
BOINOutpatient - InvestigationsEGP866,011.83644,332.824562,3520.000.003,883.410.00640,449.41
BOLCOptical-LensesEGP14,835.0014,835.00770.000.002,967.00140.0011,728.00
BOPTPhysiotherapyEGP160,564.00152,547.50354090.000.005,520.000.00147,027.50
BORXOutpatient - MedicineEGP1,533,234.591,411,822.659887,1740.000.00282,206.3596.681,129,519.62
BOSCOptical-Spectacles (eye glasses full)EGP197,877.51197,877.5139390.000.0039,575.5028,500.00129,802.01
BOSPOutpatient - Surgeries/ProceduresEGP73,232.3350,747.2134680.000.000.000.0050,747.21
BOSTOutpatient - Services/TreatmentsEGP271,894.68200,528.381478440.000.002,229.5657,696.30140,602.52
BOVFOutpatient - Followup Dr VisitEGP120.00120.00110.000.000.000.00120.00
BOVIOutpatient - Initial Dr VisitEGP333,589.57282,091.267858110.000.0020,869.000.00261,222.26
BPOEOptical-ExaminationEGP2,520.002,345.6019190.000.000.000.002,345.60
BPOSOptical-SpectaclesEGP158,338.00121,389.5019190.000.0024,277.9013,976.0083,135.60
1.OutpatientTOTALS :EGP3,617,267.513,083,687.432,54011,7530.000.00382,538.72100,408.982,600,739.73
2.Inpatient
BIANInpatient - AnesthetistEGP21,575.0016,106.25560.000.000.000.0016,106.25
BICUInpatient - Intensive Care UnitEGP880.00880.00110.000.000.000.00880.00
BIINInpatient - InvestigationsEGP16,658.4013,281.006110.000.000.000.0013,281.00
BIRBInpatient - Room & BoardEGP31,025.5722,660.6212140.000.000.000.0022,660.62
BIRXInpatient - MedicineEGP58,587.4358,097.2517200.000.000.000.0058,097.25
BISPInpatient - Surgeries/ProceduresEGP410,195.00338,591.0015310.000.000.000.00338,591.00
BISTInpatient - Services/TreatmentsEGP150,834.42143,651.3020880.000.000.000.00143,651.30
BIVIInpatient - Initial Dr VisitEGP20,290.9218,429.0015230.000.000.000.0018,429.00
2.InpatientTOTALS :EGP710,046.74611,696.42911930.000.000.000.00611,696.42
3.Other Services
BNCVCheckup - VaccinationEGP35,594.0035,594.0021300.000.007,118.800.0028,475.20
BNNCNot Covered BenefitsEGP2,113.002,113.00500.000.000.002,113.000.00
3.Other ServicesTOTALS :EGP37,707.0037,707.0026300.000.007,118.802,113.0028,475.20
4.Maternity
BMACMaternity-AbortionEGP9,470.009,375.6014330.000.000.000.009,375.60
4.MaternityTOTALS :EGP9,470.009,375.6014330.000.000.000.009,375.60
5.Dental
Policy :4031204002Desc:AMERICAN EMBASSY USAIDIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
BDCPDental-Crown-PPOEGP84,250.0070,784.0024320.000.000.0017,540.0053,244.00
BDEPDental-Extraction-PPOEGP16,000.0013,240.0015180.000.000.00600.0012,640.00
BDFPDental-Filling-PPOEGP176,326.00147,312.80991630.000.000.0017,830.00129,482.80
BDGPDental-Gum Treatment-Periodenti-PPOEGP55,850.0049,830.0042870.000.000.008,008.0041,822.00
BDMPDental-Medicine-PPOEGP1,237.261,237.26890.000.00247.450.00989.81
BDNPDental-Endodontic-PPOEGP105,570.0092,096.0048720.000.000.0016,614.0075,482.00
BDOPDental-Other Service-PPOEGP3,020.003,020.00200.000.000.003,020.000.00
BDRPDental-Orthodontic-PPOEGP224,475.00189,180.0017190.000.000.0017,600.00171,580.00
BDVPDental-Visit-Examination-PPOEGP13,600.0011,780.0069700.000.000.00500.0011,280.00
BDXPDental-X-Ray-Panaramic-PPOEGP12,070.0010,206.0042760.000.000.00200.0010,006.00
5.DentalTOTALS :EGP692,398.26588,686.063665460.000.00247.4581,912.00506,526.61
Policy :4031204002TOTALS :EGP5,066,889.514,331,152.513,03712,5550.000.00389,904.97184,433.983,756,813.56
Policy :4031204003Desc:AMERICAN EMBASSY USAIDIncurred date between 01/11/2024 and 31/10/2025
Benefit TypeCodeBenefit DescriptionCur.ClaimedApprovedClaim CntUnitsDeductibleCo-PaymentCo-InsDeniedPaid
1.Outpatient
BOINOutpatient - InvestigationsEGP88,746.0052,426.30191290.000.00190.003,473.3048,763.00
BOPTPhysiotherapyEGP5,701.005,701.002140.000.001,140.200.004,560.80
BORXOutpatient - MedicineEGP48,744.9548,724.7019570.000.009,744.920.0038,979.78
BOSPOutpatient - Surgeries/ProceduresEGP25,970.0018,715.00440.000.000.000.0018,715.00
BOSTOutpatient - Services/TreatmentsEGP268,741.34267,935.34631230.000.001,574.2937,388.06228,972.99
BOVIOutpatient - Initial Dr VisitEGP7,792.637,792.6320200.000.00800.000.006,992.63
1.OutpatientTOTALS :EGP445,695.92401,294.971273470.000.0013,449.4140,861.36346,984.20
2.Inpatient
BIANInpatient - AnesthetistEGP14,060.0013,610.00230.000.000.000.0013,610.00
BICUInpatient - Intensive Care UnitEGP60,000.0036,000.00260.000.000.000.0036,000.00
BIINInpatient - InvestigationsEGP149,465.0089,679.00380.000.000.000.0089,679.00
BIRBInpatient - Room & BoardEGP15,700.006,012.72440.000.000.000.006,012.72
BIRXInpatient - MedicineEGP11,123.5211,123.52440.000.000.000.0011,123.52
BISPInpatient - Surgeries/ProceduresEGP95,560.0093,760.00360.000.000.000.0093,760.00
BISTInpatient - Services/TreatmentsEGP212,478.85170,489.355170.000.000.000.00170,489.35
BIVIInpatient - Initial Dr VisitEGP42,000.0032,341.215250.000.000.000.0032,341.21
2.InpatientTOTALS :EGP600,387.37453,015.8028730.000.000.000.00453,015.80
3.Other Services
BNNCNot Covered BenefitsEGP34.0034.00100.000.000.0034.000.00
3.Other ServicesTOTALS :EGP34.0034.00100.000.000.0034.000.00
Policy :4031204003TOTALS :EGP1,046,117.29854,344.771564200.000.0013,449.4140,895.36800,000.00
Page:16/16Date:25/05/2026Userid:MABDULLAH

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