Alias: RRE#

(P2K_RE_RECRUITERS)

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

Recruiters

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DSP_ID	Number(10)	ID		link to P2K_CM_STATE_PROVINCES
EAS_ID	Number(10)	ID		link to P2K_HR_ASSIGNMENTS
RECRUITER_CODE	Varchar2(16)	CODE	Y
RECRUITER_STATUS	Varchar2(2)	X_RECRUITER_STATUS	Y
RECRUITER_TYPE	Varchar2(2)	X_RECRUITER_TYPE	Y
RECRUITER_CATEGORY	Varchar2(2)	X_RECRUITER_CATEGORY
DESCRIPTION	Varchar2(50)	DESCRIPTION
COMPANY_NAME	Varchar2(50)	VARCHAR50
CONTACT_NAME	Varchar2(50)	VARCHAR50
CONTACT_TITLE	Varchar2(50)	DESCRIPTION
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
EMAIL_ADDRESS(Field)	Varchar2(100)	EMAIL
WEB_ADDRESS	Varchar2(200)	URL
ADDRESS_LINE_1	Varchar2(50)	ADDRESS
ADDRESS_LINE_2	Varchar2(50)	ADDRESS
LOCALITY	Varchar2(50)	ADDRESS
ZIP_POSTAL	Varchar2(16)	POSTAL CODE
RECRUITER_TEXT	Varchar2(4000)	VARCHAR4000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
RECRUITER_PASSWORD	Varchar2(16)	ENCRYPTED
MUS_ID	Number(10)	ID		link to P2K_AM_USERS
DPS_ID	Number(10)	ID		link to P2K_CM_POSITIONS

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page