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
For an additional example of using prefix operators, see the sample program: Minimum, Maximum and Average Salary By Class.
Related Topic: Identifying An Employee's Most Recent Appointment