P 2 K_RE_RECRUITERS

Alias: RRE#

(P2K_RE_RECRUITERS)

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


Recruiters

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DSP_IDNumber(10)ID link to P2K_CM_STATE_PROVINCES
EAS_IDNumber(10)ID link to P2K_HR_ASSIGNMENTS
RECRUITER_CODEVarchar2(16)CODEY
RECRUITER_STATUSVarchar2(2)X_RECRUITER_STATUSY
RECRUITER_TYPEVarchar2(2)X_RECRUITER_TYPEY
RECRUITER_CATEGORYVarchar2(2)X_RECRUITER_CATEGORY
DESCRIPTIONVarchar2(50)DESCRIPTION
COMPANY_NAMEVarchar2(50)VARCHAR50
CONTACT_NAMEVarchar2(50)VARCHAR50
CONTACT_TITLEVarchar2(50)DESCRIPTION
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESS(Field)Varchar2(100)EMAIL
WEB_ADDRESSVarchar2(200)URL
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
RECRUITER_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
RECRUITER_PASSWORDVarchar2(16)ENCRYPTED
MUS_IDNumber(10)ID link to P2K_AM_USERS
DPS_IDNumber(10)ID link to P2K_CM_POSITIONS

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