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

CITY OF SAINT PAUL

UEI Q91BDNBC1VT7 · MN · state · FY 2025-01-01 → 2025-12-31
FY2025: Not yet due

Filed 2 years (FY2023–FY2024); overdue for FY2022 ($2.3M observed); FY2025 not yet due.

Fiscal year:
FYStatusObservedThresholdCompositionDueDays lateSEFA expendedObs. % of SEFAOwn reportCovering
2026Under threshold partial$196K $1.0M2027-09-30
2025Not yet due $2.2M $1.0Moutlays 64% + pass-through 36%2026-09-30
2024Filed $2.1M $750Koutlays 73% + pass-through 27%2025-09-30-54$8.6M24% 2024-12-GSAFAC-0000377035 ↗
2023Filed $1.7M $750Koutlays 89% + pass-through 11%2024-09-30-6$6.2M27% 2023-12-GSAFAC-0000055775 ↗
2022Overdue $2.3M $750Koutlays 83% + pass-through 17%2023-09-301041d past due
Obligation
$186K
Outlay
$1.4M
Subaward recv
$802K
Subaward passed
$60K
Loan face value
$0
Awards
8
FAC check
Audit type
Accepted
Auditor
Cognizant agency
Oversight agency
ComponentObligationOutlaySubaward recvSubaward passedLoan face value
Non-HHS federal money $186K$1.4M$802K$60K$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 SAINT PAUL NAWUYFNLSK35
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 = 'NAWUYFNLSK35'      -- this entity's parent
  AND related_uei <> 'Q91BDNBC1VT7';   -- everything else under it
EntityProvably coversLatest statusYrs delinq.Latest observed
CITY OF SAINT PAUL
SHQDV94JYMU4
Not yet due$45.2M
SAINT PAUL, CITY OF
M4F4L24BBWG5
Not yet due2$16.7M
CITY OF ST PAUL
KGJ7SH6BBK76
Under threshold1$493K
PORT AUTHORITY OF THE CITY OF SAINT PAUL
JQC2HTBJYGL6
Filed$0