Identifying First Date In CBID

The sample report below identifies the first date a faculty or staff employee was placed into a CBID.

SSA NAME CBID EFF DATE
--- ---- ---- --------

111-11-1111 EmU, John R03 08/20/2003

It was generated using the Transaction Data (TR) file and the direct operator MIN to identify the earliest (minimum) effective date for each CBID held by each employee in the TR file, active or not. Note: The TR file does not contain transactions for students or special pay appointments.

EX TR

TABLE FILE TR

SUM min.tr:effdate

by tr:ssa

by tr:cbid

end

With modification, the report commands can be used as part of a match request with the Active Current Status (AC) file to obtain data only for current employees. The match option OLD-AND-NEW is used to match data only for records in the TR file with a matching record in the AC file.

EX TR

EX AC

match file tr

sum min.tr:effdate

by tr:ssa as 'ssa'

by tr:cbid as 'cbid'

run

file ac

print ac:wname

by ac:ssa as 'ssa'

by ac:cbid as 'cbid'

after match hold as 'permrpt'

old-and-new

end

TABLE FILE PERMRPT

PRINT ssa aS 'soc sec no'

cbid aS 'CURRENT,cbid'

tr:effdate as 'initial,date'

by ac:wname as 'employee'

end

The report request is available in the common library as FOC4004. For more information on the MIN. or MATCH command, refer to your FOCUS documentation or call the Hotline.