| OSPA Reference Manual, Fifth Edition |
|
|
|
 |
| Chapter 1: Introduction |
|
The purpose of this manual is to provide 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, it includes technical information on how to process transactions in OSPA, system reports and outputs, and recommendations about basic payroll procedures and controls.
All files below are pdf unless marked otherwise.
|
|
|
| Chapter 2: OSPA Screen Descriptions |
|
All files below are pdf unless marked otherwise
Screen
Number
|
Screen Title |
Effective Date |
| ADB1 |
Payroll Benefit Package Table |
May 8, 2009 |
| ADB2 |
Payroll Benefit Package Table |
February 13, 2007 |
| ADD1 |
Payroll Deduction Table |
May 15, 2009 |
| ADD2 |
Payroll Deduction Table |
May 16, 2008 |
| ADW1 |
Payroll Work Schedule Table |
August 31, 2006 |
| ADW2 |
Payroll Work Schedule Table |
August 31, 2006 |
| P001 |
Session Default Values |
August 31, 2006 |
| P002 |
Time Capture Screen |
July 2, 2009 |
| P003 |
Time Capture Screen |
July 2, 2009 |
| P004 |
Time Capture Screen |
July 2, 2009 |
| P005 |
Payroll Time Capture - Employee Entry Menu |
January 18, 2008 |
| P006 |
Payroll Time Capture - Supervisor Entry Menu |
October 3, 2008 |
| P007 |
Payroll Time Capture - Entered Pay Types by Day - Summary |
July 25, 2008 |
| P009 |
PIN Scrub Utility |
August 31, 2006 |
| P010 |
Withhholding Data / Locator Data |
May 22, 2009 |
| P020 |
Work Schedule Data |
August 31, 2006 |
| P030 |
Job Status Data |
December 31, 2007 |
| P031 |
Job Status Update |
July 2, 2009 |
| P032 |
Job Status Display |
August 31, 2006 |
| P050 |
Gross Pay Adjustments on File |
October 3, 2008 |
| P060 |
Tax/OPE Adjustments on File |
May 22, 2009 |
| P070 |
Deductions and Deduction Adjustments |
May 8, 2009 |
| P071 |
Cloning Utility |
April 20, 2007 |
| P080 |
Bond Data Entry |
August 15, 2008 |
| P081 |
OSPS Bond System - Person Locator |
January 4, 2007 |
| P090 |
YTD Wages, Taxes, and Retirement |
May 22, 2009 |
| P091 |
YTD Wages, Taxes, and Retirement - Calculated from P370 |
May 22, 2009 |
| P130 |
Check Reversal/Stop Payment |
August 31, 2006 |
| P140 |
Manual Checks |
June 26, 2009 |
| P160 |
Name Locator |
August 31, 2006 |
| P190 |
Payroll Register Data |
March 30, 2009 |
| P191 |
Register Summary |
May 28, 2009 |
| P192 |
Register Listing |
March 30, 2009 |
| P300 |
Vendor Checks |
June 26, 2009 |
| P310 |
Vendor Check Reversal/Stop Payment |
March 28.2008 |
| P320 |
Check Print Request |
March 28, 2008 |
| P370 |
Calculation of Current Payoff |
May 28, 2009 |
| P420 |
Leave Clearing Account Balances |
August 31, 2006 |
| P430 |
Employee Leave Data |
June 4, 2009 |
| P435 |
Employee Leave Data |
June 4, 2009 |
| PACH |
ACH Stops |
April 2, 2009 |
| PBAP |
PPDB Agency Table - Payroll |
September 28, 2007 |
| PCHG |
OSPS - Work Charge Entry Table |
August 31, 2006 |
| PMSG |
OSPS Newsletter |
August 31, 2006 |
| PRPT |
OSPS - Agency Report Selection |
August 31, 2006 |
| PSEC |
OSPS - Time Entry Security Table |
March 28, 2008 |
| PTB1 |
Payroll Benefit Package Table |
May 8, 2009 |
| PTB2 |
Payroll Benefit Package Table |
February 13, 2007 |
| PTD1 |
Payroll Deduction Table |
May 15, 2009 |
| PTD2 |
Payroll Deduction Table |
May 16, 2008 |
| PTW1 |
Payroll Work Schedule Table |
August 31, 2006 |
| PTW2 |
Payroll Work Schedule Table |
August 31, 2006 |
|
|
|
| Chapter 3: Report Descriptions |
|
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 |
May 8, 2009
|
E404-09-1
|
Agency Employees with Leave Type CT |
Yes |
May 1, 2009
|
E510A
E510C
|
Agency Overtime Report |
Yes |
November 9, 2006
|
XREFRL
|
Alpha Listing of Employee Checks |
No |
November 9, 2006
|
B010
|
Batch Time Capture |
No |
November 9, 2006
|
E469-05-1
|
Check Reconciliation File-in Agy/Mcr Sequence |
No |
May 15, 2009
|
E311-018A
|
Child Support Amounts by Agency |
No |
November 9, 2006
|
BONDE010
|
Contribution Register |
No |
November 9, 2006
|
ANNLDEC
|
Deceased Employees – Agency Summary |
Yes |
November 9, 2006
|
E322-01
|
Deductions Past Job End Date |
No |
November 9, 2006
|
XREF01
|
Deduction Reconciliation |
No |
November 9, 2006
|
XREF76
XREF76C
XREF76DC
XREF15
XREF15C
|
Deduction Register Detail & Summary |
Yes |
December 26, 2006
|
E122-077-01
E122-077-02
|
Employee Furlough Leave Used |
Yes
|
April 17, 2009 |
B055CC
B055RG
|
Employee Time Exception |
No |
November 9, 2006
|
| B360 |
Employee Update Screen Activity Report |
No |
December 7, 2007 |
E357-020
|
Employees Eligible for Participation in Retirement |
No |
August 17, 2007
|
E315-009A
|
Employees Unqualified for State Pay Benefits |
No |
November 9, 2006
|
XREF68N
|
Employees with Negative Amount(s) Listed |
No |
March 6, 2009
|
E497
|
Employees with Non-blank Waivers |
Yes |
August 22, 2008
|
XREF10A
|
FICA Mag-File Detail Note of Irregularities |
No |
April 11, 2008
|
XREF11
|
FICA Mag-File Summary for Tax Year #### |
No |
April 11, 2008
|
E512A
E512C
|
FMLA/OFLA Leave Hours
|
Yes |
March 30, 2009
|
B075A
B075B
|
Gross Pay Adjustments |
No |
November 9, 2006
|
E820-1
E820-2
E820-3
|
Gross Pay Adjustments Outdated |
No |
October 31, 2008
|
E260-100
|
Gross Pay Over 2.0 x Ajd Base Exception Report |
No |
November 9, 2006
|
E370-06-01
|
Income Tax Exemptions |
Yes |
November 15, 2008
|
XREF51
|
Insurance Analysis Exceptions |
No |
October 3, 2008
|
E460
|
Leave Accrual -- Adjustments and Transfers |
Yes |
April 17, 2009
|
E505-152
|
Leave Accrual – Employee’s Leave Balance and Usage |
Yes |
June 4, 2009
|
| E455 |
Leave Accrual - Exception Report |
No
|
March 19, 2009 |
B470C
B470CM
B470D
B470S
|
Leave Accrual Register |
Yes |
April 2, 2009
|
E461-01
|
Leave Adjustments Made to Closed Periods |
No |
April 17, 2009
|
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, 2006
|
E560-04-01
|
List of In/Outdated Deductions |
No |
November 15, 2008
|
E404-25-1
|
Lost Leave Accrual CT Balance |
Yes |
May 30, 2008
|
| E370-09-1 |
Mandatory Withholdings Determination |
No |
November 30, 2007 |
E311-018B
|
Negative Child Support Amounts by Agency |
No |
November 6, 2006
|
| E311-38 |
Negative Vendor ACH Generated This Run; To Be Used Next Payroll Run |
No |
April 9, 2009 |
|
Net Pay Negative Report
|
No |
November 9, 2006
|
| E397-120-01 |
Non-leave Time Recorded on Holiday
|
Yes |
November 9, 2006
|
| 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 17, 2009
|
| E701-30-A |
Outstanding Checks to be Purged from Check Recon |
No
|
May 15, 2009 |
XREF24
XREF18
|
P&F Extra Retirement Units |
Yes |
January 4, 2007
|
XREF87
|
Payroll Check Reversals |
No |
November 9, 2006
|
E315-009B
E315-009C
|
Payroll Deduction Adjustment F & W |
No |
March 6, 2009
|
E120-042A
E120-052A
E122-042A
E122-046A
E122-056A
|
Payroll Exception |
No |
January 30, 2009
|
XREF43
XREF44
XREF45
XREF46
XREF46D
|
Payroll Register |
Yes |
May 16, 2008
|
E120-052B
E122-042B
E122-042C
|
PEBB Domestic Partner |
Yes |
November 9, 2006
|
XREF16
XREF17
|
Regular Contributions |
No |
January 4, 2007
|
XREF32
|
Retirement Remittance Advice |
No |
November 9, 2006
|
BD115
BD115A
BD115B
BD115C
BD115D
|
Savings Bonds Listing |
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 15, 2008
|
E421-260-1
|
SSN Security Table Entries by RDC/Supervisor |
No |
November 9, 2006
|
E492
|
Terminated Employees Having Leave Balances |
Yes |
February 20, 2009
|
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 |
August 22, 2008 |
| E489-1 |
Year End Report: Total Regular Hours Worked |
Yes |
November 9, 2006 |
XREF68
|
Year to Date |
Yes |
April 11, 2008
|
XREF85
|
Year to Date and Current Correction |
No |
November 9, 2006
|
| EICRPT |
Yearly Earned Income Credit for Tax Year YYYY |
Yes |
November 14, 2008 |
* DM = Report can be reproduced or partially reproduced through use of the OSPA Datamart. Details are contained within the report description document.
|
|
|
| Chapter 4: OSPA Datamart |
|
What is the OSPA Datamart?
The OSPA Datamart is a repository for information processed through the Oregon Statewide Payroll Application (OSPA). Currently, information is available from 7/1/2001 to present.
The OSPA Datamart is updated monthly following final payroll cutoff of run 2. Specific dates are listed on the OSPS Processing Calendar (pdf).
Information is stored in various tables, which can be queried using any software that is ODBC-compliant. Hyperion Intelligence Explorer is the software supported by the Statewide Accounting and Reporting Services section of the State Controller's Division.
How do I access the OSPA Datamart?
You will need security clearance to the database tables, and ODBC-compliant querying software.
To request security clearance, agency security officers should contact systems security by e-mail or fax (503) 378-8940. For each request, include:
-
Name: (Same as in PPDB – Use PBER to verify)
-
User ID
-
User Telephone #
-
Agency Name/Mnemonic (initials) i.e. DAS-OBA, DAS-BAM, CBS, OYA
-
Agency Number
-
Internet E-Mail Address:
There are many ODBC-compliant software packages. A select few are Hyperion (formerly BrioQuery), Crystal Reports, and Microsoft Access.
Training for SFMA and OSPA Datamart usage are available through the Statewide Accounting and Reporting (SARS) section of the State Controller's Division. Additionally, DAS Statewide Training and Development Services conducts classes for Hyperion, Crystal Reports, and Microsoft Access software.
Why would I use the OSPA Datmart?
There are many, many uses for the OSPA Datamart. Here are just a few:
-
Custom Reports. Just about anything you can think of can be queried from the OSPA Datamart and customized to your specific needs. Do you need to complete a PERS salary breakdown? How about finding out how often someone uses sick leave? Curious about usage statistics for parking? All of these and much more can be queried from the OSPA Datamart.
-
Identify Errors. Use the OSPA Datamart to query for specific pay or deduction codes that give you troubles. For example, use the OSPA Datamart to ensure that each SEIU union deduction code has an accompanying issues code. Or, query to ensure that insurances are being forced using a subsidy code and not just plan codes.
-
Monitor for Potential Abuse. The OSPA Datamart is ideal for doing spot queries to ensure that usage of pay codes fall within normal tolerances. For instance, you can run a query on a specific class to enquire about comp time accrual, then measure that against an expected average. Or, query specific employee groups for abnormal overtime usage.
OSPA Datmart Table Information
Use the Master Reference Guide for all OSPA Datamart Table Fields (pdf) if you are not sure which table to use to build your query. Or if you want to know "Can I query for this?"
Extensions Reference Card (pdf). Use this to understand the _B, _PB, _PP, and blank extensions to the OSPA Datamart Tables.
Further Information
Further information including details about the OSPA Datamart tables and establishing a connection for Hyperion can be found on the SARS Datamart page.
|
|
|
| Chapter 5: Recommended Practices |
|
All files below are pdf unless marked otherwise
| Recommended Practice |
Effective Date |
| Checks, Manual |
April 24, 2009 |
| Checks, Stale Dated |
March 19, 2009 |
| Collective Bargaining Agreements |
May 20, 2009 |
| Deceased Employees |
June 6, 2008 |
| Leave, Donated Hardship |
March 6, 2009 |
| Leave, Family and Medical |
March 6, 2009 |
| Leave, Injured Worker |
January 30, 2009 |
| Leave, Military |
May 8, 2009 |
| New Employees |
January 16, 2009 |
| Separations |
February 13, 2009 |
| Taxes, Corrected W-2 |
June 26, 2009 |
| Taxes, Foreign Nationals |
September 14, 2007 |
| Taxes, Reimbursements and Fringe Benefits |
March 6, 2009 |
| Taxes, Withholding |
August 15, 2008 |
| Time and Attendance |
March 23, 2007 |
| Transfers |
May 8, 2009 |
| Volunteers, Americorp |
May 11, 2007 |
| Volunteers, Boards and Commissions |
July 20, 2007 |
| Volunteers, Unpaid |
August 22, 2008 |
| Year End |
October 31, 2008 |
| Additional Recommended Practices |
Still to Come |
|
|
|
| Chapter 6: Entry Guides |
|
All files below are pdf unless marked otherwise
| Entry Guide |
Effective Date |
| Direct Deposit |
January 23, 2009 |
| Leave, Adjust Balances |
February 20, 2009 |
| Leave, Advance |
February 20, 2009 |
| Leave, Pay Off |
February 27, 2009 |
| Leave, Restore Lost |
May 30, 2008 |
| Leave, Transfer |
February 23, 2007 |
| ODT, Approving Time |
October 3, 2008 |
| ODT, Entering Time |
April 24, 2009 |
| ODT, PIN |
September 12, 2008 |
| PEBB, Domestic Partners |
January 30, 2009 |
| PEBB, Opt Out |
January 23, 2009 |
| PEBB, Part-time and Job Share Employees |
January 30, 2009 |
| PEBB, Protected Leave, Full-time Employees |
February 13, 2009 |
| PEBB, Protected Leave, Part-time and Job Share |
February 13, 2009 |
| PEBB, Waive Benefits |
October 3, 2008 |
| PERS, Start Contributions |
June 4, 2009 |
| PERS, Wage and Contribution Adjustments |
August 15, 2008 |
| Time Capture, Entering Time |
May 30, 2008 |
| Time Capture, Timesheets |
April 24, 2009 |
| Additional Entry Guides |
Still to Come |
|
|
|
| Chapter 7: Interfaces |
|
All files below are pdf unless marked otherwise
|
|
|
| Chapter 8: Internal Controls |
|
Internal Control Guidebook and Suggested Plan
The Statewide Financial Services (SFS) Internal Control Guidebook (doc) provides an overview of the control process, including why we have internal controls and a suggested plan for evaluating and strengthening controls.
Appendix D (doc) of the Internal Control Guidebook, Page 32, provides specific guidelines for the payroll cycle.
Self-Assessment Tool for Payroll Internal Controls
SFS provides self-assessment tools for several financial responsibilities. The SFS Payroll Self-Assessment Tool (doc) helps you evaluate existing internal controls and identify strengths and weaknesses.
Internal Control and Risk Management Tools
The State Controller's Division, Statewide Financial Services section provides information and several related resources for internal control and risk management tools.
This resource includes internal control newsletters and training opportunities.
Policies and Procedures
The Oregon Accounting Manual (OAM) contains policies and procedures to guide you in your internal control practices.
Relevant policies and procedures include:
|
|
|
| Chapter 99: Appendices |
|
All files below are pdf unless marked otherwise
| Appendix |
Title |
Effective Date |
| A |
Work Schedule Codes database (mdb 2.85 MB)
-- PLEASE NOTE: This file must be downloaded to your computer before you can use it. Right-click the link, then choose "save" when prompted to do so.
|
July 2, 2009 |
| |
7-day Work Schedule Codes |
July 2, 2009
|
| |
14-day Work Schedule Codes |
July 2, 2009 |
| B |
Pay and Leave Codes |
June 26, 2009 |
| C |
Deduction Codes |
June 26, 2009 |
| D |
Reserved for Future Use |
N/A |
| E |
Screen Message Codes |
June 4, 2009 |
| F |
Forms (web) |
See forms page |
| G |
Garnishment Codes |
July 2, 2009 |
| H |
Benefit Package Codes |
May 1, 2009 |
| I |
List of Screens |
June 15, 2008 |
| J |
Reserved for Future Use |
N/A |
| K |
Microfiche |
August 24, 2007 |
| L |
Glossary (web) |
See glossary page |
|
|
|
| Chapter 100: Topical Guide |
|
Coming Soon
We're working on a comprehensive guide to the many topics represented in this OSPA Reference Manual.
Until that is completed, please use the handy search tool we've provided. You can limit the search to just OSPS, or expand to include all of the Department of Administrative Services' Web sites.
If you'd like to search all of Oregon.gov, please use the search box at the top right corner of every page.
|
|
| |
|
|
