Data Act An AC Perspective Amber Matthews amber

Data Act An A-C Perspective Amber Matthews amber. matthews@usda. gov 1

What is Data Act & Req? • “The Digital Accountability and Transparency Act of 2014, or DATA Act, requires the U. S. federal government to transform its spending information into open data”(datacoalition. org) • “On May 9, 2017, every agency in the federal executive branch began reporting spending data using the standardized data structure that Treasury and OMB had established. ” (datacoalition. org) • This data is published to usaspending 2

What is A-C Inbound? • Data that does not reside in FMMI is processed through the A-C inbound. Agencies send files to us with their file A, file B, and file C data. We use these files to produce the treasury files that will go to broker. • A : Appropriations • B : Object Class Program Activity • C : Awards Financial 3

Where does the data come from? USDA • Data from FMMI • RD and FSA send their A-C Files • USDA sends their SF 133 s FSSP – Non USDA Agencies • Agencies send A-C Files • Agencies send SF 133 s • All of their A-C data is received through the inbound 4

A-C File Layout • • • • FISCAL_YEAR • POSTING_PERIOD • SYSTEM_ID • BUSINESS_AREA • DEFC_CODE (CORRECTION_FLAG_INT) • ALLOCATION_TRANSFER_AGENCY_ID • AVAILABILITY_TYPE_CODE • BPOA • EPOA • MAIN_ACCOUNT_CODE • SUB_ACCOUNT_CODE BEA_CATEGORY AUTHORITY_TYPE_CODE PROGRAM_ACTIVITY_NAME PROGRAM_ACTIVITY_CODE OBJECT_CLASS BY_DIRECT_REIMBURSABLE_FUNDING _SOURCE PIID PARENT_AWARD_ID FAIN URI SGL_ACCOUNT AMOUNT 5

Covid-19 Updates Due to Covid 19, we have been asked to make urgent changes to the Data Act process. This includes accommodating DEFC codes for reporting emergency funds. Due to the urgency of this request, we have repurposed the correction late indicator field to serve as the input for DEFC code. 6

Key Fields • • • Fiscal_Year • Posting_Period • System_ID • Business_Area Allocation_Transfer_Agenc • y_ID Agency_ID • Availability_Type_Code • BPOA • EPOA • Main_Account_Code Sub_Account_Code Program_Activity_Code Object_Class", Direct_Reimbursable_Indi cator PIID Fain URI SGL_Account DEFC_Code 7

Common Problems – MT • BUSINESS_AREA • AGENCY_ID • MAIN_ACCOUNT_CODE • PROGRAM_ACTIVITY_NAME • PROGRAM_ACTIVITY_CODE 8

Additional Concerns With the addition of DEFC Code the requirements are now to have the default value Q in “DEFC” field or it will pick up as an error. • Error 9000: Blank DEFC code • Error 4080: Invalid DEFC Code 9

A-C Error Report 10

Afterwards • After A-C files and SF 133 s are processed, we then start the refresh. Once the refresh is completed, we send Error and Certification reports so agencies can look at their data and resubmit. 11

Resources https: //www. datacoalition. org/policyissues/government-spending/data-act/ 12