Merging Officers in PICSWeb

If a user has entered a duplicate officer record in PICSWeb, any user with Database Admin User Permissions can merge the duplicate officer with the original, preserving any links between either officer and any learners or organisations.

If necessary, you can use this process to merge up to 10 duplicate records.

To merge officers, you will first need to find all duplicates in the Officer List. You may want to use the filters above the list to get the officers to display in the same page.

Once you have found the duplicates, use the tickboxes to select all duplicate officers. The Database Admin Actions menu will then appear.

Expand the menu and select Merge Officers. This will open a window where you can choose which record you want to Keep. Any related records from the deleted records will be transferred to the kept one. Once you have made your choice, select Save to merge the officers.

Bear in mind that if any officer has a user account linked, you will only be able to include it in a merge if it is the Kept officer.


Once the officers have been merged, you will be prompted to refresh the list. Select Yes to continue.

The list will then display only the officer you chose to keep, with the discarded officers permanently deleted.