Alias: RCA#

(P2K_RE_CANDIDATES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-RE30


Candidates

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
EID_ID_EMPLOYEENumber(10)ID link to P2K_HR_IDENTITIES
EID_ID_REFERRALNumber(10)ID link to P2K_HR_IDENTITIES
DSP_IDNumber(10)ID link to P2K_CM_STATE_PROVINCES
RRE_IDNumber(10)ID link to P2K_RE_RECRUITERS
DCO_IDNumber(10)ID link to P2K_CM_COUNTRIES
DSD_IDNumber(10)ID link to P2K_CM_SCHOOL_DISTRICTS
DSP_ID_MAILNumber(10)ID link to P2K_CM_STATE_PROVINCES
DTX_IDNumber(10)ID link to P2K_CM_TAX_JURISDICTIONS
CANDIDATE_CODEVarchar2(16)CODEY
DATE_SUBMITTEDDate()DATEY
CANDIDATE_STATUSVarchar2(2)X_CANDIDATE_STATUSY
CANDIDATE_TYPEVarchar2(2)X_CANDIDATE_TYPE
CANDIDATE_CATEGORYVarchar2(2)X_CANDIDATE_CATEGORY
CURRENT_EMPLOYERVarchar2(50)DESCRIPTION
CURRENT_TITLEVarchar2(50)DESCRIPTION
CANDIDATE_SOURCEVarchar2(2)X_CANDIDATE_SOURCE
CANDIDATE_PASSWORDVarchar2(16)VARCHAR16
PASSWORD_CHANGED_DATEDate()DATE
PASSWORD_CHANGED_BYVarchar2(50)VARCHAR50
EXTERNAL_CANDIDATE_IDVarchar2(16)VARCHAR16
GOVERNMENT_CODEVarchar2(16)GOVERNMENT CODE
GOVT_CODE_VERIFIEDVarchar2(1)TOGGLE
APPLICATION_START_DATEDate()DATE
APPLICATION_END_DATEDate()DATE
AVAILABILITY_DATEDate()DATE
FIRST_NAMEVarchar2(50)VARCHAR50
MIDDLE_NAMEVarchar2(50)VARCHAR50
LAST_NAMEVarchar2(50)VARCHAR50
SALUTATIONVarchar2(4)X_SALUTATION
RANKVarchar2(4)X_RANK
BIRTH_DATEDate()DATE
BIRTHPLACEVarchar2(50)VARCHAR50
GENDERVarchar2(2)X_GENDER
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
ETHNICVarchar2(4)X_ETHNIC
CHALLENGEDVarchar2(4)X_CHALLENGED
VETERAN_STATUSVarchar2(4)X_VETERAN_STATUS
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
MAIL_ADDRESS_LINE_1Varchar2(50)ADDRESS
MAIL_ADDRESS_LINE_2Varchar2(50)ADDRESS
MAIL_LOCALITYVarchar2(50)ADDRESS
MAIL_ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_UNLISTEDVarchar2(1)TOGGLE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
CELLULAR_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESS(Field)Varchar2(100)EMAIL
WEB_ADDRESSVarchar2(200)URL
MARITAL_STATUSVarchar2(2)X_MARITAL_STATUS
MARRIED_DATEDate()DATE
NUMBER_DEPENDENTSNumber(5)NUMBER5
TRANSPORTATIONVarchar2(2)X_TRANSPORTATION
YEARS_EDUCATIONNumber(5)NUMBER5
BONDED_STATUSVarchar2(2)X_BONDED
CITIZEN_STATUSVarchar2(2)X_CITIZEN_STATUS
FOREIGN_CODEVarchar2(16)CODE
DRIVERS_LICENSEVarchar2(30)LICENSE
HOW_TO_CONTACT_TEXTVarchar2(4000)VARCHAR4000
OBJECTIVES_TEXTVarchar2(4000)VARCHAR4000
CANDIDATE_TEXTVarchar2(4000)VARCHAR4000
PA_NUMBERNumber(10)NUMBER10
PA_EFFECTIVE_DATEDate()DATE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
GOVT_CODE_ORIGINVarchar2(2)X_GOVT_CODE_ORIGIN
RAW_BIRTH_DATERAW(50) RAW50
RAW_DRIVERS_LICENSERAW(50)RAW50
RAW_GOVERNMENT_CODERAW(50)RAW50
CDN_ETHNICITYVARCHAR2(2)X_CDN_ETHNICITY
US_ETHNICITYVARCHAR2(2)X_US_ETHNICITY
US_RACEVARCHAR2(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