P 2 K_LR_BUMP_RECORDS

Alias:LBR#

(P2K_LR_BUMP_RECORDS)

Unique Keys: Employee EEM_ID + Position DPS_ID + BUMP_DATE
ERD: ERD-LR06

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNUMBER(10,0) IDY
DPS_IDNUMBER(10,0) IDYLink to P2K_CM_POSITIONS
EEM_IDNUMBER(10,0) IDYLink to P2K_HR_EMPLOYMENTS
CHANGE_USERVARCHAR2(30) VARCHAR30Y
CHANGE_DATEDATE DATEY
CREATE_DATEDATE DATEY
CREATE_USERVARCHAR2(30) VARCHAR30Y
BUMP_DATEDATE DATE
BUMP_STATUSVARCHAR2(2) X_BUMP_STATUS

User Fields: Allowed
Audit Logging: Allowed


Notes #

Click to create a new notes page