Exhibit_34_Network_Detailed_Reports.xlsx

XLSX spreadsheet 61 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

This file is an Excel-based exhibit for network detailed reporting, specifically for the OEIBA (Oklahoma Employees Insurance and Benefits Act) Program, prepared by a supplier for quarterly submission to the Oklahoma Office of Management and Enterprise Services (OMES). The document provides a comprehensive template for reporting network changes and provider network details across seven distinct tabs, with a consistent reporting deadline of 60 days following the close of each calendar quarter. The reporting tabs cover network changes, primary care physicians (PCPs), specialists, pharmacies, urgent care facilities, and hospitals, requiring detailed information including provider names, National Provider Identifier (NPI) numbers, addresses, specialties, and contact information.

The reporting template is designed to track network composition and changes, with specific sections for additions and deletions across various provider categories. The PCP summary tab, for example, includes metrics such as the total number of unique PCPs, those accepting new patients, and those closed to new patients. Providers must be reported with comprehensive details including NPI, name, title, specialty, address, county, phone number, and participation status in HMO/MAPD programs. The reporting is to be submitted electronically via a secure email domain (EGIDVendorReporting@omes.ok.gov) as an Excel file, ensuring standardized and consistent network tracking for the state's insurance program.

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
Attachment_E.docx DOCX document
Exhibit_11_MAPD_Rate_Setting.xlsx XLSX spreadsheet
Exhibit_14_Bid_Submission_Network_Detailed_Reports.xlsx XLSX spreadsheet
Exhibit_16_Large_Claims_Report_for_2023_and_2024.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
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_8_Rate_Developt_Support_Early_Retirees_Employees.xlsx XLSX spreadsheet
Exhibit_9_MAPD_Benefits_Summary.docx DOCX document
OMESFormCP004.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 34: Network Detailed Reports
[Supplier Name]
OEIBA Program
[Date]
*60 days following the close of the calendar quarter
ReportReport TitleTab Name
34aSummary of Provider Network ChangesSummary of Network Changes
34bPrimary Care Physician SummaryPCP Summary
34cPrimary Care Physician NetworkPCP
34dSpecialist NetworkSpecialist
34ePharmacy NetworkPharmacy
34fUrgent Care NetworkUrgent Care
34gHospital NetworkHospital
Notes:
1) Submit reports quarterly using this template.
2) Send via email by secure domain to: EGIDVendorReporting@omes.ok.gov
3) Completed template must be submitted electronically as an Excel file.
`

34a Summary of Network Changes Due Date 60 days following the close of the calendar quarter

Summary of Provider Network Changes
[Supplier Name]
Reporting Date [Date Start - Date End]
TypeProvider Last NameProvider First NameTitleNPISpecialtyPrimary AddressCityStateZipCountyPhone
ADDITIONS
Primary Care Physicians
ExampleMichaelsonLucasMD1111811111Family Practice111 NW ExpresswayOklahoma CityOK73112Oklahoma405-777-7777

Specialists

Hospitals

Pharmacy

Urgent Care

DELETIONS
Primary Care Physicians

Specialists

Hospitals

Pharmacy

Urgent Care

34b PCP Summary Due Date 60 days following the close of the calendar quarter

Primary Care Physician Summary
[Supplier Name]
Reporting Date [Date Start - Date End]
Example:
PCPs Accepting New Patients96289.57%
PCPs Accepting Existing Patients565.21%
PCPs Closed to New Patients565.21%
Total Number of Unique PCPs1074

34c PCP Due Date 60 days following the close of the calendar quarter

Primary Care Physician Network
[Supplier Name]
Reporting Date [Date Start - Date End]
NPILast NameFirst NameTitleSpecialtyAddressCityStateZipCountyPhoneHMO/MAPD (HMO/MAPD/Both)PCPs Accepting New Patients (Y/N)
Example1111181111MichaelsonLucasMDInternal Medicine111 NW ExpresswayOklahoma CityOK73112Oklahoma405-777-7777BothY

34d Specialist Due Date 60 days following the close of the calendar quarter

Specialist Network
[Supplier Name]
Reporting Date [Date Start - Date End]
NPILast NameFirst NameTitleSpecialtyAddressCityStateZipCountyPhone
Example1111181111MichaelsonLucasMDCardiovascular Disease111 NW ExpresswayOklahoma CityOK73112Oklahoma405-777-7777

34e Pharmacy Due Date 60 days following the close of the calendar quarter

Pharmacy Network
[Supplier Name]
Reporting Date [Date Start - Date End]
Pharmacy NameNABPAddressCityStateZipCountyPhone
ExampleStillman Pharmacy1111111111 NW ExpresswayOklahoma CityOK73112Oklahoma405-777-7777

34f Urgent Care Due Date 60 days following the close of the calendar quarter

Urgent Care Network
[Supplier Name]
Reporting Date [Date Start - Date End]
Urgent Care NameAddressCityStateZipCountyPhone
ExampleAlliance Urgent111 NW ExpresswayOklahoma CityOK73112Oklahoma405-777-7777

34g Hospital Due Date 60 days following the close of the calendar quarter

Hospital Network
[Supplier Name]
Reporting Date [Date Start - Date End]
Hospital NameAddressCityStateZipCountyPhone
ExampleAlliance Hospital111 NW ExpresswayOklahoma CityOK73112Oklahoma405-777-7777

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