Wiki: P 2 K_CM_JOB

Alias: DJD#

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

Date Sensitive information for a job.

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

User Fields: Allowed
Audit Logging: Allowed