This guide provides an overview of the steps required for creating an Employment History Extract (EH) file for a single employee, and then using that file to generate a report request. For a detailed discussion of the various functions and menus, refer to the topics referenced in the steps below.
Step 1:
From the main ad hoc reporting screen in your personal library, press the F12 key to access the Extract Functions.
__________________________CIRS PERSONAL LIBRARY_______________________
Cmds B Browse C Copy D Delete E Edit Row 1 of 17
P Print R Rename S Submit Batch O Online Execution
Cmd Name Description Changed
_ AAREPORT ANNUAL AFFIRMATIVE ACTION REPORT 2003/05/23
_ CURRENT CURRENT EMPLOYEE LIST - RUN QUARTERLY 2003/05/23
_ EMPHIST EMPLOYMENT HISTORY REPORT 2003/05/28
FACULTY FACULTY STATS 2003/05/14
F1=Status F2=New F3=Exit F4=Locate F5=Sort F6=Swap Lib
F7=Up F8=Down F9=Search F10=Results F11=HoldFile F12=Extract
Step 2:
At the Extract Data menu, type 1 as the selection and press the enter key.
|-------------------- Extract Data -------------------|
| |
| SELECT: 1 1. EH - EMPLOYMENT HISTORY EXTRACT FILE |
| 2. PY - EMPLOYMENT HISTORY EXTRACT FILE |
| 3. EMPLOYMENT VERIFICATION REPORT |
|-----------------------------------------------------|
Step 3:
At the Employment History Extract Process menu, make the following selections and press enter to continue.
________________EMPLOYMENT HISTORY EXTRACT PROCESS_______________
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT SSN OPTION: 2 1. ALL SSN'S IN THE TR FILE
2. SSN'S IN LIBRARY MEMBER: HISTORY
3. SSN'S IN HOLD FILE: PERMSML
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT DATE TYPE: 1 1. EFFECTIVE DATES
ENTER DATE RANGE: FROM 950501 TO 050301 YYMMDD
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT FILE TYPE 1 1. ABSOLUTE
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
PRESS ENTER TO CONTINUE OR F3 TO EXIT
Step 4:
Select additional options (if needed), confirm the current selections and press enter to continue.
|----------------- EH ADDITIONAL OPTIONS ------------------|
| |
| N (Y OR N) INCLUDE A98 TRANSACTIONS FOR SSN'S SUPPLIED |
| N (Y OR N) INCLUDE VOIDS, FIXES, DELETES, ELIMINATES |
| N (Y OR N) INCLUDE A54 TRANSACTIONS |
| |
| -------- CURRENT SELECTIONS ------- |
| SSN OPTION: FOCEXEC(HISTORY) |
| DATE TYPE: EFFECTIVE |
| FROM: 1995/05/01 TO 2005/03/01 |
| FILE TYPE: ABSOLUTE |
| |
| ENTER TO CONTINUE - F3 TO CANCEL |
|----------------------------------------------------------|
Step 5:
Type the employee SSN in your library member named HISTORY and press the F3 key to save and submit. Note the job number on the submission message. Press the F3 key twice to clear the message and return to the main menu.
EDIT PD.CSUCFOC.userid(HISTORY) Columns 00001 00072
Command ===> Scroll ===> PAGE
****** ****************** Top of Data ***********************
000001 123-45-6789
****** ***************** Bottom of Data *********************
JOB CTHuserid (JOB34567) SUBMITTED
***
Step 6:
From the main ad hoc reporting screen, press the F1 key to view the status message and confirm the extract job completed. Press enter to clear the message.
CTHuserid JOB34567 EH EXTRACT JOB COMPLETED SUCCESSFULLY.
***
Step 7:
From the main ad hoc reporting screen in your personal library, press the F4 key to locate a report request in your personal library that uses the EH file. (If you don't have one, you can create a new report request, or copy one from the common library.)
|----------Locate Report Request---------|
| ENTER REPORT REQUEST NAME |
| OR |
| BEGINNING LETTERS |
| |
| NAME: EMPHIST_ |
|----------------------------------------|
Step 8:
Execute the report request using batch execution by typing an 'S' at the command line to the left of the report request name and press enter.
___________________________CIRS PERSONAL LIBRARY______________________
Cmds B Browse C Copy D Delete E Edit Row 1 of 17
P Print R Rename S Submit Batch O Online Execution
Cmd Name Description Changed
s EMPHIST EMPLOYMENT HISTORY REPORT 2003/05/28
_ FACULTY FACULTY STATS 2003/05/14
Step 9:
The system will automatically select the required file(s). If the file confirmation panel is turned on, you will receive a file selection menu. Press enter to confirm.
|--------------- Confirm Batch FOCUS File Selections -------------|
|. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .|
| REPORT REQUEST : EHREPORT . |
|. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .|
| DIRECT OUTPUT TO : 1 1=REPORT FILE 2=PRINTER |
|. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .|
| CAMPUS FILES (FILE SELECTION = X) |
| AC ACTIVE CURRENT STATUS . PY PAYMENT HISTORY EXTRACT |
| _ AN CURRENT STATUS 10/31/__ . _ PHS PAYMENT DATA SUMMARY |
| _ A54 TRANSACTION DATA . _ SN SENIORITY POINTS |
| _ CH CAMPUS HEADER . _ SP SEPARATED CURRENT STATUS|
| X EH EMPLOYMENT HISTORY EXTRACT _ ST STUDENT ASSISTANT |
| _ LV LEAVE FILES (ALL) . _ TR TRANSACTION DATA |
| _ PH PAY DATA FY 02/03 . _ UI UNEMPLOYMENT DATA |
| _ PH PAY DATA PRIOR MONTH . |
| |
| SYSTEMWIDE FILES (FILE SELECTION = X) |
| X PS PAY SCALES . _ SAN CURRENT STATUS 10/31/__ |
| _ SAC ACTIVE CURRENT STATUS . _ STR TRANSACTION DATA |
| |
| ENTER TO CONTINUE = F3 TO CANCEL |
|-----------------------------------------------------------------|
Step 10:
Note the job number and press enter to clear the message.
JOB CTBuserid (JOB23456) SUBMITTED
***
Step 11:
From the main ad hoc reporting screen in your personal library, press the F1 key to view the status message and confirm the batch job completed. Press enter to clear the message.
CTBuserid JOB23456 FOCUS BATCH JOB COMPLETED SUCCESSFULLY.
***
Step 12:S
After the job completes, press the F10 key to access the batch results. Type your selection (e.g., 2) and press enter.
|----- Batch Report Results -----|
| |
| SELECT: 2 1. EDIT REPORT |
| 2. PRINT REPORT |
| 3. DOWNLOAD REPORT |
|--------------------------------|
Last Updated: April 5, 2024