Alias: DJD#

Unique Keys: DJB_ID + EFFECTIVE + EXPIRY
Child Table: P2K_SA_PREMIUM_USAGES, P2K_CM_DISTRIBUTIONS
Parent Table: P2K_CM_JOBS

ERD: ERD-CM40 Date Sensitive information for a job.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DJB_IDNumber(10)IDYlink to P2K_CM_JOBS
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
DOC_IDNumber(10)ID link to P2K_CM_OCCUPATIONS
SSR_IDNumber(10)ID link to P2K_SA_SALARY_RANGES
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
SWSS_IDNumber(10)ID link to P2K_SA_WAGE_SCALE_STEPS
RJP_IDNumber(10)ID link to P2K_RE_JOB_PROFILES
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
JOB_TITLEVarchar2(50)DESCRIPTIONY
DESCRIPTION_1Varchar2(50)DESCRIPTION
DESCRIPTION_2Varchar2(50)DESCRIPTION
JOB_TYPEVarchar2(2)X_JOB_TYPE
JOB_CLASSVarchar2(2)X_JOB_CLASS
WCB_CLASSVarchar2(2)X_WCB_CLASS
EEO_CATEGORYVarchar2(4)X_EEO_CATEGORY
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
JOB_POINTSNumber(5)NUMBER5
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
OVERTIME_EXEMPTVarchar2(1)TOGGLE
DIRECT_CHARGEVarchar2(1)TOGGLE
ASSIGNMENT_REQUIREDVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
MUS_ID_PROFILENumber(10)ID link to P2K_AM_USERS
SRT_IDNumber(10)ID link to P2K_SA_REVIEW_TYPES
JOB_FAMILYVarchar2(200)VARCHAR200
MARKET_ADJUSTMENTNUMBER(18,6)AMT12V6
PERFORMANCE_ELIGIBLEVARCHAR2(1)TOGGLE
JOB_ROSTERVARCHAR2(30)X_JOB_ROSTER
REPORT_HOURS_PER_WEEKNumber(9)AMT5V4

Derived Fields#

Column Name
DRV_EVALUATION_POINTS

User Fields: Allowed
Audit Logging: Allowed


Notes #

HL-810
P2K_CM_JOB_DETAILS - new field CLASS_CONCEPT