INF_CV_WORKHISTORIES
Back to current versionRestore this version

Alias: IVRWH#

(INF_CV_WORKHISTORIES)
Work Histories

Table Columns#


Column nameData Type / SizeMand.Notes
IDNumber(10) Used internally to define a unique identification for the record. This field would not be loaded.
CANDIDATE_CODEVarchar2(16)Y
COMPANY_NAMEVarchar2(50)Y
COUNTRY_CODEVarchar2(16)
STATE_PROVINCE_CODEVarchar2(16)
INDUSTRY_CODEVarchar2(16)
VERIFIED_STATUSVarchar2(30)
DATE_VERIFIEDDate()
CONTACT_NAMEVarchar2(50)
CONTACT_TITLEVarchar2(50)
ADDRESS_LINE_1Varchar2(50)
ADDRESS_LINE_2Varchar2(50)
LOCALITYVarchar2(50)
ZIP_POSTALVarchar2(16)
PHONE_NUMBERVarchar2(20)
PHONE_EXTENSIONVarchar2(16)
ALT_PHONE_NUMBERVarchar2(20)
ALT_PHONE_EXTENSIONVarchar2(16)
FAX_NUMBERVarchar2(20)
EMAIL_ADDRESSVarchar2(50)
LANGUAGE_CODEVarchar2(30)
COMPANY_SIZEVarchar2(30)
EMPLOYMENT_TYPEVarchar2(30)
GROUP_TYPEVarchar2(30)
RESPONSIBILITY_LEVELVarchar2(30)
JOB_CATEGORYVarchar2(30)
ASSIGNMENT_TITLEVarchar2(50)
ASSIGNMENT_START_DATEDate()
ASSIGNMENT_END_DATEDate()
REASON_FOR_LEAVINGVarchar2(30)
HOURS_PER_DAYNumber(9)
HOURS_PER_WEEKNumber(9)
WAGE_RATENumber(18)
RATE_BASISVarchar2(30)
AVAILABLE_TO_CONTACTVarchar2(4)
CREATE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CREATE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_DATEDate() This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.
CHANGE_USERVarchar2(30) This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded.