Stimulus Revenue, Expenditure, and MBE/WBE Extracts
File names and layouts

The Stimulus Revenue, Expenditure, and MBE/WBE extracts are prepared using the same select criteria for data that is loaded to the Missouri Accountability Portal (MAP). They contain only records related to the American Recovery and Reinvestment Act (ARRA). Data is available in full detail or summed. The file contents can be imported into Access or Excel using the | character as the field delimiter. This character can be found directly under the backspace button on the keyboard.

Header files are provided as a convenience to those who want to import the data into Excel or Access. They contain the column headers using the same delimiter as the data file. If the browser opens the file instead of providing a 'Save As' prompt, perform a 'Save As' action after the contents have been displayed to store it as a text file on the hard drive before importing it into Excel or Access.

If you need any assistance, please call the SAM II Financial Technical Help desk at 522-1500 and choose option 1.

Excel/Access Header	File Name and Layout
Expenditure record detail	OAAMS.DWPROD.STIMEXT.ODW101S1
Expenditure amounts summarized by agency and program code	OAAMS.DWPROD.STIMEXT.ODW102S1
Expenditure records summarized by program code	OAAMS.DWPROD.STIMEXT.ODW103S1
Expenditure records summarized by program and vendor code	OAAMS.DWPROD.STIMEXT.ODW104S1
Expenditure records summarized by program and vendor employer identification (EIN)	OAAMS.DWPROD.STIMEXT.ODW105S1
Expenditure records for MWBE certified vendors summarized by vendor number, vendor name, MWBE type and program code	OAAMS.DWPROD.STIMEXT.ODW106S1
Revenue record detail	OAAMS.FNPROD.STIMEXT.OFN345S1
Revenue records summarized by program code	OAAMS.FNPROD.STIMEXT.OFN346S1
Revenue records summarized by agency and program code	OAAMS.FNPROD.STIMEXT.OFN347S1