Payroll

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  
  
  
Introduction to payroll5/12/2016 3:55 PM
Introduction to OSPA5/12/2016 3:55 PM
Payroll Calculation (see page 6 for OT calculation instructions)5/12/2016 3:55 PM
Introduction to OSPA security5/21/2018 8:40 AM
 
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.  
  
  
Benefit package codes10/5/2017 7:28 AM
Deduction codes7/18/2017 10:31 AM
Garnishment codes7/18/2017 10:32 AM
Pay and leave codes-alphabetical4/3/2018 3:19 PM
Pay and leave codes-by category4/3/2018 3:19 PM
Screen message codes1/19/2016 1:13 PM
Work schedule codes, 07-days (one week)4/3/2018 3:19 PM
Work schedule codes, 14-days (two weeks)7/18/2017 10:34 AM
Work schedule codes, all6/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 

  
  
  
ADB1Payroll benefit package table1/19/2016 3:41 PM
ADB2Payroll benefit package table1/19/2016 3:44 PM
ADD1Payroll deduction table1/19/2016 3:45 PM
ADD2Payroll deduction/plan table1/19/2016 3:48 PM
ADD3Payroll deduction/plan table1/19/2016 3:50 PM
ADW1Payroll work schedule table1/19/2016 3:50 PM
ADW2Payroll work schedule table1/19/2016 3:51 PM
P001Payroll time capture establish session default values screen1/19/2016 3:54 PM
P002Time capture screen (view only)1/19/2016 3:54 PM
P003Time capture screen1/19/2016 3:55 PM
P004Time capture screen (ODT)1/19/2016 3:55 PM
P005Payroll time capture-employee entry menu (ODT)1/19/2016 3:55 PM
P006Payroll time capture- supervisor entry menu (ODT)1/19/2016 3:56 PM
P007P007- Payroll time capture-entered pay types by day summary (ODT)1/19/2016 3:56 PM
P009PIN scrub screen (ODT)1/19/2016 3:59 PM
P010Withholding date/locator data screen9/23/2016 10:28 AM
P020Work schedule data screen1/19/2016 4:00 PM
P030Job status data screen1/19/2016 4:01 PM
P031Job status display screen1/19/2016 4:01 PM
P032Job status display screen1/19/2016 4:02 PM
P050Gross pay adjustments on file screen1/19/2016 4:02 PM
P060Tax/OPE adjustments on file screen1/19/2016 4:03 PM
P070Deductions and deduction adjustments screen12/3/2016 9:48 AM
P071Agency transfer cloning screen1/19/2016 4:05 PM
P090YTD wages, taxes and retirement screen1/19/2016 4:06 PM
P091YTD wages, taxes and retirement screen1/19/2016 4:06 PM
P130Check reversal/stop payment screen1/19/2016 4:07 PM
P140Manual check screen1/19/2016 4:07 PM
P160Name locator screen1/19/2016 4:08 PM
P190Payroll register data screen1/19/2016 4:23 PM
P191Register summary screen1/19/2016 4:08 PM
P192Register listing screen1/19/2016 4:09 PM
P300Vendor check screen1/19/2016 4:09 PM
P310Vendor check reversal/stop payment screen1/19/2016 4:14 PM
P320Check print request screen1/19/2016 4:14 PM
P370Calculation of current payoff screen1/19/2016 4:15 PM
P420Leave clearing account balances screen1/19/2016 4:15 PM
P430Employee leave data screen1/19/2016 4:16 PM
P435Employee leave data screen1/19/2016 4:16 PM
PACHACH stop screen1/19/2016 4:16 PM
PBAPAgency table-payroll screen1/19/2016 4:17 PM
PCHGWork charge entry table 1/19/2016 4:17 PM
PMSGOSPS message screen1/19/2016 4:18 PM
PPRMVariable update screen1/19/2016 4:18 PM
PRPTOSPS agency report selection screen1/19/2016 4:18 PM
PSECTime entry security table screen5/31/2016 9:57 AM
PTAUOSPS authorized user table1/19/2016 4:19 PM
PTB1Payroll benefit package table1/19/2016 4:20 PM
PTB2Payroll benefit package table1/19/2016 4:20 PM
PTD1Payroll deduction table1/19/2016 4:22 PM
PTD2Payroll deduction/plan table 12/3/2016 9:48 AM
PTD3Payroll deduction/plan table 1/19/2016 4:21 PM
PTW1Payroll work schedule table1/19/2016 4:21 PM
PTW2Payroll work schedule table1/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. 

  
  
Introduction to reports1/22/2016 8:53 AM
Index by report number1/22/2016 8:54 AM
Reports on microfiche1/22/2016 8:55 AM
     

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

Report Number
XREFRA
ACH direct deposit register report1/22/2016 11:49 AM
J463-30-1
ACH returns report1/22/2016 11:48 AM
E404-09-1
Agency employees with leave type CT balance report1/22/2016 11:50 AM
E510A
Agency overtime report1/22/2016 1:18 PM
XREFRL
Alpha listing of employee checks1/22/2016 1:18 PM
B010
Batch time capture report1/22/2016 1:19 PM
ECFD_ONE_MTH
CFD donations report1/22/2016 1:19 PM
E469-05-1
Check reconciliation file-In AGY/MICRO sequence report6/20/2017 9:03 AM
E311-018A
Child support amounts by agency report1/22/2016 1:20 PM
ANNLDEC
Deceased employees- agency summary report1/22/2016 1:20 PM
XREF01
Deduction reconciliation report1/22/2016 1:27 PM
XREF76
XREF76C
XREF76DC
XREF76RT
XREF15
XREF15C​ 
Deduction register detail and summary report1/22/2016 1:28 PM
E322-01
Deductions past job ending date report1/22/2016 1:23 PM
E421-260-1
EID security table entries by RDC/supervisor report1/22/2016 1:23 PM
EX22-077-1
EX22-077-2
EX22-200-1
EX22-200-2​
Employee furlough leave used report1/22/2016 1:28 PM
ETVALP
ETV7RDC​ 
Employee monthly timesheet report1/22/2016 1:28 PM
B055CC
B055RG​ 
Employee time exception report1/22/2016 1:28 PM

​B360

Employee update activity screen report1/22/2016 1:29 PM

​EX22-260-1

Employee voluntary furlough leave used report1/22/2016 1:30 PM

​E357-020

Employees eligible for participation in retirement report6/9/2017 11:48 AM

​E315-009A

Employees unqualifed for state pay benefits report1/22/2016 1:32 PM

​XREF68N

Employees with negative amount(s) listed report1/22/2016 1:33 PM

​E497

Employees with non-blank waiver codes report1/22/2016 1:33 PM

B500A
B500C 

EXAS/OSPS detail labor distribution and prorate report1/22/2016 1:34 PM

​XREF10-A

FICA mag-file detail note of irregularities report1/22/2016 1:34 PM

XREF11

FICA mag-file summary for tax year YYYY report1/22/2016 1:35 PM

E512A 
E512C 

FMLA/OFLA leave hours report1/22/2016 1:35 PM

B075A 
B075B 

Gross pay adjustment report1/22/2016 1:36 PM

E820-1 
E820-2 
E820-3 

Gross pay adjustments outdated report1/22/2016 1:36 PM

​E260-100

Gross pay over 2X adj base exception report1/22/2016 1:38 PM

​E370-06-1

Income tax exemptions report1/22/2016 1:38 PM

​E460

Leave accrual - adjustments and transfers report1/22/2016 1:44 PM

B470C
B470CM
B470D
B470S ​

Leave accrual detail transaction register report1/22/2016 1:44 PM
E505-152
Leave accrual-employee's leave balance & usage report1/22/2016 1:44 PM

​E455

Leave accrual exception report1/22/2016 1:47 PM

​E461-01

Leave adjustments made to closed periods report1/22/2016 1:48 PM

​ETV8L

List of daily timesheets with a supervisor lock report1/22/2016 1:50 PM

​ETV8N

List of daily timesheets without a supervisor lock report1/22/2016 1:50 PM

E560-04-01
E560-04-02 

List of in/outdated deductions report1/22/2016 1:50 PM

​E404-25-1

Lost leave accruals CT balances report1/22/2016 1:57 PM
1 - 40Next
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).  

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

  
  
Oregon Savings Growth Plan (OSGP) Interface5/12/2016 3:56 PM
Oregon State Treasury (OST) interface5/12/2016 3:56 PM
Position and Personnel Database (PPDB) Interface5/12/2016 3:56 PM
Relational Statewide Accounting and Reporting System (R*Stars) Interface5/12/2016 3:56 PM

​​​​​​​​​​​​​​​​
​​​​​​​​​​​​​​​​​​​​​​​​​​​​​
​​​​​​​​​​​