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.
Example tool call
This call uses example arguments supplied in the tool’s input schema.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"cfda": "93.224",
"limit": 10,
"state": "TX",
"material_weakness_only": true
},
"name": "fac_cross_table_screen"
}
}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. |