P 2 K_CM_POSITION_DETAILS

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 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
REPORT_HOURS_PER_WEEKNumber(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

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor

All content © High Line Corporation