| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
The Miscellaneous button allows you to run Audit Reports, Franklin in Test Mode, and review Prior-Year Databases. |
...
- From the Utilities tab, locate Miscellaneous Setup. Then, select Audit/Review Processed Applications.
- Establish the Audit Review parameters in the Application Audit Review window. Then, click Ok.
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.
A list of applications, household details and eligibility statuses will appear. Click on the plus + icon next to each Batch Code to expand the batch and view applications.
Info 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. You may drag other headers behind the first group to create subgroups.
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.
You may select a batch Once a batch has been highlighted, the following options are available
| Section | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| 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 | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
| width | 40% |
|---|
...
:
...
- 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 | ||
|---|---|---|
| ||
|
| Column | ||
|---|---|---|
| ||
|
...
| width | 40% |
|---|
- 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.
...
| width | 5% |
|---|
...
- 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.
...
| width | 40% |
|---|
- Once a batch has been highlighted, the following options are available:
- Review Application
- Review Student
- Comments
- View Image
- Application Detail Report
- Export to HTML
...
| Column | ||
|---|---|---|
| ||
Review Application and Application Detail Report will only pull up one application ID at a time.
...
| width | 5% |
|---|
| Column | ||
|---|---|---|
| ||
|
...
| width | 40% |
|---|
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.
...
...
...
| width | 55% |
|---|
...
...
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.
...
| width | 5% |
|---|
...
| width | 55% |
|---|
...
...
| width | 40% |
|---|
...
...
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 | ||
|---|---|---|
| ||
|
...
...
...
...
| width | 40% |
|---|
...
- Create a folder name and hit the return button when you are done. Then, click Open.
...
| Column | ||
|---|---|---|
| ||
|
...
| width | 40% |
|---|
...
Click Save.
Warning Do not change the file name. It must remain as index.html in order to work properly
...
.
...
...
...
| width | 55% |
|---|
...
...
You should see export data processes running. It may take a few minutes for all of the data to fully export.
...
| width | 5% |
|---|
...
| Column | ||
|---|---|---|
| ||
|
Once the export process has completed, an internet browser window will appear.
...
...
| Anchor | ||||
|---|---|---|---|---|
|
...
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 to perform functions without affecting your current database.
| Section | ||
|---|---|---|
| Column | ||
| ||
| Info | ||
In order for Test Mode to work, a test database must first be established in Advanced Setup in the Administration and Maintenance section. |
...
- From the Utilities tab, locate Miscellaneous Setup. Then, select
...
- Test Mode.
| Column | ||
|---|---|---|
| ||
|
| Column | ||
|---|---|---|
| ||
|
...
| width | 40% |
|---|
...
- Select the Test Database you wish to use when performing functions. Then, click Connect.
...
| Column | ||
|---|---|---|
| ||
|
...
| width | 40% |
|---|
...
- Enter your username and password and click Ok.
...
| Column | ||
|---|---|---|
| ||
|
...
...
| width | 55% |
|---|
...
| 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, select Test Mode (Utilities → Miscellaneous → Test Mode) again to be returned to the login screen and the live database.
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.
...
| Anchor | ||||
|---|---|---|---|---|
|
...
The Prior-Year Database option allows you to login and review information from a prior-year.
...
| width | 40% |
|---|
...
- From the Utilities tab, locate Miscellaneous Setup. Then, select
...
| width | 40% |
|---|
...
- Prior-Year Database.
| Column | ||
|---|---|---|
| ||
|
| Column | ||
|---|---|---|
| ||
|
...
- Select the Prior-Year Database you wish to review. Then, click Connect.
...
| Column | ||
|---|---|---|
| ||
|
...
...
| width | 40% |
|---|
...
- Enter your username and password and click Ok.
| Column | ||
|---|---|---|
| ||
|
| Column | ||
|---|---|---|
| ||
|
- Perform the functions to review information in the Prior-Year Database. Once you are done, select Prior-Year Database (Utilities → Miscellaneous → Prior-Year Database) again to be returned to the login screen and the live database.
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.
...
