PIMA COUNTY JUVENILE COURT
overdue for FY2023 ($767K observed); 1 year undetermined.
| FY | Status | Observed | Threshold | Composition | Due | Days late | SEFA expended | Obs. % of SEFA | Own report | Covering |
|---|---|---|---|---|---|---|---|---|---|---|
| 2027 | Undetermined partial | $0 | $1.0M | — | 2028-03-30 | — | — | — | — | — |
| 2026 | Under threshold | $731K | $1.0M | — | 2027-03-30 | — | — | — | — | — |
| 2025 | Under threshold | $746K | $750K | — | 2026-03-30 | — | — | — | — | — |
| 2024 | Under threshold | $569K | $750K | — | 2025-03-30 | — | — | — | — | — |
| 2023 | Overdue | $767K ▲ | $750K | outlays 53% + pass-through 47% | 2024-03-30 | 859d past due | — | — | — | — |
| 2022 | Under threshold | $678K | $750K | — | 2023-03-30 | — | — | — | — | — |
- Obligation
- $400K
- Outlay
- $411K
- Subaward recv
- $320K
- Subaward passed
- $0
- Loan face value
- $0
- Awards
- 1
- FAC check
- —
- Audit type
- —
- Accepted
- —
- Auditor
- —
- Cognizant agency
- —
- Oversight agency
- —
| Component | Obligation | Outlay | Subaward recv | Subaward passed | Loan face value |
|---|---|---|---|---|---|
| Substance Abuse and Mental Health Services Administration HHS | $400K | $411K | $0 | $0 | $0 |
| Non-HHS federal money | $0 | — | $320K | $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_parentFrom 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.
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 = 'JBMBVGUK5LF1' -- this entity's parent AND related_uei <> 'HE3EBN5MNKV8'; -- everything else under it
| Entity | Provably covers | Latest status | Yrs delinq. | Latest observed |
|---|---|---|---|---|
| PIMA COUNTY COMMUNITY SERVICES EB6GYYJCZD48 | — | Not yet due | 4 | $22.4M |
| PIMA COUNTY U8XUY58VDQS3 | — | Not yet due | 4 | $10.6M |
| PIMA COUNTY SCHOOL SUPERINTENDENT'S OFFICE F4A1E2SDLJR5 | — | Not yet due | 4 | $10.3M |
| PIMA COUNTY FVS1C9XG5748 | — | Not yet due | 4 | $2.6M |
| PIMA COUNTY SHERIFFS DEPARTMENT MK6RG7THHM85 | — | Not yet due | 4 | $1.2M |
| PIMA COUNTY WHN2YANV9W95 | — | Under threshold | 3 | $954K |
| PIMA COUNTY ENVIRONMENTAL DEPARTMENT H3ZQE475FKE9 | — | Under threshold | — | $622K |
| SANTA RITA FIRE DISTRICT D9D8ATBJN7Z3 | — | Under threshold | — | $345K |
| ARIZONA SUPERIOR COURT PIMA DRKHHJ35SXM7 | — | Undetermined | 2 | $144K |
| PIMA COUNTY TAJ3G9H2LQZ2 | — | Under threshold | — | $40K |
| PIMA COUNTY D593JYZZRK25 | — | Under threshold | — | $32K |
| XTGMEA18W455 XTGMEA18W455 | — | — | — | — |
| GT9SL7B4PJA2 GT9SL7B4PJA2 | — | — | — | — |
| J57ZFHNWDJU5 J57ZFHNWDJU5 | — | — | — | — |
| KG4WKZR1M7A4 KG4WKZR1M7A4 | — | — | — | — |
| RX3QPL1YPS13 RX3QPL1YPS13 | — | — | — | — |
| C17DJRK79Y43 C17DJRK79Y43 | — | — | — | — |