Vendor Export Configuration

For users with the appropriate OEDS access, the Vendor Export Configuration option will be available from the CNDC drop down menu of the navigation bar. This option requires the user to have update access to CNDC.

This option allows the CNDC participating district to customize the Vendor Export for their needs. Point of Sale (POS) systems may require the data that is being imported to be in a specific order and/or with specific column headings. The Vendor Export Configuration option will allow the district to specify what data is to be included in the export as well as the order and headings to be used. The defined setup will then be used by the Vendor Export that is available from the Review Student Summary Listing.

Default Configuration

The application provides a default configuration for the Vendor Export. By default there will be 14 data columns included. The following image shows the default configuration.

Customize Configuration

The following data elements may be included in the Vendor Export. These may be organized in any order needed and a custom heading/label applied. Any data element may be included/excluded from the export as needed with the exception of Export Run Date. Export Run Date is a required data element. The order and/or description for the Export Run Date may be updated but it can not be disabled/excluded.

Data Element	Description

Data Element	Description
Last name	Student last name
First name	Student first name
Birth date	Student date of birth
Local Student ID	Student ID assigned by the district
Free or Reduced	Benefit level, Free or Reduced
Reporting Year	School year for the benefit
Reporting Agency	Entity reporting the student
Guardian last name
Guardian first name
Street 1	Student/Guardian residence street
Street 2	Student/Guardian residence street
City	Student/Guardian residence city
State	Student/Guardian residence state
Zip code	Student/Guardian residence postal code
Middle name	Student middle name
Guardian middle name
Phone number	Guardian phone number
Student gender
County of Residence	County name and code of student/guardian residence
Admission date	Student admission date
Attending Building IRN	Six digit IRN for building the student attends
Attending Building Name	Building name of the building the student attends
Student Grade
Inactivated date	Date the student was unmatched
Inactivated by	Person who removed the student benefit match
Benefit Source	Source of the benefit: Medicaid, ODJFS, EMIS-SCR
Qualified By	Benefit type: SNAP, TANF, Medicaid, Homeless status, Migrant status, Household, Foster placement
Qualified date	Date the benefit was matched to the student
Data matched type	Full match or Potential match
Match By User	If benefit was manually matched, this will show the person who manually matched the benefit
User Matched On Date	Date that the benefit was manually matched
Unmatched By	If benefit was unmatched, this will show the person who unmatched the benefit
Unmatched on	Date that the benefit was unmatched
Matching data	Shows the data points that the student was matched to a benefit
Last modified date	Last time the benefit record was updated
Export Run Date	Date the vendor export was executed

Edit Configuration

The grid will have the data elements in the order they will appear in the actual export. Data elements that have been marked as exclude from the export will appear below the active data elements and faded/muted text.

The districts can use this Edit to define the output as needed.

When modifying the Column Order, if the same Column Order is assigned to more than one Data Element, the extract will provide those elements in alphabetic order within the Column Order number. Districts can better control the output by assigning a unique Column Order to each Data Element. When adjusting the Column Order numbers, the best results will be obtained by starting with the highest non-muted/faded number and re-ordering to the lowest non-muted/faded number. The faded/muted Data Elements will be those your Point of Sale (POS) system does not require, thus no updates would be needed for those.

An edit icon will appear on the left side of each data element. By clicking on the edit icon, a popup window will appear allowing the user to change the heading, column order number and mark the column as include or exclude.

When the updates are saved, the grid will be refreshed to reflect the updates that were just made.