01
About this report
One row per active employee with login access and per role assigned to them. Each row gives the email, job title, supervisor, role, the role's centre type and whether it is a web-services-only role.
Filter on Role to see who holds Administrator or a finance role, or on Employee to review one person. Customer, vendor and partner centre logins are not employees and do not appear. The employee name opens the employee record.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Employee | Job title | Supervisor | Role | Centre type | Web services only | |
|---|---|---|---|---|---|---|
| Dana Whitfield | dana.whitfield@example.com | Account Executive | Tom Okafor | Sales Manager | SALESCENTER | No |
| Priya Natarajan | priya.natarajan@example.com | Controller | Tom Okafor | Accountant | ACCOUNTCENTER | No |
| Priya Natarajan | priya.natarajan@example.com | Controller | Tom Okafor | A/P Clerk | ACCOUNTCENTER | No |
| Tom Okafor | tom.okafor@example.com | Chief Financial Officer | Administrator | ACCOUNTCENTER | No | |
| Integration User | integrations@example.com | Integration Web Services | BASIC | Yes |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT e.id AS employee__id,
e.entityid AS employee,
e.email AS email,
e.title AS job_title,
BUILTIN.DF(e.supervisor) AS supervisor,
ro.name AS role,
ro.centertype AS center_type,
ro.iswebserviceonlyrole AS web_services_only
FROM employee e
JOIN employeerolesforsearch er ON er.entity = e.id
JOIN role ro ON ro.id = er.role
WHERE e.giveaccess = 'T'
AND e.isinactive = 'F'
ORDER BY employee, role