!!!Alias: IVRWH (INF_CV_WORKHISTORIES) \\ Work Histories !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[CANDIDATE_CODE]|Varchar2(16)|Y| |[COMPANY_NAME]|Varchar2(50)|Y| |[COUNTRY_CODE]|Varchar2(16)| | |[STATE_PROVINCE_CODE]|Varchar2(16)| | |[INDUSTRY_CODE]|Varchar2(16)| | |[VERIFIED_STATUS]|Varchar2(30)| | |[DATE_VERIFIED]|Date()| | |[CONTACT_NAME]|Varchar2(50)| | |[CONTACT_TITLE]|Varchar2(50)| | |[ADDRESS_LINE_1]|Varchar2(50)| | |[ADDRESS_LINE_2]|Varchar2(50)| | |[LOCALITY]|Varchar2(50)| | |[ZIP_POSTAL]|Varchar2(16)| | |[PHONE_NUMBER]|Varchar2(20)| | |[PHONE_EXTENSION]|Varchar2(16)| | |[ALT_PHONE_NUMBER]|Varchar2(20)| | |[ALT_PHONE_EXTENSION]|Varchar2(16)| | |[FAX_NUMBER]|Varchar2(20)| | |[EMAIL_ADDRESS]|Varchar2(50)| | |[LANGUAGE_CODE]|Varchar2(30)| | |[COMPANY_SIZE]|Varchar2(30)| | |[EMPLOYMENT_TYPE]|Varchar2(30)| | |[GROUP_TYPE]|Varchar2(30)| | |[RESPONSIBILITY_LEVEL]|Varchar2(30)| | |[JOB_CATEGORY]|Varchar2(30)| | |[ASSIGNMENT_TITLE]|Varchar2(50)| | |[ASSIGNMENT_START_DATE]|Date()| | |[ASSIGNMENT_END_DATE]|Date()| | |[REASON_FOR_LEAVING]|Varchar2(30)| | |[HOURS_PER_DAY]|Number(9)| | |[HOURS_PER_WEEK]|Number(9)| | |[WAGE_RATE]|Number(18)| | |[RATE_BASIS]|Varchar2(30)| | |[AVAILABLE_TO_CONTACT]|Varchar2(4)| | |[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. [{If var='loginstatus' contains 'authenticated' ---- ![Discussion|Edit:Internal.INF_CV_WORKHISTORIES] [{InsertPage page='Internal.INF_CV_WORKHISTORIES' default='Click to create a new discussion page'}] }]