P 2 K_RE_WORK_HISTORIES

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_ADDRESS(Field)Varchar2(100)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

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