Agency Loop Audit

This report audits the ten parallel research loops after the schema-correction pass. It checks for known hallucinated views, suspect table or column references, placeholder examples, executable status lines, SQL blocks, and correction-log completion.

This is a lexical audit over the briefs, not a proof that every SQL block has executed. A brief is presentation-safe only when bad references are zero and the claim language matches its executable status.

Loops10
Clean10
Needs Review0
Unsafe0

Summary Table

LoopStatusWordsSQLKnown BadSuspect RefsPlaceholdersGapsSHA
01-zombie-recipients RUNNABLE_WITH_EXTRA_MATERIALIZATION 2122 1 0 0 0 9 daf814d1a098
02-ghost-capacity RUNNABLE_NOW 1317 1 0 0 0 7 8bad5151c8e5
03-funding-loops RUNNABLE_NOW 2280 1 0 0 0 12 d5af2bd594c8
04-sole-source-amendment RUNNABLE_WITH_EXTRA_MATERIALIZATION 1080 1 0 0 0 9 ac034581981f
05-vendor-concentration RUNNABLE_NOW 2327 1 0 0 0 15 0ae7ec50f984
06-related-parties RUNNABLE_WITH_EXTRA_MATERIALIZATION 1765 1 0 0 0 6 5214dd290eae
07-policy-misalignment NEEDS_EXTERNAL_DATA 1868 1 0 0 0 14 0c179d78fa8c
08-duplicative-funding NEEDS_EXTERNAL_DATA 1754 1 0 0 0 12 ccc7667863c5
09-contract-intelligence RUNNABLE_WITH_EXTRA_MATERIALIZATION 2059 1 0 0 0 7 1072da8bd791
10-adverse-media NEEDS_EXTERNAL_DATA 2493 2 0 0 0 5 292773cea7cb

Audit Trail Details

01-zombie-recipients

Status: RUNNABLE_WITH_EXTRA_MATERIALIZATION

Presentation sentence: We identified non-profits that received significant public funding despite deriving over 70% of their revenue from government and having ceased filing CRA returns, flagging them as stale-filing zombie recipients requiring further legal dissolution verification.

Correction log: === correction end rc=0 2026-04-29T13:37:04Z ===

Brief SHA-256: daf814d1a0983fc6d7064cafd90ebff36b1efbfb859b0d86eb05156e9e75c9be

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_contracts.recipient
  • ab.ab_grants
  • ab.ab_grants.recipient
  • ab.ab_sole_source.vendor
  • cra.cra_financial_details.bn
  • cra.cra_identification
  • cra.cra_identification.bn
  • cra.govt_funding_by_charity
  • cra.govt_funding_by_charity.bn
  • cra.govt_funding_by_charity.govt_share_of_rev
  • fed.grants_contributions
  • fed.grants_contributions.agreement_start_date
  • general.entity_golden_records
  • general.entity_golden_records.aliases
  • general.entity_golden_records.bn_root
  • general.entity_source_links.source_pk
  • general.vw_entity_funding
  • general.vw_entity_funding.entity_id

Placeholder Signals

None.

02-ghost-capacity

Status: RUNNABLE_NOW

Presentation sentence: We identified persistent, government-dependent charities exhibiting thin delivery-capacity signals—high compensation-to-program-spend ratios and negligible physical assets—flagging them as capacity-accounting anomalies requiring further review.

Correction log: === correction end rc=0 2026-04-29T13:36:21Z ===

Brief SHA-256: 8bad5151c8e52a00c2056e867639ed0936e541e42b87a0428c709ddc7c49a5ed

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • cra.cra_compensation
  • cra.cra_compensation.field_300
  • cra.cra_financial_details
  • cra.cra_financial_details.field_4540
  • cra.cra_identification
  • cra.cra_identification.address_line_1
  • cra.cra_identification.bn
  • cra.cra_identification.category
  • cra.cra_identification.designation
  • cra.cra_identification.sub_category
  • cra.govt_funding_by_charity
  • cra.govt_funding_by_charity.fiscal_year
  • cra.govt_funding_by_charity.govt_share_of_rev
  • cra.overhead_by_charity
  • cra.overhead_by_charity.broad_overhead_pct
  • cra.overhead_by_charity.compensation
  • cra.overhead_by_charity.programs
  • general.vw_entity_funding
  • general.vw_entity_funding.ab_total_grants
  • general.vw_entity_funding.bn_root
  • general.vw_entity_funding.entity_id
  • general.vw_entity_funding.fed_total_grants
  • general.vw_entity_funding.total_all_funding

Placeholder Signals

None.

03-funding-loops

Status: RUNNABLE_NOW

Presentation sentence: GovAlta's precomputed loop detection identifies thousands of circular funding paths; by filtering out known federated charities and hubs, we isolate the small subset of loops where high circular volume and overhead suggest potential revenue inflation or round-tripping.

Correction log: === correction end rc=0 2026-04-29T13:37:58Z ===

Brief SHA-256: d5af2bd594c89f1568d717db69912ea36106f1eace300aa1c4818f4e683fcaf7

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • cra.cra_directors
  • cra.cra_identification.designation
  • cra.cra_identification.legal_name
  • cra.cra_qualified_donees
  • cra.cra_qualified_donees.donee_bn
  • cra.cra_qualified_donees.fpe
  • cra.cra_qualified_donees.total_gifts
  • cra.identified_hubs
  • cra.johnson_cycles
  • cra.loop_edges
  • cra.loop_financials
  • cra.loop_participants
  • cra.loop_universe
  • cra.loop_universe.score
  • cra.matrix_census
  • cra.overhead_by_charity
  • cra.overhead_by_charity.broad_overhead_pct
  • cra.overhead_by_charity.programs
  • cra.overhead_by_charity.total_expenditures
  • cra.partitioned_cycles
  • cra.scc_components
  • cra.scc_summary
  • general.entity_golden_records
  • general.entity_golden_records.aliases
  • general.entity_golden_records.bn_root
  • general.entity_golden_records.dataset_sources
  • general.vw_entity_funding
  • general.vw_entity_funding.cra_program_spending
  • general.vw_entity_funding.cra_total_revenue

Placeholder Signals

None.

04-sole-source-amendment

Status: RUNNABLE_WITH_EXTRA_MATERIALIZATION

Presentation sentence: We can identify contracts that grew over five-fold from their original value through amendments, and vendors who won competitive contracts only to receive ongoing sole-source follow-ons, by computing original versus current values directly from the grants table and joining Alberta contracts to sole-source awards.

Correction log: === correction end rc=0 2026-04-29T13:36:53Z ===

Brief SHA-256: ac034581981f475975b582f6c984139e70519f72e5564c419ba6d3b6f50ee0f1

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_contracts
  • ab.ab_contracts.recipient
  • ab.ab_sole_source
  • ab.ab_sole_source.vendor
  • fed.grants_contributions
  • fed.grants_contributions.agreement_value
  • fed.grants_contributions.is_amendment
  • fed.grants_contributions.ref_number
  • general.entity_golden_records
  • general.entity_golden_records.bn_root

Placeholder Signals

None.

05-vendor-concentration

Status: RUNNABLE_NOW

Presentation sentence: High vendor concentration, measured by HHI, can be screened across federal and Alberta spending using existing data, though distinguishing natural monopolies from drifted incumbency requires external statutory and regulatory context.

Correction log: === correction end rc=0 2026-04-29T13:36:19Z ===

Brief SHA-256: 0ae7ec50f984ffbcbbd4ee2f00e918481cc52b7ec43d0412ba5714420e020383

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_contracts
  • ab.ab_sole_source
  • fed.grants_contributions
  • fed.grants_contributions.ref_number
  • general.entity_golden_records
  • general.entity_golden_records.bn_root
  • general.entity_golden_records.cra_profile
  • general.entity_golden_records.id
  • general.entity_source_links

Placeholder Signals

None.

06-related-parties

Status: RUNNABLE_WITH_EXTRA_MATERIALIZATION

Presentation sentence: Name-only director overlaps between charities that fund each other are review leads requiring identity validation, not confirmed control.

Correction log: === correction end rc=0 2026-04-29T13:38:59Z ===

Brief SHA-256: 5214dd290eaed1f8b69d8c0b379f9db411c4cc0a4fe04987ea039a158c2066c8

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_grants
  • ab.ab_grants.amount
  • ab.ab_grants.fiscal_year
  • ab.ab_grants.recipient
  • ab.ab_sole_source.vendor
  • cra.cra_directors
  • cra.cra_directors.at_arms_length
  • cra.cra_directors.bn
  • cra.cra_directors.end_date
  • cra.cra_directors.first_name
  • cra.cra_directors.last_name
  • cra.cra_directors.position
  • cra.cra_directors.start_date
  • fed.grants_contributions
  • fed.grants_contributions.agreement_end_date
  • fed.grants_contributions.agreement_start_date
  • fed.grants_contributions.agreement_value
  • fed.grants_contributions.recipient_business_number
  • fed.grants_contributions.recipient_legal_name
  • fed.grants_contributions.ref_number
  • general.entity_golden_records
  • general.entity_golden_records.aliases
  • general.entity_golden_records.bn_root
  • general.entity_golden_records.bn_variants
  • general.entity_golden_records.canonical_name
  • general.entity_golden_records.id
  • general.vw_entity_funding
  • general.vw_entity_funding.ab_total_grants
  • general.vw_entity_funding.canonical_name
  • general.vw_entity_funding.entity_id

Placeholder Signals

None.

07-policy-misalignment

Status: NEEDS_EXTERNAL_DATA

Presentation sentence: While federal spending data allows us to trace broadband funding flows, proving policy misalignment requires external policy commitment texts that are not present in the current schema.

Correction log: === correction end rc=0 2026-04-29T13:36:23Z ===

Brief SHA-256: 0c179d78fa8c00fb03ab1cbdb84b46b1ed8b7c689cef2660ab260860a03c49be

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • fed.grants_contributions
  • fed.grants_contributions.agreement_start_date
  • fed.grants_contributions.agreement_value
  • fed.grants_contributions.owner_org_title
  • fed.grants_contributions.prog_name_en
  • fed.grants_contributions.recipient_business_number
  • general.entity_golden_records
  • general.entity_golden_records.bn_root
  • general.entity_source_links

Placeholder Signals

None.

08-duplicative-funding

Status: NEEDS_EXTERNAL_DATA

Presentation sentence: Organizations receiving uncoordinated funds from multiple government levels for the same purpose represent overlap waste, while priority areas with zero funding across all levels represent systemic failure.

Correction log: === correction end rc=0 2026-04-29T13:36:33Z ===

Brief SHA-256: ccc7667863c569eeb953916bffd65d333aea7de72ca4ce27d7cb19c8e7f201d6

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_grants
  • ab.ab_grants.ministry
  • ab.ab_grants.payment_date
  • ab.ab_grants.program
  • ab.ab_grants.recipient
  • cra.cra_identification
  • cra.cra_identification.bn
  • cra.cra_qualified_donees
  • fed.grants_contributions
  • fed.grants_contributions.agreement_number
  • fed.grants_contributions.agreement_start_date
  • fed.grants_contributions.prog_name_en
  • fed.grants_contributions.ref_number
  • general.entity_golden_records
  • general.entity_golden_records.id
  • general.entity_source_links
  • general.entity_source_links.entity_id
  • general.entity_source_links.source_pk
  • general.vw_entity_funding
  • general.vw_entity_funding.entity_id

Placeholder Signals

None.

09-contract-intelligence

Status: RUNNABLE_WITH_EXTRA_MATERIALIZATION

Presentation sentence: Federal professional services and IT programs show rising vendor concentration and spend growth, but without external PPI deflators and unit-deliverable counts, we cannot distinguish true unit-cost overpayment from inflation and volume scale-ups.

Correction log: === correction end rc=0 2026-04-29T13:37:16Z ===

Brief SHA-256: 1072da8bd7914fd660e0d29d70755e7f046f131f5676013f6056f47615658d09

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_contracts
  • ab.ab_contracts.amount
  • ab.ab_contracts.display_fiscal_year
  • ab.ab_contracts.recipient
  • ab.ab_grants
  • ab.ab_grants.amount
  • ab.ab_grants.display_fiscal_year
  • ab.ab_grants.ministry
  • ab.ab_grants.program
  • ab.ab_sole_source
  • ab.ab_sole_source.amount
  • ab.ab_sole_source.contract_services
  • ab.ab_sole_source.display_fiscal_year
  • ab.ab_sole_source.ministry
  • ab.ab_sole_source.start_date
  • ab.ab_sole_source.vendor
  • cra.cra_identification
  • fed.grants_contributions
  • fed.grants_contributions.agreement_start_date
  • fed.grants_contributions.agreement_value
  • fed.grants_contributions.owner_org_title
  • fed.grants_contributions.prog_name_en
  • fed.grants_contributions.recipient_business_number
  • fed.grants_contributions.recipient_legal_name
  • general.entity_golden_records
  • general.entity_golden_records.aliases
  • general.entity_golden_records.bn_root
  • general.entity_golden_records.dataset_sources
  • general.entity_source_links

Placeholder Signals

None.

10-adverse-media

Status: NEEDS_EXTERNAL_DATA

Presentation sentence: We can match funded entities against authoritative regulatory and court actions, but the adverse media data itself requires external ingestion and cannot be derived from the current internal datasets alone.

Correction log: === correction end rc=0 2026-04-29T13:38:21Z ===

Brief SHA-256: 292773cea7cb98fad35c5381b334ae4b38b455bf76e40c91caa5f8a12a400d94

Known Bad References

None.

Suspect Schema References

None.

Verified References

  • ab.ab_grants
  • ab.ab_grants.amount
  • ab.ab_grants.fiscal_year
  • ab.ab_grants.recipient
  • cra.cra_identification.bn
  • cra.cra_identification.legal_name
  • fed.grants_contributions
  • fed.grants_contributions.agreement_value
  • fed.grants_contributions.recipient_business_number
  • fed.grants_contributions.recipient_legal_name
  • fed.grants_contributions.ref_number
  • general.entity_golden_records
  • general.entity_golden_records.aliases
  • general.entity_golden_records.bn_root
  • general.entity_golden_records.canonical_name
  • general.entity_golden_records.id
  • general.entity_source_links
  • general.entity_source_links.entity_id
  • general.entity_source_links.source_pk
  • general.entity_source_links.source_table

Placeholder Signals

None.