!!!Alias: IVRCA (INF_CV_CANDIDATES) \\ Candidates !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]| | |[CANDIDATE_CODE]|Varchar2(16)|[CODE]|Y| |[DATE_SUBMITTED]|Date()|[DATE]|Y| |[CANDIDATE_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[RECRUITER_CODE]|Varchar2(16)|[CODE]| | |[PERSON_CODE_EMPLOYEE]|Varchar2(16)|[CODE]| | |[PERSON_CODE_REFERRAL]|Varchar2(16)|[CODE]| | |[COUNTRY_CODE]|Varchar2(16)|[CODE]| | |[STATE_PROVINCE_CODE]|Varchar2(16)|[CODE]| | |[GEO_CODE]|Varchar2(16)|[CODE]| | |[SCHOOL_DISTRICT_CODE]|Varchar2(16)|[CODE]| | |[CANDIDATE_TYPE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CANDIDATE_CATEGORY]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CURRENT_EMPLOYER]|Varchar2(50)|[DESCRIPTION]| | |[CURRENT_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[CANDIDATE_SOURCE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CANDIDATE_PASSWORD]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[PASSWORD_CHANGED_DATE]|Date()|[DATE]| | |[PASSWORD_CHANGED_BY]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[EXTERNAL_CANDIDATE_ID]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[GOVT_CODE_VERIFIED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[APPLICATION_START_DATE]|Date()|[DATE]| | |[APPLICATION_END_DATE]|Date()|[DATE]| | |[AVAILABILITY_DATE]|Date()|[DATE]| | |[FIRST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[MIDDLE_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[LAST_NAME]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[SALUTATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[RANK]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[BIRTH_DATE]|Date()|[DATE]| | |[BIRTHPLACE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[GENDER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[LANGUAGE_CODE]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ETHNIC]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHALLENGED]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[VETERAN_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| | |[ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| | |[LOCALITY]|Varchar2(50)|[ADDRESS]| | |[ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| | |[MAIL_ADDRESS_LINE_1]|Varchar2(50)|[ADDRESS]| | |[MAIL_ADDRESS_LINE_2]|Varchar2(50)|[ADDRESS]| | |[MAIL_LOCALITY]|Varchar2(50)|[ADDRESS]| | |[STATE_PROVINCE_CODE_MAIL]|Varchar2(16)|[CODE]| | |[MAIL_ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| | |[PHONE_UNLISTED]|Varchar2(4)|[VARCHAR4|VARCHARnn]| | |[PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[ALT_PHONE_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[ALT_PHONE_EXTENSION]|Varchar2(16)|[VARCHAR16|VARCHARnn]| | |[FAX_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[CELLULAR_NUMBER]|Varchar2(20)|[TELEPHONE]| | |[EMAIL_ADDRESS]|Varchar2(50)|[EMAIL]| | |[MARITAL_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[MARRIED_DATE]|Date()|[DATE]| | |[NUMBER_DEPENDENTS]|Number(5)|[NUMBER5|NUMBERn]| | |[TRANSPORTATION]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[YEARS_EDUCATION]|Number(5)|[NUMBER5|NUMBERn]| | |[BONDED_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CITIZEN_STATUS]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[FOREIGN_CODE]|Varchar2(16)|[CODE]| | |[DRIVERS_LICENSE]|Varchar2(30)|[LICENSE]| | |[PA_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | |[PA_EFFECTIVE_DATE]|Date()|[DATE]| | |[GOVT_CODE_ORIGIN]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CREATE_DATE]|Date()|[DATE]| | |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| | |[CHANGE_DATE]|Date()|[DATE]| | |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]| |