!!!Alias: [IVSEP] (INF_CV_EXPERIENCES) The INF_CV_EXPERIENCES table is used to import employee experience data, for automatic wage increases, into the software data structures. Tables loaded: *[P2K_SA_EXPERIENCES] *[P2K_SA_EXPERIENCE_DETAILS] !!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. |[EXPERIENCE_TYPE]|Varchar2(30)|Y|Validation: Must be one of the fixed lexicon values from [X_EXPERIENCE_TYPE]. |[ENTITY_CODE]|Varchar2(16)|Y|Validation: Must be a valid entity code defined on [P2K_CM_ENTITIES]. |[DEPARTMENT_CODE]|Varchar2(16)| |Validation: Must be a valid position code defined on [P2K_CM_DEPARTMENTS] |[UNIT_CODE]|Varchar2(16)| |Validation: Must be a valid entity code defined on [P2K_CM_UNITS]. |[JOB_CODE]|Varchar2(16)| |Validation: Must be a valid [JOB_CODE] defined on [P2K_CM_JOBS] |[POSITION_CODE]|Varchar2(16)| |Validation: Must be a unique position code for the entity specified. |[GROUP_CODE]|Varchar2(16)| |Validation: Must be a valid [GROUP_CODE] defined on [P2K_CM_GROUPS]. |[PERSON_CODE]|Varchar2(16)| |Not moved to the software data structures, but used for validation of the employment record. Validation: Must be a valid [PERSON_CODE] already defined on the [P2K_HR_IDENTITIES] table. |[EMPLOYMENT_TYPE]|Varchar2(30)| |Validation: The employee must have an active employment record for this employment type. Must be one of the fixed lexicon values from [X_EMPLOYMENT_TYPE]. Derivation: If you do not provide an employment type value, the conversion application will look for any [P2K_HR_EMPLOYMENTS] record that matches the other criteria. Suggestion: If you are loading employees, you can set this field to a fixed value of ‘01’. |[HIRE_DATE]|Date()| |Not moved to the software structures, but used for validation of the employment record. Validation: Must be a valid date. Derivation: If you do not provide a hire date, the conversion application will look for any [P2K_HR_EMPLOYMENTS] record that matches the other criteria. |[EXPERIENCE_START_DATE]|Date()| |Validation: Must be a valid date. |[EXPERIENCE_LAST_STEP_DATE]|Date()| |Validation: Must be a valid date. |[EXPERIENCE_STATUS]|Varchar2(30)|Y|Validation: Must be one of the lexicon values from [X_EXPERIENCE_STATUS]. |[UNIT_CODE_SCALE]|Varchar2(16)| |Not moved to the software structures, but used for validation of the [STEP_CODE]. Validation: Must be a valid unit code defined on [P2K_CM_UNITS] |[SCALE_CODE]|Varchar2(16)| |Not moved to the software structures, but used for validation of the [STEP_CODE]. Validation: Must be a valid scale code defined on [P2K_SA_WAGE_SCALES] |[STEP_CODE]|Varchar2(16)| |Validation: Must be a valid step for the scale code defined on [P2K_SA_WAGE_SCALES] |[EXPERIENCE_LAST_WORKED_DATE]|Date()| |Validation: Must be a valid date |[EXPERIENCE_LAST_EVAL_DATE]|Date()| |Validation: Must be a valid date |[ELIGIBLE_DAYS]|Number(18)| | |[ELIGIBLE_HOURS]|Number(18)| | |[ELIGIBLE_UNITS]|Number(18)| | |[PRE_ELIGIBLE_DAYS]|Number(18)| | |[PRE_ELIGIBLE_HOURS]|Number(18)| | |[PRE_ELIGIBLE_UNITS]|Number(18)| | |[WORKED_DAYS]|Number(18)| | |[WORKED_HOURS]|Number(18)| | |[WORKED_UNITS]|Number(18)| | |[ABSENT_DAYS]|Number(18)| | |[ABSENT_HOURS]|Number(18)| | |[ACCUMULATED_DAYS]|Number(18)| | |[ACCUMULATED_HOURS]|Number(18)| | |[ACCUMULATED_UNITS]|Number(18)| | |[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_EXPERIENCES] [{InsertPage page='Internal.INF_CV_EXPERIENCES' default='Click to create a new notes page'}]