State of Oregon: Payroll - OSPA reference manual

This page links to technical information on OSPA, including codes used in OSPA, screens, system reports and outputs and other computer applications that interface data to or from OSPA.

Topic links

Introduction
Code list
Screen guide
Reports guide
Processes and recommended practices
Interfaces

Introduction

Document title	Modified
Introduction to OSPA	5/12/2016 3:55 PM
Payroll Calculation (see page 6 for OT calculation instructions)	5/12/2016 3:55 PM
Introduction to OSPA security	8/12/2020 10:23 AM
Introduction to payroll	5/12/2016 3:55 PM

Code list

The purpose of this section is to provide a list of codes used in OSPA by state payroll technicians. You can filter and sort this list by "Document title" or "modified" date.

Document Title	Modified
Benefit package codes	10/5/2017 7:28 AM
Deduction codes	9/29/2020 3:11 PM
Garnishment codes	6/22/2020 8:02 AM
Pay and leave codes-alphabetical	11/18/2020 2:11 PM
Pay and leave codes-by category	11/18/2020 2:11 PM
Screen message codes	1/19/2016 1:13 PM
Work schedule codes, 07-days (one week)	10/8/2020 6:03 PM
Work schedule codes, 14-days (two weeks)	10/8/2020 6:03 PM
Work Schedule Codes, 21-days (three weeks)	5/24/2022 10:58 AM
Work schedule codes, all	6/28/2017 1:01 PM

Screen guide

The purposes of this section is to provide a list of screens in OSPA. The purpose of this section is to provide a list of codes used in OSPA by state payroll technicians. You can filter and sort this list by "Screen title" or "modified" date.

OSPA Screen List

Screen number	Screen title	Modified
ADB1	Payroll benefit package table	1/19/2016 3:41 PM
ADB2	Payroll benefit package table	1/19/2016 3:44 PM
ADD1	Payroll deduction table	1/19/2016 3:45 PM
ADD2	Payroll deduction/plan table	1/19/2016 3:48 PM
ADD3	Payroll deduction/plan table	1/19/2016 3:50 PM
ADW1	Payroll work schedule table	1/19/2016 3:50 PM
ADW2	Payroll work schedule table	1/19/2016 3:51 PM
P001	Payroll time capture establish session default values screen	1/19/2016 3:54 PM
P002	Time capture screen (view only)	1/19/2016 3:54 PM
P003	Time capture screen	1/19/2016 3:55 PM
P004	Time capture screen (ODT)	1/19/2016 3:55 PM
P005	Payroll time capture-employee entry menu (ODT)	1/19/2016 3:55 PM
P006	Payroll time capture- supervisor entry menu (ODT)	1/19/2016 3:56 PM
P007	P007- Payroll time capture-entered pay types by day summary (ODT)	1/19/2016 3:56 PM
P009	PIN scrub screen (ODT)	1/19/2016 3:59 PM
P010	Withholding date/locator data screen	8/12/2020 10:21 AM
P020	Work schedule data screen	1/19/2016 4:00 PM
P030	Job status data screen	1/19/2016 4:01 PM
P031	Job status display screen	1/19/2016 4:01 PM
P032	Job status display screen	1/19/2016 4:02 PM
P050	Gross pay adjustments on file screen	1/19/2016 4:02 PM
P060	Tax/OPE adjustments on file screen	1/19/2016 4:03 PM
P070	Deductions and deduction adjustments screen	12/3/2016 9:48 AM
P071	Agency transfer cloning screen	1/19/2016 4:05 PM
P090	YTD wages, taxes and retirement screen	1/19/2016 4:06 PM
P091	YTD wages, taxes and retirement screen	1/19/2016 4:06 PM
P130	Check reversal/stop payment screen	1/19/2016 4:07 PM
P140	Manual check screen	1/19/2016 4:07 PM
P160	Name locator screen	1/19/2016 4:08 PM
P190	Payroll register data screen	1/19/2016 4:23 PM
P191	Register summary screen	1/19/2016 4:08 PM
P192	Register listing screen	1/19/2016 4:09 PM
P300	Vendor check screen	1/19/2016 4:09 PM
P310	Vendor check reversal/stop payment screen	1/19/2016 4:14 PM
P320	Check print request screen	1/19/2016 4:14 PM
P370	Calculation of current payoff screen	1/19/2016 4:15 PM
P420	Leave clearing account balances screen	1/19/2016 4:15 PM
P430	Employee leave data screen	1/19/2016 4:16 PM
P435	Employee leave data screen	1/19/2016 4:16 PM
PACH	ACH stop screen	1/19/2016 4:16 PM
PBAP	Agency table-payroll screen	1/19/2016 4:17 PM
PCHG	Work charge entry table	1/19/2016 4:17 PM
PMSG	OSPS message screen	1/19/2016 4:18 PM
PPRM	Variable update screen	1/19/2016 4:18 PM
PRPT	OSPS agency report selection screen	1/19/2016 4:18 PM
PSEC	Time entry security table screen	5/31/2016 9:57 AM
PTAU	OSPS authorized user table	1/19/2016 4:19 PM
PTB1	Payroll benefit package table	1/19/2016 4:20 PM
PTB2	Payroll benefit package table	1/19/2016 4:20 PM
PTD1	Payroll deduction table	1/19/2016 4:22 PM
PTD2	Payroll deduction/plan table	12/3/2016 9:48 AM
PTD3	Payroll deduction/plan table	1/19/2016 4:21 PM
PTW1	Payroll work schedule table	1/19/2016 4:21 PM
PTW2	Payroll work schedule table	1/19/2016 4:21 PM

Reports guide

The purpose of this section is to provide a list of reports generated by OSPA. Some reports can be reproduced or partially reproduced through use of the OSPA Datamart. Details are contained within the report description document.

Document Title	Modified
Introduction to reports	1/22/2016 8:53 AM
Reports on microfiche	1/22/2016 8:55 AM
Index by report number	1/22/2016 8:54 AM

The reports are in alphabetical order by title. You can filter and sort this list by "report number" or "modified" date.

Report Number	Report title	Modified
XREFRA	ACH direct deposit register report	1/22/2016 11:49 AM
XREF11	FICA mag-file summary for tax year YYYY report	1/22/2016 1:35 PM
EX22-260-1	Employee voluntary furlough leave used report	1/22/2016 1:30 PM
J463-30-1	ACH returns report	1/22/2016 11:48 AM
ECFD_ONE_MTH	CFD donations report	1/22/2016 1:19 PM
E357-020	Employees eligible for participation in retirement report	6/9/2017 11:48 AM
E404-09-1	Agency employees with leave type CT balance report	1/22/2016 11:50 AM
E510A	Agency overtime report	1/22/2016 1:18 PM
XREFRL	Alpha listing of employee checks	1/22/2016 1:18 PM
B055CC B055RG	Employee time exception report	1/22/2016 1:28 PM
E322-01	Deductions past job ending date report	1/22/2016 1:23 PM
B500A B500C	EXAS/OSPS detail labor distribution and prorate report	1/22/2016 1:34 PM
B075A B075B	Gross pay adjustment report	1/22/2016 1:36 PM
E311-018A	Child support amounts by agency report	1/22/2016 1:20 PM
XREF01	Deduction reconciliation report	1/22/2016 1:27 PM
B360	Employee update activity screen report	1/22/2016 1:29 PM
E315-009A	Employees unqualifed for state pay benefits report	1/22/2016 1:32 PM
EX22-077-1 EX22-077-2 EX22-200-1 EX22-200-2	Employee furlough leave used report	1/22/2016 1:28 PM
E421-260-1	EID security table entries by RDC/supervisor report	1/22/2016 1:23 PM
E497	Employees with non-blank waiver codes report	1/22/2016 1:33 PM
E260-100	Gross pay over 2X adj base exception report	1/22/2016 1:38 PM
XREF76 XREF76C XREF76DC XREF76RT XREF15 XREF15C	Deduction register detail and summary report	1/22/2016 1:28 PM
B010	Batch time capture report	1/22/2016 1:19 PM
E469-05-1	Check reconciliation file-In AGY/MICRO sequence report	6/20/2017 9:03 AM
ANNLDEC	Deceased employees- agency summary report	1/22/2016 1:20 PM
XREF68N	Employees with negative amount(s) listed report	1/22/2016 1:33 PM
ETVALP ETV7RDC	Employee monthly timesheet report	1/22/2016 1:28 PM
E820-1 E820-2 E820-3	Gross pay adjustments outdated report	1/22/2016 1:36 PM
XREF10-A	FICA mag-file detail note of irregularities report	1/22/2016 1:34 PM
E512A E512C	FMLA/OFLA leave hours report	1/22/2016 1:35 PM
E460	Leave accrual - adjustments and transfers report	1/22/2016 1:44 PM
E370-06-1	Income tax exemptions report	1/22/2016 1:38 PM
E505-152	Leave accrual-employee's leave balance & usage report	1/22/2016 1:44 PM
E461-01	Leave adjustments made to closed periods report	1/22/2016 1:48 PM
ETV8L	List of daily timesheets with a supervisor lock report	1/22/2016 1:50 PM
B470C B470CM B470D B470S	Leave accrual detail transaction register report	1/22/2016 1:44 PM
E560-04-01 E560-04-02	List of in/outdated deductions report	1/22/2016 1:50 PM
E311-018B	Negative child support amounts by agency report	1/22/2016 1:58 PM
E404-25-1	Lost leave accruals CT balances report	1/22/2016 1:57 PM
E370-09-1	Mandatory withholding determinations report	1/22/2016 1:57 PM
E455	Leave accrual exception report	1/22/2016 1:47 PM
ETV8N	List of daily timesheets without a supervisor lock report	1/22/2016 1:50 PM
E311-38	Negative vendor ACH generated this run report	1/22/2016 1:58 PM
E397-120-01	Non-Leave time recorded on a holiday report	1/22/2016 1:59 PM
E120-042A E120-052A E122-042A E122-046A E122-056A	Payroll exception report	11/22/2016 9:33 AM
B850-01	Nov or Dec pay reported in two tax years report	1/22/2016 2:00 PM
E502-02	Negative vendor ACH payments- please bill report	1/22/2016 1:59 PM
E475-B	OPEU FLSA exempt employees with CT/ST balances report	1/22/2016 2:00 PM
E701-030-A	Outstanding checks to be purged from check recon report	6/20/2017 9:04 AM
XREF51	PEBB insurance exception report	1/22/2016 2:10 PM
XREF24 XREF18	P & F EXTRA RETIREMENT UNITS	7/19/2016 1:12 PM
E260-200	Net pay negative report	1/22/2016 1:59 PM
XREF87	Payroll check reversals report	1/22/2016 2:03 PM
XREF43 XREF44 XREF45 XREF46 XREF46D	Payroll register report	1/22/2016 2:09 PM
E315-009B E315-009C E315-009D	Payroll deduction adjustment report	1/22/2016 2:03 PM
E120-052B E122-042B E122-042C	PEBB domestic partner exception report	1/22/2016 2:10 PM
XREF16 XREF17	Regular contributions report	1/22/2016 2:11 PM
XREF32	Retirement remittance advice report	1/22/2016 2:13 PM
E357-030	Separated employees with net pay positive adjustment report	1/22/2016 2:14 PM
E480-A	Seasonal, temporary, and permanent part-time hours worked report	1/22/2016 2:13 PM
JR07-1	Terminal list-by agency report	1/22/2016 2:15 PM
XREF90 XREF90C XREF91 XREF91C XREF92 XREF92C XREF93 XREF93C XREF94 XREF95 XREF96 XREF96C XREF99	SFMS cost distribution report	1/22/2016 2:14 PM
B065A B065C	Timesheet audit and control report	1/22/2016 2:15 PM
B030-020	Timesheet forecast report	1/22/2016 2:17 PM
E492	Terminated employees having leave balances report	1/22/2016 2:15 PM
E311-01	Vendor ACH deductions report	1/22/2016 2:18 PM
XREF21	WBF assessment and SAIF premium summary report	1/22/2016 2:20 PM
XREF68-C XREF68-P	Year to date report	1/22/2016 2:22 PM
XREF23	Vendor check summary report	1/22/2016 2:18 PM
E513A E513C	Training hours taken/given report	1/22/2016 2:17 PM
E381-30-2	W-2 distribution list report	1/22/2016 2:20 PM
E489-1	Year-end report: total hours worked	1/22/2016 2:23 PM
EICRPT	Yearly earned income credit for tax year report	1/22/2016 2:23 PM
XREF85	Year to date and current correction	1/22/2016 2:22 PM

To navigate this list, use the forward or back arrows.

Processes and recommended practices

The purpose of this section is to provide links to additional tools and support to state payroll technicians and managers for processing and managing payroll at their agencies. As a supplement to each agency’s own policies, procedures, or internal controls, links contain technical information on how to process transactions in OSPA, and recommendations about basic payroll procedures and controls.

This list can be filtered or sorted by document title or date modified (column titles).

Document title	Modified
Collective bargaining agreements recommended practice	5/13/2016 4:11 PM
Deceased employees recommended practice	5/17/2016 1:51 PM
Direct deposit entry guide	11/22/2016 2:27 PM
Family medical leave recommended practice	5/13/2016 4:12 PM
Hardship leave (donated) recommended practice	5/13/2016 4:11 PM
Income taxes process	5/17/2016 2:10 PM
Injured worker leave recommended practice	5/13/2016 4:11 PM
Leave accrual and reporting process (LARS)	5/12/2016 3:58 PM
Manual checks recommended practice	5/13/2016 4:10 PM
Military leave of absence process	5/12/2016 3:58 PM
New employee process	5/12/2016 4:17 PM
PEBB benefits process	5/12/2016 4:17 PM
Public Employees Retirement System (PERS)	5/12/2016 3:58 PM
Separating employees process	5/12/2016 4:17 PM
Stale dated checks recommended practice	7/15/2016 1:09 PM
Time and attendance recommended practice	5/16/2016 3:25 PM
Timesheet entry process	5/13/2016 4:04 PM
Transferring employees process	5/12/2016 4:18 PM
Volunteers, boards, and commissions recommended practice	5/13/2016 4:12 PM
Year-end payroll processes	5/12/2016 4:18 PM

Interfaces

The purpose of this section is to provide links to information on systems that interface with OSPA, including a brief overview of the system and its relationship to OSPA.

Document title	Modified
Oregon Savings Growth Plan (OSGP) Interface	5/12/2016 3:56 PM
Oregon State Treasury (OST) interface	5/12/2016 3:56 PM
Position and Personnel Database (PPDB) Interface	5/12/2016 3:56 PM
Relational Statewide Accounting and Reporting System (R*Stars) Interface	5/12/2016 3:56 PM