| 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 16, 2008 |
| ADB2 |
Payroll Benefit Package Table |
February 13, 2007 |
| ADD1 |
Payroll Deduction Table |
June 20, 2008 |
| 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 |
August 22, 2008 |
| P003 |
Time Capture Screen |
August 22, 2008 |
| P004 |
Time Capture Screen |
July 25, 2008 |
| 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 |
July 18, 2008 |
| P020 |
Work Schedule Data |
August 31, 2006 |
| P030 |
Job Status Data |
December 31, 2007 |
| P031 |
Job Status Update |
August 31, 2006 |
| P032 |
Job Status Display |
August 31, 2006 |
| P050 |
Gross Pay Adjustments on File |
October 3, 2008 |
| P060 |
Tax/OPE Adjustments on File |
August 30, 2007 |
| P070 |
Deductions and Deduction Adjustments |
June 20, 2008 |
| 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 2, 2008 |
| P091 |
YTD Wages, Taxes, and Retirement - Calculated from P370 |
April 11, 2008 |
| P130 |
Check Reversal/Stop Payment |
August 31, 2006 |
| P140 |
Manual Checks |
June 6, 2008 |
| P160 |
Name Locator |
August 31, 2006 |
| P190 |
Payroll Register Data |
November 15, 2007 |
| P191 |
Register Summary |
April 11, 2008 |
| P192 |
Register Listing |
May 11, 2007 |
| P300 |
Vendor Checks |
August 31, 2006 |
| P310 |
Vendor Check Reversal/Stop Payment |
March 28.2008 |
| P320 |
Check Print Request |
March 28, 2008 |
| P370 |
Calculation of Current Payoff |
October 3, 2008 |
| P420 |
Leave Clearing Account Balances |
August 31, 2006 |
| P430 |
Employee Leave Data |
August 31, 2006 |
| P435 |
Employee Leave Data |
February 15, 2008 |
| 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 |
February 13, 2007 |
| PTB2 |
Payroll Benefit Package Table |
February 13, 2007 |
| PTD1 |
Payroll Deduction Table |
April 11, 2008 |
| 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 |
September 12, 2008
|
E404-09-1
|
Agency Employees with Leave Type CT |
Yes |
May 30, 2008
|
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 |
August 17, 2007
|
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 |
November 9, 2006
|
EICRPT
|
Earned Income Credit |
Yes |
November 9, 2006
|
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 |
August 22, 2008
|
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 |
November 9, 2006
|
B075A
B075B
|
Gross Pay Adjustments |
No |
November 9, 2006
|
E820-1
E820-2
E820-3
|
Gross Pay Adjustments Outdated |
No |
November 9, 2006
|
E260-100
|
Gross Pay Over 2.0 x Ajd Base Exception Report |
No |
November 9, 2006
|
E370-06-01
|
Income Tax Exemptions |
Yes |
November 9, 2006
|
XREF51
|
Insurance Analysis Exceptions |
No |
October 3, 2008
|
E460
|
Leave Accrual -- Adjustments and Transfers |
Yes |
November 9, 2006
|
|
Leave Accrual – Employee’s Leave Balance and Usage |
Yes |
November 9, 2006
|
B470C
B470CM
B470D
B470S
|
Leave Accrual Register |
Yes |
July 18, 2008
|
E461-01
|
Leave Adjustments Made to Closed Periods |
No |
August 17, 2007
|
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 9, 2006
|
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
|
|
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 |
January 5, 2007 |
E475-B
|
OPEU FLSA Exempt Employees with Comp Time Balances |
Yes |
May 30, 2008
|
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 |
November 9, 2006
|
E120-042A
E120-052A
E122-042A
E122-046A
E122-056A
|
Payroll Exception |
No |
October 3, 2008
|
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 |
August 17, 2007
|
E421-260-1
|
SSN Security Table Entries by RDC/Supervisor |
No |
November 9, 2006
|
E492
|
Terminated Employees Having Leave Balances |
Yes |
February 23, 2007
|
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
|
* 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 |
| Deceased Employees |
June 6, 2008 |
| Leave, Injured Worker |
August 15, 2008 |
| Leave, Donated Hardship |
May 16, 2008 |
| Leave, Family and Medical |
May 16, 2008 |
| Leave, Military |
September 12, 2008 |
| Manual Checks |
January 18, 2008 |
| New Employees |
February 15, 2008 |
| Separations |
June 6, 2008 |
| Taxes, Corrected W-2 |
September 14, 2007 |
| Taxes, Foreign Nationals |
September 14, 2007 |
| Taxes, Reimbursements and Fringe Benefits |
May 16, 2008 |
| Taxes, Withholding |
August 15, 2008 |
| Time and Attendance |
March 23, 2007 |
| Transfers |
June 6, 2008 |
| Volunteers, Americorp |
May 11, 2007 |
| Volunteers, Boards and Commissions |
July 20, 2007 |
| Volunteers, Unpaid |
August 22, 2008 |
| Year End |
April 4, 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 |
April 20, 2007 |
| Leave, Adjust Balances |
May 30, 2008 |
| Leave, Advance |
May 30, 2008 |
| Leave, Pay Off |
January 5, 2007 |
| Leave, Restore Lost |
May 30, 2008 |
| Leave, Transfer |
February 23, 2007 |
| ODT, Approving Time |
October 3, 2008 |
| ODT, Entering Time |
September 12, 2008 |
| ODT, PIN |
September 12, 2008 |
| PEBB, Domestic Partners |
January 5, 2007 |
| PEBB, Force Premiums |
May 16, 2008 |
| PEBB, Opt Out |
October 3, 2008 |
| PEBB, Part-time and Job Share Employees |
May 16, 2008 |
| PEBB, Waive Benefits |
October 3, 2008 |
| PERS, Start Contributions |
February 15, 2008 |
| PERS, Wage and Contribution Adjustments |
August 15, 2008 |
| Time Capture, Entering Time |
May 30, 2008 |
| Time Capture, Timesheets |
January 11, 2008 |
| 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.
|
September 19, 2008 |
| |
7-day Work Schedule Codes |
September 19, 2008 |
| |
14-day Work Schedule Codes |
September 19, 2008 |
| B |
Pay and Leave Codes |
September 19, 2008 |
| C |
Deduction Codes |
October 3, 2008 |
| D |
Reserved for Future Use |
|
| E |
Screen Message Codes |
October 3, 2008 |
| F |
Forms (web) |
January 26, 2007 |
| G |
Garnishment Codes |
October 3, 2008 |
| H |
Benefit Package Codes |
May 16, 2008 |
| I |
List of Screens |
June 15, 2007 |
| J |
Reserved for Future Use |
N/A |
| K |
Microfiche |
August 24, 2007 |
| L |
Glossary (web) |
November 21, 2007 |
|
|
|
| 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.
|
|
| |
|
|
