HCM module OTBI / SQL report on employee information

Summary:

SQL / OTBI report related to LE / BU / Employee first name & Last name / Person number/ Person ID/ Person type /contact with email / Department / User name if the user account created

Content (please ensure you mask any confidential information):

Hi Team,

We would like to have the reconciliation report of HCM but we cannot find any standard report related to generate specific information

could anyone help to provide SQL / any standard OTBI report to generate below information which may help to verify after employee import and user creation
LE: employee assigned to Legal entity

BU: Business unit

Pers

Person type which included Employee and Contingent worker