Alias: IVRWH#

(INF_CV_WORKHISTORIES)
Work Histories

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
CANDIDATE_CODEVarchar2(16)CODEY
COMPANY_NAMEVarchar2(50)VARCHAR50Y
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
INDUSTRY_CODEVarchar2(16)CODE
VERIFIED_STATUSVarchar2(30)VARCHAR30
DATE_VERIFIEDDate()DATE
CONTACT_NAMEVarchar2(50)VARCHAR50
CONTACT_TITLEVarchar2(50)DESCRIPTION
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
LANGUAGE_CODEVarchar2(30)VARCHAR30
COMPANY_SIZEVarchar2(30)VARCHAR30
EMPLOYMENT_TYPEVarchar2(30)VARCHAR30
GROUP_TYPEVarchar2(30)VARCHAR30
RESPONSIBILITY_LEVELVarchar2(30)VARCHAR30
JOB_CATEGORYVarchar2(30)VARCHAR30
ASSIGNMENT_TITLEVarchar2(50)DESCRIPTION
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_END_DATEDate()DATE
REASON_FOR_LEAVINGVarchar2(30)VARCHAR30
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(30)VARCHAR30
AVAILABLE_TO_CONTACTVarchar2(4)VARCHAR4
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30