Delete Employees by Classification
This feature will delete a portion of the employee / user tables, based on classification.
All existing student data will be wiped out (for FERPA.) Staff data may be partially wiped out. However, faculty data will need to be left intact, so that students can assign cases and request prescriptions as normal.
This feature will also support deleting the new Class of #### that will be added under User Management, to allow for quick bulk delete of any previous students that don’t have full setup yet.
Faculty members running this may have to run the process multiple times, if they intended to clear out multiple employee classifications.
This function is new and does not have a related JSP script. These queries will need to be made from scratch.
Delete Employees based on EMPLOYEE_TYPE_MASTER
Use the selected Employee Classification from the EMPLOYEE_TYPE_MASTER table, and join it to the EMPLOYEE table.
Delete any employees with the selected TYPE MASTER in the EMPLOYEE.EMP_TYPE column.
Delete Employees based on the Class of 20XX Year:
Use the selected CLASS_YEAR field to delete any employees with that year entered. Unlike the Classification, this table won’t require a join - it should be straight forward.
A Warning
Like the Deletion of the transactional data, display a pop up box with the option
Success Message
If all the selected employees can be deleted, display a success message.
Error State
This process is intended to be completed after all the transactional data was erased. If the selected employees are still listed in any episodes, it will likely throw an error.
Or if there are any other errors encountered, display an appropriate message.