!!!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|VARCHARnn]| |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|VARCHARnn]| |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|VARCHARnn]| |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|VARCHARnn]| |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.
Suggestion:	If you are not loading multiple date-effective records for the same entity code, then populate this field with a constant ‘01-Jan-0001’ which represents the beginning of time.
|[EXPIRY]|Date()|[EXPIRY]|Y|Destination:	P2K_CM_ASSIGNMENT_DETAILS.EXPIRY Validation:	Must be a valid date format, with a date after the effective date Suggestion:	If you are not loading multiple date-effective records for the same entity code, then populate this field with a constant ‘31-Dec-3999’ which represents the end of time.
|[CHANGE_CODE]|Varchar2(16)|[CODE]| |Destination:	P2K_CM_ASSIGNMENT_DETAILS.DCR_ID. Validation:	The Change Code provided must be defined on [P2K_CM_CHANGE_REASONS].  
|[STATUS_CODE]|Varchar2(16)|[CODE]| |Destination:	P2K_CM_ASSIGNMENT_DETAILS.DES_ID Validation:	Must be an Employment Status code defined on [P2K_CM_EMPLOYMENT_STATUSES]. 
|[POSITION_CODE]|Varchar2(16)|[CODE]| |Destination:	P2K_HR_ASSIGNMENT_DETAILS.DPS_ID Validation:	The Position Code provided must be defined on [P2K_CM_POSITIONS]
|[DEPARTMENT_CODE]|Varchar2(16)|[CODE]| |Destination:	P2K_HR_ASSIGNMENT_DETAILS.DDP_ID Validation:	The Department Code provided must be defined on [P2K_CM_DEPARTMENTS]
|[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]| |