Exhibit_16_Large_Claims_Report_for_2023_and_2024.xlsx
XLSX spreadsheet 25 KB Posted
- Attached to
- OEIBA Program Commercial HMO, MSP, and MAPD Plans State and local contract opportunity
- Solicitation number
- EV00000681
- Issued by
- Oklahoma County, Hobart City, Oklahoma
About this file
The file is an Excel exhibit titled "Large Claims Report for 2023 and 2024" with instructions for reporting large claims data for a health insurance or benefits program. The document provides templates for reporting de-identified large claims information for active and early retiree populations, specifically requesting data for claims exceeding $100,000 in aggregate medical and pharmacy expenses for the 12-month periods ending December 2023 and December 2024, aligned with Plan Year 2026. The reporting instructions require comprehensive claim details including claimant primary diagnosis, status, medical costs, pharmacy costs, and total expenses.
The exhibit appears to be part of a comprehensive claims reporting process, likely for a state, local, or organizational health benefits program. The templates are designed to capture detailed claims experience across two consecutive years, enabling analysis of high-cost medical claims trends. Each reporting period includes space for up to 50 individual claimants, with an example entry demonstrating the required format. The document is marked as confidential and seems to be a standard reporting template for tracking and analyzing large medical claims for potential risk management, budgeting, and benefits planning purposes.
View the file
Other files for this state and local contract opportunity
Show all 49
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Report Cover
| Exhibit 16: Large Claims Reports for 2023 and 2024 |
| [Supplier Name] |
| [Date] |
| Report | Report Title | Tab Name |
| 16a | Large Claims 12 mo Ending December 2023 | 2023 |
| 16b | Large Claims 12 mo Ending December 2024 | 2024 |
16a 2023
| Large Claims 12 mo. Ending December 2023 |
| Plan Year 2026 |
| 2023 Large Claims Report - Active and Early Retiree |
| Instructions on providing the experience segments: |
- Provide de-identified large claim data information requested below (dollars and diagnosis)
- Provide information for any claimant over $100,000 in aggregate claims (both medical and pharmacy)
- Data must be provided in the below worksheet - do not refer to a separate document
- Provide information for the 12 months ending December 2023 on an INCURRED basis (12/24)
| Claimant | Primary Diagnosis | Status | Medical | Pharmacy | Total | |
| Example | Claimant 1 | Diabetes | Active | $82,300 | $27,500 | $109,800 |
| 1. | ||||||
| 2. | ||||||
| 3. | ||||||
| 4. | ||||||
| 5. | ||||||
| 6. | ||||||
| 7. | ||||||
| 8. | ||||||
| 9. | ||||||
| 10. | ||||||
| 11. | ||||||
| 12. | ||||||
| 13. | ||||||
| 14. | ||||||
| 15. | ||||||
| 16. | ||||||
| 17. | ||||||
| 18. | ||||||
| 19. | ||||||
| 20. | ||||||
| 21. | ||||||
| 22. | ||||||
| 23. | ||||||
| 24. | ||||||
| 25. | ||||||
| 26. | ||||||
| 27. | ||||||
| 28. | ||||||
| 29. | ||||||
| 30. | ||||||
| 31. | ||||||
| 32. | ||||||
| 33. | ||||||
| 34. | ||||||
| 35. | ||||||
| 36. | ||||||
| 37. | ||||||
| 38. | ||||||
| 39. | ||||||
| 40. | ||||||
| 41. | ||||||
| 42. | ||||||
| 43. | ||||||
| 44. | ||||||
| 45. | ||||||
| 46. | ||||||
| 47. | ||||||
| 48. | ||||||
| 49. | ||||||
| 50. |
CONFIDENTIAL
16a 2024
| Large Claims 12 mo. Ending December 2024 |
| Plan Year 2026 |
| 2024 Large Claims Report - Active and Early Retiree |
| Instructions on providing the experience segments: |
- Provide de-identified large claim data information requested below (dollars and diagnosis)
- Provide information for any claimant over $100,000 in aggregate claims (both medical and pharmacy)
- Data must be provided in the below worksheet - do not refer to a separate document
- Provide information for the 12 months ending December 2024 on an INCURRED basis (12/16)
| Claimant | Primary Diagnosis | Status | Medical | Pharmacy | Total | |
| Example | Claimant 1 | Hemophilia | Active | $82,300 | $27,500 | $109,800 |
| 1. | ||||||
| 2. | ||||||
| 3. | ||||||
| 4. | ||||||
| 5. | ||||||
| 6. | ||||||
| 7. | ||||||
| 8. | ||||||
| 9. | ||||||
| 10. | ||||||
| 11. | ||||||
| 12. | ||||||
| 13. | ||||||
| 14. | ||||||
| 15. | ||||||
| 16. | ||||||
| 17. | ||||||
| 18. | ||||||
| 19. | ||||||
| 20. | ||||||
| 21. | ||||||
| 22. | ||||||
| 23. | ||||||
| 24. | ||||||
| 25. | ||||||
| 26. | ||||||
| 27. | ||||||
| 28. | ||||||
| 29. | ||||||
| 30. | ||||||
| 31. | ||||||
| 32. | ||||||
| 33. | ||||||
| 34. | ||||||
| 35. | ||||||
| 36. | ||||||
| 37. | ||||||
| 38. | ||||||
| 39. | ||||||
| 40. | ||||||
| 41. | ||||||
| 42. | ||||||
| 43. | ||||||
| 44. | ||||||
| 45. | ||||||
| 46. | ||||||
| 47. | ||||||
| 48. | ||||||
| 49. | ||||||
| 50. |
CONFIDENTIAL
File details come from the government source that posted it. Updated .