CITY OF SHREVEPORT

UEI NJUKCVR2LWM8 · LA · local · FY 2022-01-01 → 2022-12-31

FY2022: Filed

Filed FY2022.

FY2022 reconciliation conflict. Our observed money and the FAC filing disagree about the threshold — contradicted -- FAC shows over threshold. The audit reports $47,406,025 of SEFA against $155K observed here (0.3% of SEFA), which usually means the filing covers more entities than this one.

Fiscal year:

FY	Status	Observed	Threshold	Composition	Due	Days late	SEFA expended	Obs. % of SEFA	Own report	Covering
2022	Filed	$155K	$750K	—	2023-09-30	-55	$47.4M	0.3%	2022-12-CENSUS-0000146784 ↗	—

Obligation: $0
Outlay: —
Subaward recv: $155K
Subaward passed: $0
Loan face value: $0
Awards: 0
SEFA reported: $47.4M (obs. 0.3%)

▲ pass-through money only

FAC check: contradicted -- FAC shows over threshold
Audit type: single-audit
Accepted: 2023-08-06
Auditor: CARR, RIGGS & INGRAM, LLC
Cognizant agency: —
Oversight agency: 20

Component	Obligation	Outlay	Subaward recv	Subaward passed	Loan face value
Non-HHS federal money	$0	—	$155K	$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 SHREVEPORT E4TMLTXS3WV9

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

Entity	Provably covers	Latest status	Yrs delinq.	Latest observed
SHREVEPORT REGIONAL AIRPORT LLCFFT43KLY3	—	Not yet due	3	$9.8M
CITY OF SHREVEPORT FIRE DEPARTMENT UQUDFJU5KYP7	—	Not yet due	—	$1.7M
CITY OF SHREVEPORT LLXGKN1875Y7	—	Under threshold	—	$398K
SWF2AJ5KEUL1 SWF2AJ5KEUL1	—	—	—	—