Auditor of State Employee Report


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.

Report Bundles#ScheduleanAOSReportBundle

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

Positions only paid during the date range specified, will be on the report

Any compensations that have a Start/Stop dates within the date range, will produce a line on the output file, whether it's one or many compensations

Only Contract and Legacy compensations are included on the reports, No Non-contracts are included


Create AOS report

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 remove 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