Create An EH Current Status File

Various files in CIRS are referred to as 'current status files' because they provide a snap-shot of employment history on a specific date. However, if the time-frame of those files is not appropriate for your reporting needs, the Employment History (EH) extract process is a wonderful tool for generating a current status file for any point in time back to January 1, 1976 or when your campus began on PIMS.

To generate an EH current status file, make the following selections at the Employment History Extract Process screen. The resulting EH file can be used to generate ad hoc reports for 60 days, or until it is written over by another EH extract. For complete information on the Employment History Extract Process, refer to the CIRS User Manual.

EMPLOYMENT HISTORY EXTRACT PROCESS

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

SELECT SSN OPTION: 1 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 ______ TO ______ YYMMDD

FROM 760101 TO CURRENT

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

SELECT FILE TYPE 3 1. ABSOLUTE

2. RELATIVE

3. CURRENT STATUS

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

PRESS ENTER TO CONTINUE OR F3 TO EXIT

This option selects the SSN's of all employees in the Transaction (TR) file. The TR file contains employment history transactions for faculty, staff and management positions. A98 and A54 transactions are not maintained in the TR file, so those SSN's will not be supplied for the extract process, unless those employees also have a regular faculty or staff position .

The dates must be entered in a year, month, day format and must be equal. For example, to create an EH current status file as of March 30 2005, the dates would be entered as FROM 050330 TO 050330.

When a current status file type is selected, the extract process will select transactions in effect at close of business on the date specified for each position sequence held by the SSN's supplied. Note: This option can only be selected when the effective date option is selected and the dates entered for FROM and TO are equal.

After the selections above are made, and the enter key is pressed, you will prompted to include/exclude student assistant (A98 concurrent or prior assignments) and separated positions in the resulting EH file. To create an EH file that mimics the Active Current Status (AC) file, exclude those transactions.