Wiki: REEC

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 IDGR

Each 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 full 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.

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.

Notes #

Click to create a new notes page