P 2 K_RE_CANDIDATES
Back to current versionRestore this version

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_ADDRESSVarchar2(50)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

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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation