!!!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|AMTnn]| |
|[STD_HOURS_PER_WEEK]|Number(9)|[AMT5V4]| |
|[STD_HOURS_PER_PAY]|Number(9)|[AMT5V4|AMTnn]| |
|[POSITION_POINTS]|Number(5)|[NUMBER5|NUMBERn]| |
|[USE_FTE_WAGES]|Varchar2(1)|[TOGGLE]| |
|[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]| |
|[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|AMTnn]| |
|[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\\