Issue: One or more User (UGN) records are missing after rollover


Cause: This is due to the New Year Rollover UGN logic - if an account hasn't logged in within the last year, it's not rolled forward


To learn more about the New Year Rollover logic, click here



Solution: The records will need to be recreated in the current year
  • The following query will narrow down which accounts were set to be deleted during the rollover:
LIST UGN UN UID TY CD XD LDT IF TY = 1 AND ( LDT < 06/01/2023  OR LDT = NULL ) AND XD = NULL  AND UN ; "AERIES."  
  • Adjust dates accordingly