fedspendingtransparency/usaspending-api

usaspending_api/etl/management/sql/c_file_linkage/check_assistance_file_c_linkages.sql

Summary

Maintainability

Test Coverage

Issues

-- Get the count of all unlinked File C assistance records
SELECT
    COUNT(*)
FROM
    financial_accounts_by_awards
WHERE
    piid IS NULL  -- if piid is null, then fain or uri is populated per DAIMS
    AND award_id IS NULL
;