Table types

  • Posted:
  • / By: cremeadm
  • / In: Data Editor

The dietary and residential models require several data as inputs. These data must be stored into tables to be created into the CARES NG® platform in order to be used for risk assessments. Different table types are available to store the user data in an efficient and orderly manner. These are the types of table available in CARES NG®:

  • Chemical table
  • Residue Concentration table
  • Time series table
  • Food table
  • Product table
  • Residue From PDP

Chemical table

A chemical table contains the toxicology data and substance information of the pesticides under analysis. It has the following columns:

  • Dietary population: each cell of this column contains a drop-down menu with the list of the dietary populations.
  • Residential Population: each cell of this column contains a drop-down menu with the list of the residential populations.
  • Chemical Name: name of the chemical to be analysed.
  • CAS Number: CAS number of the pesticide. This field accepts only a combination of numbers and dash signs.
  • Route: exposure route. The following values are allowed: oral, dermal and inhalation. Only oral will be accepted in a dietary assessment
  • Time Frame: this field contains the timeframe the toxicology data are to be applied to. The following values are allowed: chronic, cancer, acute, multi-day, within-day, short-term, intermediate-term or long-term/chronic.
  • Point of Departure (mg/kg/day): is a numeric value representing the toxicology safety limit.
  • Absorption Factor: is a numeric values representing the fraction of pesticide absorbed by the human body through dermal and inhalation exposure. This field is not used in the dietary assessment.
  • Q*: numeric value representing the cancer Q1*. Used only in cancer assessments.
  • Decay Factor: numeric value representing the exponential decay factor. Used only in within-day assessments.
  • Uncertainty Factor: is a numeric value which accounts for inter- or intra-population variability
  • Comments: optional text fields which contains comments

Please download an Excel template of the chemical table from this link: chemical_table_template

Residue concentration table

It contains the pesticide concentration values found in agricultural commodities consumed by the U.S. population and the limit of detection of the methodologies used to measure such concentrations. These data are stored the following columns:

  • Sample ID: distinct numeric code for each row
  • Chemical ID: the CAS number of the chemical(s) which the concentration values are related to. This table can contain concentration data for multiple chemicals
  • Concentration (ppm): numeric value representing the concentration residue values of the chemical(s).
  • Limit of Detection/Quantification (ppm): this field accepts both the Limit of Detection and the Limit of Quantification of the method used to measure the chemical concentration values. The CARES NG® program does not make any distinction between the two sets of values; it is an risk assessor’s responsibility to insert the correct set of values.

Please download an Excel template of the residue concentration table from this link: Residue_concentration_table_template

Time series table

This table contains the concentration data obtained from the PRZM\EXAMS model. It can be used only for the water commodity in the dietary assessments and contains these columns:

  • Date: this field contains the date of each concentration value. The dates must be provided in the format YYYY/MM/DD. The user must provide at least 365 concentration values for each year, otherwise the assessment will fail. The concentration related to the 29th of February will be discarded.
  • Chemical ID: the CAS number of the chemical(s) which the concentration values are related to.
  • Concentration (ppm): numeric value representing the residue concentration values of the chemical(s).

Please download an Excel template of the time series table from this link: Time_series_table_template

Foods table

The Foods table is the only table containing pre-populated columns that cannot be edited by the user. These columns store information related to the agricultural commodities that can be analysed in the dietary assessments:

  • Food Code: numeric code of each food commodity recorded in the NHANES\WWEIA database
  • Fcid Food Description: name of each food commodity recorded in the NHANES\WWEIA database
  • Fcid Food Crop Group: numeric code of the groups which each food commodity belongs to
  • Food Form: numeric code accounting for the cooked status, cooking method and food form of each commodity
  • SFC Name: description of the commodity food form code. SFC stands for cooked Status, Food form and Cooking method
  • Blended Status: food commodities are divided into three categories according to blending levels when consumed: blended, partially blended and not blended.

The Foods table has the following columns that requires inputs from the user:

  • Residue Source: the residue data can come from different data sources:
    • Monitoring for monitoring data
    • Field for field trial data
    • Values for tolerance levels or single value residues
    • Distribution to use statistical distributions in place of empirical data
    • Time series for data obtained from the PRZM\EXAMS model. This option is available only for the three water types: water direct tap (8601100000), water direct bottled (8601200000), water indirect all sources (8602000000)
  • Residue Value (ppm): this field accepts different data types according to the option selected in the column Residue Source:
    • a numeric value for the Values residues
    • a link to the appropriate residue concentration table for Monitoring and Field residues
    • the name and parameter values of a statistical distribution for Distribution residues
  • Percentage of Crop Treated: percentage value representing the probability that the food contains the chemical(s) under analysis. The default value is 100%.
  • Modification Factor 1, Modification Factor 2, Modification Factor 3: these three factors account for changes in the chemical concentration in the food due to the preparation and cooking process. These three columns contain default values that can be modified.
  • Comments: optional text fields which contains comments

Please download an Excel template of the food table from this link: Food_table_template

Product table

The Product table contains information on the pesticidal products that can be used in the residential scenarios:

  • Product Id: alphanumeric code of each residential product recorded in the table
  • Product Name: name of each residential product
  • Chemical ID: the CAS number of the chemical(s) contained into the product.
  • Scenario: drop-down menu with the list of the residential scenarios where the product can be used.
  • Formulation: drop-down menu with the list of the product’s formulations handled by the residential model
  • Application Method: drop-down menu with the list of the product’s application methods handled by the residential model
  • Purity Perc Ai: concentration of the chemical in the product
  • Decay Factor: environmental decay factor. It represents the percentage of chemical that degrades for each day following the product’s application
  • Max Appl Rate: quantity of product used in each application event
  • Units: units of measurement to be related to the application rate in the previous column
  • Consumer Product: this field contains a checkbox for each product; if selected, the product is considered a consumer product that can be applied directly by the homeowner. Otherwise, the product is considered a professional product applicable only by professionals
  • Comments: optional text fields which contains comments

Please download an Excel template of the product table from this link: product_table_template

Residue From PDP table

Please refer to the PDP Tool page for more information on this option.