Sample Request: Identifying New Hires

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