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

Other files attached to OEIBA Program Commercial HMO, MSP, and MAPD Plans, newest first.
File Type Posted
Exhibit_22_Satisfaction_Surveys.xlsx XLSX spreadsheet
Exhibit_28_MAPD_File_and_Changes_Reports.xlsx XLSX spreadsheet
Exhibit_2_Geo-Access_Report.xlsx XLSX spreadsheet
Exhibit_35_HMO_Detailed_Utilization_Reports.xlsx XLSX spreadsheet
Exhibit_36_MAPD_Detailed_Utilization_Reports.xlsx XLSX spreadsheet
Exhibit_38_Advertising_Approval_Request_Form.docx DOCX document
VendorSecurityAssessment_(1).xlsx XLSX spreadsheet
OMES-FORM-CP-011-Amendment_2.pdf PDF
AttachmentB-NegotiableTerms.docx DOCX document
BID_PACKET_ATTACHMENTS_INSTRUCTIONS.pdf PDF
Exhibit_10_MAPD_Premium_Rate_and_LIS_Quote.docx DOCX document
Exhibit_13_MSP_Premium_Rate.docx DOCX document
Exhibit_20_Member_ID_Card_Example.xlsx XLSX spreadsheet
Exhibit_23_CAHPS_Survery_MAPD.xlsx XLSX spreadsheet
Exhibit_24_OEIBA_Program_Census_Information.xlsx XLSX spreadsheet
Exhibit_27_Minimum_Required_Reporting_List.docx DOCX document
Exhibit_29_Premium_Discrepancy_Reports.xlsx XLSX spreadsheet
Exhibit_33_Network_Changes_Summary.xlsx XLSX spreadsheet
Exhibit_34_Network_Detailed_Reports.xlsx XLSX spreadsheet
Exhibit_8_Rate_Developt_Support_Early_Retirees_Employees.xlsx XLSX spreadsheet
Exhibit_9_MAPD_Benefits_Summary.docx DOCX document
OMESFormCP004.pdf PDF
Attachment_E.docx DOCX document
Exhibit_11_MAPD_Rate_Setting.xlsx XLSX spreadsheet
Exhibit_14_Bid_Submission_Network_Detailed_Reports.xlsx XLSX spreadsheet
Exhibit_17_Audited_Financial_Statements.xlsx XLSX spreadsheet
Exhibit_1_Standardized_Service_Areas.xlsx XLSX spreadsheet
Exhibit_31_HIPAA,_FWA,_and_Grievance_Reports.xlsx XLSX spreadsheet
Exhibit_32_HMO_Utilization_Reports.xlsx XLSX spreadsheet
Exhibit_37B_Individual_Employer_Experience_Reports.xlsx XLSX spreadsheet
Exhibit_3_Ratio_of_PCPs_to_Members.xlsx XLSX spreadsheet
Exhibit_7_Rate_Development_Supporting__Active_Employees.xlsx XLSX spreadsheet
Fillable_OMESFormCP076.pdf PDF
OMES-FORM-CP-011-Amendment_Q_A.pdf PDF
AttachmentD-ITTerms.pdf PDF
Attachment_A.pdf PDF
Bidder_Instructions.pdf PDF
Exhibit_12_MSP_Benefits_Summary.docx DOCX document
Exhibit_15_New_Supp_Aggregate_Utilization_Exp_.xlsx XLSX spreadsheet
Exhibit_18_License(s).xlsx XLSX spreadsheet
Exhibit_19_Actuary_Certification.xlsx XLSX spreadsheet
Exhibit_21_Organizational_Chart_and_Brand_Logos.xlsx XLSX spreadsheet
Exhibit_25_Carrier_Eligibility_Companion_Guide.pdf PDF
Exhibit_26_OEIBB_Commercial_Carrier_Policy.pdf PDF
Exhibit_30_Member_Services_Reports.xlsx XLSX spreadsheet
Exhibit_37A_Individual_Emp_Experience_Reports_Instructions.docx DOCX document
Exhibit_4_HMO_Plan_Design.docx DOCX document
Exhibit_5_HMO_Premium_Quote.docx DOCX document
Exhibit_6_HMO_Rate_Development.xlsx XLSX spreadsheet
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]
ReportReport TitleTab Name
16aLarge Claims 12 mo Ending December 20232023
16bLarge Claims 12 mo Ending December 20242024

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)

ClaimantPrimary DiagnosisStatusMedicalPharmacyTotal
ExampleClaimant 1DiabetesActive$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)

ClaimantPrimary DiagnosisStatusMedicalPharmacyTotal
ExampleClaimant 1HemophiliaActive$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 .