P 2 K_CM_JOB_DETAILS

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 #

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