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 23 Next »


The Reporting Entity Count Summary Report Options generates a report that displays Retirement days(service days), ODJFS weeks, and/or EMIS attendance and absence days with the Percentage of Attendance for employees by selected time periods. This report has several sort and selection options that provide you with the flexibility to generate the report for a wide range of employees or a specific group or individual. 

The report is an employee level report.  If any of the report parameters entered matches any pay history or any Attendance entries, the employee will be included. 

The Reporting Entity Count Summary Report can be a helpful tool in determining and verifying reporting requirements for the Retirement, ODJFS, and EMIS data submission.

The report includes Long Term Illness days for EMIS staff reporting verification. Also reported is the teacher attendance rate, this % is used for EMIS staff reporting as calculated by the Ohio Department of Education and is used in various aspects of EMIS.

Report will be in the order selected in parameter, with a secondary sort always sorting by employee number.

Field Definitions:

Save and Recall option  allows the users to create and save certain reports  for different report runs for each report option.  The Default option is the original SSDT report and the Most Recent is the last report that was ran by the user.  If the report is no longer needed, click on to delete the report. The Default reports cannot be deleted.  

Reporting Entity Summary Report is the default filename for the report. This can be changed by entering a new file name in the Report Title field.

Select the 'Report Format' from the drop-down box.

  • PDF (download)
  • Comma Separated Value (CSV)
  • Excel-Data

Select the Sort Options from the drop-down box: 

  • Employee Number
  • Building/Department
  • Employee Name
  • Pay Group
  • Job Calendar
  • Building IRN

Select Job Status to be included.  Leave Selected empty to include ALL Job Status's. (Default is Active). 

Check  to Include Archived Employee? (default is unchecked)

Check to enter Retirement days start and Retirement days end?   (NOT PAY DATES)  (default is unchecked)

  • In the Retirement days start field, enter the payroll begin dates of the first pay period you want to include in the count.
  • In the Retirement days end field, enter the payroll end dates of the last pay period you want to include in the count. 

Check to enter ODJFS weeks start and ODFJS weeks end?  (default is unchecked) 

  • In the ODJFS week start field, enter the start date for counting ODJFS weeks of credit.
  • In the ODFJS week end field, enter the ending date for counting ODJFS weeks of credit.
    • ODJFS uses Calendar Start/Stop dates, verify dates 

    • It starts with the quarter date range
      Finds the first Saturday of the quarter
      Then sets the Start Date = the preceding Sunday of the first Saturday of month.

      To find the stop date, it uses the last Saturday of the month of the stop date of the quarter.

      Example 1st Quarter 2019 - 01/01/2019 03/31/19 - the programming range is starting at 12/30/2019 - 03/30/19 to find the count of weeks.

Check to enter EMIS days start and EMIS days end?  (NOT PAY DATES)  (default is unchecked)

  • In the EMIS days start field, enter the payroll begin dates of the first pay period you want to include in the count.
  • In the EMIS days end field, enter the payroll end dates of the last pay period you want to include in the count. 

Check to include Specific Job Calendars?  (Leave empty to select all Pay Groups)

Check to select a Specific Employee(s) (default is unchecked)

Check to be included Specific Pay Groups? (Leave empty to select all Pay Groups) (default is unchecked)

Click on to create report

Example of a Reporting Entity Summary Report with Retirement Days selected and a Specific job Calendar selected.pdf

Example of a Reporting Entity Summary Report with EMIS Days selected.csv

How the report is calculated?

How SERS and STRS days are calculated

The SERS per pay report shows Days Paid and to get this, we get the pay history for the payroll selected by the user in the report options and for each SERS positions we find the days on the calendar and also attendances/absences that fall within the pay group date range used on the payroll.  It also looks at the calendar start / stop dates for compensation to gather this info and compares it to the dates of the pay group / payroll.

**NOTE** If a contract has multiple contracts ( Example, legacy and a new contract) make sure the Calendar Stop date of the Legacy is before the Beginning date of the payroll the employee is being paid on the New Contract, otherwise, SERS will pick up Work Days on the calendar, Example, employee's new contract starts 09/01/2021 but their Old Legacy Calendar Start date is set to 08/31/2021 and the Job calendar has work days for all of August.  When running payroll for dates of 08/23/2021 - 09/05/2021, the system will pickup up all Work days starting from 8-23-2021 thru 09-05-2021.  So a Calendar Stop date on the Old Legacy needs to be 08/22/2021 so no Work days will be picked up from 08/23/2021 thru 08/31/2021. 

  • No labels