AFRI (CFDA 10.310) Inquiry

Comments

8 comments

  • Official comment
    Avatar
    AmandaC - Treasury

    Hi Eugenio - Thank you for your question.

    1. We don't have a shareable file of DUNS and IPEDS/NCSES data.

    Publicly available IPEDS data can be found here:

    https://nces.ed.gov/ipeds/use-the-data

    2. AFRI funds fall under the CFDA: 10.310 and are USDA awards.

    You can search for AFRI awards under USDA in an Advanced Search with the CFDA filter.

    3. The best way to determine the amount of AFRI monies an institution received is by totaling the column "federal_action_obligation".

    Please let us know if you have any other questions or concerns.

    Comment actions Permalink
  • Avatar
    Eugenio Hernandez

    AmandaC,

    Thank you for your reply!

    If an institution has negative values for "federal_action_obligation", does that mean they had to return the unspent funding?

    Lastly, is there a data dictionary for "award_id_fain"? I'm guessing the first 4-digits are year, but I'm not sure about the next 10-digits. Same for the trailing number after the period (e.g. YYYY1234567890.X). This is for me to know if I should split funding across years.

    Thank you!

    0
    Comment actions Permalink
  • Avatar
    AmandaC - Treasury

    Hi Eugenio - Thank you for your question.

    Negative values for "federal_action_obligation" are for de-obligations.

    There is a data dictionary for "FAIN", it can be found by going to USAspending.gov and selecting "Data Dictionary" which is under the Resources tab. Unfortunately, a standardized format has not been adopted by all agencies.

    Please let us know if you have any other questions or concerns.

    0
    Comment actions Permalink
  • Avatar
    Eugenio Hernandez

    Amanda,

    One more question, for the column "disaster_emergency_fund_codes_for_overall_award" when it says "Q: Excluded from tracking (uses non-emergency/non-disaster designated appropriations)", should I omit the amount on the columns "federal_action_obligation" (regardless if it's a positive/negative dollar amount)?

    Thank you!

    0
    Comment actions Permalink
  • Avatar
    Eugenio Hernandez

    Amanda,

    I have an example where the same FAIN has 4 different rows and I don't know how to interpret them. Would it be correct to assume that the corresponding FAIN (print screen) corresponds to one award of $4M? or, would it be 4 awards of $4M each (for a total award of $16M) and one de-obligation at the end?

    Thank you for your help!

    Eugenio

    0
    Comment actions Permalink
  • Avatar
    AmandaC - Treasury

    Hi Eugenio - Thank you for your questions.

    The Disaster Emergency Fund Code (DEFC) is a field used to track the spending of funding for disasters and emergencies such as COVID-19.

    DEFC = Q means the funding is not disaster or emergency related. Think of it as ordinary funding.

    We recommend not omitting the amount on the columns for "federal_action_obligation" even when it has the value "Q" for the column "disaster_emergency_fund_codes_for_overall_award", unless you are looking only at disaster or emergency funding.

    In regards to the image you posted about FAIN 20116800230185.

    The image actually includes five different awards with similar but different FAINs of:
    20116800230185.1
    20116800230185.2
    20116800230185.3
    20116800230185.4
    20116800230185

    These may appear as the same FAIN the award_id_fain cells due to Excel formatting.

    Technically, these are four awards of $4,000,000 each and one award with a de-obligation. You would have to contact USDA to ask them whether this award was submitted to USAspending correctly.

    Please let us know if you have any other questions or concerns.

    0
    Comment actions Permalink
  • Avatar
    Eugenio Hernandez

    Amanda,

    Thank you for you patience and responses.

    I identified those FAIN ids as different awards. For the purpose of my research I ended up relying on the 'total_obligated_amount' to figure out the gross amount of the 'original' award. This approach works pretty well for most FAIN ids given that 'total_obligated_amount' may include any de-obligation registered in the 'federal_action_obligation'. Of course one of the few exceptions happened to be that FAIN I mentioned in a previous post (20116800230185). For example:

    I do wonder, how are these awards disbursed to the main recipient institutions? Maybe a lump sum at the 'period_of_performance_start_date'? or, maybe periodically between the 'start_date' and the 'end_date'?

    Again, thank you for your assistance!

    Eugenio

    0
    Comment actions Permalink
  • Avatar
    AmandaC - Treasury

    Hi Eugenio - Thank you for your question.

    The amounts distributed, known as outlays, have only been reported since April 2020 and required only for COVID-19 related awards.

    The outlay data is not part of many awards on USAspending.gov. All awards issued in Fiscal Year (FY) 2022 onwards are required to have outlays reported.

    Please let us know if you have any other questions or concerns.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk