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

FORT WORTH, CITY OF

UEI F7RMBTZ8D1D5 · TX · government · FY 2024-10-01 → 2025-09-30
FY2025: Under threshold

3 years undetermined.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Undetermined partial$0 $1.0M2027-06-30
2025Under threshold $175K $1.0M2026-06-30
2024Undetermined $0 $750K2025-06-30
2023Under threshold $745K $750K2024-06-302023-09-GSAFAC-0000026068 ↗
2022Undetermined $0 $750K2023-06-302022-09-CENSUS-0000172891 ↗
Obligation
$31K
Outlay
$175K
Subaward recv
$0
Subaward passed
$0
Loan face value
$0
Awards
1
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $31K$175K$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 = 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 OF FORT WORTH 2023-09-GSAFAC-0000026068 ↗
Standing link — declared from fac, observed FY2022–FY2023. 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
CITY OF FORT WORTH ENS6MKS1ZL18
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 = 'ENS6MKS1ZL18'      -- this entity's parent
  AND related_uei <> 'F7RMBTZ8D1D5';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
FORT WORTH, CITY OF
FXG4SWSNZKT9
Overdue2$13.0M
CITY OF FORT WORTH
K2CDYZPHGMA9
Overdue1$4.0M
CITY OF FORT WORTH
U79EKD6DXHC6
Under threshold$289K
D782K1HG55C7
D782K1HG55C7