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 | Y | |
| CHANGE_DATE | DATE | DATE | Y | |
| CREATE_DATE | DATE | DATE | Y | |
| CREATE_USER | VARCHAR2(30) | VARCHAR30 | Y | |
| BUMP_DATE | DATE | DATE | Y | |
| BUMP_STATUS | VARCHAR2(2) | X_BUMP_STATUS |
User Fields: Allowed
Audit Logging: Allowed
