!!!Alias: IVRWH (INF_CV_WORKHISTORIES) \\ Work Histories !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[CANDIDATE_CODE]|Varchar2(16)|[CODE]|Y| |[COMPANY_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]|Y| |[COUNTRY_CODE]|Varchar2(16)|[CODE]| | |[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| | |[INDUSTRY_CODE]|Varchar2(16)|[CODE]| | |[VERIFIED_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[DATE_VERIFIED]|Date()|[DATE]| | |[CONTACT_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[CONTACT_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| | |[ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| | |[LOCALITY]|Varchar2(50)|[ADDRESS]| | |[ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| | |[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[ALT_PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[ALT_PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| | |[LANGUAGE_CODE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[COMPANY_SIZE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[EMPLOYMENT_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[GROUP_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[RESPONSIBILITY_LEVEL]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[JOB_CATEGORY]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ASSIGNMENT_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[ASSIGNMENT_START_DATE]|Date()|[DATE]| | |[ASSIGNMENT_END_DATE]|Date()|[DATE]| | |[REASON_FOR_LEAVING]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[HOURS_PER_DAY]|Number(9)|[AMT5V4|AMTnn]| | |[HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| | |[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| | |[RATE_BASIS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[AVAILABLE_TO_CONTACT]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |