01
About this report
Counts from the employee records. For each department, the number of active employees, how many have NetSuite login access, how many are sales reps, and how many were hired in the last twelve months. Employees with no department show as (no department).
Compare With login access against the organisation chart when you review licences, and use Hired, last 12 months to see which departments are growing.
02
Sample preview
Fictional figures in the shape you will see. Yours come from your account.
| Department | Employees | With login access | Sales reps | Hired, last 12 months |
|---|---|---|---|---|
| Engineering | 42 | 18 | 0 | 7 |
| Sales and Marketing | 19 | 17 | 12 | 4 |
| Operations | 27 | 9 | 0 | 3 |
| Administration | 8 | 8 | 0 | 1 |
| (no department) | 2 | 1 | 0 | 0 |
03
The SuiteQL
This is the query each report runs. Read it, copy it, or change it after import.
SELECT NVL(BUILTIN.DF(e.department), '(no department)') AS department,
COUNT(*) AS employees,
SUM(CASE WHEN e.giveaccess = 'T' THEN 1 ELSE 0 END) AS with_access,
SUM(CASE WHEN e.issalesrep = 'T' THEN 1 ELSE 0 END) AS sales_reps,
SUM(CASE WHEN e.hiredate > ADD_MONTHS(TRUNC(SYSDATE), -12) THEN 1 ELSE 0 END) AS hired_12_months
FROM employee e
WHERE e.isinactive = 'F'
GROUP BY NVL(BUILTIN.DF(e.department), '(no department)')
ORDER BY employees DESC