IVRCA
Back to current versionRestore this version

Table of Contents

CANDIDATE INTERFACE FILE#

The Candidate Interface File screen is used to import candidate records into the software data structures.

Candidate Interface File data is maintained on the INF_CV_CANDIDATES table.

ID
This field uniquely identifies the candidate record within the data base.
CANDIDATE_CODEVarchar2(16)Y
DATE_SUBMITTEDDate()Y
CANDIDATE_STATUSVarchar2(30)Y
RECRUITER_CODEVarchar2(16)
PERSON_CODE_EMPLOYEEVarchar2(16)
PERSON_CODE_REFERRALVarchar2(16)
COUNTRY_CODEVarchar2(16)
STATE_PROVINCE_CODEVarchar2(16)
GEO_CODEVarchar2(16)
SCHOOL_DISTRICT_CODEVarchar2(16)
CANDIDATE_TYPEVarchar2(30)
CANDIDATE_CATEGORYVarchar2(30)
CURRENT_EMPLOYERVarchar2(50)
CURRENT_TITLEVarchar2(50)
CANDIDATE_SOURCEVarchar2(30)
CANDIDATE_PASSWORDVarchar2(16)
PASSWORD_CHANGED_DATEDate()
PASSWORD_CHANGED_BYVarchar2(50)
EXTERNAL_CANDIDATE_IDVarchar2(16)
GOVT_CODE_VERIFIEDVarchar2(4)
APPLICATION_START_DATEDate()
APPLICATION_END_DATEDate()
AVAILABILITY_DATEDate()
FIRST_NAMEVarchar2(50)
MIDDLE_NAMEVarchar2(50)
LAST_NAMEVarchar2(50)
SALUTATIONVarchar2(30)
RANKVarchar2(30)
BIRTH_DATEDate()
BIRTHPLACEVarchar2(50)
GENDERVarchar2(30)
LANGUAGE_CODEVarchar2(30)
ETHNICVarchar2(30)
CHALLENGEDVarchar2(30)
VETERAN_STATUSVarchar2(30)
ADDRESS_LINE_1Varchar2(50)
ADDRESS_LINE_2Varchar2(50)
LOCALITYVarchar2(50)
ZIP_POSTALVarchar2(16)
MAIL_ADDRESS_LINE_1Varchar2(50)
MAIL_ADDRESS_LINE_2Varchar2(50)
MAIL_LOCALITYVarchar2(50)
STATE_PROVINCE_CODE_MAILVarchar2(16)
MAIL_ZIP_POSTALVarchar2(16)
PHONE_UNLISTEDVarchar2(4)
PHONE_NUMBERVarchar2(20)
PHONE_EXTENSIONVarchar2(16)
ALT_PHONE_NUMBERVarchar2(20)
ALT_PHONE_EXTENSIONVarchar2(16)
FAX_NUMBERVarchar2(20)
CELLULAR_NUMBERVarchar2(20)
EMAIL_ADDRESSVarchar2(50)
MARITAL_STATUSVarchar2(30)
MARRIED_DATEDate()
NUMBER_DEPENDENTSNumber(5)
TRANSPORTATIONVarchar2(30)
YEARS_EDUCATIONNumber(5)
BONDED_STATUSVarchar2(30)
CITIZEN_STATUSVarchar2(30)
FOREIGN_CODEVarchar2(16)
DRIVERS_LICENSEVarchar2(30)
PA_NUMBERNumber(10)
PA_EFFECTIVE_DATEDate()
GOVT_CODE_ORIGINVarchar2(30)

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