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)

This particular version was published on 26-Nov-2021 10:22 by JMyers.Top