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.