Free/Reduced program records can be imported into SchoolWise by using 'Import Meal Status Direct Certify from CALPADS' located in the Meals category of the Desktop Report Explorer. 


By using the import you understand and agree with the logic performed on your meal program records.



Please refer to the following logic before importing records into SchoolWise: 


 If Program/File Date is less than student school enrollment/calendar start date, use the latest date.


1. If Program record doesn't exist (Student is currently Paid): 

  • New program record added for Free or Reduced Status with Verify Type, Direct Cert Reason and Date from File. 

 

2. If Program Status is Reduced and File Status is Free 

a. And Program Date is BEFORE the File Date: 

  • Program record is closed 1 day prior to the File Date 
  • New program created with Status of 'Free' with Verify Type and Direct Cert Reason from File. 


     b. And Program Date is AFTER the File Date:

  • Update program Status with 'Free' and replace Date from File.


c. And Program Date is the SAME as the File Date:

  • Update program Status with 'Free' and Verify Type/Reason from File.
     

3. If Program Status is Free and File Status is Reduced 

    a. And Program Date is the SAME as the File Date 

        i. And Program Verify Type is 'Not Verified':  

  • Update program Status with 'Reduced' and update Verify Type and Direct Cert Reason from File.


    b. And Program Date is AFTER the File Date 

        i. And Program Verify Type is something other than 'Not Verified':  

  • New gap record created with Status of 'Reduced' with Verify Type, Direct Cert Reason and Date from File.
  • Gap record is closed 1 day prior to the Program Date 


        ii. And Program Verify Type is 'Not Verified':  

  • Update program Status with 'Reduced' and update Verify Type and Direct Cert Reason from File.


 

4. If Program and File Status are the SAME

a. And Program and File Date the SAME 

    i. And Program Verify Type is 'Not Verified': 

  • Update program record with Verify Type and Direct Cert Reason from File.


    ii. Program and File Verify Type is 'Direct Certify' and Reason is different: 

  • Update program record with the Direct Cert Reason from File.


b. And Program Date is BEFORE the File Date:   

    i. And Verify Type is the SAME:

  • Update program record with the Direct Cert Reason and Date from File.


ii. And Verify Type is NOT the SAME:

  • Program record is closed 1 day prior to the File Date 
  • New program record added with the new Verify Type and Reason from File

 

 c. And Program Date is AFTER the File Date:       

           i. And Program Verify Type is something other than 'Not Verified':  

  • New gap record created with Verify Type, Direct Cert Reason and Date from File.
  • Gap record is closed 1 day prior to the Program Date 


            ii. And Program Verify Type is 'Not Verified':  

  • Update program record with Verify Type, Direct Cert Reason and Date from File.