State of Vermont
Agency of Education
Data Collection and Reporting Knowledge Base
Data Collection and Reporting Knowledge Base
Here are the steps to perform a DC3 upload, which lets us know your enrollment information so we can tell you who is directly certified for FRL.
Only 3 files are required to be submitted to get your Direct Cert information:
03_0_Student_Identity.csv - Download Template - Specs
03_4_PS_Enroll.csv - Download Template - Specs
03_5_PS_GradeProg.csv - Download Template - Specs
Please prepare the above files based ontheir specifications.
To download the Reporting Group that now contains direct cert information for your previously submitted enrollment data in DC3.
Direct Certification for Free and Reduced Lunch
located at the bottom of the listNOTE if desired year is not visible, you must submit a DC#03 unofficial collection. The Information box will show you what source data the export is derived from.
The direct cert reports will be available in edfusion after the SU/SDs have submitted their DC#03 nighlty unofficial. Once an official collection is state certified, the reporting group will pull from the most recent official state certified data submission, below are instructions to pull your report;
The export will appear in the export history window below.
Columns BP-BV populates the following field names;
All YES values in either of the fields below, identify these students are directly certified to receive free lunch.
Each month AOE receives a file from DCF that lists names of all directly certified persons less than age 22. On (or around) the 20th of each month, AOE will upload a new Direct Cert list into the edfusion system.
If your source data is from DC#06_FALL_ADM_Official, DC#07_Spring_Official or DC#04_YearEndCollection_Official, the reporting group will not populate until all data is certified from every SU/SD in the state.
However,
DC#03_NightlyCollection_Unofficial source data will process overnight.
In order to obtain your Direct Cert information, you must upload the following 3 files. The DC#03 Unofficial Submission is the only submission that does not require you to load all templates with each submission. However, if the files you load contain relationship dependencies you will receive errors.
Vermont Agency of Education Child Nutrition Programs has been working with AOE's Data Team to create a new Food Service Directors User Role for EdFusion. This user role will allow Food Service Directors to run the Direct Certification for Free and Reduced Lunch reporting group.
We hope this new user role will improve ease of access to the Direct Cert information for Food Service Directors and simultaneously improve communication between Food Service Directors and Data Managers within an SU/SD.
The DC #03 Unofficial Enrollment is the enrollment list that Data Managers upload monthly in EdFusion from which the Direct Certification reporting group gets matched. The Direct Certification for Free and Reduced Lunch Report will only be as accurate as the most recently uploaded DC #03 Unofficial Enrollment. Only Data Managers have the ability to upload an updated DC # 03 Unofficial Enrollment. Food Service Directors should communicate with the Data Manager in their SU/SD in order to be sure that the enrollment is up to date monthly, and when any new student enrolls. AOE Child Nutrition Programs and Data Team will continue to communicate to Business Managers, Food Service Directors, and Data Managers through their respective ListServs about when the monthly Direct Certification information has been updated.
Food Service Directors must connect with Data Managers in their SU/SD in order to request user access to this new Food Service Director User Roll in EdFusion. Data Managers will then contact the AOE SLDS Support Group to request access on behalf of the Food Service Director.
Once the request is received, SLDS Support Group will send Food Service Directors an email with login information to access EdFusion.
When users receive the email with their username and temporary password, they should navigate to the EdFusion login page in order to change their password and begin accessing the site.
Before running a report be sure to remember: the Direct Certification for Free and Reduced Lunch Report will only be as accurate as the most recently uploaded DC #03 Unofficial Enrollment. Check with your data manager that the DC #03 is up to date before running this report. Additionally, a quick edit check could be performed by comparing your total monthly enrollment number against the number of students listed in the Direct Certification for Free and Reduced Lunch Report. For example, if you know that there are 1,705 students currently enrolled in your SU/SD but the report only shows you 1,696 students this may be an indicator the DC #03 is not up-to-date.
To create a reporting group:
From the landing page, hover over the "Insight" tab in the top left corner.
Select "Reporting Group" from the options that appear.
You will not be able to customize the first row, entitled "Selection Criteria." This is preselected to Source: Analysis Data Mart, Reporting Group: Direct Certification for Free and Reduced Lunch, and Columns: all selected. Under "Filter Criteria" choose the most current year as your School Year and select your LEA ID as the Submitting Org.
Underneath the "Information" section, and to the right, click "Create."
Wait a few moments for the request to process before scrolling down to "Export History" to view the report.
Click "Download" to view the file of the reporting group.
Once you run the Direct Certification for Free and Reduced Lunch reporting group and export the file to excel, you will be looking at a list of every student who is currently enrolled in your SU/SD along with their identifying information and relevant Direct Certification information. Put another way, this is a list of Directly Certified children and not-Directly Certified children.
Column headers of the report are defined below:
Column | Description |
---|---|
SY | School Year; school year 2021-2022 is denoted as '2022' |
ENRORGID | School ID Number |
ORGNAME | School Name |
ADMINID | LEA ID Number |
LCLSTUNUM | School/LEA's Internal Student ID Number |
PERMNUMBER | State-Issued Student ID Number |
FNAME | Student First Name |
MNAME | Middle Name |
LNAME | Last Name |
POSTNAME | Post Name |
DOB | Date of Birth |
GRADE | Grade; KF = Kindergarten, PK=Pre-K, AW= ,EE=Early Education |
DCERT_TANF_RUFA_REACHUP | YES or NO, Directly Certified through ReachUp (known nationally as TANF, previously referred to as RUFA) |
DCERT_SNAP_3SQUARESVT | YES or NO, Directly Certified through 3SquaresVT (known nationally as SNAP) |
DCERT_OTHER | This column is blank. It is currently a placeholder for a possible future Direct Certification Reporting Group category. |
DCERT_STATEPLACEDFOSTER | Every student should be listed as "NO" in this column, at this time. We are working on adding State Place Foster as a Direct Certification Reporting Group, but it is not yet live. |
When you first open your downloaded file in excel it will look similar to the below screenshot. Some columns may show the symbol '#' where the column is not wide enough to display all of the data (circled in red, below). Where that is the case, you must expand the column to see the full set of data.
Since this is a list of every single student currently enrolled in your SU/SD, you must sort the list if you want to view only the students who are directly certified (have a YES in either the ReachUp or 3SquaresVT columns).
To sort the data, select the entire sheet using the triangle in the leftmost corner of the sheet. Then click the "Sort & Filter" button in the top ribbon and select "Filter." These buttons are circled in purple in the below screenshot. Selecting the Filter option will result in the addition of dropdown arrows on each of the column headers. Click the dropdown button to sort the column by any of the header categories.
To sort by multiple levels (e.g. Sort first by School, then within each School sort further by 3SquaresVT and again by ReachUp) select the "Sort & Filter" button in the upper ribbon, choose "Custom Sort." Be sure "My data has headers" is selected in the upper right corner of the pop-out window before selecting your "Column," "Sort on," and "Order." Click the green plus sign in the upper left corner of the pop-out window to "Add Level," and when you're finished click "OK."
The most important headers in this reporting group are those which indicate if a student is Directly Certified for free school meals, DCERT_TANF_RUFA_REACHUP and DCERT_SNAP_3SQUARESVT. A "YES" in either of these columns indicates that the student in that row is Directly Certified. If a student has a "YES" in both the ReachUp and 3SquaresVT columns on the report, the 3SquaresVT classification takes precedence in categorizing the student in your eligibility lists or Point of Sale (POS) system.
The Direct Certification list is matches student ID numbers with enrollment data for ReachUp and 3SquaresVT that the VT Department for Children and Families (DCF) shares with the Agency of Education for use in determining Direct Certification. This data is not a complete list of all directly certified children. The definition of Direct Certification includes determinations of eligibility for free meals where the determining information comes directly from a state agency or other authority. Ways that children can be Directly Certified, in additional to being listed in the Direct Cert Report, include if the child is homeless, enrolled in the Migrant Education Program, in state-placed foster, or runaway.
The information in the Direct Certification list is on a need-to-know basis and should never be shared with anyone that is not directly involved in the eligibility determination for school meals. This list should not be shared with inquiring parents, school staff, or any other inquiring part who is not a determining official or school food service program administrator. Take care not to email the Direct Cert list and save and view it only from your work computer.
Users who have login credentials for EdFusion must follow these steps to set a new password:
Go to the EdFusion login page.
Enter your username as it was initially established in the email from AOE SLDS Support Group.
Click on the "Forgot Password" link.
Enter your username and click "Retrieve Credentials."
A one-time temporary password will be sent to the email address associated with your account. Copy the password exactly as it appears in the email, without any additional spaces at the beginning or end.
Return to the EdFusion login page and follow the prompts to reset your password, pasting in the temporary password from your email and creating a new password.
You will then have an opportunity to review your security questions and either click "Update" to change your answers, or "Go Home" to navigate to the landing page.
Go to the EdFusion login page.
Click on the "Forgot Login" link.
Enter the email associated with your EdFusion account and click "Retrieve Credentials."
Your Username will be emailed to you, as well as a link to reset your Password.
Please be sure to check your SPAM folder just in case the Password reset email was filtered out by your SPAM filter.
In the event you are unable to complete either of the Forgot Password or Forgot Login processes, or if you need technical assistance with EdFusion please contact the AOE SLDS Support Group at AOE.SLDSSupportGroup@vermont.gov.