LIST EMPLOYEE COUNTS #
Processing Information#
The List Employee Counts (REEC) report allows you produce a report on how many employees are in a specific entity. The report also allows you to limit the count by area or specific employee type.Report Parameters & Filters#
| Report Parameters | |
|---|---|
| As of Date | Date, LOV Available This is the date used to retrieve employee, group and position information. |
| From Date | Date, LOV Available This field will identify the date from which the assignments will be reported. |
| To Date | Date, LOV Available This field will identify the date up to which the assignments will be reported. |
| Work Timed Element | Mandatory, LOV Available This will limit the report to the pay elements (defined on IPPE) selected. The element is used to calculate the FTE Hours column in concert with: *the number of pay periods a person had Pay Headers for in the time period specified by the From/To dates, and *the Standard Hours per Pay Period as specified on the POSITION for the person. |
| Exclude Type“T, I, P” | Optional, Toggle If Yes is selected, then employees whose Employment Status is of type "Terminated", "Inactive" or "Pending" will also be counted (otherwise they are included in the count) |
| Break Level | Mandatory, LOV Available |
| User Comment | Optional, Text This field holds the user-supplied comment which will appear in the header of all pages of the report. |
| Report Filters | |
|---|---|
| People List | Optional, Multiple Selection Available, LOV Available This will limit the report to the people lists listed. |
| Person | Optional, Multiple Selection Available, LOV Available This will limit the report to the individuals listed. |
| Entity | Optional, LOV Available This field limits the report to the single entity selected. |
| Location | Optional, Multiple Selection Available, LOV Available This will limit the report to the locations selected |
| Auth Area | Optional, Multiple Selection Available, LOV Available This will limit the report to the authorization areas selected |
| Department | Optional, Multiple Selection Available, LOV Available This will limit the report to the departments selected. |
| Org Level Type | Optional, Lexicon Available This will limit the report to the organization level type selected. Note:Org Level Type MUST be specified IF you are using the Sort Option of Org Level OR if you want to filter by Org Levels. |
| Org Level | Optional, Multiple Selection Available, LOV Available This will limit the report to the organization levels selected. |
| Unit | Optional, Multiple Selection Available, LOV Available This will limit the report to the units selected |
| Group | Optional, Multiple Selection Available, LOV Available This will limit the report to the groups selected |
| Payroll | Optional, Multiple Selection Available, LOV Available This will limit the report to the payrolls selected |
| Job | Optional, Multiple Selection Available, LOV Available This field will limit the report to the jobs selected. |
| Position | Optional, Multiple Selection Available, LOV Available This field will limit the report to the positions selected. |
| Employment Status | Optional, Multiple Selection Available, LOV Available This will limit the report to the employment statuses selected. |
| Employment Type | Optional, Multiple Selection Available, LOV Available This field will limit the report to the employment types selected. |
| Assignment Type | Optional, Multiple Selection Available, LOV Available This field will limit the report to the assignment types selected. |
| Pay Type | Optional, Multiple Selection Available, LOV Available This field will limit the report to the pay types selected. |
REEC Columns#
An employee is categorized as Full Time / Part Time / Irregular Part Time by comparing the standard hours per pay on the employee's assignment record IEAS with the standard hours per pay on the group associated with the employee IDGREach column is totaled by Org Level or Department, as
| Full Time | If the group hours are 75, and the employee's hours are 75 or greater; or if the group hours are 80, and the employee's hours are 80 or greater then they are counted as full time. |
| Part Time | If the group hours are 75 or 80, and the employee's hours are between half and the full amount, the employee is counted as part time. |
| Irregular Part Time | If the group hours are 75 or 80, and the employee's hours are less than half this amount, the employee is counted as irregular part-time. |
| If the group hours are 40 as opposed to 75 or 80, if the group is defined as part time group - resulting in a full time classification in REEC because the assignment is set at 40. |
| FTE | This is the sum of the FTEs for the employees in this grouping (department or org level) |
| FTE Hours | This is computed based upon the pays that have been closed within the From/To period, for each employee. FTE hours is the value of the pay components included in the Time Worked Element specified in this report, divided by the number of pay periods included, divided by the standard hours per pay as defined on the position definition IDPS. |
The counts of New Hire and Termination may include the same person, if they were hired and terminated within the reporting period.
- New Hire
- This is the count of employees whose HIRE DATE IEEI is within the From/To period.
- Terminated
- This is the count of employees whose TERMINATION DATE IEEI is within the From/To period.
The count of New Hire and Terminated employees is taken regardless of your selection to exclude Terminated/Inactive/Pending employment statuses.
