Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Panel
bgColor#ffffff
titleColor#ffffff
titleBGColor#5084ee
titleOverview

The Miscellaneous button allows you to run Audit Reports, Franklin in Test Mode, and review Prior-Year Databases.

Section
Column
width40%

 In the Utilities tab, locate and click on the Miscellaneous button.

Column
width5%

 

Column
width55%

 


Anchor
AuditReview
AuditReview
Audit/Review Processed Applications

Info

The steps below do not reflect the entire Audit/Review process. In order to view complete details to complete Audit/Review reports, refer to MCS Suite - Report & Audit Guidelines.

Section
Column
width40%

Step 1: Create the Review Processed Applications report.

  • Locate the Utilities tab. Then, select Miscellaneous Setup > Audit/Review Processed Applications.

 

Column
width5%

 

Column
width55%



Section
Column
width40%

Step 2: Establish the Audit Review parameters in the Application Audit Review window.

  • Select By Category, then use the magnifying glass  icon to select the CRE category.
Info

If you choose to filter by Specific School, separate export folders will need to be created for each school.

  • After you have selected the category, click the next magnifying glass  icon to select the Category Description.
  • You may choose to add a filter to the audit report. 
    • Scanned Batch - Enter a specific batch number.
    • Online applications Received On - Enter a date to select only online applications on a particular date.
    • All applications - Creates a report for all applications in the category and category description.
  • Include Only Current Applications - This box is checked off by default. You may choose to uncheck the box.

 

When you are done, click Ok.

Column
width5%

 

Column
width55%

 


Step 3: 
A list of applications, household details and eligibility statuses will appear.

Section
Column
width40%
  • Franklin gives you the ability to group the applications by headers. To group by Batch Code, left-mouse click on the Batch Code column. While holding down the left-mouse button, drag and drop the header into the area stating "Drag a column header here to group by that column." Release the left mouse button once you have dragged the header to the position.
Note

You can drag other headers behind the first group to create subgroups.


Column
width5%

 

Column
width55%

  • Click on the plus  icon next to each Batch Code to expand the batch and view applications.
    • If you see Online Application (Click to View), the application was received online. You can view the submitted information by clicking on the link and logging in to the Apply for Lunch website.

  • If you see an image, a hardcopy of the application was received and scanned into the system.

Section
Column
width40%
  • Once a batch has been highlighted, the following options are available:
    • Review Application
    • Review Student
    • Comments
    • View Image
    • Application Detail Report
    • Export to HTML
Note

Review Application and Application Detail Report will only pull up one application ID at a time.

Column
width5%

 

Column
width55%

 



Section
Column
width40%

Step 4: Create the Export Audit Report

To create an entire report that simulates the Scanning Report, you need to export the file. Click Export All to HTML.

Column
width5%

 

Column
width55%

 



Section
Column
width40%

Step 5: Choose how to sort exported data

In the Export Audit-Review Data window, select which way data should be sorted. Then click Ok.

Column
width5%

 

Column
width55%

 



Section
Column
width40%

Step 6: Establish an export path

Warning

You must create a new, empty folder in order to successfully export the Audit/Review file.

  • A window will appear for you to save the file. Choose the location you wish to save the file by clicking on the list to the left.
  • Then, right-click the mouse and locate New. A subwindow will appear.
  • Click on New Folder.
Column
width5%

 

Column
width55%

 

Section
Column
width40%
  • Create a folder name and hit the return button when you are done. Then, click Open.
Column
width5%

 

Column
width55%

 

Section
Column
width40%
Warning

Do not change the file name. It must remain as index.html in order to work properly.

  • Click Save.
Column
width5%

 

Column
width55%

 

Section
Column
width40%

You should see export data processes running. It may take a few minutes for all of the data to fully export.

Column
width5%

 

Column
width55%

 

Once the export process has completed, an internet browser window will appear.


Anchor
Test Mode
Test Mode
Test Mode

Info

In order for Test Mode to work, a test database must first be established in Advanced Setup in the Administration and Maintenance section.

 If you wish to attempt  to perform an operation and are unsure how the results will affect your data, you can choose Test Mode. This will allow you perform functions without affecting your current database.

Section
Column
width40%

 Locate the Utilities tab. Then, select Miscellaneous Setup > Test Mode.

Column
width5%

 

Column
width55%

 

Section
Column
width40%

 Select the Test Database you wish to use when performing functions. Then, click Connect.

Column
width5%

 

Column
width55%

 

Section
Column
width40%

Enter your username and password and click Ok.

Column
width5%

 

Column
width55%

 

Info

The Test Database and Prior-Year Database appear with a different background color and text to indicate you are not in the original database.

Perform the functions in Test Mode to review the results. Once you are done, close Franklin. Upon login, you will be returned to the original database.


Anchor
Prior Year
Prior Year
Prior-Year Database

 

Info

A Prior-Year Database allows you to login and review information from a prior-year.

Section
Column
width40%

 Locate the Utilities tab. Then, select Miscellaneous Setup > Prior-Year Database.

Column
width5%

 

Column
width55%

 

Section
Column
width40%

 Select the Prior-Year Database you wish to review. Then, click Connect.

Column
width5%

 

Column
width55%

 

Section
Column
width40%

Enter your username and password and click Ok.

Column
width5%

 

Column
width55%

 

Info

The Test Database and Prior-Year Database appear with a different background color and text to indicate you are not in the original database.

Perform the functions to review information in the Prior-Year Database. Once you are done, close Franklin. Upon login, you will be returned to the original database.