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

SAN FRANCISCO, CITY & COUNTY OF

UEI M1SRCANUXPW9 · CA · government · FY 2022-01-01 → 2022-12-31
FY2022: Overdue

overdue for FY2022 ($1.5M observed).

Possible coverage — unverified. CITY AND COUNTY OF SAN FRANCISCO is in the same corporate family and files an audit that FAC records as covering 22 other entities — but not this one.
That sibling's coverage is proven (declared); the inferred step is only the corporate-family link joining the two, which comes from USAspending. Confirming this entity sits inside that audit needs the report's SEFA detail by agency. Nothing here changes a status.
Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2022Overdue $1.5M $750Kpass-through 100%2023-09-301041d past due
Obligation
$0
Outlay
Subaward recv
$1.5M
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
Health Resources and Services Administration HHS$0$1.5M$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 = 'LYCMERUN3Z73'      -- this entity's parent
  AND related_uei <> 'M1SRCANUXPW9';   -- 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
EL3RB31KENH3
Covered by parent$71.0M
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
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