!!!Alias:LBR
(P2K_LR_BUMP_RECORDS)

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

 
!!Table Columns
||Column name||Data Type / Size||Domain||Mand.||Notes
|[ID]|NUMBER(10,0)| [ID]|Y|
|[DPS_ID]|NUMBER(10,0)| [ID]|Y|Link to [P2K_CM_POSITIONS]
|[EEM_ID]|NUMBER(10,0)| [ID]|Y|Link to [P2K_HR_EMPLOYMENTS]
|[CHANGE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[CHANGE_DATE]|DATE| [DATE]|Y|
|[CREATE_DATE]|DATE| [DATE]|Y|
|[CREATE_USER]|VARCHAR2(30)| [VARCHAR30|VARCHARnn]|Y|
|[BUMP_DATE]|DATE| [DATE]|Y|
|[BUMP_STATUS]|VARCHAR2(2)| [X_BUMP_STATUS ]| |

User Fields: Allowed\\
Audit Logging: Allowed\\


----
![Notes|Edit:Internal.P2K_LR_BUMP_RECORDS] 	
[{InsertPage page='Internal.P2K_LR_BUMP_RECORDS' default='Click to create a new notes page'}]