This is version 1 2 3 4 5 6 7 8 9 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: IVEEM#

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.

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	Varchar2(2000)		Validation: This value is applied against the User defined field EEM01, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_02	Varchar2(2000)		Validation: This value is applied against the User defined field EEM02, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_03	Varchar2(2000)		Validation: This value is applied against the User defined field EEM03, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_04	Varchar2(2000)		Validation: This value is applied against the User defined field EEM04, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_05	Varchar2(2000)		Validation: This value is applied against the User defined field EEM05, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_06	Varchar2(2000)		Validation: This value is applied against the User defined field EEM06, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_08	Varchar2(2000)		Validation: This value is applied against the User defined field EEM08, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_09	Varchar2(2000)		Validation: This value is applied against the User defined field EEM09, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
USER_FIELD_VALUE_10	Varchar2(2000)		Validation: This value is applied against the User defined field EEM10, which must have been previously defined in the P2K_AM_USER_FIELDS table. This may be accomplished through the cv_uf_employments.sql script.
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.