DIA Condition - Missing Base Pay
- Knowledge Assistant
I have a Missing Base Pay DIA condition that needs to be removed before our upgrade from 11.3 to 2019.1
- Payroll
- System Administration
- DIA - Data Integrity Assistant
- A non-base pay record in Employee Job/Salary was existing without a Base Pay record.
- Risk Code on non-base pay did not match base pay record.
- Status on non-base pay did not match base pay record.
Table Information: The Employee Pays table stores employee pay information (information in Employee Job/Salary program).
Data Condition Information: Munis requires at least one base pay to exist for each data set, employee, job and Effective Date in Employee Job/Salary. Each data set, employee, job, pay and Effective Date combination listed is missing a corresponding base pay and should most likely be deleted. Alternately, a base pay may be added for the employee and job by selecting the "View" option and adding a base pay record in Employee Job/Salary.
Auto-Corrections: The following changes will be made, in order, when selecting the 'Auto-Correct' option for this data condition: The default action will be to remove all pays listed. Note that all changes made by the 'Auto-Correct' option will still need to be applied to the system using the 'Apply' option.
To delete the Pay Record manually.
- Go to Employee Job/Salary. (Payroll>Employee Maintenance>Employee Job/Salary)
- Search for the employee. Click Accept. Locate the pay record referenced in the DIA condition. Click Delete in the menu.
- Choose Yes to the prompt to delete.
- Employees can have multiple base pay records in Employee Job/Salary as long as they are in different Job Classes. You cannot have different base pay codes for a single Job Class.
- When an initial pay record is added to an employee, a base pay record must first exist, then additional non-base pay codes can be linked to that base pay/Job Class.
- The Data Set column on the DIA screen displays the proj number for the record. Proj 0 is live Employee Job Salary. Any proj between 101-200 or 1001-2000 are Projection Employee Job Salary records in a Salary Projection. Can view other proj codes in document Proj Codes in Payroll