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

SAN JOAQUIN COUNTY HEALTH SERVICES EMPLOYEES GUILD

UEI LKGVGAMTMGS3 · CA · non-profit · FY 2024-07-01 → 2025-06-30
FY2025: Under threshold

Filed 3 years (FY2022–FY2024).

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2025Under threshold $24K $750K2026-03-30
2024Filed $981K $750Koutlays 100%2025-03-30-19$1.4M69% 2024-06-GSAFAC-0000356472 ↗
2023Filed $3.2M $750Koutlays 94% + pass-through 6%2024-03-30-138$4.3M75% 2023-06-GSAFAC-0000006323 ↗
2022Filed $1.8M $750Koutlays 88% + pass-through 12%2023-03-30-12$1.7M104% 2022-06-CENSUS-0000254673 ↗
Obligation
$-2K
Outlay
$24K
Subaward recv
$0
Subaward passed
$0
Loan face value
$0
Awards
4
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
HHS, component not specified HHS$0$0$0$0
Health Resources and Services Administration HHS$-2K$24K$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
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 = 'MKMGP2C1C2V7'      -- this entity's parent
  AND related_uei <> 'LKGVGAMTMGS3';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
SAN JOAQUIN COUNTY - HUMAN SERVICES AGENCY
L3XZK6UCWTF3
Not yet due4$7.6M
SAN JOAQUIN REGIONAL RAIL COMMISSION
LQF9KNKTYMC5
Not yet due$6.7M
SAN JOAQUIN COUNTY DISTRICT ATTORNEYS OFFICE
HZKBH1PWPG74
Not yet due3$1.7M
SAN JOAQUIN, COUNTY OF
GMKHJQ8GRG78
Not yet due1$1.5M
WOODBRIDGE RURAL COUNTY FIRE PROTECTION DISTRICT
QFFQFMKF27S1
Not yet due$1.0M
COUNTY OF SAN JOAQUIN
KL9UNJA5L1C7
Under threshold$451K
FRENCH CAMP FIRE DISTRICT
EA7FR3KL8JC5
Under threshold$238K
LAX4YU2UU543
LAX4YU2UU543
JR6BBU4KDT34
JR6BBU4KDT34
NPTELF6N4588
NPTELF6N4588