Listing database users details

Hi team,

I have audit task, i need to list all database users/schemas and provide certain details like Account Name / User’s Name / Email ID / Employee ID / Role, Profile, Access assigned to account /User Account Status (active/inactive) /Date Created /Date Modified /Date of Last Login. Database version is 12.1.

Since now i have only this :

select username, profile, decode(account_status,'OPEN','ACTIVE','INACTIVE') "ACCOUNT STATUS", created, last_login from dba_users;

I assume that i can query for email and employee id for personal accounts by looking HRMS tables like per_all_people_f or similar?

I have doubts regarding role as well, so i assume it would be good to put in list every role granted to user.