How to get the Salary of terminated employee

Summary

How to get the Salary of terminated employee

Content

Hi Team,

We are extracting the employee salaries with the effective date of today using HCM extracts.. But this extract is giving '0' amount for the terminated employees(it is expected as terminated employee is not getting any salary for the given date).. But we need to bring the salary of the last working day amount in that field if that employee is terminated. 

please let me know if any one has worked extract for this scenarios or any ideas to achieve this one.

Thanks,

Pol