Fac Cross Table Screen
fac_cross_table_screenScreen single audits across state, federal program (CFDA), and finding type / material weakness in ONE call — a join FAC's own live API cannot express (its PostgREST has no foreign key between /general, /federal_awards and /findings). Answers compound diligence questions like "material weaknesses in Texas under CFDA 93.224" or "questioned-cost findings on highway funding (20.205) over $1M". Every filter is optional; pass at least one to keep the result meaningful. Returns one row per matching (audit, award, finding) combination, ranked by award dollar amount.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cfda | No | Assistance Listing / CFDA number, e.g. "93.224" or a bare 2-digit agency prefix "93". Aliases: program_number, assistance_listing, program, cfda_number. | |
| limit | No | Rows to return, 1-100 (default 25). | |
| state | No | 2-letter auditee state code, e.g. "TX". | |
| offset | No | Rows to skip, for paging. | |
| audit_year | No | Restrict to one audit year. | |
| min_amount | No | Only award rows expending at least this many dollars. | |
| finding_type | No | Substring match on FAC's finding type_requirement code (e.g. "A" internal control, "B" allowable costs — FAC packs several letters into one field, so this matches loosely). | |
| federal_agency_prefix | No | Two-digit agency prefix on its own. Alias: prefix. | |
| material_weakness_only | No | Only findings flagged as a material weakness. | |
| federal_award_extension | No | Program extension on its own, e.g. "224". Alias: extension. |