fedspendingtransparency/usaspending-api

usaspending_api/etl/management/sql/c_file_linkage/check_contract_file_c_linkages.sql

Summary

Maintainability

Test Coverage

Issues

-- Get the count of all unlinked File C contract records
SELECT
    COUNT(*)
FROM
    financial_accounts_by_awards
WHERE
    piid IS NOT NULL
    AND award_id IS NULL
;