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 name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DJB_ID	Number(10)	ID	Y	link to P2K_CM_JOBS
DCR_ID	Number(10)	ID		link to P2K_CM_CHANGE_REASONS
DOC_ID	Number(10)	ID		link to P2K_CM_OCCUPATIONS
SSR_ID	Number(10)	ID		link to P2K_SA_SALARY_RANGES
DWR_ID	Number(10)	ID		link to P2K_CM_WORK_RULES
SWSS_ID	Number(10)	ID		link to P2K_SA_WAGE_SCALE_STEPS
RJP_ID	Number(10)	ID		link to P2K_RE_JOB_PROFILES
EFFECTIVE	Date()	EFFECTIVE	Y
EXPIRY	Date()	EXPIRY	Y
JOB_TITLE	Varchar2(50)	DESCRIPTION	Y
DESCRIPTION_1	Varchar2(50)	DESCRIPTION
DESCRIPTION_2	Varchar2(50)	DESCRIPTION
JOB_TYPE	Varchar2(2)	X_JOB_TYPE
JOB_CLASS	Varchar2(2)	X_JOB_CLASS
WCB_CLASS	Varchar2(2)	X_WCB_CLASS
EEO_CATEGORY	Varchar2(4)	X_EEO_CATEGORY
STD_HOURS_PER_DAY	Number(9)	AMT5V4
STD_HOURS_PER_WEEK	Number(9)	AMT5V4
STD_HOURS_PER_PAY	Number(9)	AMT5V4
JOB_POINTS	Number(5)	NUMBER5
WAGE_RATE	Number(18)	AMT12V6
RATE_BASIS	Varchar2(2)	X_RATE_BASIS
OVERTIME_EXEMPT	Varchar2(1)	TOGGLE
DIRECT_CHARGE	Varchar2(1)	TOGGLE
ASSIGNMENT_REQUIRED	Varchar2(1)	TOGGLE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
MUS_ID_PROFILE	Number(10)	ID		link to P2K_AM_USERS
SRT_ID	Number(10)	ID		link to P2K_SA_REVIEW_TYPES
JOB_FAMILY	Varchar2(200)	VARCHAR200
MARKET_ADJUSTMENT	NUMBER(18,6)	AMT12V6
PERFORMANCE_ELIGIBLE	VARCHAR2(1)	TOGGLE
JOB_ROSTER	VARCHAR2(30)	X_JOB_ROSTER
REPORT_HOURS_PER_WEEK	Number(9)	AMT5V4

Derived Fields#

Column Name
DRV_EVALUATION_POINTS

User Fields: Allowed
Audit Logging: Allowed

---

Notes #