Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Reports module allows the user to generate a report from either a  listing of template reports or create a custom report using the "detail" option.

A crosswalk of the Reports menu options and their Classic counterparts is available below.  For a printable version of the crosswalk, click here here

USPS-R Reports Option

USPS Classic Report Comparison

Definition

Report Bundles

New Feature

Report

Bundles are

Bundles are used to automatically generate reports by the system to be listed under Utilities/File Archive/Payroll Archive or to set up single or multiple reports to be emailed to a user at any time. 

Report Manager

New Feature

Predefined SSDT template report definitions as well as user-created reports are displayed here; can Import and Create reports

     Import Report

Safari Report/Shared Reports

Import Reports from an outside source. Must be in .JSON format.

    Create Form

Allows the user to create alternate versions of forms like Direct Deposit Notices or Payroll Checks, they can add their own "Form" and then the drop down will show these

Custom Report Creator

Safari and New Feature

Allows for dynamic reporting of all data objects in USPS-R

ACH Submission

    ACH Submission

PAYDIR

It creates an ACH file which is uploaded to the bank for payroll

    HSA Submission

PAYDED

It creates an HSA file which is uploaded to the bank  for HSA Payroll Items (HSA deductions)

Afford Report

AFFORD

Will assist in determining if an employee will exceed 30 hours per week or 130 hours per month and therefore, be classified as full-time under the Affordable Care Act (ACA).

Attendance Reports>

ABS101

ABS103

Perfect Attendance Report

ABS101

ABS103

ABS104

ABS101, the Staff Attendance Report, provides a listing of attendance and absence categories by employee, by date. It also includes the day of the week the activity occurred, the length of the activity, and the subcategory if applicable. Totals by category for number of records, days, and hours are displayed at the end of the report.

ABS103, the Staff Attendance Summary Report, summarizes absence/attendance occurrences by employee. Grand totals are provided at the end of the report.

This report will show all employees that have not missed any days with the category's selected.

Audit Report

AUDRPT

This program tracks the old values and the new values entered in various USPS programs.

Auditor of State Reports>

Auditor of State Employee Report

Auditor of State Payment Reports

USPAUDIT

This program extracts USPS check history information into specially formatted files for use by auditors. Auditors will use these files to assist in automating the audit process.

 The

 The report will contain a line for each compensation that has a date range that overlaps the user provide report date range.

This program extracts Payroll check history information into specially formatted files for use by auditors. Auditors will use these files to assist in automating the audit process.

Benefit Obligation Reports>

Benefit Obligation By Account

Benefit Obligation By Employee

BENOBL/BENACT

BENOBL/BENEMP

Provides information by Account about the dollar amount of benefit obligations a district would incur if employees were to use their entire sick, vacation, and personal balances.

The 

The Benefit Obligation By Account

 provides

 provides information about the dollar amount of benefit obligations a district would incur if employees were to use their entire sick, vacation, and personal balances.

The Benefit

The Benefit Obligation by

Employee provides

Employee provides information about the dollar amount of benefit obligations a district would incur if employees were to use their entire sick, vacation, and personal balances.

Census Report

CENSUS

The CENSUS program will create a common census file per ING requirements.

CRDC Report

CRDC Report

Civil Rights Report-

 produces

 produces a report listing different required variables for specific reporting groups.

Date Code Extract Report

New

This report will gather all employee date code data and extract them into a csv file. This report can be added to Report Bundles

Eligible to Retire Report

ELIRET

Creates a report of employees showing Age, Retirement System, District Experience, Total Experience, 60 Year/s exp, 55 years/25 exp and 30 exp.

EMIS Reports>

EMIS Data Collection Reports

EMIS Data Extract Report

Similar to PERDET

Option produces a report listing data errors or invalid data prior to EMIS reporting.

Employee Earnings Register

ERNREG

Can be ran for one and all Employees or Pay Groups receiving a paycheck.

Employee Master

EMPMST

Report that reflects the Core program data element fields.

Employer Distributions

BRDDIS

Generates a worksheet to provide you with dollar amounts for the distribution of board paid deductions to the proper USAS accounts.

Employer Retirement Share

BRDRET

Distributes the board's retirement share by allocating amounts to non-general (non-001) fund accounts at a flat 14% rate of the current payroll items paid.

Job Calendar Report

CALRPT

Produces a report showing job calendars which have been created.

Leave Activity Report

The 

The Leave Activity Report

 provides

 provides a listing of accruals and absence categories by employee, by date applied date and then by activity date. It also includes the Beginning Balance, Length and Ending Balance of the activity by category.

Leave Balance Report

BENRPT

The Leave Balance Report shows the balances of sick, vacation, and personal leave.

Leave Projection Report

LEVPRO

This program creates a posting file from which absences may be charged to the proper leave accounts.

New Contract Report

NEWCNT/REPORT

Generate a report outlining purged contract information.

ODJFS Reporting

ODJFS New Hire Report

ODJFS Report

NEWHIRE

ODJFSRPT

To assist in the reporting of new employees to the Ohio Department of Job and Family Services

The ODJFS New Hire Report is designed to assist in the reporting of new employees to the Ohio Department of Human Services. This reporting is to be done within 20 days of the employee's hire date.

Generates a report of quarter-to-date figures for employees and provides information necessary to complete the IRS Form 941 Quarterly statement. Creates submission file to submit to ODJFS for unemployment purposes.

Payment Transaction Status Report

CHKSTS

Generates a report that lists the check number; check status and type; employee ID, deduction code, or vendor number (depending on the check type); name; issue date; period ending date; date voided; date reconciled; gross pay; and net pay.

Quarter Report

QRTRPT

Generates a report of quarter-to-date figures for employees and provides information necessary to complete the IRS Form 941 Quarterly statement.

Reporting Entity Count Summary Report

RPTSUM

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.

SERS Reporting>

SERS Monthly Report

SERS New Hire Report

SERS Per Pay Report

SERS Surcharge Report

RETIRE/SERSMONTH

RETIRE/SERSHIRE

RETIRE/SERSREG

SURCHG

Creates a report for SERS balancing and month-end reporting purposes.

Create a projection report or a new employee enrollment file to upload to the eSERS website.

Creates a projection report to verify State Employees Retirement System (SERS) and will create a tape file used for submission of data to SERS (per pay).

Creates reports that will assist with the SERS surcharge calculations and GAAP reporting.

STRS Reporting>

Check STRS Advance

STRS Advance

STRS Monthly Report

STRS New Hire Report

STRS Per Pay Report

CHKSTRS

STRSAD

RETIRE/STRSMONTH

RETIRE/STRSHIRE

RETIRE/STRSREG

Report showing employee's STRS Advance Payments

Allows you to create Advance FYTD, Advance Position and Non-Advanced reports. Also, can create the tape file for the STRS annual report submission.

Creates a report for STRS balancing purposes.

Creates a projection report as well as an option to create a STRS New Hire submission file and submit it to STRS. 

Creates a projection report to verify State Employees Retirement System (STRS) as well as an option to create a STRS submission file and submit it to STRS.

Wage Obligation Reports>

Wage Obligation By Account

Wage Obligation By Employee

WAGOBL

WAGOBL

This program generates a report listing the district's current accrued wage obligations by account code.

This program generates a report listing the district's current accrued wage obligations by employee.

W2 Reports>

W2 Archive Individual Forms

W2 Form Output Files

W2 Mailable Forms

W2 Report and Submission

W2PROC

Program creates reports, form files, data files, and tape files used for reporting W2 wage information at calendar

year end

year end.

W2 Archive Individual Forms

 is

 is used to schedule a job (Job Scheduler) and produce a file in a folder in Utilities/File Archive/W2 Archive for the year being reported.

The W2 Form Output

Files will

Files will store the processed W2 Forms (Employee), W2 Forms City and W2 Mailable Forms

The W2

The W2 Mailable Forms option can generate a 8 1/2" x 14" paper form for all employees included on the parameters. 

The W2 Report module creates a reports and Submission files used for reporting W2 wage information at calendar year end.

W2 Corrections>

W2C Forms Output Files

W2C Records

W2C Reports

W2C

 W2C Statement of Corrections Form

The W2C Forms Output

Files will

Files will store the processed W2C Forms (Employee)

To create a W2C correction record for employees

Creates a

report

Report and Forms from the W2C Records

W2 SSN Verification>

Create Submission File

Results Report

W2MAINT

Generates an extract file that can be uploaded to the Social Security Administration’s Business Services Online to assure the SSN entered in USPS matches the SSN on file.

Any errors are returned in a results file and this option can be used to view that information.

YTD Report

YTDRPT

The YTD report program provides year-to-date totals and a benefit statement for all employees, pay groups, or individual employees.