Person number of employee/contingent worker of a successful referred candidate

Summary:

Customer is looking for a report with the person number of the employee/contingent worker who has been successfully hired after being referred by an internal employee/contingent worker.

This is required to support the referral program of the customer.

Anyone having a catalog or SQL kindly share

Content (required):

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

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