Need to display active employees and terminated employees compared to previous run

Content

Hi All,

We have a requirement to display active employees for every run and terminated employees compared to previous run extract. Whether they will change or not, we need to always display active employees. 

Lets say for an example: the below two employees are active if we run every time these two records will display in the output. If we terminate 6787 employee, in the next run will display 12345 and 6787(terminated)  employees. After that if we run at anytime 6787 won't display in the output because we already displayed in the previous run as Inactive employee but we need to display 12345 employees whether they is a change or not.