Populations data formats

Populations

Populations are primary entities of the data model.

Populations

Populations are used to select dietary, nondietary and human monitoring surveys. Optionally, a name and description can be added. Population can be restricted to a certain time period. AgeMin, AgeMax and Gender are optional properties of a population.

Table aliases: Populations, Population.

Table 14 Table definition for Populations.
Name Type Description Aliases Required

idPopulation

AlphaNumeric(50)

Unique identification code of the population.

IdPopulation, PopulationId, Code, Id

Yes

Name

AlphaNumeric(100)

The name of the population.

Name, PopulationName

No

Description

AlphaNumeric(200)

Description of of the population.

Description

No

Location

AlphaNumeric(50)

Location.

No

StartDate

DateTime

Starting date of the specific time window marking this population.

StartDate

No

EndDate

DateTime

End date of the specific time window marking this population.

EndDate

No

AgeMin

Integer

Inclusive minimum bound (in years) of the specific age group of this population.

AgeMinimum

No

AgeMax

Integer

Inclusive maximum bound (in years) of the specific age group of this population.

AgeMaximum

No

Gender

AlphaNumeric(50)

Gender levels of this population.

Sex

No