This document outlines the steps needed to create a benefit file to upload into AESOP. 

  • 1. Run BENRPT.

  • 2. File transfer BENRPT.TXT to your computer. 

    Transfer Type should be ASCII

  • 3. Using EXCEL, open the BENRPT.TXT file.

    Make sure once in EXCEL and looking for the file, you select the option to browse for “All Files.”
    • Adjust the column width in EXCEL to only include the ID.
    • Click Next and Finish
  • 4. In EXCEL, change the following column headings to:
    • ID = Identifier
    • Sick Leave Balance = Balance
    • Vacation = Balance 2
    • Personal Leave = Balance 3
  • 5. In EXCEL, delete the following columns:
    • Pay Group
    • Bldg/Dept
    • Employee Name
  • 6. Add columns before and after each ‘Balance’ column
    •  The columns headings for each need to be the following:
      • Absence Reason External ID = SI
      • Balance = Current balance listed in the report
      • As of date = Extracted date
      • Absence Reason External ID 2 = VA
      • Balance 2 = Current balance listed in the report
      • As of date 2 = Extracted date
      • Absence Reason External ID 3 = PL
      • Balance 3=Current balance listed on report                

      • As of Date 3 = Extracted date 

  • 7. Replace all ****** with 0.000
  • 8. Save file
  • 9. Follow AESOP instructions to upload.








  • No labels