Individuals data formats
Simulates individuals with properties like age, body weight, sex, and body surface area.
Download empty dataset template:
Individual sets
Contains the definitions of individual sets.
Accepted table names: IndividualSets, IndividualSet.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idSet |
AlphaNumeric (50) |
Unique identification code of the individual set. |
id, idSet, idIndividualSet, SetCode, Code |
Yes |
Name |
AlphaNumeric (100) |
Name of the individual set. |
Name |
No |
Description |
AlphaNumeric (200) |
Description of the individual set. |
Description |
No |
BodyWeightUnit |
AlphaNumeric (50) |
The unit of bodyweight of the individuals of the set: kg (default) or g. |
BodyWeightUnit, UnitBodyWeight, WeightIn |
No |
AgeUnit |
AlphaNumeric (50) |
The unit of age, i.e., year or month. |
UnitAge, agein, AgeUnit |
No |
StartDate |
DateTime |
The starting date of the set. |
StartDate |
No |
EndDate |
DateTime |
The end date of the set. |
EndDate |
No |
idPopulation |
AlphaNumeric (50) |
Unique identification code of the population. |
IdPopulation, PopulationId |
No |
Individuals
The individuals of a survey are recorded in the Individuals table. Add additional properties like Region, Breastfeeding to further describe an individual. In table IndividualProperties, each property in the Individuals table is described (recommended way). Note that only those properties that are available in the Individuals table are used in module Populations, table Populations or PopulationIndividualPropertyValues to subset the individuals. This is only relevant when the UseData option in the population module is used.
Accepted table names: Individuals, SurveyIndividuals, ConsumptionSurveyIndividuals, FoodConsumptionSurveyIndividuals.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idIndividual |
AlphaNumeric (50) |
Unique identification code of the individual. |
idIndividual, IndividualId, Individual, Id |
Yes |
idFoodSurvey |
AlphaNumeric (50) |
The identification code / short name of survey. |
idSurvey, idFoodSurvey, Survey, FoodSurvey, SurveyId, FoodSurveyId, SurveyCode, idSet, SetCode, Code |
Yes |
BodyWeight |
Numeric |
The body weight of the individual. |
BodyWeight, Weight |
No |
SamplingWeight |
Numeric |
The sampling weight for an individual (default = 1). |
SamplingWeight |
No |
NumberOfSurveyDays |
Integer |
The number of days the individual participated in the survey. |
NumberOfSurveyDays, NumberOfDaysInSurvey, DaysInSurvey, NDaysInSurvey |
No |
Name |
AlphaNumeric (100) |
Name or label of the individual. |
Name |
No |
Description |
AlphaNumeric (200) |
Additional description of the individual. |
Description |
No |
Individual properties |
Other individual properties can be added like the fields Age, Gender, Region etc. These properties are automatically parsed as co-factors or co-variables. |
No |
Individual properties
This table is used to describe the properties used in the Populations or PopulationIndividualPropertyValues table characterising the population (table Populations) and/or the properties used in the Individuals table characterising an individual. Properties like Age, Gender, Region are describing an individual (PropertyLevel = Individual). Properties like Period (for populations) or Month (sampling date for an individual day) are describing an individual day (PropertyLevel = IndividualDay).
Accepted table names: IndividualProperties, IndividualProperty.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idIndividualProperty |
AlphaNumeric (50) |
The code of the property. |
idIndividualProperty, IndividualPropertyId, IndividualProperty |
Yes |
Name |
AlphaNumeric (100) |
The name of the property. |
Name |
No |
PropertyLevel |
PropertyLevelType | The level of the property. This type follows a controlled terminology, with possible values: Individual or IndividualDay. |
PropertyLevel, LevelProperty |
No |
Description |
AlphaNumeric (200) |
Description of the property. |
Description |
No |
Type |
IndividualPropertyType | This field specifies the type of the values of this individual property. This type follows a controlled terminology, with possible values: Boolean, Categorical (default), Numeric, Nonnegative, Integer, NonnegativeInteger, Month, Datetime, Gender. |
Type |
No |
Individual property values
Not recommended. This table describes individual property values. Property values are describing an individual for properties like e.g. Region, Breastfeeding. The recommended way is to add these columns as additional columns in the Individuals table. In table IndividualProperties, each property in the IndividualPropertyValues table is described.
Accepted table names: IndividualPropertyValues, IndividualPropertyValue.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idIndividual |
AlphaNumeric (50) |
The identification number of the Individual. |
Id |
Yes |
PropertyName |
AlphaNumeric (50) |
The name of the property. |
Name |
Yes |
TextValue |
AlphaNumeric (50) |
The value of the property as text value. |
No |
|
DoubleValue |
Numeric |
The value of the property as number. |
No |