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.