IROC Compare

From the State, download the PROJECTIONS file.  Save it to your computer and then use this screen to upload it.  Click on the Choose File button, navigate to the location on your computer where you saved the PROJECTIONS file, then select it.  Next, click the Upload File and Download Excel Report button.  You will use this comparison report to gather any changes needed to be made in the State's software.

What happens when a PROJECTIONS file is uploaded....

1. For each row in the file, a record is created where a staff member can be found in SchoolFi with a matching Pensions / Member #.  All other records are discarded.
2. The following comparisons are made from the data in the file to actual payroll run data:
   1. Last Name of the Staff vs in the file (up to the ,)
   2. Base Salary This Quarter
   3. Pension Rate
   4. Pension Contributions  (Sum of pension deductions taken out this quarter from payroll history)
   5. Pension + Back Contributions (Sum of pension + back pen deductions taken out this quarter from payroll history)
   6. Back Deductions (Sum of back pen deductions taken out this quarter from payroll history)
   7. Arrears Deductions (Sum of arrears pen deductions taken out this quarter from payroll history)
   8. Insurance Premiums (Sum of Contributory Insurance deductions taken out this quarter from payroll history)
   9. Loan No. Pays (KNOWN ISSUE: SchoolFi value is loan balance / amount.  Doesn't seem to match what's in ROCK file)
   10. Loan Payments (Sum of Pension Loan Deductions taken out this quarter from payroll history)