Table Information for the Update Salaries For Compensation Plan Changes Screen
Changes to this screen update the following:
- Update Employees for Compensation Plan Changes: PARMS_HSCOMP
- Compensation Plan Salary Ranges: COMP_PLAN_LN
- Compensation Plan Setup: COMP_PLAN_SETUP
- Employee: EMPL
- Employee Salary Information: EMPL_LAB_INFO
- Employee Taxes: EMPL_TAX
- Labor Settings: LAB_SETTINGS
- Pay Periods: PAY_PD
- Timesheet Periods: TS_PD
Report Columns
| Column Heading | Screen | Table Name |
|---|---|---|
| Employee ID | Employee User Flow | EMPL |
| Employee Salary Information | EMPL_LAB_INFO | |
| Employee Name | Employee User Flow | EMPL |
| Employee Salary Information | EMPL_LAB_INFO | |
| Current Effective Dt/ Next Rvw Dt | Employee Salary Information/Employee User Flow | EMPL_LAB_INFO/ EMPL |
| Home Organization/ Labor Group | Employee Salary Information | EMPL_LAB_INFO |
| Grade | Employee Salary Information | EMPL_LAB_INFO |
| Current Annl Amt/ New Annl Amt | Employee Salary Information/ Compensation Plan Salary Ranges | EMPL_LAB_INFO/ COMP_PLAN_HDR, COMP_PLAN_LN |
| Annual Difference | Employee Salary Information/ Compensation Plan Salary Ranges
** New Annl Amt - Current Annl Amt ** |
EMPL_LAB_INFO/ COMP_PLAN_HDR, COMP_PLAN_LN
**New Annl Amt - Current Annl Amt ** |
| Salary Difference | Derived - Annual Difference / pay periods | No particular tables |
| Eligible to Update | If there is a positive Salary Difference, the employee is eligible to update. | No particular tables |