This page (revision-13) was last changed on 26-Nov-2021 10:22 by jmyers

This page was created on 26-Nov-2021 10:22 by JMyers

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
13 26-Nov-2021 10:22 2 KB jmyers to previous
12 26-Nov-2021 10:22 2 KB JMyers to previous | to last
11 26-Nov-2021 10:22 2 KB JMyers to previous | to last
10 26-Nov-2021 10:22 2 KB JMyers to previous | to last
9 26-Nov-2021 10:22 2 KB JMyers to previous | to last
8 26-Nov-2021 10:22 2 KB JMyers to previous | to last
7 26-Nov-2021 10:22 2 KB JMyers to previous | to last
6 26-Nov-2021 10:22 2 KB JMyers to previous | to last
5 26-Nov-2021 10:22 1 KB JMyers to previous | to last
4 26-Nov-2021 10:22 1 KB JMyers to previous | to last
3 26-Nov-2021 10:22 1 KB JMyers to previous | to last
2 26-Nov-2021 10:22 999 bytes JMyers to previous | to last
1 26-Nov-2021 10:22 3 KB JMyers to last

Page References

Incoming links Outgoing links
IVEEM
IVEEM

Version management

Difference between version and

At line 1 changed 2 lines
!!!Alias: [IVEEM]
(INF_CV_EMPLOYMENTS)
[{TableOfContents }]
!!!EMPLOYMENT INTERFACE FILE
At line 4 changed one line
The INF_CV_EMPLOYMENTS table is used to import employee’s employment information into the software data structures. Employees normally will have one employment record (that may have date effective splits) but may have multiple employment types. Each employment record reflects one period of employment under one set of terms.
The Employment Interface File screen is used to import the employee’s employment information into the software data structures.
At line 6 changed 35 lines
Tables loaded:
*[P2K_HR_EMPLOYMENTS] (first record for each employee only)
*[P2K_AM_USER_FIELD_VALUES] (one for each user field value provided)
!!Table Columns
\\
||Column name||Data Type / Size||Mand.||Notes
|[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded.
|[ENTITY_CODE]|Varchar2(16)|Y|Validation: Must be a unique entity code
|[PERSON_CODE]|Varchar2(16)|Y|Validation: Must be a valid [PERSON_CODE] already defined on the [P2K_HR_IDENTITIES] table.
|[EMPLOYMENT_TYPE]|Varchar2(30)|Y|Validation: If provided, must be one of the fixed lexicon values from [X_EMPLOYMENT_TYPE]
|[HIRE_DATE]|Date()|Y|Validation: Must be a valid date
|[TERMINATION_CODE]|Varchar2(16)| |Validation: The Termination Code provided must be defined on [P2K_CM_TERMINATION_REASONS].
|[ORIGINAL_HIRE_DATE]|Date()| |Validation: Must be a valid date. Derivation: If not specified, this field is set to the [HIRE_DATE].
|[SENIORITY_DATE]|Date()| |Validation: Must be a valid date. Derivation: If not specified, this field is set to the [HIRE_DATE].
|[HIRE_SEQUENCE]|Number(5)| |
|[FIRST_WORK_DATE]|Date()| |Validation: Must be a valid date.
|[LAST_WORK_DATE]|Date()| |Validation: Must be a valid date.
|[TERMINATION_DATE]|Date()| |Validation: Must be a valid date.
|[ROE_STATUS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_ROE_STATUS]
|[ROE_ISSUED_DATE]|Date()| |: Must be a valid date.
|[ROE_LETTER]|Varchar2(30)| |Validation: If provided, must be one of the valid letters supported by the Record of Employment form (A-M). See the ROE form for the explanation of these codes in detail. Must be one of the fixed lexicon values from [X_ROE_LETTER].
|[ROE_COMMENTS]|Varchar2(2000)| |
|[REHIRE_STATUS]|Varchar2(30)| |Validation: If provided, must be one of the fixed lexicon values from [X_REHIRE_STATUS]
|[EXPECTED_RETURN_DATE]|Date()| |Validation: Must be a valid date.
|[INCOME_GUARANTEE]|Number(5)| |
|[USER_FIELD_VALUE_01|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM01 defined on [IMUF]
|[USER_FIELD_VALUE_02|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM02 defined on [IMUF]
|[USER_FIELD_VALUE_03|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM03 defined on [IMUF]
|[USER_FIELD_VALUE_04|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM04 defined on [IMUF]
|[USER_FIELD_VALUE_05|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM05 defined on [IMUF]
|[USER_FIELD_VALUE_06|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM06 defined on [IMUF]
|[USER_FIELD_VALUE_07|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM07 defined on [IMUF]
|[USER_FIELD_VALUE_08|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM08 defined on [IMUF]
|[USER_FIELD_VALUE_09|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM09 defined on [IMUF]
|[USER_FIELD_VALUE_10|USER_FIELD_VALUE_nn]|Varchar2(2000)| |Looking for EEM10 defined on [IMUF]
Employment Interface File data is maintained on the [INF_CV_EMPLOYMENTS] table.
At line 8 added 19 lines
;[|ID]:
;[Entity|ENTITY_CODE]:This field holds the entity assocciated with the employment.
;[Employee #|PERSON_CODE]:The employee who's employment information is being loaded is listed in this field.
;[Employment Type|EMPLOYMENT_TYPE]:This field list the employment type for this employee.
;[Date of Hire|HIRE_DATE]:The employee's date of hire is listed in this field.
;[Termination Reason|TERMINATION_CODE]:If the employee has been terminated, the reason for termination is listed in this field.
;[Original Hire Date|ORIGINAL_HIRE_DATE]:The employee's original hire date is listed in this field.
;[Seniority Date|SENIORITY_DATE]:The employee's seniority date is listed in this field.
;[Hiring Sequence|HIRE_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|FIRST_WORK_DATE]/[Last Date Worked|LAST_WORK_DATE]:The first and last dates of the employment are listed in these fields.
;[Date of Termination|TERMINATION_DATE]:If the employee has been terminated, the date of termination will be displayed in this field.
;[ROE Status|ROE_STATUS]:This field indicates whether an ROE (or a duplicate) is required, requested or issued for the employment
;[ROE Issued on|ROE_ISSUED_DATE]:The date the ROE was issued is listed in this field.
;[ROE Letter|ROE_LETTER]:This field shows the corresponding termination code for the Record of Employment(ROE) provided by the Government of Canada.
;[ROE Comments|ROE_COMMENTS]:This field provides text to the comments section of the ROE report.
;[Rehire Status|REHIRE_STATUS]:This field indicates whether a terminated or laid off employee would be rehired or recalled.
;[Expected to Return On|EXPECTED_RETURN_DATE]:If the employee is to return to the employment, the date they are expected to return will be listed in this field.
;[Income Guarantee|INCOME_GUARANTEE]:This field shows the percentage of disposable income that is guaranteed to an employee.
;[User Field Value 1 - 10|USER_FIELD_VALUE_nn]: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.
At line 28 added 3 lines
----
![Notes|Edit:Internal.IVEEM]
[{InsertPage page='Internal.IVEEM' default='Click to create a new notes page'}]
At line 44 removed one line
[{If var='loginstatus' contains 'authenticated'
At line 46 removed 3 lines
----
![Discussion|Edit:Internal.IVEEM]
[{InsertPage page='Internal.IVEEM' default='Click to create a new discussion page'}]
At line 50 removed one line
}]
This page (revision-13) was last changed on 26-Nov-2021 10:22 by jmyersTop