Skip to main content

Employees

The Employees menu counts the people a connected application knows as employees — the basis of the licences sold per employee. Three entries: Dashboard draws the headcount over time, Summary gives it per collection day and group, Details lists the people behind each figure. Open them from Applications → Employees.

Each collection takes a snapshot of the day: the history grows run after run, so a trend appears after a few collections.


At a glance​

The Dashboard draws one line per group — INTERNAL_COUNT and EXTERNAL_COUNT — with one point per collection day. Application narrows it to one application (or All); Excel and PDF export it, the refresh button reads it again.

EmployeesJDE employees — internal vs external headcount over time, per application.APPLICATIONAll ⌄ExcelPDF↻Updated at 08:12Employees — Internal vs External2401801206002026-07-012026-08-012026-09-012026-10-012026-11-01EXTERNAL_COUNTINTERNAL_COUNTApplicationone or all JDE systemsInternalsearch type E, from payrollExternalevery other search typeExcel · PDF · Refreshexport or read againOne point per collection daya snapshot each run

Summary​

Summary (License - JDE Employees) gives, for each application and collection day, the number of distinct people of each group.

License - JDE Employees10 rows · 12 msTableChart⌕ Search…▷ RunMax rows default▦ Views⏷ Filters⌘ Group▥ Columns⇩ Export ▾APPLICATION ID (I…APPLICATION IDEXTRACT DATEEMPLOYEES GROUP# EMPLOYEES···1JDE-PROD2026-11-01External52···1JDE-PROD2026-11-01Internal221···1JDE-PROD2026-10-01External44···1JDE-PROD2026-10-01Internal218Rows per page50 ⌄Showing 1–10 of 10« ‹ 1 2 … 3 › »Display EmployeesnavigateExtract Dateone snapshot per dayEmployees GroupInternal · External# Employeesdistinct address numbersRow actions (···)or right-click the rowDisplay Employeesthe people behind the countExportto Excel
ColumnSourceWhat it tells you
Application IDLEMP_APPS_ID — application identifier.The connected application.
Extract DateLEMP_DT_EXTRACT — day of the collection.Day of the snapshot.
Employees GroupInternal / External.Internal: search type E. External: any other search type.
# EmployeesDistinct address numbers.Headcount of the group that day.

The ··· button of a row (or a right-click) offers Display Employees: the Details of that application, filtered on the day and the group. Back, above the details, returns to the summary.


Details​

Details (License - JDE Employees - Details) lists the people, one line per address number and collection day.

License - JDE Employees - Details› ⏷ Advanced filters273 rows · 12 msTableChart⌕ Search…▷ RunMax rows default▦ Views⏷ Filters⌘ Group▥ Columns⇩ Export ▾APPLICATION ID (I…APPLICATION IDEXTRACT DATEEMPLOYEE IDEMPLOYEE NAMEEMPLOYEE TY…TYPECOMPANYSTART DATELAST WORK DATE1JDE-PROD2026-11-014021Doe, JohnEEmployees000012019-03-041JDE-PROD2026-11-014388Smith, AnnaEEmployees000012021-09-011JDE-PROD2026-11-017710Wilson, BobVSuppliers002002026-10-202026-10-31Rows per page50 ⌄Showing 1–50 of 273« ‹ 1 2 … 3 › »Employeeaddress number and nameEmployee Type · Typesearch type and its descriptionStart · Last work datefrom the payroll tablesAdvanced filtersapplication, date, groupGroupe.g. by company or type
ColumnSourceWhat it tells you
Application IDLEMP_APPS_ID — application identifier. Filterable.The connected application.
Extract DateLEMP_DT_EXTRACT — day. Filterable.Day of the snapshot.
Employee IDLEMP_ID — address number.The person.
Employee NameLEMP_NAME — name in the address book.Who it is.
Employee TypeLEMP_TYPE — search type code.E for an employee, another code otherwise.
TypeLEMP_TYPE_DESC — description of the search type.What the code means.
CompanyLEMP_COMPANY — home company.Where the person works.
Start DateLEMP_DT_START — first date known.Start of employment or of the first time entry.
Last work dateLEMP_DT_WORK — last date worked.Latest time entry.
Employees GroupInternal / External. Filterable.Group the person is counted in.
JDE-specific

The people are read from the JD Edwards EnterpriseOne payroll tables — the employee master (F060116) for the employees, and the time entry tables (F06116, F06116Z1) for the others — joined to the address book (F0101) for the name and the search type, whose description comes from the UDC 01/ST. A person found in several tables is counted once per day. The step runs with the licence collection (Jobs → Collect licences).


Tips & best practices​

  • Compare the last point with the contract. The figure that matters is the headcount on the date the licences are counted; the Dashboard shows whether it is stable or growing.
  • Read the External group carefully. People paid through time entry without an employee record (contractors, temporary staff) land there — check with HR whether the contract counts them.
  • Export the details of the day used for the licence count and keep the file with the compliance records.