BRS File Format (For AIRS ARUPLOAD)

Select A BRS Export file to Convert

• BRS files generated for fuel and work order can be blank. If the file is blank, no need to convert nor upload.
• After converson, these files need to be uploaded AIRS.OKSTATE.EDU.

Select A Source File

---

The purpose of this form is convert a BRS Export file from SQ7 to the correct Banner_AR upload format so that it can be uploaded to Banner.

Before using this form, be sure inspect the source file and make sure its contents are valid. The file name must be in this format: BRS_20260512_MOTORPOOLA_20260512.txt ( replace date and time, and Motorpool with Fuel or WorkOrder)

1. Click on the Choose File button to browse to the location where BRS Export file is stored.
2. Click on the Convert button.
3. The converted file is stored in the DOWNLOAD folder. Open the file if it is not already open and inspect its content
4. Upload the converted file to Banner

---

Sample 1: (Original File)

            
                    $$$MTR00108092023OSUTSCorrectionYBM000310000147160020236
                    64AA12345678NM01A20236     999945000060000D                                                AI#V999945RC99929 
                    64AA12345678NM01A20236     999945000067070D                                                AI#V999945RC99929 
                    64AA12345678NM01A20236     999945000002400D                                                AI#V999945RC99929 
                
            

Sample 2: (Converted File)

BRS files are uploaded to ARUPLAOD via AIRS.OKSTATE.EDU.

                    
                            OSU   A12345678202360NM01       60000V999945  OSUTS-Lease V999945RC99929
                            OSU   A12345678202360NM01       67070V999945  OSUTS-Lease V999945RC99929
                            OSU   A12345678202360NM01        2400V999945  OSUTS-Lease V999945RC99929