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)
Table Columns#
| Column name | Data Type / Size | Domain | Mand. | Notes |
|---|---|---|---|---|
| ID | Number(10) | ID | ||
| ENTITY_CODE | Varchar2(16) | CODE | Y | Destination:Not moved to the software data structures, but used for validation of the employment record. Validation: The Entity Code provided must be defined on P2K_CM_ENTITIES. |
| PERSON_CODE | Varchar2(16) | CODE | Y | Destination:Not moved to the P2K_CM_LOCATIONS table, 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) | VARCHAR30 | Destination:Not moved to the P2K_CM_LOCATIONS table, but used for validation. Validation: The employee must have an active employment record for this employment type. Must be one of the X_EMPLOYMENT_TYPE fixed lexicon values. | |
| HIRE_DATE | Date() | DATE | Destination:Not moved to the P2K_CM_LOCATIONS table, but used for validation of the employment record. Validation: Must be a valid date. | |
| ASSIGNMENT_CODE | Varchar2(16) | CODE | Y | Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_CODE Validation: None. Suggestion:Set the Assignment Code to be the same as the assignment type. |
| ASSIGNMENT_TYPE | Varchar2(30) | VARCHAR30 | Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_TYPE. Validation: If provided, must be a value from the X_ASSIGN_TYPE fixed lexicon | |
| ASSIGNMENT_STATUS | Varchar2(30) | VARCHAR30 | Destination: P2K_HR_ASSIGNMENTS.ASSIGNMENT_STATUS. Validation: If provided, must be a value from the X_ASSIGN_STATUS fixed lexicon | |
| ASSIGNMENT_START_DATE | Date() | DATE | Destination: P2K_HR_ASSIGNMENTS.ASSIGNMENT_START_DATE Validation: Must be a valid date. | |
| ASSIGNMENT_END_DATE | Date() | DATE | Destination:P2K_HR_ASSIGNMENTS.ASSIGNMENT_END_DATE. Validation: Must be a valid date. | |
| PRIME_ASSIGNMENT | Varchar2(4) | VARCHAR4 | Destination: P2K_HR_ASSIGNMENTS.PRIME_ASSIGNMENT Validation: This field is a “toggle” field. The value will be translated as False if the value is left NULL, set to “N”, “NO” or “0”. All other values will translate to True. | |
| DESCRIPTION | Varchar2(50) | DESCRIPTION | Destination: P2K_HR_ASSIGNMENTS.DESCRIPTION | |
| NEXT_REVIEW_DATE | Date() | DATE | Destination: P2K_HR_ASSIGNMENTS.NEXT_REVIEW_DATE | |
| TS_SENIORITY_DATE | Date() | DATE | ||
| EFFECTIVE | Date() | EFFECTIVE | Destination: P2K_CM_ASSIGNMENT_DETAILS.EFFECTIVE Validation: Must be a valid date format. |
