CITY OF HAVERHILL TREASURER-COLLECTOR

UEI FH6MXBRJMRD7 · MA · government · FY 2022-01-01 → 2022-12-31

FY2022: Overdue

overdue for FY2022 ($11.4M observed).

Fiscal year:

FY	Status	Observed	Threshold	Composition	Due	Days late	SEFA expended	Obs. % of SEFA	Own report	Covering
2022	Overdue	$11.4M ▲	$750K	pass-through 100%	2023-09-30	1041d past due	—	—	—	—

Obligation: $0
Outlay: —
Subaward recv: $11.4M
Subaward passed: $0
Loan face value: $0
Awards: 0

▲ pass-through money only

FAC check: —
Audit type: —
Accepted: —
Auditor: —
Cognizant agency: —
Oversight agency: —

Component	Obligation	Outlay	Subaward recv	Subaward passed	Loan face value
Non-HHS federal money	$0	—	$11.4M	$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 HAVERHILL CSHMGK8KWBX4

↓ 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 = 'CSHMGK8KWBX4'      -- this entity's parent
  AND related_uei <> 'FH6MXBRJMRD7';   -- everything else under it

Entity	Provably covers	Latest status	Yrs delinq.	Latest observed
HAVERHILL, CITY OF HHGQZJ98QQ44	—	Not yet due	1	$1.3M
CITY OF HAVERHILL GBLEKH5LRLB8	—	Not yet due	4	$1.2M
HWVSBQZCMF75 HWVSBQZCMF75	—	—	—	—
TB1XMLJWAE51 TB1XMLJWAE51	—	—	—	—