DIA Condition - Missing Base Pay

Owned by Knowledge Assistant
Last updated: Mar 30, 2022



Description of Issue

I have a Missing Base Pay DIA condition that needs to be removed before our upgrade from 11.3 to 2019.1

Context
  • Payroll
  • System Administration
  • DIA - Data Integrity Assistant 
Cause
  • 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. 
Resolution

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.

  1. Go to Employee Job/Salary. (Payroll>Employee Maintenance>Employee Job/Salary)
  2. Search for the employee. Click Accept. Locate the pay record referenced in the DIA condition. Click Delete in the menu. 
  3. Choose Yes to the prompt to delete. 
Additional Information
  • 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