Alias: DPD#

Unique Keys: DPS_ID_CHILD_OF + EFFECTIVE + EXPIRY
Child Table: P2K_SA_PREMIUM_USAGES, P2K_CM_DISTRIBUTIONS
Parent Table: P2K_CM_POSITIONS

ERD: ERD-CM40

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
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
LAST_REVIEW_DATE	Date()	DATE
SUSPENDED_DATE	Date()	DATE
ABOLISHED_DATE	Date()	DATE
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	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
BYPASS_ORG_CHART	Varchar2(1)	TOGGLE
ORG_RECORD_TYPE	Varchar2(2)	X_ORG_RECORD_TYPE
SP_KEY_POSITION	Varchar2(1)	TOGGLE
PERFORMANCE_ELIGIBLE	VARCHAR2(1)	TOGGLE
POSTING_RESP_CHECK_LEVEL	VARCHAR2(2)	X_RESPONSIBILITY_LEVEL
REPORT_HOURS_PER_WEEK	Number(9)	AMT5V4

Derived Fields#

Column Name
DRV_EVALUATION_POINTS
DRV_FIRST_MANAGER_EID

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page