Text Size:   A+ A- A   •   Text Only
Find     
Site Image
OSPA System-Related Documents
Introduction
woman at keyboard
Need info on payroll processes / procedures?  See our processes page.
 
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.

 
All files below are pdf unless marked otherwise.
 


 Title  Effective Date
 Introduction to Payroll   July 13, 2012
 OSPA Introduction   December 22, 2011
 Payroll Calculation (See Page 6 for OT calculation instructions.)  November 23, 2010

 
Code Lists
All files below are pdf unless marked otherwise
 
 Title  Effective Date
 Benefit Package Codes  October 31, 2012
 Deduction Codes  December 4, 2014
 Garnishment Codes   December 12, 2014
 Pay and Leave Codes  December 4, 2014
 Screen Message Codes  September 12, 2012
 Work Schedule Codes, 7-days (One Week)  July 2014
 Work Schedule Codes, 14-days (Two Weeks)  July 2014
 ​All Work Schedule Codes (excel file) ​ July 2014
 Work Schedule Codes, Database (All Options) (zip)  -- PLEASE NOTE:   You must download and unzip this file to your computer before you can use it.  Right-click the link, then choose "save" when prompted to do so.
 July 2014

 
Screen Guides
 
Title Effective Date
List of Screens (pdf)  December  16,  2011

All files below are pdf unless marked otherwise
 
 Screen
 Number
 Screen Title   Effective Date 
 ADB1  Payroll Benefit Package Table  December  2,  2011
 ADB2  Payroll Benefit Package Table  November 12, 2010
 ADD1  Payroll Deduction Table  December 16, 2011
 ADD2  Payroll Deduction Table  March 22, 2012
 ADD3  Payroll Deduction Table  March 22, 2012
 ADW1  Payroll Work Schedule Table  July 13, 2012
 ADW2  Payroll Work Schedule Table  July 13, 2012
 P001  Session Default Values  March 26, 2010
 P002  Time Capture Screen  March 26, 2010
 P003  Time Capture Screen  July 13, 2012
 P004  Time Capture Screen  February 12, 2010
 P005  Payroll Time Capture - Employee Entry Menu  April 15, 2011
 P006  Payroll Time Capture - Supervisor Entry Menu  July 9, 2009
 P007  Payroll Time Capture - Entered Pay Types by Day - Summary  September 12, 2012
 P009  PIN Scrub Utility  September 12, 2012
 P010  Withhholding Data / Locator Data  May 17, 2012
 P020  Work Schedule Data  May 17, 2012
 P030  Job Status Data  March 22, 2012
 P031  Job Status Update  July 2, 2009
 P032  Job Status Display  September 4, 2009
 P050  Gross Pay Adjustments on File  March 22, 2012
 P060  Tax/OPE Adjustments on File  March 22, 2012
 P070  Deductions and Deduction Adjustments  September 12, 2012
 P071  Cloning Utility  July 26, 2012
 P090  YTD Wages, Taxes, and Retirement  November 18, 2011
 P091  YTD Wages, Taxes, and Retirement - Calculated from  P370  November 18, 2011
 P130  Check Reversal/Stop Payment  May 13, 2011
 P140  Manual Checks  August 30, 2012
 P160  Name Locator  August 31, 2006
 P190  Payroll Register Data  March 30, 2009
 P191  Register Summary  August 30, 2012
 P192  Register Listing  August 30, 2012
 P300  Vendor Checks  May 13, 2011
 P310  Vendor Check Reversal/Stop Payment  March 28.2008
 P320  Check Print Request  May 13, 2011
 P370  Calculation of Current Payoff  May 17, 2012
 P420  Leave Clearing Account Balances  March 21, 2011
 P430  Employee Leave Data  March 26, 2010
 P435  Employee Leave Data  May 17, 2012
 PACH  ACH Stops  April 2, 2009
 PBAP  PPDB Agency Table - Payroll  November 12, 2010
 PCHG  OSPS - Work Charge Entry Table  August 31, 2006
 PMSG  OSPS Newsletter  August 31, 2006
 PPRM   Variable Update Screen  October 30, 2009
 PRPT  OSPS - Agency Report Selection  March 4, 2011
 PSEC  OSPS - Time Entry Security Table  September 18, 2009
 PTB1  Payroll Benefit Package Table  December  2,  2011
 PTB2  Payroll Benefit Package Table  November 12, 2010
 PTD1  Payroll Deduction Table  February 14, 2014
 PTD2  Payroll Deduction Table  March 22, 2012
 PTD3   Payroll Deduction Table  March 22, 2012
 PTW1  Payroll Work Schedule Table  July 13, 2012
 PTW2  Payroll Work Schedule Table  July 13, 2012

 
Report Guides
Conventions Used in the Reports Section
 
Some reports have OSPS as part of the report number or the report title.  For the report descriptions, we have omitted that designation.  The reports are in alphabetical order by title, omitting the OSPS reference.
 

 Title  Effective Date
 Introduction to Reports (pdf)  May 13, 2011
 Index by Report Number (pdf)  December 11, 2012
 Reports on Microfiche (pdf)  October 8, 2009

All files below are pdf unless marked otherwise
 
Report Number
Report Name
*DM?
Effective Date
XREFRA
ACH Direct Deposit Register
 No  February 23, 2007
J463-30-1
ACH Returns
 No  November 9, 2012
E404-09-1
Agency Employees with Leave Type CT   Yes  April 22, 2011
E510A
E510C
Agency Overtime Report   Yes  November 9, 2012
XREFRL
Alpha Listing of Employee Checks   No  November 9, 2006
B010
Batch Time Capture   No  November 9, 2006
ECFD Series CFD Donations     December 16, 2011
E469-05-1
Check Reconciliation File-in Agy/Mcr Sequence   No  August 8, 2013 
E311-018A
Child Support Amounts by Agency   No  May 14, 2010
ANNLDEC
Deceased Employees – Agency Summary   Yes  May 14, 2010
E322-01
Deductions Past Job End Date   No  November 9, 2012
XREF01
Deduction Reconciliation   No  November 9, 2012

XREF76
XREF76C
XREF76DC
XREF76RT
XREF15
XREF15C

Deduction Register Detail & Summary   Yes  December 11, 2012
E421-260-1 EID Security Table Entries by RDC/Supervisor  No  August 14, 2009
EX22-077-1
EX22-077-2
EX22-200-1
EX22-200-2 
Employee Furlough Leave Used 
Yes
 July 27, 2012
ETVALP
ETV7RDC
Employee Monthly Timesheet  Yes  July 13, 2012
B055CC
B055RG
Employee Time Exception   No  September  11,  2009
B360 Employee Update Screen Activity Report  No  May 14, 2010
EX22-260-1
EX22-260-2
EX22-290-1
EX22-290-2
Employee Voluntary Furlough Leave Used  Yes  July 27, 2012
E357-020
Employees Eligible for Participation in Retirement   No  November 9, 2012
E315-009A
Employees Unqualified for State Pay Benefits   No  November 9, 2012
XREF68N
Employees with Negative Amount(s) Listed   No  November 9, 2012
E497
Employees with Non-blank Waivers   Yes  November 9, 2012
B500A
B500C
EXAS OSPS Detail Labor Distribution and Prorate   No  September 4, 2009
XREF10-A
FICA Mag-File Detail Note of Irregularities   No  February 18, 2011
XREF11
FICA Mag-File Summary for Tax Year ####   No  February 25, 2011
E512A
E512C
FMLA/OFLA Leave Hours
 Yes  November 9, 2012
B075A
B075B
Gross Pay Adjustments   No  November 9, 2012
E820-1
E820-2
E820-3
Gross Pay Adjustments Outdated   No  September 27, 2012
E260-100
Gross Pay Over 2.0 x Ajd Base Exception Report   No  November 9, 2012
E370-06-01
Income Tax Exemptions   Yes  September 27, 2012
E460
Leave Accrual -- Adjustments and Transfers   Yes  April 17, 2009
E505-152
Leave Accrual – Employee’s Leave Balance and Usage   Yes  April 29, 2011
E455 Leave Accrual - Exception Report 
 No
 March 19, 2009
B470C
B470CM
B470D
B470S
Leave Accrual Detail Transaction Register   Yes  April 29, 2011
E461-01
Leave Adjustments Made to Closed Periods   No  August 4, 2011
ETV8L
List of Daily Timesheets with a Supervisor Lock   No  November 9, 2006
ETV8N
List of Daily Timesheets without a Supervisor Lock   No  November 9, 2012
E560-04-01
E560-04-02
List of In/Outdated Deductions   No  November 18, 2011
E404-25-1
Lost Leave Accrual CT Balance   Yes  November 9, 2012
E370-09-1 Mandatory Withholdings Determination  No  September 18, 2009
E311-018B
Negative Child Support Amounts by Agency   No  May 14, 2010
E311-38 Negative Vendor ACH Generated This Run; To Be Used Next Payroll Run  No  April 9, 2009
E502-02 Negative Vendor ACH Payments - Please Bill   No  March 5, 2010
E260-200
Net Pay Negative Report  No  November 9, 2012
E397-120-01 Non-leave Time Recorded on Holiday
 Yes  November 9, 2012
B850-01 Nov or Dec Pay Reported in Two Tax Years  Yes  November 15, 2008
E475-B
OPEU FLSA Exempt Employees with CT/ST Balances   Yes  April 15, 2011
E701-30-A Outstanding Checks to be Purged from Check Recon 
No
 August 8, 2013
XREF24
XREF18
P&F Extra Retirement Units   Yes  February 5, 2010
XREF87
Payroll Check Reversals   No  November 9, 2006
E315-009B
E315-009C
E315-009D
Payroll Deduction Adjustment   No  March 21, 2011
E120-042A
E120-052A
E122-042A
E122-046A
E122-056A
Payroll Exception   No  May 17, 2012
XREF43
XREF44
XREF45
XREF46
XREF46D
Payroll Register   Yes  September 27, 2012
E120-052B
E122-042B
E122-042C
PEBB Domestic Partner   Yes  November 9, 2012
XREF51 PEBB Insurance Exceptions   No  November 9, 2012
XREF16
XREF17
Regular Contributions   No  February 5, 2010
XREF32
Retirement Remittance Advice   No  November 9, 2006
E480A
Seasonal, Temporary, and Permanent Part-time Hours Worked   Yes  November 9, 2006
E357-030
Separated Employees with Net Pay Positive Adj   No  November 9, 2012
XREF90
XREF90C
XREF91
XREF91C
XREF92
XREF92C
XREF93
XREF93C
XREF94
XREF95
XREF96
XREF96C
XREF99
SFMS Cost Distribution  Yes  September 4, 2009
JR07-1 Terminal List - By Agency  No  August 28, 2009
E492
Terminated Employees Having Leave Balances   Yes  November 9, 2012
B065A
B065C
Timesheet Audit and Control   No  November 6, 2006
B030-020
Timesheet Forecast Control   No  November 9, 2006
E513A
E513C
Training Hours Taken/Given   Yes  November 9, 2006
E311-01
Vendor ACH Deductions   No  November 9, 2006
XREF23
Vendor Check Summary   No  November 9, 2006
XREF21
WBF Assessment & SAIF Premium Summary   No  November 9, 2006
E381-30-2 W-2 Distribution List   No  May 13, 2011
E489-1 Year End Report: Total Regular Hours Worked  Yes  November 9, 2006
XREF68-C
XREF68-P
Year to Date   Yes  February 25, 2011
XREF85
Year to Date and Current Correction   No  November 9, 2012
* DM = Report can be reproduced or partially reproduced through use of the OSPA Datamart.  Details are contained within the report description document.

 
Interfaces with Other Systems
All files below are pdf unless marked otherwise

 Interface Guide  Effective Date
 Oregon State Treasury (OST)   December 11, 2012
 Oregon Savings Growth Plan (OSGP)   September 12, 2012
 Position and Personnel DataBase (PPDB)   December 11, 2012
 Relational STatewide Accounting & Reporting System (R*STARS)   February 12, 2010