|
USDA SR Data
The USDA publishes nutrient data in the Nutrient Database for Standard Reference for us in products (like NutriBase). They assign a unique "Nutrient Data Bank" (NDB) number to each food item in this database. These food items are for 100 gram portions of these foods. These numbers are integers - they contain no letters, decimals, or other characters.
Canadian Nutrient File Numbers
Health Canada makes the Canadian Nutrient Files available for use in products (like NutriBase). They assign a unique number to each food item in this database. These food items are for 100 gram portions of these foods. These numbers are integers - they contain no letters, decimals, or other characters.
Brand Name Numbers
CyberSoft has compiled and included a large number of entries for brand name foods that the USDA has not compiled. CyberSoft has given these entries unique "NutriBase ID Numbers." CyberSoft Brand Name entries include food items and restaurant menu items. Each NutriBase ID Number is unique. No suffixes are used.
NutriBase ID Numbers
For many of the food items in both the SR data and the CNF data, both NDL and Health Canada have provided the gram weights for common household measures. Common household measures for the SR data tend to be in English measurements (tsp, tbsp, cups, oz, etc.) while the common household measures for the CNF data tend to be in metric measurements (grams, ml). CyberSoft did the arithmetic required to derive the nutrient values for all food items that included gram weights for common household measures. CyberSoft added suffixes to these common household measures and thereby produced "new" NutriBase ID Numbers.
CyberSoft used these original SR and CNF numbers to create similar numbers that we call the "NutriBase ID Number." CyberSoft did this by keeping the original identifying numbers for the 100 gram portions of these food items, then adding lower-case suffix letters ("a", "b", "c", "d", etc.) to these original numbers to represent the common household measures of these food items.
These suffixes indicate the relative gram weight of the household measurement. The lowest suffix ("a") denotes the household measurement with the lowest gram weight. The next letter suffix ("b") indicates the next highest gram weight, and so on. The NutriBase ID Number with the highest letter suffix designator has the highest gram weight (unless it is less than 100 grams).
Example:
| NDB # | Description | Measurement | Gram Weight
| 01001 | Butter, with salt | 100 grams | 100.0
| | 01001a | Butter, with salt | 1 pat | 5.0
| | 01001b | Butter, with salt | 1 tbsp. | 14.2
| | 01001c | Butter, with salt | 1 stick | 113.4
| | 01001d | Butter, with salt | 1 cup | 227.0 | |
Notice that the NutriBase ID Number with no suffix is the original number for the 100 gram portion. The lowest suffix ("a") denotes portion with the lowest gram weight and that the suffixes increment as the gram weights increase.
How to Display NutriBase ID Numbers
You can display the NutriBase ID Numbers for food items by double-clicking on any food item while you are viewing it in any spreadsheet view. Another way to do this is to highlight the food of interest, then clicking the View Button.
NutriBase ID Number Summary:
1) The NutriBase ID Numbers with no suffixes identify the original 100 gram portion food items from the SR Data or the CNF Data.
2) The NutriBase ID Numbers with suffixes identify the new food items that were derived from calculations based on household measure information provided in the SR or CNF data.
3) The smallest household measures have the smallest letter suffixes; the largest serving sizes have the largest letter suffixes.
4) The new NutriBase ID Numbers provide a unique identifier for every food item in the database.
| 
