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