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

MESCALERO APACHE TRIBE

UEI KUPBFZQBMQ53 · NM · tribal · FY 2024-10-01 → 2025-09-30
FY2025: Overdue

overdue for FY2022, FY2023, FY2024, FY2025 ($84.4M observed); FY2026 not yet due.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Not yet due partial$21.1M $1.0Moutlays 100%2027-06-30
2025Overdue $36.2M $1.0Moutlays 100% + pass-through 0%2026-06-3037d past due
2024Overdue $10.0M $750Koutlays 100%2025-06-30402d past due
2023Overdue $23.9M $750Koutlays 100% + pass-through 0%2024-06-30767d past due
2022Overdue $14.3M $750Koutlays 100% + pass-through 0%2023-06-301133d past due
Obligation
$23.3M
Outlay
$36.2M
Subaward recv
$32K
Subaward passed
$0
Loan face value
$0
Awards
66
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Administration for Children and Families HHS$2.8M$1.9M$0$0$0
Indian Health Service HHS$2.6M$2.2M$0$0$0
Administration for Community Living HHS$227K$39K$0$0$0
Substance Abuse and Mental Health Services Administration HHS$-182K$74K$0$0$0
Non-HHS federal money $17.9M$32.0M$32K$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 = 'MQYNJ93PJ7N6'      -- this entity's parent
  AND related_uei <> 'KUPBFZQBMQ53';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
MESCALERO APACHE TRIBE
NKCTUC8N3CG9
Under threshold$75
MB5BKN8J2KC6
MB5BKN8J2KC6