!!!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|
|[PERSON_CODE]|Varchar2(16)|[CODE]|Y|
|[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[HIRE_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_CODE]|Varchar2(16)|[CODE]|Y|
|[ASSIGNMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ASSIGNMENT_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[ASSIGNMENT_START_DATE]|Date()|[DATE]| |
|[ASSIGNMENT_END_DATE]|Date()|[DATE]| |
|[PRIME_ASSIGNMENT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[DESCRIPTION]|Varchar2(50)|[DESCRIPTION]| |
|[NEXT_REVIEW_DATE]|Date()|[DATE]| |
|[TS_SENIORITY_DATE]|Date()|[DATE]| |
|[EFFECTIVE]|Date()|[EFFECTIVE]| |
|[EXPIRY]|Date()|[EXPIRY]|Y|
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |
|[STATUS_CODE]|Varchar2(16)|[CODE]| |
|[POSITION_CODE]|Varchar2(16)|[CODE]| |
|[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| |
|[UNIT_CODE]|Varchar2(16)|[CODE]| |
|[JOB_CODE]|Varchar2(16)|[CODE]| |
|[LOCATION_CODE_WORK_IN]|Varchar2(16)|[CODE]| |
|[COUNTRY_CODE]|Varchar2(16)|[CODE]| |
|[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| |
|[GEO_CODE]|Varchar2(16)|[CODE]| |
|[GROUP_CODE]|Varchar2(16)|[CODE]| |
|[AUTHORIZATION_CODE]|Varchar2(16)|[CODE]| |
|[WORK_RULE_CODE]|Varchar2(16)|[CODE]| |
|[LOCATION_CODE_PAYDEST]|Varchar2(16)|[CODE]| |
|[PERSON_CODE_REPLACED_BY]|Varchar2(16)|[CODE]| |
|[PERSON_CODE_SUPERVISED_BY]|Varchar2(16)|[CODE]| |
|[RANGE_CODE]|Varchar2(16)|[CODE]| |
|[SCALE_CODE]|Varchar2(16)|[CODE]| |
|[STEP_CODE]|Varchar2(16)|[CODE]| |
|[FTE]|Number(9)|[AMT5V4|AMTnn]| |
|[WORK_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[WCB_CLASS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| |
|[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
|[HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| |
|[PERIODS_ELECTED]|Number(5)|[NUMBER5|NUMBERn]| |
|[CONTRACT_DAYS]|Number(9)|[AMT5V4|AMTnn]| |
|[CONTRACT_LIMIT]|Number(18)|[AMT12V6|AMTnn]| |
|[USE_FTE_WAGES]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[OUT_OF_RANGE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[SCALE_OVERRIDDEN]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[ASSIGNMENT_TITLE]|Varchar2(50)|[DESCRIPTION]| |
|[JOB_SENIORITY_DATE]|Date()|[DATE]| |
|[RESPONSIBILITY_LEVEL]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| |
|[PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| |
|[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| |
|[SERVICE_RATING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[LEAVE_DATE]|Date()|[DATE]| |
|[LEAVE_RETURN_DATE]|Date()|[DATE]| |
|[LEAVE_REASON]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[PAY_STARTING_DATE]|Date()|[DATE]| |
|[TRIGGER_RETRO]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[PROVIDE_PUBLIC_SERVICE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[PROVIDE_INTERNAL_SERVICE]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[SUPERVISORY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[BURDEN_METHOD]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[BURDEN_PERCENT]|Number(18)|[AMT12V6|AMTnn]| |
|[LONG_TERM_ASSIGNMENT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[REQUIRES_TIME_SHEET]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[JOB_PROFILE_CODE]|Varchar2(16)|[CODE]| |
|[WORK_CALENDAR_CODE]|Varchar2(16)|[CODE]| |
|[WEB_PAY_STUB_ONLY]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[PREMIUM_CODE]|Varchar2(16)|[CODE]| |
|[PREMIUM_RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[PREMIUM_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[SPLIT_SEQUENCE]|Number(5)|[NUMBER5|NUMBERn]| |
|[DISTRIBUTION_CODE]|Varchar2(50)|[DISTRIBUTION]| |
|[SPLIT_RULE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[SPLIT_PERCENT]|Number(5)|[PERCENT]| |
|[SPLIT_AMOUNT]|Number(18)|[AMT12V6|AMTnn]| |
|[ADDITIONAL]|Varchar2(4)|[VARCHAR4|VARCHARnn]| |
|[START_DATE]|Date()|[DATE]| |
|[END_DATE]|Date()|[DATE]| |
|[GL_FUND_CODE]|Varchar2(16)|[CODE]| |
|[USER_PERCENT]|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]| |
|[USER_FIELD_VALUE_11]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[USER_FIELD_VALUE_12]|Varchar2(2000)|[VARCHAR2000|VARCHARnn]| |
|[CREATE_DATE]|Date()|[DATE]| |
|[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |
|[CHANGE_DATE]|Date()|[DATE]| |
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |