CN Database Release Archive: CN15

Child Nutrition Database Release 15
(Final version posted April 1, 2011)

The Child Nutrition Database (CN-D) is required to be part of the software programs approved by USDA for use with Nutrient Standard Menu Planning (NSMP) or conducting analyses to meet School Meals Initiative (SMI) requirements. Data is collected on the following 15 nutrients: calories, total fat, saturated fat, trans fat, cholesterol, sodium, carbohydrate, dietary fiber, protein, vitamin A, vitamin C, calcium, iron, ash and moisture.

USDA Child Nutrition (CN) Database Online Web Tool for Submitting Nutrient Data

Food Manufacturers: Click here to add nutrient data to the CN Database for foods sold in the school market. You now need a Level 1 USDA eAuthorization account to access the Online Web Tool for Submitting Nutrient Data. When you go to the link above, click Register to obtain your eAuth account. When you return to submit data, select Sign In.

Comments and Notes for CN15 Release

CN15 Release: A record with a date after 3/31/2010 in the "date added" field is a new record in the CN15 release. A record with a date after 3/31/2010 in the "last modified" field contains a revised value in one or more of its fields with the CN15 release.

All records with a blank value for "last modified" date have been updated with the value in the "date added" field for that record in the CN15 release. For the purposes of tracking records with revised values in one or more fields, the "last modified" date must be later than 03/31/2010 AND different from the value in the "date added" field.

35 new USDA Foods (commodity foods) used in the National School Lunch Program and School Breakfast Program were added to CN15.

The "Food Category Code" values in the CTGNME file that do not have a corresponding code in the Standard Reference 23 FD GROUP table have all been marked as discontinued in CN15. These categories will be removed in the CN16 release. As a result, a number of items in the FDES file have been re-categorized moving them from the discontinued category to an active category.

Note for CN15: All Standard Reference 23 updates have been applied to the CN SREF products included in this release. 112 additional SREF products have been added and 25 SREF products have been coded as discontinued in this release. Nutrient and Weight change information was applied to the SREF products included in this release.

System Components and File Formats (documentation)
(MS Word) (plain text)

Child Nutrition Database in Access Format
Access Database
(right click and choose "Save Target As" or "Save Link As")
This file includes all the components listed below under the Comma Delimited Format

Child Nutrition Database in Plain Text Format

Please submit any issues or concerns regarding the Child Nutrition (CN) Database to:

Healthy Meals Resource System
Food and Nutrition Information Center
National Agricultural Library
10301 Baltimore Avenue, Room 105
Beltsville, MD 20705
Contact via E-Mail