/
DIA Condition - Missing Base Pay

DIA Condition - Missing Base Pay



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





Related content

DIA - Employee Pay Records - Duplicate Employee Job Salary Pays
DIA - Employee Pay Records - Duplicate Employee Job Salary Pays
More like this
Munis Data Integrity Assistant error Invalid Source Pay Type
Munis Data Integrity Assistant error Invalid Source Pay Type
More like this
Step Date on Non-base Pay Precedes Base Pay DIA Condition
Step Date on Non-base Pay Precedes Base Pay DIA Condition
More like this
DIA Condition - Invalid Pay Type
DIA Condition - Invalid Pay Type
More like this
Munis Data Integrity Assistant error Missing Invalid Calc Code
Munis Data Integrity Assistant error Missing Invalid Calc Code
More like this
Base pay information missing in Employee Inquiry
Base pay information missing in Employee Inquiry
More like this