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

JEFFERSON COUNTY SHERIFF

UEI JN62PX2K3TN7 · KY · 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 $1,433,568 of SEFA against $171K observed here (12% of SEFA), which usually means the filing covers more entities than this one.
Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2022Filed $171K $750K2023-09-30304$1.4M12% 2022-12-GSAFAC-0000050101 ↗
Obligation
$0
Outlay
Subaward recv
$171K
Subaward passed
$0
Loan face value
$0
Awards
0
SEFA reported
$1.4M (obs. 12%)
▲ pass-through money only
FAC check
contradicted -- FAC shows over threshold
Audit type
single-audit
Accepted
2024-07-30
Auditor
Allison Ball, Auditor of Public Accounts
Cognizant agency
Oversight agency
21
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $0$171K$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 = 'NQBCBM4WVMP8'      -- this entity's parent
  AND related_uei <> 'JN62PX2K3TN7';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
LOUISVILLE-JEFFERSON COUNTY METRO GOVERNMENT
XTABXRBBAUB1
Not yet due$58.1M
LOUISVILLE-JEFFERSON COUNTY METRO
G8ZKJYAEAWT8
Under threshold$10K
FJMCV5J6C3J8
FJMCV5J6C3J8
GMN2RDHK15H1
GMN2RDHK15H1
CF6PV9NFH6P2
CF6PV9NFH6P2
MFALSKNHP3D6
MFALSKNHP3D6
MNYMY8NCNTK3
MNYMY8NCNTK3
MUVVM2JGF9U4
MUVVM2JGF9U4
NSHKQ4LEWKT9
NSHKQ4LEWKT9
LDBGCMQ1JLE5
LDBGCMQ1JLE5
DRU8VG7LKR48
DRU8VG7LKR48