!!!Alias: DPD Unique Keys: ___\\ Child Table: ___\\ Parent Table: ___\\ \\ Holds Date Effective information about a position. !!Table Columns \\ ||Column name||Data Type / Size||Domain||Mand.||Notes |[ID]|Number(10)|[ID]|Y| |[DDP_ID]|Number(10)|[ID]|Y|link to [P2K_CM_DEPARTMENTS] |[DPS_ID_CHILD_OF]|Number(10)|[ID]|Y|link to [P2K_CM_POSITIONS] |[DLN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_LOCATIONS] |[DUN_ID]|Number(10)|[ID]|Y|link to [P2K_CM_UNITS] |[DGR_ID]|Number(10)|[ID]|Y|link to [P2K_CM_GROUPS] |[DJB_ID]|Number(10)|[ID]|Y|link to [P2K_CM_JOBS] |[DAA_ID]|Number(10)|[ID]| |link to [P2K_CM_AUTHORIZATION_AREAS] |[DWR_ID]|Number(10)|[ID]| |link to [P2K_CM_WORK_RULES] |[DPS_ID_REPORTING_TO]|Number(10)|[ID]| |link to [P2K_CM_POSITIONS] |[EID_ID]|Number(10)|[ID]| |link to [P2K_HR_IDENTITIES] |[SSR_ID]|Number(10)|[ID]| |link to [P2K_SA_SALARY_RANGES] |[SWSS_ID]|Number(10)|[ID]| |link to [P2K_SA_WAGE_SCALE_STEPS] |[DCR_ID]|Number(10)|[ID]| |link to [P2K_CM_CHANGE_REASONS] |[EFFECTIVE]|Date()|[EFFECTIVE]|Y| |[EXPIRY]|Date()|[EXPIRY]|Y| |[POSITION_TITLE]|Varchar2(50)|[DESCRIPTION]|Y| |[DESCRIPTION_1]|Varchar2(50)|[DESCRIPTION]| | |[DESCRIPTION_2]|Varchar2(50)|[DESCRIPTION]| | |[POSITION_TYPE]|Varchar2(2)|[X_POSITION_TYPE]| | |[WCB_CLASS]|Varchar2(2)|[X_WCB_CLASS]| | |[LANGUAGE_CLASS]|Varchar2(2)|[X_LANGUAGE_CLASS]| | |[ORG_CHART_LEVEL]|Varchar2(2)|[X_ORG_CHART_LEVEL]| | |[RESPONSIBILITY_LEVEL]|Varchar2(2)|[X_RESPONSIBILITY_LEVEL]| | |[STD_HOURS_PER_DAY]|Number(9)|[AMT5V4]| | |[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4]| | |[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4]| | |[POSITION_POINTS]|Number(5)|[NUMBER5|NUMBERn]| | |[USE_FTE_WAGES]|Varchar2(1)|[TOGGLE]| | |[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]| | |[POSITION_STATUS]|Varchar2(2)|[X_POSITION_STATUS]| | |[BUDGET_RULE]|Varchar2(2)|[X_BUDGET_RULE]| | |[AUTHORIZED_FTE]|Number(9)|[AMT5V4]| | |[FTE_OVERRIDE_RULE]|Varchar2(2)|[X_FTE_OVERRIDE_RULE]| | |[APPROVED_DATE]|Date()|[DATE]| | |[APPROVED_BY]|Varchar2(50)|[VARCHAR50|VARCHARnn]| | |[LAST_REVIEW_DATE]|Date()|[DATE]| | |[SUSPENDED_DATE]|Date()|[DATE]| | |[ABOLISHED_DATE]|Date()|[DATE]| | |[CREATE_DATE]|Date()|[DATE]|Y| |[CREATE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[CHANGE_DATE]|Date()|[DATE]|Y| |[CHANGE_USER]|Varchar2(30)|[VARCHAR30|VARCHARnn]|Y| |[DOC_ID]|Number(10)|[ID]| |link to [P2K_CM_OCCUPATIONS] |[DIN_ID]|Number(10)|[ID]| |link to [P2K_CM_INDUSTRIES] |[DEFAULT_FTE]|Number(9)|[AMT5V4]| | |[RJP_ID]|Number(10)|[ID]| |link to [P2K_RE_JOB_PROFILES] |[PROVIDE_PUBLIC_SERVICE]|Varchar2(1)|[TOGGLE]| | |[PROVIDE_INTERNAL_SERVICE]|Varchar2(1)|[TOGGLE]| | |[SUPERVISORY]|Varchar2(1)|[TOGGLE]| | |[DLN_ID_PAYDEST]|Number(10)|[ID]| |link to [P2K_CM_LOCATIONS] |[SRT_ID]|Number(10)|[ID]| |link to [P2K_SA_REVIEW_TYPES] |[JOB_FAMILY]|Varchar2(200)|[VARCHAR200|VARCHARnn]| | User Fields: Allowed\\ Audit Logging: Allowed\\