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.
Summary
Summary (License - JDE Employees) gives, for each application and collection day, the number of distinct people of each group.
| Column | Source | What it tells you |
|---|---|---|
| Application ID | LEMP_APPS_ID — application identifier. | The connected application. |
| Extract Date | LEMP_DT_EXTRACT — day of the collection. | Day of the snapshot. |
| Employees Group | Internal / External. | Internal: search type E. External: any other search type. |
| # Employees | Distinct 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.
| Column | Source | What it tells you |
|---|---|---|
| Application ID | LEMP_APPS_ID — application identifier. Filterable. | The connected application. |
| Extract Date | LEMP_DT_EXTRACT — day. Filterable. | Day of the snapshot. |
| Employee ID | LEMP_ID — address number. | The person. |
| Employee Name | LEMP_NAME — name in the address book. | Who it is. |
| Employee Type | LEMP_TYPE — search type code. | E for an employee, another code otherwise. |
| Type | LEMP_TYPE_DESC — description of the search type. | What the code means. |
| Company | LEMP_COMPANY — home company. | Where the person works. |
| Start Date | LEMP_DT_START — first date known. | Start of employment or of the first time entry. |
| Last work date | LEMP_DT_WORK — last date worked. | Latest time entry. |
| Employees Group | Internal / External. Filterable. | Group the person is counted in. |
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.