Alias: IVEAS#
(INF_CV_ASSIGNMENTS)Provides all of the details for the Assignment
The INF_CV_ASSIGNMENTS table is used to import employee’s work assignment information and attendant data into the software data structures. Employees will perform work for the company, reflected by the assignment that they are given. Assignments may be for specific positions or for a more generic job definition. The assignment record defines under what jurisdiction an employee will be taxed (as their work location) by default.
SQL Loader control file sample: ASSIGNMENTS.CTL, loading from ASSIGNMENTS.DAT
Tables loaded:
P2K_HR_ASSIGNMENTS (first record for each employee only
P2K_HR_ASSIGNMENT_DETAILS (first record and subsequent effective splits)
P2K_AM_USER_FIELD_VALUES (one for each user field value provided)
