18F / FAC-Distiller

Federal Audit Clearing House Distiller
2 stars 4 forks source link

CFDA prefixes correlated with subagencies #14

Open bpdesigns opened 4 years ago

bpdesigns commented 4 years ago

Determine the source of CFDA #s that agencies use to identify data

Originally posted by @fureigh in https://github.com/18F/federal-grant-reporting/issues/147#issuecomment-519665740

Update: I learned that CFDA prefixes are not reliably correlated with subagencies. Each agency assigns them differently.

This means the "minimally" above is the way to go. We'll have to provide a way for users to enter CFDA numbers. Goodbye, single-step dropdown menu.

bpdesigns commented 4 years ago

@bpdesigns is investigating this with DoT/FTA partner.

bpdesigns commented 4 years ago

Here is the link to current CFDA#s in a CSV from 3 different data sources. I think they have all the same info so not sure why there are 3 versions.

I'm having a meeting with DOT/FTA tomorrow to confirm process. It seems like they search for all audits for their parent agency DOT and then go through each one to find the ones related to FTA.