About Award Data and Non-Award Data

Comments

7 comments

  • Official comment
    Avatar
    AmandaC - Treasury

    Hi Beichen - Thank you for your question.

    We do not have glossary definitions for "award data" or "non-award data".

    Award data has major object classes of 20, 30 and 40 while non-award data is covered in major object class 90. For object class details see:

    https://www.whitehouse.gov/wp-content/uploads/2018/06/s83.pdf#83.6

    We cannot troubleshoot and issues without more details of where you are getting your expected vs. actual numbers.

    Some thing to consider:

    • the date ranges for available data can differ between Spending Explorer and Customer Account Data
    • DOD has a 90-day delay in reporting some of their data
      = for more details see https://www.usaspending.gov/about

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

    Comment actions Permalink
  • Avatar
    Beichen

    Thanks for your answer. I compare the sum of the “transaction obligated amount”  within RDT&E, Army, RDT&E, Navy, RDT&E, Air force and RDT&E, Defense Wide of DOD using "Custom Account Data",  with the sum of the "obligations incurred" within the same four federal accounts unsing "PA&OC" , and the result is about 30%, so I want to know the reason.

    0
    Comment actions Permalink
  • Avatar
    AmandaC - Treasury

    Hi Beichen,

    Thanks. We still need more information.

    Could you post a screen shot of your selected options from the bottom of the Custom Account Data page for your download(s)?

    You can also email us the screen shot(s) at usaspending.help@fiscal.treasury.gov

    Thanks!

    0
    Comment actions Permalink
  • Avatar
    Beichen

    Sorry for getting back to you late. Figure 1~4 show what I have downloaded. I compared the the amount of the "obligations_incurred"  under "Account Breakdown by Program Activity & Object Class" and  the amount of the “transaction_obligated _amount” under "Account Breakdown by Award"  for each Federal Account selected. The amount of “transaction_obligated _amount” is much smaller than "obligations_incurred". The result is different from other agencies like NSF, DOE, NIH and NASA, which have a cloesr amount between “transaction_obligated _amount” and "obligations_incurred".

    0
    Comment actions Permalink
  • Avatar
    AmandaC - Treasury

    Hi Beichen - Thank you for the additional information.

    What you're seeing are values from different systems for different time periods.

    The data in the Account Breakdown by Program Activity & Object Class file comes from the agency financial systems and is cumulative fiscal year to date - in this case all of FY 2019.

    The data in the Account Breakdown by Award file comes from the agency award systems and is just transactions for July, August, and September 2019. 

    We expect the transaction_obligated_amount in Account Breakdown by Award to be less than or equal to the obligations_incurred in the Account Breakdown by Program Activity & Object Class.

    Most likely DOD has transaction_obligated_amounts in other quarters earlier in the year.

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

    0
    Comment actions Permalink
  • Avatar
    Beichen

    Hello Amanda,

    Thanks for your answer. Just as you said (Did I have a correct understanding?), I re-downloaded the Account Break`down by Award file of “Research, Development, Test, and Evaluation, Army” in FY2019 (Figure 1~4). However, when I compared the number of the data under “submission_period”, I found that the file downloaded by Figure 4 had contained the transactions data for other three quarters (Figure 5~8, and Figure 5 is the counting result to Figure 1, Figure 6 to Figure 2, and so on).

    In addition, I had also compared other federal accounts of other agency (DOE、HHS、NASA、NSF)before, and I found that the amount of the transaction_obligated_amount in Account Breakdown by Award is close to the amount of the obligations_incurred in the Account Breakdown by Program Activity & Object Class when I used the same download method shown in the previous post. So it seems that there are other special reasons that cause statistical result above of DOD.

    Looking forward to your reply.

    0
    Comment actions Permalink
  • Avatar
    AmandaC - Treasury

    Hi Beichen  - Thank you for your question.

    We made an error -  you are correct.  Account Breakdown by Award file is cumulative for the year to date. 

    We cannot tell specifically why the difference between DOD's Account Breakdown by Program Activity & Object Class and Account Breakdown by Award is larger than other agencies. Some ideas as to why this may occur include unlinked awards, per the note on the Custom Account Data page or awards that may not be available to the public due to security concerns. 

    This may be a question to ask DOD directly through a FOIA request.

    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