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

WAGNER COMMUNITY MEMORIAL HOSPITAL

UEI MNG1KMML14E7 · SD · non-profit · FY 2025-07-01 → 2026-06-30
FY2026: Under threshold

Filed 3 years (FY2022–FY2024).

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold $655K $1.0M2027-03-30
2024Filed $6K $750K2025-03-30-55$3.1M0.2% 2024-06-GSAFAC-0000353099 ↗
2023Filed $0 $750K2024-03-30-99$3.6M<0.1% 2023-06-GSAFAC-0000013422 ↗
2022Filed $258K $750K2023-03-30-71$3.4M7.5% 2022-06-CENSUS-0000192984 ↗
Obligation
$0
Outlay
$655K
Subaward recv
$0
Subaward passed
$0
Loan face value
$0
Awards
0
▲ pass-through money only
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $0$655K$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
AVERA HEALTH N3MLDJDPQAA3
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 = 'N3MLDJDPQAA3'      -- this entity's parent
  AND related_uei <> 'MNG1KMML14E7';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
AVERA MCKENNAN
LNGXAKMH8J26
Not yet due$9.1M
AVERA HOLY FAMILY
FDL6G1DRUB38
Not yet due$2.1M
SIOUX CENTER HEALTH
L75JNT582HD8
Under threshold$620K
AVERA QUEEN OF PEACE
N9CAKFVHXKW3
Under threshold$365K
AVERA ST. LUKE'S
QJFYL3HDDEG7
Under threshold$270K
ST. MICHAEL'S HOSPITAL, INC.
S2MLB3UE6ED3
Under threshold$258K
AVERA MARSHALL
HEKKHJAQMM98
Under threshold$66K
AVERA ST. MARY'S
K8VMR2XLNGY1
Under threshold$59K
M191LX7FMNB5
M191LX7FMNB5
L2K2X8MEBLU7
L2K2X8MEBLU7
NKLZEFSAWNJ1
NKLZEFSAWNJ1
Q3VKM3RPLJJ3
Q3VKM3RPLJJ3
J47QNNWULU18
J47QNNWULU18
JE1EFE44NQA6
JE1EFE44NQA6
LJEDPWYLTD45
LJEDPWYLTD45