INF_CV_WORKHISTORIES
Back to current versionRestore this version

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation