The Download Item Database report located from the report icon in the upper right hand corner of the Item Database screen will allow you to download an excel report of all of the items in the Item Database with some related attributes of each item. The intention with this report is that it can be used for auditing purposes and gives the user the ability to see and sort items in the Item Database in a way that is more convenient than looking at the items from the Item Database UI.
The information that will be exported out of the Item Database will not detail every single data point related to the item. Rather only certain information as well as some columns which detail whether or not data is there but not the actual data itself. The data exported out of the Item Database in the excel spreadsheet includes:
- Item Name
- Exact match to item data in UI
- Serving Size - Wt
- Exact match to item data in UI
- Serving Size-Wt UOM
- Exact match to item data in UI
- Serving Size - Meas
- Exact match to item data in UI
- Serving Size-Meas UOM
- Exact match to item data in UI
- Brand Name
- Exact match to item data in UI
- Manufacturer
- Exact match to item data in UI
- Manufacturer Code
- Exact match to item data in UI
- GTIN
- Exact match to item data in UI
- Source DB
- For inTEAM use only
- External Unique ID
- For inTEAM use only
- Allergen - Milk, Peanuts, Fish, Soybeans, Eggs, Tree Nuts, Shellfish, Wheat
- "Y" if allergen is present, NULL if not
- Missing Meal Components?
- "N" if meal components are entered for this item, "Y" if none exist in UI
- Purchase Unit Ct
- Total PU count
- Purchase Unit Ct - Unspecified
- Only PUs when Vendor = Unspecified
- Purchase Unit Ct - USDA
- Only PUs when Vendor = USDA
- Purchase Unit Ct - Other
- Only PUs when Vendor = Other
To run the Download Item Database Report:
- Go to the local Item Database by clicking on Item Database from the navigation panel. Click on the Report icon from the top right hand side of your screen and click the Download Item Database button
- Open the downloaded excel file to review the data
A sample report is attached below.