An attribute named fsuEduPSHRexpireDate is populated for only those folks that are or will be terminated.

OMNI has the following values for Employee Status. I've placed a ‘/T' next to those that I believe should constitute terminated in the sense that their FSUID and CARS accounts could be removed.

A - Active
D – Deceased /T
L - Leave of Absence
P - Leave with Pay
Q - Retired with Pay
R - Retired
S - Suspended
T – Terminated /T
U – Terminated with Benefits /T
V – Terminated Pension Pay Out /T
W – Short Work Break
X – Retired-Pension Administration

Assuming all of an individual's appointments are terminated (meets one of the /T criteria above) then I will populate fsuEduPSHRexpireDate ; with the most recent date if multiple appointments exist.

Likewise, if any of an individual's appointments become active then I will delete any value in fsuEduPSHRexpireDate .

--Donny