PROTOTYPE — Not for official use. Data and outputs are for demonstration only and do not constitute official HHS determinations.
← delinquency review

CLEVELAND DEPARTMENT PUBLIC HEALTH

UEI R6LWW3MWGQQ1 · OH · local · FY 2025-01-01 → 2025-12-31
FY2025: Under threshold

overdue for FY2022, FY2023, FY2024 ($12.0M observed).

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold partial$432K $1.0M2027-09-30
2025Under threshold $936K $1.0M2026-09-30
2024Overdue $3.4M $750Koutlays 39% + pass-through 61%2025-09-30310d past due
2023Overdue $3.4M $750Koutlays 30% + pass-through 70%2024-09-30675d past due
2022Overdue $5.2M $750Koutlays 19% + pass-through 81%2023-09-301041d past due
Obligation
$1.1M
Outlay
$874K
Subaward recv
$62K
Subaward passed
$365K
Loan face value
$0
Awards
1
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Health Resources and Services Administration HHS$1.1M$768K$52K$365K$0
Centers for Disease Control and Prevention HHS$0$10K$0$0
Non-HHS federal money $0$106K$0$0$0

Relationships

Three independent link types, one card each. They overlap — the same money can appear under more than one, so never add them together.

link_type = corporate_parent

From SAM.gov registration: the headquarters an entity registered under, and the entities registered beneath it. A registration record, not an org chart — it does not mean the parent runs the entity’s programs. The link itself never changes, but the lists below follow the selected year: an entity only appears in years it had federal activity.

Rolls up to
PTV3L9YMEHY6 PTV3L9YMEHY6
Rolls up to this entity
Nothing — no entity rolls up to this one.
derived — not a link_type

Not a stored relationship. These entities are found by taking this entity’s parent and looking up everything else registered under it — so they will not appear in any row keyed to this entity’s own UEI. Shown because the coverage lead above rests on them: if a sibling provably covers other entities, it may account for this one too.

Show the query
SELECT related_uei, link_type FROM pub.entity_link
WHERE link_type = 'corporate_parent'
  AND uei = 'PTV3L9YMEHY6'      -- this entity's parent
  AND related_uei <> 'R6LWW3MWGQQ1';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
CITY OF CLEVELAND
JL2EYRT4GNU8
Not yet due3$35.1M
CITY OF CLEVELAND
YR5DREGHLCY7
Not yet due3$5.9M
CLEVELAND, CITY OF
FAPSL5JABAJ4
Not yet due2$5.0M
CITY OF CLEVELAND
YNBRX833CQK6
Filed$2.4M
CITY OF CLEVELAND
NAQLA294SNS4
Not yet due$1.9M
M4LPC1WP24J6
M4LPC1WP24J6
J2AZJY9NKQK5
J2AZJY9NKQK5
F69PZ3H8Y2N5
F69PZ3H8Y2N5