Alias: RWH#

(P2K_RE_WORK_HISTORIES)

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


Work Histories

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
RCA_IDNumber(10)IDYlink to P2K_RE_CANDIDATES
DSP_IDNumber(10)ID link to P2K_CM_STATE_PROVINCES
DIN_IDNumber(10)ID link to P2K_CM_INDUSTRIES
COMPANY_NAMEVarchar2(50)VARCHAR50Y
VERIFIED_STATUSVarchar2(2)X_VERIFIED_STATUS
DATE_VERIFIEDDate()DATE
CONTACT_NAMEVarchar2(50)VARCHAR50
CONTACT_TITLEVarchar2(50)DESCRIPTION
ADDRESS_LINE_1Varchar2(50)ADDRESS
ADDRESS_LINE_2Varchar2(50)ADDRESS
LOCALITYVarchar2(50)ADDRESS
ZIP_POSTALVarchar2(16)POSTAL CODE
PHONE_NUMBERVarchar2(20)TELEPHONE
PHONE_EXTENSIONVarchar2(16)VARCHAR16
ALT_PHONE_NUMBERVarchar2(20)TELEPHONE
ALT_PHONE_EXTENSIONVarchar2(16)VARCHAR16
FAX_NUMBERVarchar2(20)TELEPHONE
EMAIL_ADDRESSVarchar2(50)EMAIL
LANGUAGE_CODEVarchar2(3)X_LANGUAGE_CODE
COMPANY_SIZEVarchar2(2)X_COMPANY_SIZE
EMPLOYMENT_TYPEVarchar2(2)X_EMPLOYMENT_TYPE
GROUP_TYPEVarchar2(2)X_GROUP_TYPE
RESPONSIBILITY_LEVELVarchar2(2)X_RESPONSIBILITY_LEVEL
JOB_CATEGORYVarchar2(2)X_JOB_CATEGORY
ASSIGNMENT_TITLEVarchar2(50)DESCRIPTION
ASSIGNMENT_START_DATEDate()DATE
ASSIGNMENT_END_DATEDate()DATE
REASON_FOR_LEAVINGVarchar2(2)X_REASON_FOR_LEAVING
HOURS_PER_DAYNumber(9)AMT5V4
HOURS_PER_WEEKNumber(9)AMT5V4
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
WORK_HISTORY_TEXTVarchar2(4000)VARCHAR4000
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
AVAILABLE_TO_CONTACTVarchar2(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
This particular version was published on 26-Nov-2021 10:22 by JEscott.Top