Learn Systems Design
  • Home
  • About
  • Protocol
    • Log On To POS System
    • Log Off POS System
    • Unlock A Terminal
    • Check A Printer
    • Back Up Data
    • Download Join Me App
    • Install Hyperterminal 6.3
    • Install the DC ftp App
    • Install WinSCP .ftp program
    • Install Putty
  • Back Office Tutorials
    • End Of Day >
      • Back Office End of Day Video
    • End Of Month >
      • End of Month Video Tutorial
    • Master File Maintenance >
      • Master File Overview
      • Add A Student To The Master File
      • Change Information In The Master File
      • Menu Item Maintenance >
        • Enter New Menu Item
        • Change A Menu Item
        • Move A Menu
        • Menu Item Cost
      • Touch Screen Button Maintenance
      • Correct A Student Balance
      • Meal Input Corrections
      • Meals Per Labor Hour
      • Set A Credit Limit On Charges
      • Teacher Quick Input
    • About Reports >
      • Reports Menu Overview >
        • Print a Student Status Report
      • Other Reports Menu Overview >
        • Print Summary by School
      • Printing From Your PC >
        • Find Your Server IP Address
    • Site Based Claim >
      • File A Digital Reimbursement Claim
      • File A Manual Reimbursement Claim
    • Student Meal Balance Inquiry >
      • Student Meal Inquiry
      • Student Cash Inquiry
      • Print a Student Statement >
        • Student Statement Example
    • Transfer Funds Between Accounts
    • Print ID Cards and Homeroom Bar Code Lists >
      • Print Individual ID Cards
      • Print Home Room Bar Code Lists
    • The Home Room Input Feature
    • The Express Input Feature
    • Shortcut Entries >
      • Cash Report Shortcut
      • Meal Report Shortcut
      • Correct Reconciliation Shortcut
    • Quick Input Programs >
      • Employee Account Input
      • Quick Home Room Input
      • Direct Cert Quick Input
      • Teacher Homeroom Input
    • Community Eligibility Provision
    • AR Reports Information >
      • Section 100 Answers
      • Upload Letter Templates
      • Export Free and Reduced Students
      • Export Denied Students
      • Export Categorically Eligibile Students
      • Export Verification Report
      • Rated Meal Summary Report
      • Export Accuclaim Report For Review Month
      • Export the F R D .CVS File
    • Displaced Students Instructions
    • Find Server IP
    • Program and Non Program Revenue Reports >
      • Expanded Income Analysis >
        • Expanded Income Analysis Example
      • Expanded Sales Summary Report >
        • Expanded Sales Summary Report Example
      • Meal Summary By Date Range >
        • Meal Summary By Date Range Exammple
    • CoVid19 Set Up Process
    • SSO Preperation
    • Change SSO Reimbursement Rates
  • Application Processing
    • Application Program Overview
    • Basic Family Application
    • Multiple Students On Application
    • Multiple Incomes On Application
    • Direct Certification >
      • DC Medicaid Reduce Proceedures >
        • Medicaid Reduced Benefit Letter
        • Set Up User Code
        • Find Student on an Application
        • Print Letter of Benefits
    • Community Elgibility Report >
      • Community Elgibility Report Form
      • CEP Report Instructions
    • Change Grace Period
    • Temporary Status Expiration >
      • Print Letters to Expiring Statuses
      • Print A List Of Expiring Statuses >
        • The Expiring List Report
      • Update Temporary Student Statuses
    • Application Verification Process >
      • Running the Selection Process
      • Print Verification Notification Letters >
        • Printing Second Notice Letters
      • Change Grace Period
      • Print Audit Record Form
      • Print Application Totals Report >
        • Application Totals Report
      • Print Archived Application Totals Report >
        • Application Totals Report from Archives
      • Recording Verification Results
      • Print Adverse Action Letters
      • Print Verification Results Report >
        • Verification Results Report Example
    • Required March 2022 CEP Report >
      • March CEP Report Example
    • PK Categorically Eligible Status
    • PK Audit Report
    • PK True Eco Report
  • Instruction Sheets
    • Changing Meal and Cash History
    • Audit Preperation Instructions
    • Saving .pdf File To iPad
    • Back Office Admin Manual
    • POS Instruction Handout
    • Cashiers Manual
    • Cashier Quick Start Card
    • Correcting Cash Mistakes
    • Correcting Meal Mistakes
    • Direct Certification
    • CE File Upload Instructions
    • Installing Hyperterminal 6.3
    • Program Function Keys >
      • Touch Screen Button Layout
    • Print A Report To Excell
    • Calibrate Touchscreen
    • Summer Feeding Set Up
    • Negative Balance Email Setup
    • Set Up Teacher in LMN
  • Helpful Links
  • Director Orentation
  • Learning For Cashiers
    • Touch Screen Tutorial
    • Touch Screen Overview
    • Home Room Option
    • Log In To The POS
    • Log Off POS Terminal >
      • Log Off Acer
      • Log Off Termteck
    • Recording Meals >
      • Record A Free Students Meal
      • Record A Paid Students Meal
      • Record Ala Carte Sales
      • Recording Adult Meals
      • Recording Checks
      • POS Homeroom Option
    • Cash Receipts Posting >
      • Recording Cash Payments
      • Recording Check Payments
    • Cashier End Of Day Actions >
      • Print Cash Report >
        • The Cash Report
      • Print Meal Transaction Report >
        • The Meal Report
      • Clerk Reconciliation >
        • The Clerk Reconciliation Report
      • Campus Reconciliation >
        • The Campus Reconciliation Report
      • Managers Daily Deposit
    • Correcting Meal And Cash Mistakes >
      • Correcting Meal Mistakes
      • Correcting Cash Mistakes
    • Student Meal Balance Inquiry >
      • Student Meal Inquiry
      • Student Cash Inquiry
    • Cashier Report Menu >
      • Print Student Balances >
        • The Student Balances Report
      • Print School Menu Listing >
        • The School Menu Listing
      • Print Negative Balance Notices
    • After School Snacks >
      • Recording Snacks For Individuals
      • Recording Snacks Multiple Students
    • New Cashier Option >
      • Cashier End of Day Actions
      • Video on New Cashier Option
      • Cashier Option Change Feature
      • New Cashier Reports Option
    • Additional POS Features >
      • The Look Up Feature
      • The Received Listing
      • Quick Meal Totals
      • Balance Inquiry
      • Cash History Inquiry
    • Printable Documentation >
      • Cashier Quick Start Card
      • Touch Screen Information
      • Cashiers Manual
    • If Your Printer Won't Print
  • Contact Us
  • New Install Form
  • Sign Up Page
  • Classroom Help
  • Video Tutorials
    • Change Status of Meal Served
    • Print DC By Association List
  • P-EBT Program
  • Meals in Classroom
  • Non-Congregant Meals
    • NC POS Procedures
    • Clerk Handout NC Meals
    • Holiday Calendar
    • Correcting Prior Day Meals NC

Information That Will Assist In Your Review

The CE Administrative Review 2020+2021 has requirements to which Systems Design is providing  information so that you may answer questions and produce reports that are required by the AR.  We have created tutorials that will assist you in the printing of reports, and in some cases where appropriate, the extraction of data and then the transport of that data to your PC and then electronic submission to TXUMPS.  Reports may also be produced and printed in a traditional manner, scanned, and then submitted. Please note that some routines require that you have the Systems Design version of Hyperterminal 6.3 installed on the PC which is used to extract and submit the collected data.  Also note that you must create a directory on your PC named csdi.
Click here to view the tutorial on preparing Hyperterminal to transfer files.
Below you will find links to the text answers to AR questions and links to the mentioned tutorials on extracting certain data and the printing of certain data mentioned in the CE Administrative Review Checklist.  We have categorized the requirements by section and then provided links to the instructions.


Section 100
Answers to Questions in Section 100
Upload Letter Templates
Export Free and Reduced Student Files
Export Denied Student Files
Export Categorically Eligible Files
Section 200
Export Application Verification Reports
Section 300
Export the Rated Meal Summary Report

Export the Accuclaim Report for the Month of Review
You may wish to export a list of Free, Reduced and Denied students in a format which may be uploaded to TXUNPS.  Below you will find a link to a tutorial that will show you how to export a file in .CVS format which will permit you to construct an excel spreadsheet which will may be uploaded.
How to Export the F R D .CVS file
There may be other requirements and reports required for your audit.  If so, please call our software support office at 800.887.1828 so that our support staff may assist you.
The staff at Systems Design is available to assist you if required during the reviews.  There may be occasion where the reviewer could ask for reports and or information that are not part of the day to day routines that are familiar.  We will be assist you in obtaining information or reports upon your communication with our support office.


Contact Us
Meal App Now
Lunch Money Now
Systems Design Site