Alias: DPD#

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

Holds Date Effective information about a position.

Table Columns#


Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
DDP_IDNumber(10)IDYlink to P2K_CM_DEPARTMENTS
DPS_ID_CHILD_OFNumber(10)IDYlink to P2K_CM_POSITIONS
DLN_IDNumber(10)IDYlink to P2K_CM_LOCATIONS
DUN_IDNumber(10)IDYlink to P2K_CM_UNITS
DGR_IDNumber(10)IDYlink to P2K_CM_GROUPS
DJB_IDNumber(10)IDYlink to P2K_CM_JOBS
DAA_IDNumber(10)ID link to P2K_CM_AUTHORIZATION_AREAS
DWR_IDNumber(10)ID link to P2K_CM_WORK_RULES
DPS_ID_REPORTING_TONumber(10)ID link to P2K_CM_POSITIONS
EID_IDNumber(10)ID link to P2K_HR_IDENTITIES
SSR_IDNumber(10)ID link to P2K_SA_SALARY_RANGES
SWSS_IDNumber(10)ID link to P2K_SA_WAGE_SCALE_STEPS
DCR_IDNumber(10)ID link to P2K_CM_CHANGE_REASONS
EFFECTIVEDate()EFFECTIVEY
EXPIRYDate()EXPIRYY
POSITION_TITLEVarchar2(50)DESCRIPTIONY
DESCRIPTION_1Varchar2(50)DESCRIPTION
DESCRIPTION_2Varchar2(50)DESCRIPTION
POSITION_TYPEVarchar2(2)X_POSITION_TYPE
WCB_CLASSVarchar2(2)X_WCB_CLASS
LANGUAGE_CLASSVarchar2(2)X_LANGUAGE_CLASS
ORG_CHART_LEVELVarchar2(2)X_ORG_CHART_LEVEL
RESPONSIBILITY_LEVELVarchar2(2)X_RESPONSIBILITY_LEVEL
STD_HOURS_PER_DAYNumber(9)AMT5V4
STD_HOURS_PER_WEEKNumber(9)AMT5V4
STD_HOURS_PER_PAYNumber(9)AMT5V4
POSITION_POINTSNumber(5)NUMBER5
USE_FTE_WAGESVarchar2(1)TOGGLE
WAGE_RATENumber(18)AMT12V6
RATE_BASISVarchar2(2)X_RATE_BASIS
OVERTIME_EXEMPTVarchar2(1)TOGGLE
DIRECT_CHARGEVarchar2(1)TOGGLE
ASSIGNMENT_REQUIREDVarchar2(1)TOGGLE
POSITION_STATUSVarchar2(2)X_POSITION_STATUS
BUDGET_RULEVarchar2(2)X_BUDGET_RULE
AUTHORIZED_FTENumber(9)AMT5V4
FTE_OVERRIDE_RULEVarchar2(2)X_FTE_OVERRIDE_RULE
APPROVED_DATEDate()DATE
APPROVED_BYVarchar2(50)VARCHAR50
LAST_REVIEW_DATEDate()DATE
SUSPENDED_DATEDate()DATE
ABOLISHED_DATEDate()DATE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
DOC_IDNumber(10)ID link to P2K_CM_OCCUPATIONS
DIN_IDNumber(10)ID link to P2K_CM_INDUSTRIES
DEFAULT_FTENumber(9)AMT5V4
RJP_IDNumber(10)ID link to P2K_RE_JOB_PROFILES
PROVIDE_PUBLIC_SERVICEVarchar2(1)TOGGLE
PROVIDE_INTERNAL_SERVICEVarchar2(1)TOGGLE
SUPERVISORYVarchar2(1)TOGGLE
DLN_ID_PAYDESTNumber(10)ID link to P2K_CM_LOCATIONS
SRT_IDNumber(10)ID link to P2K_SA_REVIEW_TYPES
JOB_FAMILYVarchar2(200)VARCHAR200
BYPASS_ORG_CHARTVarchar2(1)TOGGLE
ORG_RECORD_TYPEVarchar2(2)X_ORG_RECORD_TYPE
SP_KEY_POSITIONVarchar2(1)TOGGLE
PERFORMANCE_ELIGIBLEVARCHAR2(1) TOGGLE
POSTING_RESP_CHECK_LEVELVARCHAR2(2) X_RESPONSIBILITY_LEVEL

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
This particular version was published on 26-Nov-2021 10:22 by khiggs.Top