Alias: DJD#

Unique Keys: _
Child Table: _
Parent Table: _

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

Derived Fields#

Column Name
DRV_EVALUATION_POINTS

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