UEEE

PRINT EMPLOYMENT EQUITY#

The Print Employment Equity (UEEE) report will produce a report and a series of files for submission to the Canadian government in support of the Employment Equity Computerized Reporting System EECRS.

Set Up Required#

This report uses Census Metropolitan Area (CMA) codes to identify locations for reporting employment equity statistics. These codes are defined in the user-defined lexicon X_CMA_CODES and are then associated to each location in the IDLN screen.

Although the codes are specified by the federal government, you only need to set up those codes in the lexicon that you will actually use.

Each location in your organization must be assigned to the appropriate CMA.

Other fields that require set up are:

When you will run the report, if some of data is not correct, you will receive an error message on your report. The report will show for each individual, their person code, first name, last name and listed below that will be an error message for any set up that is missing, or incorrect.

Report Parameters
EntityMandatory, LOV Available
This field limits the report to one entity.
As Of DateDate, LOV Available
The date that employee data will be derived "as of".
File DirectoryText, Mandatory, Manual
This field defines the location of the three files necessary for import into EECRS (employee.txt, term.txt, promo.txt).
Note that this directory is data base server-centric (i.e. the data base server process must be able to write to this directory)
Regular EarningsMandatory, LOV Available
This field allows the user to choose the appropriate element for regular earnings, used to calculate the salary.
Additional EarningsMandatory, LOV Available
This field allows the user to choose the appropriate element for additional earnings, used to calculate the salary.
Include Employee NameMandatory, Yes/No - Default is 'No'
If ‘Yes’, Employee’s name will be written to the employee.txt file.
If ‘No’, Employee’s name will NOT be written to the employee.txt file.
Exception Level Mandatory, LOV Available
Defaults to ‘Exceptions Only’, may be changed to allow users to view higher-level exception messages (if problems occur, or to assist in set up and testing).

Processing Executed#

Three files will be generated in the format specified by the federal government EECRS program:

EMPLOYEE.TXT#

EECRS Group TypeIDGR Group Type
Full TimeFull Time
Part TimePart Time
CasualCasual
TemporaryTemp Full Time + Temp Part Time
OtherOther + Students + Contractor + Retiree + COBRA + Survivor

TERM.TXT#

PROMO.TXT#

This file will be create only for those employees who:


Notes #

Click to create a new notes page