Validate Payroll Data {FPRIV-1}

This program performs extensive validation of the following salary-related records: personnel biographical information, service records, and fund membership.

Up to three error reports will be produced by the program, containing “Fatal Errors” and / or “Warnings”.  

An error report is produced if there is at least one fatal error or warning.  

A control report is always produced.  

The ideal situation is a personnel database, which produces a control report with a zero fatal error count and a zero warning count.

The fatal errors will cause either the salary calculation or the SITE/IRP5 program to crash or act unpredictably; the warnings will, or may, affect the correctness of salary calculations and tax certificates.

1. Validation Of Salary-Related Data
• Fatal Errors:
• Invalid marital status
• Invalid increase month
• Invalid account type for payment type bank or tape transfer
• No bank account or branch code for bank or tape transfer
• Invalid bonus month
• Tax-on-bonus indicator is equal to “M” for bonus month equal to 0 or null
• Invalid calculation number or pay_date
• No notch record in the Salary Notch Record table. (A notch value of 0 should exist for Paid By Claim employees.)
• Warnings:
• Invalid tax-on-bonus indicator
• Invalid payment type
•  “C” Records without “Q” records.  (Payroll calculations without cheques.)
   
2. Validation Of Fund Membership Records
• Fatal Error
• Duplicate end dates
   
3. Validation Of Service Records
• Fatal Errors:
• No service records at all
• Duplicate start dates
• Duplicate end dates
• Start date on record bigger than end date
• End date of record is bigger than start date of next
• No record with start date = appointment date
• No record with end date = resignation date
• Record has no end date, but resignation date exists
• Record with no end date is followed by record with end date
• Warnings:
• Post, Rank or Appointment code or name missing
  

• Procedures:
• None