!!!Alias: [IVRCA] (INF_CV_CANDIDATES) \\ Candidates !!Table Columns \\ ||Column name||Data Type / Size||Mand.||Notes |[ID]|Number(10)| |Used internally to define a unique identification for the record. This field would not be loaded. |[CANDIDATE_CODE]|Varchar2(16)|Y| |[DATE_SUBMITTED]|Date()|Y| |[CANDIDATE_STATUS]|Varchar2(30)|Y| |[RECRUITER_CODE]|Varchar2(16)| | |[PERSON_CODE_EMPLOYEE]|Varchar2(16)| | |[PERSON_CODE_REFERRAL]|Varchar2(16)| | |[COUNTRY_CODE]|Varchar2(16)| | |[STATE_PROVINCE_CODE]|Varchar2(16)| | |[GEO_CODE]|Varchar2(16)| | |[SCHOOL_DISTRICT_CODE]|Varchar2(16)| | |[CANDIDATE_TYPE]|Varchar2(30)| | |[CANDIDATE_CATEGORY]|Varchar2(30)| | |[CURRENT_EMPLOYER]|Varchar2(50)| | |[CURRENT_TITLE]|Varchar2(50)| | |[CANDIDATE_SOURCE]|Varchar2(30)| | |[CANDIDATE_PASSWORD]|Varchar2(16)| | |[PASSWORD_CHANGED_DATE]|Date()| | |[PASSWORD_CHANGED_BY]|Varchar2(50)| | |[EXTERNAL_CANDIDATE_ID]|Varchar2(16)| | |[GOVT_CODE_VERIFIED]|Varchar2(4)| | |[APPLICATION_START_DATE]|Date()| | |[APPLICATION_END_DATE]|Date()| | |[AVAILABILITY_DATE]|Date()| | |[FIRST_NAME]|Varchar2(50)| | |[MIDDLE_NAME]|Varchar2(50)| | |[LAST_NAME]|Varchar2(50)| | |[SALUTATION]|Varchar2(30)| | |[RANK]|Varchar2(30)| | |[BIRTH_DATE]|Date()| | |[BIRTHPLACE]|Varchar2(50)| | |[GENDER]|Varchar2(30)| | |[LANGUAGE_CODE]|Varchar2(30)| | |[ETHNIC]|Varchar2(30)| | |[CHALLENGED]|Varchar2(30)| | |[VETERAN_STATUS]|Varchar2(30)| | |[ADDRESS_LINE_1]|Varchar2(50)| | |[ADDRESS_LINE_2]|Varchar2(50)| | |[LOCALITY]|Varchar2(50)| | |[ZIP_POSTAL]|Varchar2(16)| | |[MAIL_ADDRESS_LINE_1]|Varchar2(50)| | |[MAIL_ADDRESS_LINE_2]|Varchar2(50)| | |[MAIL_LOCALITY]|Varchar2(50)| | |[STATE_PROVINCE_CODE_MAIL]|Varchar2(16)| | |[MAIL_ZIP_POSTAL]|Varchar2(16)| | |[PHONE_UNLISTED]|Varchar2(4)| | |[PHONE_NUMBER]|Varchar2(20)| | |[PHONE_EXTENSION]|Varchar2(16)| | |[ALT_PHONE_NUMBER]|Varchar2(20)| | |[ALT_PHONE_EXTENSION]|Varchar2(16)| | |[FAX_NUMBER]|Varchar2(20)| | |[CELLULAR_NUMBER]|Varchar2(20)| | |[EMAIL_ADDRESS]|Varchar2(50)| | |[MARITAL_STATUS]|Varchar2(30)| | |[MARRIED_DATE]|Date()| | |[NUMBER_DEPENDENTS]|Number(5)| | |[TRANSPORTATION]|Varchar2(30)| | |[YEARS_EDUCATION]|Number(5)| | |[BONDED_STATUS]|Varchar2(30)| | |[CITIZEN_STATUS]|Varchar2(30)| | |[FOREIGN_CODE]|Varchar2(16)| | |[DRIVERS_LICENSE]|Varchar2(30)| | |[PA_NUMBER]|Number(10)| | |[PA_EFFECTIVE_DATE]|Date()| | |[GOVT_CODE_ORIGIN]|Varchar2(30)| | |[CREATE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CREATE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_DATE]|Date()| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. |[CHANGE_USER]|Varchar2(30)| |This field used internally only to provide audit information for the creation/updating of records. This field would not be loaded. ---- ![Notes|Edit:Internal.INF_CV_CANDIDATES] [{InsertPage page='Internal.INF_CV_CANDIDATES' default='Click to create a new notes page'}]