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 DateDate, LOV Available
This is the date used to retrieve employee, group and position information.
From DateDate, LOV Available
This field will identify the date from which the assignments will be reported.
To DateDate, LOV Available
This field will identify the date up to which the assignments will be reported.
Work Timed ElementMandatory, 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 LevelMandatory, LOV Available
User CommentOptional, Text
This field holds the user-supplied comment which will appear in the header of all pages of the report.

Report Filters
People ListOptional, Multiple Selection Available, LOV Available
This will limit the report to the people lists listed.
PersonOptional, Multiple Selection Available, LOV Available
This will limit the report to the individuals listed.
EntityOptional, LOV Available
This field limits the report to the single entity selected.
LocationOptional, Multiple Selection Available, LOV Available
This will limit the report to the locations selected
Auth AreaOptional, Multiple Selection Available, LOV Available
This will limit the report to the authorization areas selected
DepartmentOptional, Multiple Selection Available, LOV Available
This will limit the report to the departments selected.
Org Level TypeOptional, 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 LevelOptional, Multiple Selection Available, LOV Available
This will limit the report to the organization levels selected.
UnitOptional, Multiple Selection Available, LOV Available
This will limit the report to the units selected
GroupOptional, Multiple Selection Available, LOV Available
This will limit the report to the groups selected
PayrollOptional, Multiple Selection Available, LOV Available
This will limit the report to the payrolls selected
JobOptional, Multiple Selection Available, LOV Available
This field will limit the report to the jobs selected.
PositionOptional, Multiple Selection Available, LOV Available
This field will limit the report to the positions selected.
Employment StatusOptional, Multiple Selection Available, LOV Available
This will limit the report to the employment statuses selected.
Employment TypeOptional, Multiple Selection Available, LOV Available
This field will limit the report to the employment types selected.
Assignment TypeOptional, Multiple Selection Available, LOV Available
This field will limit the report to the assignment types selected.
Pay TypeOptional, 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 IDGR

Each column is totaled by Org Level or Department, as

Full TimeIf 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 TimeIf 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 TimeIf 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.

FTEThis is the sum of the FTEs for the employees in this grouping (department or org level)
FTE HoursThis 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.


Notes #

Click to create a new notes page