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

CITY & COUNTY OF SAN FRANCISCO

UEI EL3RB31KENH3 · CA · local · FY 2024-07-01 → 2025-06-30
FY2025: Covered by parent

covered by another audit for 1 year.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2025Covered by parent $71.0M $750Kpass-through 100%2026-03-302025-06-GSAFAC-0000405901 ↗
Obligation
$0
Outlay
Subaward recv
$71.0M
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$71.0M$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 = audit_coverage

Whose single audit accounts for this entity, and whose this entity accounts for. The LINKS are standing — they apply to every year, and a gap in the observed span is a gap in FAC reporting, not a year the entity stood alone. The rolled AMOUNTS below follow the selected fiscal year, so the entity count there can be smaller than the standing list.

Covered by
CITY AND COUNTY OF SAN FRANCISCO 2025-06-GSAFAC-0000405901 ↗
Standing link — declared from fac, observed FY2022–FY2025. This entity is not independently delinquent in any year; the coverer carries the filing obligation.
This entity’s audit covers
Nothing — no other entity relies on this one’s audit.
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 = 'LYCMERUN3Z73'      -- this entity's parent
  AND related_uei <> 'EL3RB31KENH3';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
CITY AND COUNTY OF SAN FRANCISCO
MYM4VNNBN6T9
22Not yet due$47.4M
CITY & COUNTY OF SAN FRANCISCO
LFNSYLNF7C84
Covered by parent$238.2M
CITY & COUNTY OF SAN FRANCISCO
GSL6KW4Z5UE1
Not yet due$213.8M
CITY & COUNTY OF SAN FRANCISCO
K2Z4R5AKMT95
Not yet due$168.4M
CITY & COUNTY OF SAN FRANCISCO
DCTNHRGU1K75
Not yet due$58.0M
SAN FRANCISCO, CITY AND COUNTY OF
MN12Y8JWN5P8
Covered by parent$10.4M
CITY & COUNTY SAN FRAN
SLJ1LL3ZPKJ3
Not yet due$8.8M
CITY & COUNTY OF SAN FRANCISCO
G2ACFK8T2MJ6
Not yet due$4.9M
CITY & COUNTY OF SAN FRANCISCO
SRZKDWN293M2
Not yet due$2.1M
SAN FRANCISCO, CITY & COUNTY OF
JZ9BSV3GSJ54
Not yet due$1.9M
SAN FRANCISCO, CITY & COUNTY OF
M1SRCANUXPW9
Overdue1$1.5M
CITY AND COUNTY OF SAN FRANCISCO
LNADLQGAWKL6
Under threshold$780K
CITY AND COUNTY OF SAN FRANCISCO
JJCMD7L3NGP9
Under threshold$203K
CITY & COUNTY OF SAN FRANCISCO ADULT PROBATION DEPARTMENT
ETKMKZJ6RGB7
Undetermined$50K
CITY & COUNTY OF SAN FRANCISCO
LTDTMU3KHMH6
Under threshold$19K
SAN FRANCISCO SHERIFFS DEPARTMENT
N9JTR4AN3ZD1
Undetermined$0
SAN FRANCISCO, CITY & COUNTY OF
CK7BAVKBDW28
Undetermined$0
YESSWK7AXF36
YESSWK7AXF36
E4E3MPR48KH4
E4E3MPR48KH4
GHXUS2VEXHY1
GHXUS2VEXHY1
KDKCKG1YZCB6
KDKCKG1YZCB6
T9KNF13HRCB6
T9KNF13HRCB6
WGMKMEM9N5Z5
WGMKMEM9N5Z5
CCJRSK3E5ZW5
CCJRSK3E5ZW5