!!!Alias: RCA
(P2K_RE_CANDIDATES)

Unique Keys: \\
Child Table: \\
Parent Table: \\
ERD: [ERD-RE30]

\\
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(Field)]|Varchar2(100)|[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]| | 


!![Derived Fields|DERIVED FIELDS]
||Column Name
|[DRV_AGE]
|[DRV_APPLICATIONS]
|[DRV_CANCELED_APP]
|[DRV_CANDIDATE]
|[DRV_NEW_APP]
|[DRV_WORK_PREFERENCE_COUNT]
|[DRV_WORK_PREFERENCE_STATUS]
|[DRV_WORK_PREFERENCE_VALUE]

User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_RE_CANDIDATES] 	
[{InsertPage page='Internal.P2K_RE_CANDIDATES' default='Click to create a new notes page'}]