Alias: IVRCA#

(INF_CV_CANDIDATES)
Candidates

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)ID
CANDIDATE_CODEVarchar2(16)CODEY
DATE_SUBMITTEDDate()DATEY
CANDIDATE_STATUSVarchar2(30)VARCHAR30Y
RECRUITER_CODEVarchar2(16)CODE
PERSON_CODE_EMPLOYEEVarchar2(16)CODE
PERSON_CODE_REFERRALVarchar2(16)CODE
COUNTRY_CODEVarchar2(16)CODE
STATE_PROVINCE_CODEVarchar2(16)CODE
GEO_CODEVarchar2(16)CODE
SCHOOL_DISTRICT_CODEVarchar2(16)CODE
CANDIDATE_TYPEVarchar2(30)VARCHAR30
CANDIDATE_CATEGORYVarchar2(30)VARCHAR30
CURRENT_EMPLOYERVarchar2(50)DESCRIPTION
CURRENT_TITLEVarchar2(50)DESCRIPTION
CANDIDATE_SOURCEVarchar2(30)VARCHAR30
CANDIDATE_PASSWORDVarchar2(16)VARCHAR16
PASSWORD_CHANGED_DATEDate()DATE
PASSWORD_CHANGED_BYVarchar2(50)VARCHAR50
EXTERNAL_CANDIDATE_IDVarchar2(16)VARCHAR16
GOVT_CODE_VERIFIEDVarchar2(4)VARCHAR4
APPLICATION_START_DATEDate()DATE
APPLICATION_END_DATEDate()DATE
AVAILABILITY_DATEDate()DATE
FIRST_NAMEVarchar2(50)VARCHAR50
MIDDLE_NAMEVarchar2(50)VARCHAR50
LAST_NAMEVarchar2(50)VARCHAR50
SALUTATIONVarchar2(30)VARCHAR30
RANKVarchar2(30)VARCHAR30
BIRTH_DATEDate()DATE
BIRTHPLACEVarchar2(50)VARCHAR50
GENDERVarchar2(30)VARCHAR30
LANGUAGE_CODEVarchar2(30)VARCHAR30
ETHNICVarchar2(30)VARCHAR30
CHALLENGEDVarchar2(30)VARCHAR30
VETERAN_STATUSVarchar2(30)VARCHAR30
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
STATE_PROVINCE_CODE_MAILVarchar2(16)CODE
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_UNLISTEDVarchar2(4)VARCHAR4
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
CELLULAR_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
MARITAL_STATUSVarchar2(30)VARCHAR30
MARRIED_DATEDate()DATE
NUMBER_DEPENDENTSNumber(5)NUMBER5
TRANSPORTATIONVarchar2(30)VARCHAR30
YEARS_EDUCATIONNumber(5)NUMBER5
BONDED_STATUSVarchar2(30)VARCHAR30
CITIZEN_STATUSVarchar2(30)VARCHAR30
FOREIGN_CODEVarchar2(16)CODE
DRIVERS_LICENSEVarchar2(30)LICENSE
PA_NUMBERNumber(10)NUMBER10
PA_EFFECTIVE_DATEDate()DATE
GOVT_CODE_ORIGINVarchar2(30)VARCHAR30
CREATE_DATEDate()DATE
CREATE_USERVarchar2(30)VARCHAR30
CHANGE_DATEDate()DATE
CHANGE_USERVarchar2(30)VARCHAR30