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	6/29/2020 1:09 PM
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	6/23/2020 12:21 PM
Garnishment codes	6/22/2020 8:02 AM
Pay and leave codes-alphabetical	6/25/2020 8:08 AM
Pay and leave codes-by category	6/25/2020 8:08 AM
Screen message codes	1/19/2016 1:13 PM
Work schedule codes, 07-days (one week)	6/22/2020 8:03 AM
Work schedule codes, 14-days (two weeks)	6/22/2020 8:03 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	9/23/2016 10:28 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

(More Items...)

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