The HealthCare Connection, Inc. (LINCOLN HEIGHTS HEALTH CENTER) (CH059880)
Community health center, 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.
The name is HRSA's, from its public list of covered entities read on 11 November 2026. The workbook prints the 340B ID and no name.
About this workbook
- 340B ID
- CH059880 The HealthCare Connection, Inc. (LINCOLN HEIGHTS HEALTH CENTER) (Community health center)
- 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 | $0 | $442,701.06 | $555,362.55 | $304,381.40 | $1,302,445 |
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by the Covered Entity | $0 | $0 | $1,083,346.61 | $1,359,043.83 | $744,860.56 | $3,187,251 |
| All prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B and non-340B) | 0 | 0 | 12,115.3956 | 14,855.349880000002 | 8,330.0028000000002 | 35,644 |
| 340B prescriptionsTotal number of Prescriptions dispensed by the Covered Entity (340B) | 0 | 0 | 11,267.317908000001 | 13,815.475388400002 | 7,746.9026040000008 | 33,149 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | #DIV/0! | #DIV/0! | 0.93% | 0.93% | 0.93% | 93% |
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: | $0 | $0 | $0 | $1,646,844 | $0 | $0 | $1,770,307 |
| Payments receivedAggregate Payments Received for all 340B drugs dispensed by all Contract Pharmacies on behalf of the Covered Entity above: | $0 | $0 | $0 | $2,910,868 | $0 | $0 | $2,805,852 |
| All prescriptionsTotal number of Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity (340B and non-340B): | 0 | 0 | 0 | 3,485 | 0 | 0 | 3,485 |
| 340B prescriptionsTotal number of 340B Prescriptions filled by all Contract Pharmacies on behalf of the Covered Entity: | 0 | 0 | 0 | 3,485 | 0 | 0 | 3,485 |
| Percentage that were 340BPercentage of total Covered-Entity associated prescriptions that were 340B: | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
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 | $0 | $0 | $0 | $0 | $0 | $0 |
| Actual paymentsAggregate Payments Received for all 340B drugs administered by the Covered Entity - Actual Payments | $0 | $0 | $0 | $0 | $0 | $0 |
| 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) | 0 | 0 | 0 | 0 | 0 | 0 |
| 340B prescriptionsTotal number of Prescriptions administered by the Covered Entity (340B) | 0 | 0 | 0 | 0 | 0 | 0 |
| Percentage that were 340BPercentage of total prescriptions that were 340B | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! | #DIV/0! |
Where the workbook formats a cell as a percentage it stores a fraction of one, and the page shows it as the workbook's cell shows it: 0.25 is 25%. The dataset keeps the stored number.
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.
Costs of running the program
Amounts in US dollars, as the workbook stores them.
| Cost | Amount | Cell |
|---|---|---|
| Contract pharmacies | $25,483.37 | C46 |
| Third-party administrators | $277,107.83 | C47 |
| Consultants | - | C48 |
| Software and IT | - | C49 |
| Other outside costs | ||
| Staffing | $314,773.12 | C53 |
| Internal IT | $39,364 | C54 |
| Other internal costs | $558,705.15 | C55 |
Contract pharmacies
- Number of contract pharmacies as typed
- 86
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 | Interpreting costs for our patients who do not speak English as a first language. This includes an outsourced interpreting company, and salaries for our interpreting staff. | $266,204.71 | C65 |
| Program or service | Pharmacy delivery and mailing service to ensure continuity of care when a patient does not have the resources to pick up their prescription | $3,590 | C66 |
| Program or service | After Hours Answering Service | $10,519 | C67 |
| Program or service | Case Management for patients | $29,941.96 | C68 |
The filer in the workbook
- 340B ID as typed
- CH059880
- NPIs as typed
- 1053337675
- 1154347789
- 1922024553
- 1790439156
- 1174867881
- 1578244687
- 1760136113
- 1073407748
- 1326932096
Cells outside the template
The filer typed text in cells the template does not ask for. They are listed as found, by cell.
| Cell | Text |
|---|---|
| B65 | Program/Service 1: Interpreting Services |
| B66 | Program/Service 2: Pharmacy Delivery Services |
| B67 | Program/Service 3: Answering Service |
| B68 | Program/Service 4: Case Management |
| B83 | The HealthCare Connection utilizes savings generated through the 340B Drug Pricing Program to expand access to comprehensive healthcare services for underserved and vulnerable populations in our community. Rather than distributing these funds as profit, 340B savings are reinvested into programs and services that support our mission as a Federally Qualified Health Center. |
| B85 | Specifically, 340B savings help offset the cost of providing care to uninsured and underinsured patients, support expanded pharmacy services, maintain medication access programs, and fund clinical staff and care coordination services that are not fully reimbursed by third-party payers. These funds also help sustain behavioral health, dental, vision, and primary care services, improve patient access through extended hours and care management, and support investments in technology, equipment, and infrastructure that enhance patient care. |
| B87 | As reimbursement rates often do not fully cover the cost of providing comprehensive healthcare services, 340B savings are essential to maintaining financial sustainability while allowing The HealthCare Connection to continue expanding services, improving health outcomes, and reducing barriers to care for the communities we serve. |
Differences in this workbook
This workbook has 2 places where two of its figures differ. Nothing was changed; both figures are kept as stored.
The five payer cells of aggregate acquisition cost dispensed through contract pharmacies add up to the Total cell (the Indeterminate column is not part of the total)
- Expected
- 1,646,844
- Stored
- 1,770,307
- Difference
- 123,463
Aggregate acquisition cost, dispensed through contract pharmacies. The total cell holds 1,770,307.00. The five payer cells add to 1,646,844.00. The Indeterminate cell is not part of the total.
The form itself says the two figures agree. Rule
contract_acquisition_cost.rows=totalin Methods.The five payer cells of aggregate payments received dispensed through contract pharmacies add up to the Total cell (the Indeterminate column is not part of the total)
- Expected
- 2,910,868
- Stored
- 2,805,852
- Difference
- -105,016
Aggregate payments received, dispensed through contract pharmacies. The total cell holds 2,805,852.00. The five payer cells add to 2,910,868.00. The Indeterminate cell is not part of the total.
The form itself says the two figures agree. Rule
contract_payments_received.rows=totalin Methods.
Source
- Workbook
- Open CH059880.xlsx on the Ohio Department of Health's website
- Size
- 17 KB
- Retrieved
- 16 November 2026
- SHA-256
- fccdcce6ee8f7c8d027b5526ae85545dffd78689d082c74b84dbfeb943627b91
- 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.