You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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.
  3. Using EXCEL, open the BENRPT.TXT file.
    1. Make sure once in EXCEL and looking for the file, you select the option to browse for “All Files.”
    2. Adjust the column width in EXCEL to only include the ID.
    3. Click Next and Finish
  4. Once in EXCEL, change the following column headings to:
    1. ID = Identifier
    2. Sick Leave Balance = Balance
    3. Vacation = Balance 2
    4. Personal Leave = Balance 3
  5. Once in EXCEL, delete the following columns:
    1. Pay Group
    2. Bldg/Dept
    3. Employee Name
  6. Add columns before and after each ‘Balance’ column
  7. The columns headings for each need to be the following:
    1. Absence Reason External ID = SI
    2. Balance = Current balance listed in the report
    3. As of date = Extracted date
    4. Absence Reason External ID 2 = VA
    5. Balance 2 = Current balance listed in the report
    6. As of date 2 = Extracted date
    7. Absence Reason External ID 3 = PL
    8. Balance 3=Current balance listed on report                
    9. As of Date 3 = Extracted date
  8. Replace all ****** with 0.000
  9. Save file.
  10. Follow AESOP instructions to upload.

Sample Headings:





  • No labels