Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 7 Next »


The AOS of State Employee Report can be ran in csv or tab delimited file based upon the user selected output.  The report will contain a line for each compensation that has a date range that overlaps the user provide report date range.  An employee can have multiple lines in the report if they have multiple compensations with date ranges overlapping the report date range.  The report is also available to be added to Report Bundling.

Listed below, is a list of fields of how and where the data is being determined:

RetirementEmployerShare - within user entered date range - total Employer amount from SERS/SERS annuity or STRS/STRS annuity (depending on retirement code from position) from payroll history plus any adjustments for SERS/SERS annuity or STRS/STRS annuity for Board Amount or Board Pickup Amount

RetirementEmployerPickup - within user entered date range - total Employer amount from the Employer SERS or Employer STRS item from payroll history plus any adjustments for Employer SERS or Employer STRS for Board Amount or Board Pickup Amount

RetirementEmployeeShare - within user entered date range - total Employee amount from SERS/SERS annuity or STRS/STRS annuity (depending on retirement code from position) from payroll history plus any adjustments for SERS/SERS annuity or STRS/STRS annuity for Amount Withheld or Additional Withholding

    ** if ran for the current fiscal year, then the FYTD totals on the pay items can be used to help find these totals above

RehiredRetiree - comes from the flag on the SERS/STRS items (usually code 400/450)

Leave Fields
    End Balance - balance as of stop date entered by user
    Used - total non deferred absences falling within user entered date range (applied to balance flag on absence is true)
    Deferred - total deferred absences falling within user entered date range (applied to balance flag on absence is false)
    Accum per month - value comes from leave view accum per month
    Max - value come from leave view max field

AccredDistrictExperience, DistrictExperience, RetireSystemExperience - from experience flags on employee

DaysWorkedPerYear - contract work days on compensation

HoursWorkedPerDay - hours in day on compensation

TotalAnnualHoursWorked - DaysWorkedPerYear * HoursWorkedPerPay

PayPeriodsPerYear - from compensation pay plan: Biweekly = 26, Semimonthly = 24, Monthly = 12

MedicalPremiums - total amount withheld and employer amount withheld within the user date range for Regular, Annuity, or HSA items with a pay item config that has the employer health coverage box checked

MaritalStatus - from employee's federal tax item

Enter a Start Date (required) (default start date is first day of the Fiscal year)

Enter a Stop Date (required) (default stop date is last day of the Fiscal year)

Report Format

  • Tab Separated Values
  • Comma Separated Values (CSV)

Have the option to Select by Employees.  Once employee is selected, click on to move employee to the 'Selected Employees' box. To removed the employee from the box, check the box next to the employee and click on .  To run the report for all employees, leave blank.

Click on

AOS Employee Report (Tab Separated Values)

AOS CSV


Errors

Severe - Start Date is after Stop date!

Severe - Start Date is required

Severe - Stop Date is required



  • No labels