Duplicate department records

[Vadla Srimaan]

Hello!

Need inputs on handling a data inconsistency scenario.

In our department table, few departments manually added via XML and users got assigned to them.

Again, from workday integration same departments data was created and some other users were assigned to them.

Now on SP portal, record producer forms have department question and users are seeing duplicate records and confused with what to select.

Now how to delete duplicate records?

Please guide me if you have fixed similar issue.

[Sandeep Rajput]

@Vadla Srimaan You need to address this issue with following steps.

1. Identify the duplicate departments: As a starting point, you need to identify the duplicate department first, name could be a criteria using which you can identify what all departments are duplicate on your instance.

2. Identify the users: Identify all users who are associated with the duplicate department. This is needed as you need to map the correct department on all such user records

3. Delete the duplicate entry: Once the correct department is mapped to user records, you can delete the duplicate department. 

You can write a fix script with Rollback option checked to perform all these steps.

[Voona Rohila]

@Vadla Srimaan - Adding to sandeep

Make sure you update the records which user raised with proper department values from background script before deleting the duplicate record.

[Dr Atul G- LNG]

Just to add,  expert's( @Sandeep Rajput  @Voona Rohila ) perspective, this is purely a data issue. After deleting (which you can do manually), make sure to update the reports/dashboard where this data has been used as a filter.

[Vadla Srimaan]

Hi @Sandeep Rajput ,

There is no specific identifier. For example, in the image below both departments have different users assigned to them.