Integrity Check
Integrity Check is under System Manager
Data Integrity usually is performed by the system through the use of standard rules and procedures and is maintained through the use of error checking and validation routines. However, sometimes some abnormal operation will break that integrity, e.g. User entered leave entries for an employee (e.g. on Mar 28) and later terminated the employee at an earlier date (e.g. on Mar 12). In this case, the balance displayed is kind of incorrect.
This Integrity check will perform some checking and report the abnormal cases.
Optionally select which Integrity check to perform, and click the Begin Check button to start the checking.
1. Duplicated Appointment History Start Date Check
Check if there exists AppointmentHistory with the same Start Date
2. Employee Join Date vs Appointment History Start Date Integrity Check
Check whether the Join Date is the Appointment History Start Date in first line in Employee Master.
3. Employee with empty Global Work Hrs Type and Roster Code
Check whether both Global Work Hrs Type and Roster Code are empty in Employee Master.
4. Join Date vs MPF Dates Check
Check whether there exists payroll records that the MPF Contribution Date is earlier than the Month of the Join Date.
5. Leave Date vs EE Join Date/Termination Date Integrity Check
Check if the Leave Date in Leave Entry is within the employee's Join Date and Termination Date.
6. Leave Records vs Leave Day Records
Check if the Leave Records are consistence with the Leave Day Records.
7. Payroll Period vs EE Join Date/Termn Date Integrity Check
Check if the Employee's Payroll Batches are within the employee's Join Date and Termination Date.
8. Salary Info SI vs Appointment History PH Integrity Check
Check whether the payroll amounts in Salary Info tab is consistence with the payroll amounts in Appointment History in Employee Master.
9. Work Pay vs Basic Salary
Check if the Work Pay (i.e. Hourly Pay, Daily Pay) and Monthly Pay are both defined in Employee Master.
10. Duplicated Employee Email Address
Check if there exists active employees with the same Email Address.
11. Attendance Date vs EE Join Date / Termination Date Integrity Check
Check if the Period of the Attendance Date in the Attendance Record is within the employee's Join Date and Termination Date's Period.
12. Invalid Cost Centre Percentage Sum Integrity Check
Whether the sum of the cost centre is 100% or not.
13. Leave Entry days vs calculated days
Whether the calculated leave days based on the current settings are equal to the days recorded in the Leave Entry or not.
You can create the integrity check runs in a regular interval using Business Alert. See Business Alert/User Query Samples