Comparing Value To Value

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​