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.