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

VACAVILLE, CITY OF

UEI L6K7J51NX2K6 · CA · local · FY 2023-07-01 → 2024-06-30
FY2024: Filed

Filed 2 years (FY2023–FY2024).

FY2024 reconciliation conflict. Our observed money and the FAC filing disagree about the threshold — contradicted -- FAC shows over threshold. The audit reports $45,459,812 of SEFA against $70K observed here (0.2% of SEFA), which usually means the filing covers more entities than this one.
Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2024Filed $70K $750K2025-03-30124$45.5M0.2% 2024-06-GSAFAC-0000376888 ↗
2023Filed $100K $750K2024-03-30103$35.0M0.3% 2023-06-GSAFAC-0000050078 ↗
2022Under threshold $6K $750K2023-03-30
Obligation
$0
Outlay
$70K
Subaward recv
$0
Subaward passed
$0
Loan face value
$0
Awards
0
SEFA reported
$45.5M (obs. 0.2%)
▲ pass-through money only
FAC check
contradicted -- FAC shows over threshold
Audit type
single-audit
Accepted
2025-08-01
Auditor
LSL, LLP
Cognizant agency
Oversight agency
14
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $0$70K$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
CITY OF VACAVILLE NT7DVC87LKH9
Rolls up to this entity
Nothing — no entity rolls up to this one.
link_type = succession

One entity replaced by another — a survivor inherits its predecessors’ obligations. Not year-specific.

Succeeded by
Nothing — this entity is the survivor.
Merged into this entity (1)
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 = 'NT7DVC87LKH9'      -- this entity's parent
  AND related_uei <> 'L6K7J51NX2K6';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
CITY OF VACAVILLE
UDA4HNSADJR7
Under threshold$234K
HSP5RBXJHKP7
HSP5RBXJHKP7