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
PASSWORD_CHANGED_DATE	Date()	DATE
PASSWORD_CHANGED_BY	Varchar2(50)	VARCHAR50
EXTERNAL_CANDIDATE_ID	Varchar2(16)	VARCHAR16
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
MIDDLE_NAME	Varchar2(50)	VARCHAR50
LAST_NAME	Varchar2(50)	VARCHAR50
SALUTATION	Varchar2(4)	X_SALUTATION
RANK	Varchar2(4)	X_RANK
BIRTH_DATE	Date()	DATE
BIRTHPLACE	Varchar2(50)	VARCHAR50
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
ALT_PHONE_NUMBER	Varchar2(20)	TELEPHONE
ALT_PHONE_EXTENSION	Varchar2(16)	VARCHAR16
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
TRANSPORTATION	Varchar2(2)	X_TRANSPORTATION
YEARS_EDUCATION	Number(5)	NUMBER5
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
OBJECTIVES_TEXT	Varchar2(4000)	VARCHAR4000
CANDIDATE_TEXT	Varchar2(4000)	VARCHAR4000
PA_NUMBER	Number(10)	NUMBER10
PA_EFFECTIVE_DATE	Date()	DATE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
GOVT_CODE_ORIGIN	Varchar2(2)	X_GOVT_CODE_ORIGIN
RAW_BIRTH_DATE	RAW(50)	RAW50
RAW_DRIVERS_LICENSE	RAW(50)	RAW50
RAW_GOVERNMENT_CODE	RAW(50)	RAW50
CDN_ETHNICITY	VARCHAR2(2)	X_CDN_ETHNICITY
US_ETHNICITY	VARCHAR2(2)	X_US_ETHNICITY
US_RACE	VARCHAR2(2)	X_US_RACE

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 #

Click to create a new notes page