sql query to get person number, hire date, hire title of a candidate if hired in the system

Summary:

Hi all,

I need to fetch the person number, hire date, and hire title of candidates hired in the Fusion system.

Could anyone please provide the relevant tables and joins that store this information? If anyone has a handy query or table joins, it would be very helpful.

Thanks.

Content (please ensure you mask any confidential information):

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

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