SSN Option |
Date Type |
File Type |
Additional Options |
Submitting The Extract
The Employment History Extract process allows you to build a file containing transactions keyed by your campus payroll staff to the Personnel/Payroll Management Information System (PIMS). Transactions are available from 1976, when PIMS began, up to the current moment. The resulting Employment History Extract (EH) file can be used to generate ad hoc reports and is available for 60 days, or until it is overwritten. Refer to the
CIRS Data Element Dictionary for a description of the EH file.
To choose this type of extract, select option 1 from the Extract Data menu and press the enter key.
|-------------------- Extract Data -------------------|
1 1. EH - EMPLOYMENT HISTORY EXTRACT FILE |
| 2. PY - EMPLOYMENT HISTORY EXTRACT FILE |
| 3. EMPLOYMENT VERIFICATION REPORT |
The Employment History Extract Process screen is shown below and has three sections: SSN option, date type and range, and file type. The settings from the last extract are displayed and can be typed over, if needed. Complete each section before pressing the enter key to continue the extract process.
EMPLOYMENT HISTORY EXTRACT PROCESS
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT SSN OPTION: _ 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. EFFECTIVE DATES
AND 2. ENTRY DATES
ENTER DATE RANGE: FROM
FROM 760101 TO CURRENT
SELECT FILE TYPE _ 1. ABSOLUTE
3. CURRENT STATUS
PRESS ENTER TO CONTINUE OR F3 TO EXIT
The transactions extracted from PIMS for your EH file depend on your selections for the SSN option, date type and range, and file type (profile). Refer to the
Employment History Extract Profiles for examples of selection criteria and the resulting extracted transactions.
In order to extract information from PIMS, you must supply CIRS with a list of social security numberâ€™s (SSNâ€™s). You can choose one of three options to supply SSNâ€™s for the extract process: the All SSN file, your library member named HISTORY, or your permanent hold file named PERMSML. To specify the SSN option, type your selection at the prompt.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT SSN OPTION: 1. ALL SSN'S IN THE TR FILE
2. SSN'S IN LIBRARY MEMBER: HISTORY
This option supplies a list of SSNâ€™s from the Transaction Data (TR) file for the extract process. The TR file contains all transactions for your faculty and staff, active or separated, from 1976 to current. This option should only be used to extract a narrow range of historical information (i.e., one year or less) due to the volume of data that will be extracted. If that time-frame is not sufficient, contact the HR-ISA Hotline.
This option is used to manually type selected SSNâ€™s into your library member named HISTORY. This method of supplying SSN's for the extract process is used when you need employment history for a small group of specific employees (usually, 20 or less) and their SSNâ€™s are known. When this option is selected, your library member named HISTORY will automatically display after the confirmation screen. SSN's can be entered after confirming the extract selections, or before initiating the extract process.
EDIT PD.CSUCFOC.userid(HISTORY) Columns 00001 00072
Command ===> Scroll ===> PAGE
****** *************** Top of Data **********************
****** ************** Bottom of Data *********************
Enter one SSN per line, with or without the dashes.
The SSNâ€™s do not have to be in numerical order.
You can optionally supply a position sequence number (PSN) immediately following the SSN. The format is 999999999xx or 999-99-9999xx, where 999999999 is the SSN and xx is the PSN.
If you do not supply a PSN for a SSN, you will receive data for all position sequences at your campus.
When a PSN is supplied, only that position sequence is extracted.
If you want to extract data for multiple PSN's for an employee, supply each SSN and PSN on a separate line..
Your library member named HISTORY should only be used for the EH extract process.
For information on available edit commands, refer to the topic:
Edit Report Requests.
This option is used to select the SSNâ€™s placed in your hold file named PERMSML for use with the extract process. Before this option can be selected, you must first supply SSNâ€™s to your PERMSML file either by creating a hold file (discussed below) or by using the
upload function. With either method, the SSN's do not need to be in numeric order and can be listed with or without hyphens. Any duplicate SSN's will be ignored.
The following is an example of a report request used to write SSNâ€™s to your PERMSML hold file. (For more information on hold files, refer to your FOCUS documentation.) In this example, only employees in Collective Bargaining Id R01 will be held. The field AC:SSAPSN resides on the second level of the AC file and contains both the SSN and position sequence concatenated into one field. Using this field, the extract process will only select positions that are R01 for the selected SSNâ€™s. If all position sequences are wanted, use the field AC:SSA.
TABLE FILE AC
IF AC:EMPCBID EQ R01
ON TABLE HOLD AS PERMSML
When the report request above is executed in either the online or batch environment, the message HOLDING..., will appear to indicate processing is complete. The list of SSNâ€™s will not display, but the resulting hold file can be browsed. Alternately, you can view the data held in PERMSML by executing the following commands:
TABLE FILE PERMSML
After selecting the SSN option, you must specify whether to extract transactions based on effective dates or key entry dates, and enter the date range. The dates must be entered as YYMMDD (year, month, day) without spaces, hyphens, etc. The maximum range of dates available is from January 1, 1976 (760101) to the current date. If you want a specific day (e.g., June 30, 2004), both the FROM and TO date will be 040630. To select effective or entry dates, type your selection at the prompt and enter the date range.
SELECT DATE TYPE: 1. EFFECTIVE DATES
2. ENTRY DATES
Use this option to select transactions based on the effective date of the action. You can enter a specific effective date, or a range of effective dates. Dates can be selected through the current business day.
Use this option to select transactions based on when the action was key entered*. You can enter a specific key entry date or range of key entry dates. A range of dates through the prior business day can be selected.
*Note: You can not extract transactions with a D, E, F or V suffix based on the entry date of the corrective action because those transaction records reflect the entry date of the
original action, not the date when the corrective action was taken.
After selecting the SSN option and date type and range, you must select the file type. The three file types are: absolute, relative or current status. To select a file type, enter your selection at the prompt.
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
SELECT FILE TYPE 1. ABSOLUTE
An absolute file type will select transactions that fall on or within the specified dates. This file type can be used with EFFECTIVE or ENTRY dates.
A relative file type will select transactions that fall on or within the specified dates and also the prior transaction if an SSN does not have a transaction effective on the FROM date. This file type can only be used with EFFECTIVE dates.
If the ALL SSN's option is selected with this file type, then only position sequences active on or within the specified date range will have transaction(s) extracted.
If the HISTORY or PERMSML option is used to supply SSN's for this file type and the employee separates before the specified date range, then the most current transaction (i.e., separation transaction) will be extracted.
A current status file type will select only the most current transaction as of the date specified. This file type can be selected only if you entered a specific EFFECTIVE date (i.e., the FROM/TO dates are the same).
After all selections are made and the enter key is pressed, you will receive a screen with additional options. The options offered will vary depending on which file type was selected. To select an option, type a Y (yes) over the N.
For relative and absolute file types, you will be prompted to include A98 transactions, voided (etc.) transactions, and A54 transactions.
|----------------- EH ADDITIONAL OPTIONS ------------------|
| N (Y OR N) INCLUDE A98 TRANSACTIONS FOR SSN'S SUPPLIED |
| N (Y OR N) INCLUDE VOIDS, FIXES, DELETED, ELIMINATES |
| N (Y OR N) INCLUDE A54 TRANSACTIONS |
For a current status file type, you will be prompted to include A98 transactions and separated transactions.
| N (Y OR N) INCLUDE SEPARATIONS |
If you choose to include separated transactions, you will also be prompted to include A54 transactions and prompted to exclude separations older than a specific date.
| EXCLUDE SEPARATIONS OLDER THAN _______________ YYMMDD |
Note: If A54 transactions are included, and the ALL SSN option was selected, the extract process will select all transactions from the A54 Transaction (A54) file that meet your date type and range criteria, whether or not the SSN's for those transactions exist in the TR file.
After the additional options are selected, (if any) the current selections will display for your confirmation. If any changes are needed, press the F3 key to return to the Employment History Extract Process menu. Otherwise, press the enter key to submit your extract job. For example:
|------------------- CURRENT SELECTIONS -------------------|
| SSN OPTION: ALL SSN |
| DATE TYPE: EFFECTIVE |
| FROM: 2005/04/01 TO 2005/04/01 |
| FILE TYPE: CURRENT STATUS |
| A98 TRANS: EXCLUDE |
| SEPARATIONS: EXCLUDE |
| ENTER TO SUBMIT - F3 TO CANCEL |
A submission message will display either at the bottom of the screen or on a blank screen. Note the job number, and press the enter key to clear the message.
JOB CTHuserid (JOB12345) SUBMITTED
If your library member named HISTORY was used to provide SSN's for the extract process, the submission message will display after the SSN's are typed into HISTORY and the F3 key is pressed.
Use the job number to check status and system notification messages.
Do not submit another EH extract until the first one has completed and you have finished using the output.
Before executing a report request against your extract file, confirm your job completed successfully and there are no employees with an overflow condition. For more information, refer to the topic,
Verifying a Successful Extract.