Table of Contents

EMPLOYMENT INTERFACE FILE#

The Employment Interface File screen is used to import the employee’s employment information into the software data structures.

Employment Interface File data is maintained on the INF_CV_EMPLOYMENTS table.

Entity
This field holds the entity assocciated with the employment.
Employee #
The employee who's employment information is being loaded is listed in this field.
Employment Type
This field list the employment type for this employee.
Date of Hire
The employee's date of hire is listed in this field.
Termination Reason
If the employee has been terminated, the reason for termination is listed in this field.
Original Hire Date
The employee's original hire date is listed in this field.
Seniority Date
The employee's seniority date is listed in this field.
Hiring Sequence
If more than one employee is hired on the same date, this field provides the sequential number to the employee for seniority purposes.
First Work Date/Last Date Worked
The first and last dates of the employment are listed in these fields.
Date of Termination
If the employee has been terminated, the date of termination will be displayed in this field.
ROE Status
This field indicates whether an ROE (or a duplicate) is required, requested or issued for the employment
ROE Issued on
The date the ROE was issued is listed in this field.
ROE Letter
This field shows the corresponding termination code for the Record of Employment(ROE) provided by the Government of Canada.
ROE Comments
This field provides text to the comments section of the ROE report.
Rehire Status
This field indicates whether a terminated or laid off employee would be rehired or recalled.
Expected to Return On
If the employee is to return to the employment, the date they are expected to return will be listed in this field.
Income Guarantee
This field shows the percentage of disposable income that is guaranteed to an employee.
User Field Value 1 - 10
This field is used for conversion. This value is applied against the user-defined field for each table which must have been previously defined in the P2K_AM_USER_FIELDS table.

Notes #

Click to create a new notes page