Issues reporting on employee relations tables

[Austin Fassinge]

Has anyone had any luck reporting on the employee relations tables? With the Corrective Actions and the outcomes being on different tables, it is difficult to report on this. We have a database view but are seeing a lot of duplicates. Any suggestions or success stories would be greatly appreciated. 

Thank you!

[Susan Britt]

What specifically are you wanting in your report?  If you share your database view setup, we can try to help resolve your duplicate records.

[Austin Fassinge]

@sbritt Thank you for your response.

We are looking to have a report that allows us to view the allegation type, allegation sub-type, outcome and corrective action on one table. Along with the standard case fields and the involved party type, which we can reference from the corrective action table. Currently we have the following database view but are removing the involved parties because it is causing the bulk of the duplicates:

After this, if we have a case with 2 results and 2 outcomes, we get 4 records for one case. 

Thank you!

[Sowmya18]

Hi Austin,

Did you find a solution for this issue?

Thanks

Sowmya

[wysenk]

Hi there, did you manage to get a solution for this item?