Quick Guide: Employment History Extract

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.

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.  

• SSN Option:  SSN's in Library Member: History

• Date Type:  Effective (enter date range FROM and TO)

• File Type:  Absolute

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.

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.

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.   

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.  

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.

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 |

|--------------------------------|