The screening statement WHERE can be used in your report requests to make field to field comparisons. For example, the report request below compares the value of Employment Date to the value of (Appointment) Effective Date to identify new employees to the campuses in the last fiscal year.
EX EH
TABLE FILE EH
PRINT EH:WNAME
EH:POSITION
EH:EFFDATE
WHERE EH:TRANCODE EQ 'A50'
WHERE EH:EFFDATE FROM 20010701 TO 20020631
WHERE EH:EMPDATE EQ EH:EFFDATE
END
Before executing the report above, you must use the TR file to select SSN's with an A50 transaction in the last fiscal year and then hold those SSN's and position sequences (SSNPSN) to your PERMSML file. After that step is complete, create your EH file with the following parameters:
SSN: PERMSML
DATES: EFFECTIVE DATES FROM ___ TO ___
TYPE: ABSOLUTE
OUTPUT: EH
For more information on the WHERE command, refer to your FOCUS documentation/user manual.
For information on creating extract files, email the CIRS Help ([email protected]).
Last Updated: February 27, 2024