Reporting Entity Count Summary Report


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 (rounded to 1 decimal point to match what is sent to the data collector) 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