Fac

What Fac does

Fac provides MCP access to public US Federal Audit Clearinghouse records collected under 2 CFR 200 Subpart F. The dataset covers organizations receiving federal funds, their audit filings, Assistance Listing programs, amounts expended, auditor information, and findings recorded by FAC.

Queries can locate audits by auditee name, UEI, EIN, state, ZIP prefix, audit year, or federal spending amount. A report lookup returns program rows from the Schedule of Expenditures of Federal Awards, including program identifiers, names, expenditures, major-program status, and opinion type. Recipient history queries organize audits by year and include total federal awards expended and a percentage-change trend.

How it works

Rather than calling the FAC API for each request, Fac reads a local database populated from FAC's public bulk CSV extracts. A scheduled process refreshes the data weekly using the general, federal_awards, findings, findings_text, and corrective_action_plans tables. The response metadata includes data_as_of, which identifies the last successful refresh.

The local structure supports queries that are difficult or unavailable through the live API. Full-text finding searches use a PostgreSQL text-search function over an indexed text column. Cross-table screening joins general audit records, federal award rows, and findings so callers can combine filters such as state, Assistance Listing number, finding type, material weakness status, amount, and audit year.

Tools and capabilities

The MCP tool surface includes:

• include_text for attaching narrative finding text to applicable results.
• websearch_to_tsquery for PostgreSQL web-style text query parsing.
• fac_findings_search for searching finding narratives, including phrases about submission deadlines or questioned costs.
• fac_cross_table_screen for screening audits across recipient location, federal program, and finding attributes.
• fac_general for general audit and recipient records.
• fac_federal_awards for federal award and program expenditure data.
• fac_findings for findings associated with audits.

Friendly aliases support common inputs such as query, q, or name for auditee names, and several ZIP field names. Assistance Listing values can use dotted, dashed, undelimited, or agency-prefix forms. Unsupported arguments are returned in ignored_arguments with a warning instead of being silently discarded.

Limitations and notes

The copy excludes named individual contact fields, email addresses, and phone numbers. Organizational details such as auditee names, auditor firms, addresses, and EINs remain available. Results can be affected by the weekly refresh schedule and by the historical values recorded in FAC.

ZIP filtering uses a five-digit prefix because FAC stores some ZIP values as five digits and others as ZIP+4 without a separator. An entity's ZIP may also differ between filing years. If a ZIP filter removes an otherwise matching entity, the response can identify the ZIP values FAC holds for that entity.

The loaded tables do not include notes_to_sefa, passthrough, additional_ueis, additional_eins, or secondary_auditors. Before the first successful refresh, data_as_of is null and the response reports the coverage status rather than presenting an empty result as proof that no audits exist.