How to query user details if person_id and party_id are null and no data in per_ldap_users?

Summary:

Customer has requested a report to display all the usernames along with their first name, last name, email etc. I have encountered a username for whom person_id and party_id are null in the per_users table. The table PER_LDAP_USERS is also not having any data for this user (joined with per_users by USER_GUID) I can see the first name, last name and email for this user on the Users screen (Tools -> Security Console -> Users) With which table can I join per_users to get the required details? Q2: Which table-column holds the information if the user is locked or