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 summarized. The file contents can be imported into Access or Excel using the | (pipe) 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.