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 





Last Updated: March 1, 2024