2023 FDA Science Forum
Development and Application of the CFSAN Analytical Product Survey (CAPS) Database: FDA’s Tool for Effectively Managing Marketplace Survey Data
- Authors:
- Center:
-
Contributing OfficeCenter for Food Safety and Applied Nutrition
Abstract
CFSAN’s Office of Regulatory Science/Division of Bioanalytical Chemistry (ORS/DBC) routinely performs sampling studies, or surveys, of foods and dietary supplements from the United States market to collect information on ingredients and contaminants. ORS/DBC, in collaboration with CFSAN’s Office of Management/Division of Information Technology (OM/DITM), developed an internal, relational database to store, analyze, and communicate information related to sampling studies performed or coordinated by CFSAN. The CFSAN Analytical Product Survey (CAPS) database provides a standardized platform for managing product label information (e.g., ingredients, nutrients, and serving size information) and analytical data generated for each sampled product. Data are available to users through an interactive web-based interface with data visualizations (Dashboard), product information tables (Data View), and computational calculations (Reports). Filtering, quick search, and referral level flagging capabilities enhance the customized data analysis experience. As a benefit to the Agency, the CAPS database improves communication with stakeholders, provides a platform for standardized reporting, promotes data integration and interoperability, helps to inform signal detection, and supports feasibility assessments. The CAPS database currently houses information for two cannabis-derived product sampling studies, including data on 1,519 products and 40,000 data points, with expansion to new analytical product surveys already underway. The CAPS database provides a user-friendly, interactive tool for effectively managing big data and builds capacity for future data uses within CFSAN.