Single value consumptions data formats

Single value consumptions data provides a single per-individual-day and per-food consumption amount for a population. Also the bodyweight should be specified, and optionally also age, sex, and other properties may be recorded. The consumption amounts are usually expressed in grams, but may also be expressed in alternative units of plates, cups, or spoons. Optionally, the uncertainty of food consumption quantifications can be specified, see [Souverein et al., 2011].

Single value consumptions

Single value consumptions are described using one table: PopulationConsumptionSingleValues.

Population consumption single values

Population consumption single values describe population food consumptions in the form of single value statistics.

Table aliases: ConsumptionSingleValues, SingleValueConsumptions, PopulationConsumptionSingleValues, PopulationConsumptionValues.

Table 33 Table definition for PopulationConsumptionSingleValues.
Name Type Description Aliases Required

idPopulation

AlphaNumeric(50)

Unique identification code of the population.

IdPopulation, PopulationId

Yes

idFood

AlphaNumeric(50)

The unique identification code of the consumed food.

idFood, FoodCode, Food

Yes

Value type of the single value consumption amount.

ConsumptionValueTypes

The value type of this consumption value.

ConsumptionType, ValueType, ConsumptionValueType, ConsumptionSingleValueType

Yes

Percentile

Numeric

The percentile (if consumption value type is a percentile).

Percentile

No

ConsumptionAmount

Numeric

The consumed amount.

Amount, Consumption, ConsumptionAmount, AmountConsumed

Yes

ConsumptionUnit

ConsumptionIntakeUnits

The unit of the consumption amount.

AmountUnit, UnitAmount, ConsumptionUnit

No

Reference

AlphaNumeric(200)

Reference to the source from which this value is obtained.

Reference, References, Source, Sources

No