​​​

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.

 

​__________________________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.  

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

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

  • File Type:  Absolute

​________________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

       AND             2. ENTRY DATES

ENTER DATE RANGE:         FROM 950501 TO 050301 YYMMDD

                          FROM 760101 TO CURRENT

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

SELECT FILE TYPE    1  1. ABSOLUTE

                       2. RELATIVE

                       3. CURRENT STATUS

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

 

                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