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, RawPopulations.

Table 15 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

No

Location

AlphaNumeric(50)

Location.

No

StartDate

DateTime

Starting date

StartDate

No

EndDate

DateTime

End date

EndDate

No

AgeMin

Integer

Minimum age

AgeMinimum

No

AgeMax

Integer

Maximum age

AgeMaximum

No

Gender

AlphaNumeric(50)

All levels of gender

Sex

No