The report below identifies an employee's earliest appointment to the campus by using the prefix operator MIN to identify the minimum effective date. The data is held to a temporary hold file and then evaluated to determine if the minimum effective date is greater than or equal to a specific date.
In the example below, the screening date is January 1, 2001.
EX TR
TABLE FILE TR
SUM MIN.TR:EFFDATE
BY TR:SSA
BY TR:WNAME
ON TABLE HOLD
END
-*
TABLE FILE HOLD
PRINT TR:SSA
TR:WNAME
IF TR:EFFDATE GE 01012001
END
Last Updated: March 1, 2024