Integrity Check

Data Integrity usually are 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, sometime some abnormal operation will break that integrity, e.g. User entered leave entries for a staff (e.g. on Mar 28) and later terminated the staff at 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, 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 Attendance Record is within the employee's Join Date and Termination Date's Period