• How can an Admin User emulate a Teacher in a previous year, if their security account no longer exists in the current year?


    Since security is handled in the current year, the Security account of the teacher needs to remain in the current year.  It should not be deleted, but it can be set to "Disabled".  If it has already been deleted, the DEL-tag can be removed via SQL.


UGN records UN Del tagged in SQL database - Sample query examples

Find your records to get the UID and confirm they are DEL tagged.


select * from ugn
where ln in ('xxxx','xxxxxx')

Back up the table

SELECT * INTO ugn_bak_20241008 FROM ugn
UN DEL tag the records

update ugn
set del = 0
where uid in (xxx,xxx)