CHC08238-00
Covered entity, Ohio, calendar year 2025. Everything below is as the workbook stored it, with figures shown to the cent. Each section follows the Ohio Department of Health's template, in its order and words.
HRSA's list of covered entities does not hold this ID, so the page shows the ID as the workbook gives it. The workbook prints no name.
About this workbook
- 340B ID
- CHC08238-00
- Reporting period as typed
- January 1, 2025 - December 31, 2025
- Form
- Ohio Department of Health, ORC 3701.88 340B Covered Entity Reporting Template, calendar year 2025
Drugs dispensed in house
Drugs the covered entity dispensed through its own pharmacies.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Total |
|---|---|---|---|---|---|---|
| Acquisition costAggregate Acquisition Cost for all 340B drugs dispensed by the Covered Entity | $0 | |||||
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by the Covered Entity | $0 | |||||
| All prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B and non-340B) | 0 | |||||
| 340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B) | 0 | |||||
| Percentage that were 340BPercentage of total prescriptions that were 340B | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Drugs dispensed through contract pharmacies
Drugs contract pharmacies dispensed on behalf of the covered entity.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Indeterminate (Explain) | Total |
|---|---|---|---|---|---|---|---|
| Acquisition costAggregate Acquisition Cost for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above: | $278,373.32 | $321,261.32 | $7,826.32 | $0 | $22.75 | $0 | $607,483.71 |
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above: | $700,130.52 | $1,057,075.81 | $24,130.98 | $0 | $81.84 | $0 | $1,781,419.15 |
| All prescriptionsTotal number of Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity (340B and non-340B): | 1,042 | 1,243 | Withheldnext to a small count | 0 | Withheldfewer than 6 | 0 | 2,323 |
| 340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity: | 1,042 | 1,243 | Withheldnext to a small count | 0 | Withheldfewer than 6 | 0 | 2,323 |
| Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B: | 100% | 100% | Withheldwould show a small count | #DIV/0! | Withheldwould show a small count | #DIV/0! | 100% |
Drugs administered
Drugs the covered entity administered, for example by infusion or injection.
| Row of the template | Commercial Insurance/Private Insurance | Medicare | Medicaid (all states) | Other Third-Party Payor | Uninsured/Self-Pay | Total |
|---|---|---|---|---|---|---|
| Acquisition costAggregate Acquisition Cost for all 340B drugs administered by the Covered Entity | $100,837.26 | $4,438.50 | $68,727.46 | $0 | $12,760.70 | $186,763.92 |
| Actual paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Actual Payments | $168,944.01 | $545.08 | $6,665.36 | $0 | $5,990.31 | $182,144.76 |
| Estimated paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Estimated Payments* | $0 | $0 | $0 | $0 | $0 | $0 |
| Total paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - TOTAL | $0 | $0 | $0 | $0 | $0 | $0 |
| All prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B and non-340B) | 1,454 | 64 | 991 | 0 | 184 | 2,693 |
| 340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B) | 518 | 38 | 320 | 0 | 44 | 920 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | 35.63% | 59.38% | 32.29% | #DIV/0! | 23.91% | 34.16% |
Figures are shown to the cent. The downloads keep each figure exactly as it is written in the file, and the cell file lists the workbook cell each one was read from.
Cells marked Withheld. A count of prescriptions from 1 to 5 is never published, and neither is a figure that would let a reader work one out.
- The figure is not withheld because it is small. Next to the printed totals it would let a reader work out a count of 1 to 5 in another cell.
- The count of prescriptions is 1 to 5. A count that small is never published, here or in the data files.
- The percentage would let a reader work out a count of 1 to 5 in another cell.
Costs of running the program
Amounts in US dollars, as the workbook stores them.
| Cost | Amount | Cell |
|---|---|---|
| Contract pharmacies | $291,235.74 | C46 |
| Third-party administrators | $78,661.28 | C47 |
| Consultants | $42,000 | C48 |
| Software and IT | - | C49 |
| Other outside costs | - | C50 |
| Staffing | $143,178 | C53 |
| Internal IT | $14,083 | C54 |
| Other internal costs | - | C55 |
Contract pharmacies
- Number of contract pharmacies as typed
- 13
Uses of 340B funds
What the filer typed under the template's questions about how it uses the money 340B brings in. A dash or an empty cell is left out.
| Kind | Description | Amount | Cell |
|---|---|---|---|
| Program or service | Transportation of clients to and from appointments. Available to all patients but mainly utliized by low income and patients with a handicap disability | $314,568 | C65 |
| Program or service | Customer Resource Coordinators. Targets low income patients. Assist patients with insurance enrollment, sliding fee scale, and social barrier referrals. | $160,345 | C66 |
| Program or service | School Based Health Centers. Serves students, faculty, staff to reduce absenteeism and increase student health. We operate in all school districts in our serve area and provide medical, dental, and behavioral services. | $129,865 | C67 |
The filer in the workbook
- 340B ID as typed
- CHC08238-00
- NPIs as typed
- The workbook lists none.
Differences in this workbook
This workbook has 5 places where two of its figures differ. Nothing was changed; both figures are kept as stored.
Administered drugs, commercial column: total payments equal actual payments plus estimated payments
- Expected
- 168,944.01
- Stored
- 0
- Difference
- -168,944.01
Administered drugs, commercial column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 168,944.01.
The form itself says the two figures agree. Rule
administered_payments_total.commercial=actual+estimatedin Methods.Administered drugs, medicare column: total payments equal actual payments plus estimated payments
- Expected
- 545.08000000000004
- Stored
- 0
- Difference
- -545.08000000000004
Administered drugs, medicare column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 545.08.
The form itself says the two figures agree. Rule
administered_payments_total.medicare=actual+estimatedin Methods.Administered drugs, medicaid column: total payments equal actual payments plus estimated payments
- Expected
- 6,665.36
- Stored
- 0
- Difference
- -6,665.36
Administered drugs, medicaid column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 6665.36.
The form itself says the two figures agree. Rule
administered_payments_total.medicaid=actual+estimatedin Methods.Administered drugs, uninsured column: total payments equal actual payments plus estimated payments
- Expected
- 5,990.31
- Stored
- 0
- Difference
- -5,990.31
Administered drugs, uninsured column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 5990.31.
The form itself says the two figures agree. Rule
administered_payments_total.uninsured=actual+estimatedin Methods.Administered drugs, total column: total payments equal actual payments plus estimated payments
- Expected
- 182,144.75999999998
- Stored
- 0
- Difference
- -182,144.75999999998
Administered drugs, total column. The total payments cell holds 0.00. The actual payments cell and the estimated payments cell add to 182,144.76.
The form itself says the two figures agree. Rule
administered_payments_total.total=actual+estimatedin Methods.
Source
- Workbook
- Open CHC0823800.xlsx on the Ohio Department of Health's website
- Size
- 22 KB
- Retrieved
- 16 November 2026
- SHA-256
- 9194aaf2f5b36ae9f329c0fb5f431c18847b22d114aeb9cd1bb54e01c1620dfb
- How it was read
- Two separate programs read each cell of the workbook, and a value is kept when their reads agree. The cells of this workbook are listed one by one in the dataset repository.