Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

    Tip

    Transfer Type should be ASCII


  •  

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

    Tip
    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 
      Expand
      titleSample Heading Screenshot
      Image Added


      •  7. Replace all ****** with 0.000

      ...

      •  8. Save file
      •  9.

      ...

      • Follow AESOP instructions to upload.

      ...

      Sample Headings:

      Image Removed