Oregon PERS (EDX File Creation) Report

***Pre Requisite ***
Setup of PERS deductions before running the report is mandatory for Pre and After Tax Classifications

PERS requires contributions to be noted for Pre Tax deduction or After Tax Deduction. Follow these steps to complete the proper setup of these deductions:

1.  Enter Web Financial Office.

2.  From the menu tree select Master Code and File Entry | Master File Data Entry

3.  Select Deductions/Benefits Master

4.  Select each PERS deduction(s)

5.  Under Misc Code 1 field place a P for Pre Tax or a A for After Tax

6.  Save.

http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/pretaxjune.png

Pre Tax Deduction
http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/pretaxjune2.png

After Tax Deduction
http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/pretaxjune3.png

 

Running the Report:

The payroll(s) should be closed before creating this file.

7.  Enter Web Financial Office.

8.  From the menu tree select Payroll Processing |State and Federal Reporting. 

9.  Select Oregon from the state dropdown.

10. Select PERS (EDX File Creation) from the report dropdown.

http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/pretaxjune4.png

11. Enter the employer information and reporting month, etc. required on the screen.

12. Calendar Starting and Calendar Ending Dates: Enter the SDS payroll calendar starting and ending dates covered in this reporting period. If one payroll is being reported, the starting and ending dates will be the same. If more than one payroll is being reported, it will be the first and last payroll calendar dates.

13. Report Date: The report date on the calendar on the screen is used for the pay date being reported to PERS.

14. Under the Retirement Selector, select the retirement codes to be reported.

http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/pretaxjune5.png

15. After all of the items have been filled in on the screen select the Save Setup button.

16. To create the file, select the Create Report button.

    The file that is created will be listed at the top of the screen when first created. When you re-enter this report it will be displayed under Show/Hide Historic Reports. All files created will have a date and time stamp on them for when they were created.

o http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/pretaxjune6.png

 

The file name created will be the District Number.Reporting Period End Date.dat. The District Number comes from the District Number Field on the reporting screen. The Reporting Period End Date comes from the Period Ending Date on the screen.   

Saving and Re-naming the file directions:

1.  Right click on the yellow folder and select Save Target as

2.  Select where to save the file under Save in (desktop or other desired location on your computer)

3.  Save as type:  select All Files

4.  File Name:  highlight and type over the file name with the same name the file was named when created

5.  Select save

6.  Now it can be uploaded to the PERS site  

7.  If you open the file to review it do not save it to upload for opening the file and saving it will change the format of the file and therefore create error when uploaded.

 http://help.schooloffice.com/helpconsole/SDSFinanceHelp/images/org7.png

File Details

The file that gets created will be composed of several different record types. Bold = Field Name and next to is the table and field used in SDS

Header

    PERS Employer Number: Screen - District Number

    Employer Name:  Screen- Employer Name

    Report Date:  Screen - Period Ending Date

    Date Created:  System Date (mmddyyyy)

    Service Center Number:  Screen –Svc Center Number

    Service Center Name:  Screen –Svc Center Name

    Format Version Code:  2 = current format

 

DTL2 – Wage and Service Record
The Wage and Service record (DTL2) will be created for employees who have earnings in the reported pay period. Data required for these records will come from several different areas.

     PERS Employer Number: Screen – District Number

     Social Security Number: Social Security Number field on the Employee Master

     Last Name: Employee Name field on the Employee Master

     First Name: Employee Name field on the Employee Master

     Middle Name: Employee Name field on the Employee Master

     Pay Date: Screen – Period Ending Date

     Hours Worked (Regular):  Gross Pay Entry Screen Reg Hrs field + Retirement Hrs Days Field

     Hours Worked (Overtime):   OT Hrs field on Gross Pay Entry and Adjustments entry screen

     Wage Code: Employee Wage Code field on Gross Pay Entry and Adjustments entry screen

     Subject Salary, Regular: Gross Pay field on Gross Pay Entry and Adjustments entry screen

     Subject Salary, Overtime: OT Wages field on Gross Pay Entry and Adjustments entry screen

     Gross Salary:  Gross Pay field on Gross Pay Entry and Adjustments screen

     Non-Subject Salary: Gross Pay field that has a Retirement code = N on the Gross Pay Entry and Adjustments entry screen

     Lump Sum Payoff:  Gross Pay field that has Notes = LSP on the Gross Pay Entry and Adjustment entry screen

     Member Paid After-Tax Contribution:  Employee YTD Detail History - Deduction Master if Misc Code 1 = A

     Employer Paid Pre-Tax Contribution:  Employee YTD Detail History – Deduction Master if Misc Code 1 = P

     Unit Contribution:  N/A – not used for Teachers:

     Optional Employer Matching % IAP:  N/A – not used for Teachers

     Optional Employer Matching Amount IAP:  N/A – not used for Teachers

     PERS Job Class Code:   blank

     Average Overtime Hours Code:    N/A – not used for Teachers

     Employer Site Distribution Code:  N/A – not used for Teachers

     Non PERS Data Memo:  N/A – not used for Teachers

     Work Period Begin Date:  Screen – Period Starting

     Work Period End Date:  Screen – Period Ending

     Lump-sum Vacation Payoff:  Gross Pay field that has Notes = LSV on the Gross Pay Entry and Adjustment entry screen

Footer

     PERS Employee Number:  Screen Prompt – District Number

     Employer Name:  Screen Prompt - Employer Name

     Total Detail Records:  Total Records Reported