|
OSPA System-Related Documents
|
|
|
|
|
|
Article Content  |
| Introduction |
|
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.
|
|
|
| Code Lists |
|
All files below are pdf unless marked otherwise
| Title |
Effective Date |
| Benefit Package Codes |
October 31, 2012 |
| Deduction Codes |
December 11, 2012 |
| Garnishment Codes |
March 22, 2013 |
| Pay and Leave Codes |
December 11, 2012 |
| Screen Message Codes |
September 12, 2012 |
| Work Schedule Codes, 7-days (One Week) |
January 23, 2013 |
| Work Schedule Codes, 14-days (Two Weeks) |
January 23, 2013 |
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.
|
January 23, 2013 |
|
|
|
| Screen Guides |
|
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 |
December 16, 2011 |
| 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.
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 |
November 9, 2012
|
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 |
May 19, 2011 |
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
|
|
|
|
|
|
|
|
|