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

BAY MILLS INDIAN COMMUNITY

UEI N3CYAA8YYYQ8 · MI · local · FY 2025-01-01 → 2025-12-31
FY2025: Filed

Filed 4 years (FY2022–FY2025).

FY2025 reconciliation conflict. Our observed money and the FAC filing disagree about the threshold — contradicted -- FAC shows over threshold. The audit reports $1,668,004 of SEFA against $960K observed here (58% of SEFA), which usually means the filing covers more entities than this one.
Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold partial$207K $1.0M2027-09-30
2025Filed $960K $1.0M2026-09-30-113$1.7M58% 2025-12-GSAFAC-0000420514 ↗
2024Filed $2.0M $750Koutlays 49% + pass-through 51%2025-09-30-99$1.0M190% 2024-12-GSAFAC-0000373054 ↗
2023Filed $990K $750Koutlays 100%2024-09-30-61$1.1M86% 2023-12-GSAFAC-0000051455 ↗
2022Filed $842K $750Koutlays 100%2023-09-30-129$1.7M50% 2022-12-CENSUS-0000187374 ↗
Obligation
$1.0M
Outlay
$960K
Subaward recv
$0
Subaward passed
$0
Loan face value
$0
Awards
1
SEFA reported
$1.7M (obs. 58%)
FAC check
contradicted -- FAC shows over threshold
Audit type
single-audit
Accepted
2026-06-09
Auditor
Anderson, Tackman & Co., PLC
Cognizant agency
Oversight agency
14
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $1.0M$960K$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
FLDHUX86JE16 FLDHUX86JE16
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 = 'FLDHUX86JE16'      -- this entity's parent
  AND related_uei <> 'N3CYAA8YYYQ8';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
BAY MILLS INDIAN COMMUNITY
JYX5LABKGUV3
Not yet due$27.6M