Selecting a Date Range
Entering SSN's in VERIFY$
Submitting and Verifying the Extract
Editing or Printing The Report
The Employment Verification Report provides a quick and simple method for verifying employee(s) gross pay and employment history over a range of calendar years. This option minimizes the effort to collect this information without performing multiple batch runs against the Payment History (PH) or Payment History Extract (PY) files, and an Employment History Extract (EH) file. You can select the default date range (current and two prior calendar years) or specify your own range of payment and employment history dates.
To select the Employment Verification Report, type a 3 as the selection at the Extract Data menu and press the enter key.
|-------------------- Extract Data -------------------| | | |
SELECT:
3 1. EH - EMPLOYMENT HISTORY EXTRACT FILE | | 2. PY - EMPLOYMENT HISTORY EXTRACT FILE | | 3. EMPLOYMENT VERIFICATION REPORT | |-----------------------------------------------------| |
The Employment Verification menu is displayed below. The steps are:
Selecting a range of payment and employment data.
Entering SSN's in your library member named VERIFY$ and submiting the extract.
Editing and/or printing the report.
Status Report EMPLOYMENT VERIFICATION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . SELECT RANGE: 1 1. YEAR-TO-DATE AND TWO PRIOR CALENDAR YEARS OF PAYMENT/EMPLOYMENT HISTORY DATA 2. ENTER PAYMENT HISTORY ISSUE DATES FROM 020101 TO 999999 YYMMDD ENTER EMPLOYMENT HISTORY EFFECTIVE DATES FROM 760101 TO 999999 YYMMDD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . NOTE: SELECT THE RANGE AND PRESS ENTER TO DISPLAY YOUR MEMBER
(VERIFY). ENTER SOCIAL SECURITY NUMBERS IN VERIFY$ FOR THE EMPLOYMENT VERIFICATION REPORT AND PRESS F3 TO SUBMIT.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PRESS ENTER TO SUBMIT OR F3 TO EXIT |
To specify the date range, type your selection at the prompt and press enter to receive your library member named VERIFY$.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT RANGE: 1 1. YEAR-TO-DATE AND TWO PRIOR CALENDAR YEARS OF PAYMENT/EMPLOYMENT HISTORY DATA 2. ENTER PAYMENT HISTORY ISSUE DATES FROM 020101 TO 999999 YYMMDD ENTER EMPLOYMENT HISTORY EFFECTIVE DATES FROM 760101 TO 999999 YYMMDD . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . |
Year-To-Date and Two Prior Calendar Years
By default, this is the selected date range. This option will provide you with the data most often requested on employment verification requests. When this option is selected, payment history and employment history issue dates are ignored.
The payment history data provided is the gross pay amount of payments issued during the current calendar year, including the current business month, and the last two calendar years.
The employment history data consists of transactions effective January 1, two calendar years back. If a transaction did not fall on January 1, then the next transaction date will be selected.
payment History Issue Dates and Employment History Effective Dates
The date range selection allows you the freedom to specify your own range of payment issue dates and transaction effective dates. Both date formats are YYMMDD. Century is automatically added to the dates specified.
Payment issue dates are available for a rolling 36 months. A value of 999999 entered as the TO date is equivalent to the last issue date of the previous business month.
Employment history effective dates are available from 76/01/01 up to the current date. There are no restrictions on the amount of history selected.
After selecting the range of payment and employment history and pressing the enter key, your library member named VERIFY$ will display. This member should only be used for the Employment History Verification extract. Type the selected SSN’s for the extract process into this library member. For information on available edit commands, refer to the topic:
Edit Report Requests.
EDIT PD.CSUCFOC.userid(VERIFY$) Columns 00001 00072 Command ===> Scroll ===> PAGE ****** ****************** Top of Data ************************ 000001 012-34-5678 000002 123-45-6789 000003 234-56-7890 ****** ***************** Bottom of Data ********************** |
SSN's for the extract can be entered in sequential or random order and with or without dashes.
Do not enter a position sequence next to the SSN. Position sequence selection is not valid for this type of extract. If a position sequence is entered after the SSN, it will be removed when the next extract is submitted.
It is more efficient and cost effective to submit multiple SSN's at once rather than running the extract for one SSN at a time.
After all the SSN’s are entered in your library member named VERIFY$ , press the F3 key to save the list and submit the extract job. A submission message will display either at the bottom of the screen or on a blank screen. For example:
JOB CTVuserid (JOB12345) SUBMITTED *** |
Note the job number and press enter to clear the message. The job number is used to check status messages to verify a successful extract. Do not proceed to the edit or print function until you have determined the status of your extract. Refer to the topic
Verifying a Successful Extract for more information.
After confirming a successful extract, the resulting batch report can be edited or printed from the action bar on the Employment Verification menu. Position your cursor over the word Report on the action bar and press the enter key. A pop-up window will appear with selection to edit or print the report.
Status Report EMPLOYMENT VERIFICATION |
To select an option, type the number of your selection at the prompt and press enter.
|------------------------------|
|
_ 1. EDIT BATCH REPORT |
| 2. PRINT BATCH REPORT |
|------------------------------|
Edit Batch Report
If this option is selected, your batch report will display in edit mode. For more information refer to the topic: Batch Results.
Print Batch Report
If this option is selected, the
printer options menu will appear. If desired, change the printer destination, number of copies and/or lines to print before pressing the enter key.
Below is a sample of the report:
08/01/03 THE CALIFORNIA STATE UNIVERSITY PAGE 1 EMPLOYMENT VERIFICATION REPORT PIMS REPORT PDC0016B ISSUE DATES: 01/01/01 - 08/08/12 NAME: SMITH JOHN T SSN: 111-22-3333 PAYMENT HISTORY INFORMATION: (THESE AMOUNTS MAY NOT MATCH THE GROSS PAY TOTALS LISTED ON THE EMPLOYEES W2 FORM) 2001 2002 2003 REGULAR: 999.00 99,999.00 99,999.00 OVERTIME: SHIFT: OTHER: 100.00 TOTAL: 1,099.00 99,999.00 99,999.00 EMPLOYMENT HISTORY INFORMATION: PSN SEP EFFECT TRAN POSITION CLASS TITLE TIME SALARY SAL EMPLOY PROB ANNI SEQ CDE DATE CODE BASE TOTAL PER DATE CODE DATE 01 T 08/21/03 645 000-111-2360-305 PROFESSOR AY FT 9,999.00 M 09/01/01 I 9999 T 08/22/02 S42 000-111-2360-305 PROFESSOR AY FT 9,999.00 M 09/01/01 I 9999 07/01/02 CRO 000-111-2360-305 PROFESSOR AY FT 9,999.00 M 09/01/01 I 9999 04/01/01 GEN 000-111-2360-305 PROFESSOR AY FT 9,999.00 M 09/01/01 I MAX 01/01/01 GEN 000-111-2360-305 PROFESSOR AY FT 9,999.00 M 09/01/01 I MAX 02 S 07/26/93 A54 000-111-2357-924 PROFESSOR SS IND .00 U 06/01/82 0000 03 S 08/23/87 S35 000-111-3306-905 ADMIN IIIA 001002 9,999.00 M 08/23/82 Q NONE |