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

SAN MATEO, COUNTY OF

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

overdue for FY2022 ($1.2M observed).

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2022Overdue $1.2M $750Kpass-through 100%2023-09-301041d past due
Obligation
$0
Outlay
Subaward recv
$1.2M
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.2M$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 = 'MFFRTNKE5KP7'      -- this entity's parent
  AND related_uei <> 'MJA3KD7887Z7';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
COUNTY OF SAN MATEO
DBMER51WFWH5
Not yet due4$8.1M
COUNTY OF SAN MATEO
NN2CZ9SAYTK5
Not yet due4$7.3M
SAN MATEO COUNTY HEALTH
PP88MKPKJZ54
Not yet due4$6.5M
COUNTY OF SAN MATEO
FMNFY9KZHDD5
Not yet due2$3.4M
SAN MATEO, COUNTY OF
MUYBVAG79AF8
Not yet due2$2.1M
SAN MATEO, COUNTY OF
E42TUXRRF6F8
Under threshold2$743K
SAN MATEO, COUNTY OF
SM84P856R674
Under threshold$188K
SAN MATEO, COUNTY OF
KM4XKCFE4EN8
Under threshold$50K
CA SAN MATEO COUNTY- CORONERS OFFICE
HUGQN1KJPKJ1
Under threshold$9K
SAN MATEO, COUNTY OF
MAPQTA9Z9XK8
Undetermined$0
SAN MATEO CO DEPT OF PU
PGEMA4HEP1L5
Undetermined3$0
COUNTY OF SAN MATEO
HKUWFVADCLM4
Undetermined$0
SEYBBYP5PVL5
SEYBBYP5PVL5