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

CITY & COUNTY OF HONOLULU ENVIRON SERVICES

UEI LUC1RRKCT3Q9 · HI · local · FY 2025-07-01 → 2026-06-30
FY2026: Not yet due

overdue for FY2022, FY2023, FY2024, FY2025 ($84.7M observed); FY2026 not yet due.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Not yet due $33.1M $1.0Mpass-through 100%2027-03-30
2025Overdue $28.0M $750Kpass-through 100% (outlay unknown)2026-03-30129d past due
2024Overdue $22.0M $750Kpass-through 100%2025-03-30494d past due
2023Overdue $22.4M $750Kpass-through 100%2024-03-30859d past due
2022Overdue $12.3M $750Kpass-through 100%2023-03-301225d past due
Obligation
$0
Outlay
Subaward recv
$33.1M
Subaward passed
$0
Loan face value
$0
Awards
0
▲ pass-through money only
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $0$33.1M$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
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 = 'D4W7SB9CF8G4'      -- this entity's parent
  AND related_uei <> 'LUC1RRKCT3Q9';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
HONOLULU, CITY & COUNTY OF
V9DEKYMD2MG1
Not yet due4$273.2M
CITY AND COUNTY OF HONOLULU
LY6TQSK6LNH1
Not yet due4$4.7M
HONOLULU, CITY & COUNTY OF
ZUSKKSMDB246
Overdue1$3.6M
CITY & COUNTY OF HONOLULU
FKQ6F96Q5LC6
Not yet due4$2.4M
HONOLULU, CITY & COUNTY OF
L42NGMVDEBF4
Under threshold1$522K
CITY & COUNTY OF HONOLULU EMERGENCY MEDICAL SERVICES
JYURXDF7VHK8
Under threshold$250K
CITY AND COUNTY OF HONOLULU DEPARTMENT OF PLANNING & PERMITTING
N9F1BHDRDYK3
Under threshold$228K
HONOLULU CITY COUNTY RECEPTIONIST
KBR6T8Y69HD6
Under threshold$125K
CITY & COUNTY OF HONOLULU
CNXTSHERUHN9
Under threshold1$20K
TEJHKGHX4TE3
TEJHKGHX4TE3
GM6SNJE95G95
GM6SNJE95G95