This is version 1 2 3 4 5 6 7 8 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

LIST EMPLOYEE COUNTS #

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
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 person. 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.