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

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

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
9 26-Nov-2021 10:22 4 KB JMyers to previous
8 26-Nov-2021 10:22 4 KB RForbes to previous | to last
7 26-Nov-2021 10:22 5 KB JEscott to previous | to last
6 26-Nov-2021 10:22 5 KB JEscott to previous | to last
5 26-Nov-2021 10:22 5 KB JEscott to previous | to last
4 26-Nov-2021 10:22 5 KB JEscott to previous | to last
3 26-Nov-2021 10:22 1 KB JEscott to previous | to last
2 26-Nov-2021 10:22 2 KB JEscott to previous | to last
1 26-Nov-2021 10:22 1 KB JEscott to last

Page References

Incoming links Outgoing links
INF_CV_EMPLOYMENTS
INF_CV_EMPLOYMENTS

Version management

Difference between version and

At line 1 changed one line
!!!Alias: IVEEM
!!!Alias: [IVEEM]
At line 3 removed 2 lines
\\
Provides all of the details for the entity Employm
At line 4 added 5 lines
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.
Tables loaded:
*[P2K_HR_EMPLOYMENTS] (first record for each employee only)
*[P2K_AM_USER_FIELD_VALUES] (one for each user field value provided)
At line 8 changed 34 lines
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|Number(10)|[ID]| |
|[ENTITY_CODE]|Varchar2(16)|[CODE]|Y|
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y|
|[HIRE_DATE]|Date()|[DATE]|Y|
|[TERMINATION_CODE]|Varchar2(16)|[CODE]| |
|[ORIGINAL_HIRE_DATE]|Date()|[DATE]| |
|[SENIORITY_DATE]|Date()|[DATE]| |
|[HIRE_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |
|[FIRST_WORK_DATE]|Date()|[DATE]| |
|[LAST_WORK_DATE]|Date()|[DATE]| |
|[TERMINATION_DATE]|Date()|[DATE]| |
|[ROE_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ROE_ISSUED_DATE]|Date()|[DATE]| |
|[ROE_LETTER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ROE_COMMENTS]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[REHIRE_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[EXPECTED_RETURN_DATE]|Date()|[DATE]| |
|[INCOME_GUARANTEE]|Number(5)|[PERCENT]| |
|[USER_FIELD_VALUE_01]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_02]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_03]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_04]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_05]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_06]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_07]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_08]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_09]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_10]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
||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]
|[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
|[CHANGE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
----
![Notes|Edit:Internal.INF_CV_EMPLOYMENTS]
[{InsertPage page='Internal.INF_CV_EMPLOYMENTS' default='Click to create a new notes page'}]
This page (revision-9) was last changed on 26-Nov-2021 10:22 by JMyersTop