!!!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|AMTnn]| |
|[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |
|[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| |
|[JOB_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[WAGE_RATE]|Number(18)|[AMT12V6|AMTnn]| |
|[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|VARCHARnn]|Y|
|[CHANGE_DATE]|Date()|[DATE]|Y|
|[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|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|VARCHARnn]| |
|[MARKET_ADJUSTMENT]|NUMBER(18,6)|[AMT12V6|AMTnn]| |
|[PERFORMANCE_ELIGIBLE]|VARCHAR2(1)|[TOGGLE]| |
|[JOB_ROSTER]|VARCHAR2(30)|[X_JOB_ROSTER]| |
|[REPORT_HOURS_PER_WEEK]|Number(9)|[AMT5V4|AMTnn]| |


!![Derived Fields|DERIVED FIELDS]

||Column Name
|[DRV_EVALUATION_POINTS]

User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_CM_JOB_DETAILS] 	
[{InsertPage page='Internal.P2K_CM_JOB_DETAILS' default='Click to create a new notes page'}]