!!!Alias: RCA Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Candidates !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[EID_ID_EMPLOYEE]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES] |[EID_ID_REFERRAL]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES] |[DSP_ID]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES] |[RRE_ID]|Number(10)|[ID]| |link to [P2K_RE_RECRUITERS] |[DCO_ID]|Number(10)|[ID]| |link to [P2K_CM_COUNTRIES] |[DSD_ID]|Number(10)|[ID]| |link to [P2K_CM_SCHOOL_DISTRICTS] |[DSP_ID_MAIL]|Number(10)|[ID]| |link to [P2K_CM_STATE_PROVINCES] |[DTX_ID]|Number(10)|[ID]| |link to [P2K_CM_TAX_JURISDICTIONS] |[CANDIDATE_CODE]|Varchar2(16)|[CODE]|Y| |[DATE_SUBMITTED]|Date()|[DATE]|Y| |[CANDIDATE_STATUS]|Varchar2(2)|[X_CANDIDATE_STATUS]|Y| |[CANDIDATE_TYPE]|Varchar2(2)|[X_CANDIDATE_TYPE]| | |[CANDIDATE_CATEGORY]|Varchar2(2)|[X_CANDIDATE_CATEGORY]| | |[CURRENT_EMPLOYER]|Varchar2(50)|[DESCRIPTION]| | |[CURRENT_TITLE]|Varchar2(50)|[DESCRIPTION]| | |[CANDIDATE_SOURCE]|Varchar2(2)|[X_CANDIDATE_SOURCE]| | |[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]| | |[GOVERNMENT_CODE]|Varchar2(16)|[GOVERNMENT CODE]| | |[GOVT_CODE_VERIFIED]|Varchar2(1)|[TOGGLE]| | |[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(4)|[X_SALUTATION]| | |[RANK]|Varchar2(4)|[X_RANK]| | |[BIRTH_DATE]|Date()|[DATE]| | |[BIRTHPLACE]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[GENDER]|Varchar2(2)|[X_GENDER]| | |[LANGUAGE_CODE]|Varchar2(3)|[X_LANGUAGE_CODE]| | |[ETHNIC]|Varchar2(4)|[X_ETHNIC]| | |[CHALLENGED]|Varchar2(4)|[X_CHALLENGED]| | |[VETERAN_STATUS]|Varchar2(4)|[X_VETERAN_STATUS]| | |[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]| | |[MAIL_ZIP_POSTAL]|Varchar2(16)|[POSTAL CODE]| | |[PHONE_UNLISTED]|Varchar2(1)|[TOGGLE]| | |[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]| | |[WEB_ADDRESS]|Varchar2(200)|[URL]| | |[MARITAL_STATUS]|Varchar2(2)|[X_MARITAL_STATUS]| | |[MARRIED_DATE]|Date()|[DATE]| | |[NUMBER_DEPENDENTS]|Number(5)|[NUMBER5|NUMBERn]| | |[TRANSPORTATION]|Varchar2(2)|[X_TRANSPORTATION]| | |[YEARS_EDUCATION]|Number(5)|[NUMBER5|NUMBERn]| | |[BONDED_STATUS]|Varchar2(2)|[X_BONDED]| | |[CITIZEN_STATUS]|Varchar2(2)|[X_CITIZEN_STATUS]| | |[FOREIGN_CODE]|Varchar2(16)|[CODE]| | |[DRIVERS_LICENSE]|Varchar2(30)|[LICENSE]| | |[HOW_TO_CONTACT_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[OBJECTIVES_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[CANDIDATE_TEXT]|Varchar2(4000)|[VARCHAR4000|VARCHARnn]| | |[PA_NUMBER]|Number(10)|[NUMBER10|NUMBERn]| | |[PA_EFFECTIVE_DATE]|Date()|[DATE]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[GOVT_CODE_ORIGIN]|Varchar2(2)|[X_GOVT_CODE_ORIGIN]| | User Fields: Allowed\\ Audit Logging: Allowed\\