Alias: RWH#

(P2K_RE_WORK_HISTORIES)

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

Work Histories

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
RCA_ID	Number(10)	ID	Y	link to P2K_RE_CANDIDATES
DSP_ID	Number(10)	ID		link to P2K_CM_STATE_PROVINCES
DIN_ID	Number(10)	ID		link to P2K_CM_INDUSTRIES
COMPANY_NAME	Varchar2(50)	VARCHAR50	Y
VERIFIED_STATUS	Varchar2(2)	X_VERIFIED_STATUS
DATE_VERIFIED	Date()	DATE
CONTACT_NAME	Varchar2(50)	VARCHAR50
CONTACT_TITLE	Varchar2(50)	DESCRIPTION
ADDRESS_LINE_1	Varchar2(50)	ADDRESS
ADDRESS_LINE_2	Varchar2(50)	ADDRESS
LOCALITY	Varchar2(50)	ADDRESS
ZIP_POSTAL	Varchar2(16)	POSTAL CODE
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
LANGUAGE_CODE	Varchar2(3)	X_LANGUAGE_CODE
COMPANY_SIZE	Varchar2(2)	X_COMPANY_SIZE
EMPLOYMENT_TYPE	Varchar2(2)	X_EMPLOYMENT_TYPE
GROUP_TYPE	Varchar2(2)	X_GROUP_TYPE
RESPONSIBILITY_LEVEL	Varchar2(2)	X_RESPONSIBILITY_LEVEL
JOB_CATEGORY	Varchar2(2)	X_JOB_CATEGORY
ASSIGNMENT_TITLE	Varchar2(50)	DESCRIPTION
ASSIGNMENT_START_DATE	Date()	DATE
ASSIGNMENT_END_DATE	Date()	DATE
REASON_FOR_LEAVING	Varchar2(2)	X_REASON_FOR_LEAVING
HOURS_PER_DAY	Number(9)	AMT5V4
HOURS_PER_WEEK	Number(9)	AMT5V4
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
WORK_HISTORY_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
AVAILABLE_TO_CONTACT	Varchar2(1)	TOGGLE

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_YEARS

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page