INF_CV_CANDIDATES
Back to current versionRestore this version

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

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