When we try to fecth the inactive employees data using OTBI we facing below the issue

Summary:

Hi Team,

when we try create the inactive employees data we facing the issue that is suppose some of employees have mutlipule terimation relationships like 'X' employee have assignment status is active- payroll and inactive-no payroll due to pending worker to employee and inactive-no payroll due to rehire like but when i try create the report when i put the filter is only inactive employees(Requirement ) but in report showing 'X' employee also but we need only inactive employess not like 'X' we need like 'Y' in the report .

Thanks,

Ajay

Content (please ensure you mask any confidential information):