An attribute named fsuEduRetired was added to our Schema. It is indexed and contains one of the following values for individuals retired from FSU.

USPS
A&P
Faculty
OPS (This is for retired employees with a current OPS appointment)

These values are populated via the nightly script named mdsdata.uc.fsu.edu:/root/updateScripts/fsuEduRetired.pl

A table named FSZDBA.RETIRED_EMPLOYEES contains everyone who retired from the university and includes people from both the legacy HRMS data and OMNI data.  

This table is populated/updated via a nightly script named mdsdata.uc.fsu.edu:/root/updateScripts/RETIRED_EMPLOYEES.pl

--Donny