Page tree

Versions Compared

Key

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

...

  •  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 Modified


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

...