Pull all active and terminated employee or single employee based on person number

Summary:

I want to fetch all the records of active and terminated employees or single employees based on the person number parameter and history of all the employee changes using SQL query and create a BI report on it

Content (required):

can anyone help on this

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):