Human monitoring data data formats¶
Data are provided on the survey, the individuals in the survey, the samples taken, the analyses performed, the analytical methods used, the properties for substances analysed, and the concentrations found.
- Data are provided in the following relational tables:
Human monitoring surveys
Human monitoring individuals
Human monitoring samples
Human monitoring sample analyses
Sample concentrations
Analytical methods
Analytical method properties for substances
Human monitoring samples¶
Suggested table definitions for human monitoring data.
Human monitoring surveys¶
Contains the survey definitions.
Table aliases: HumanMonitoringSurveys, HumanMonitoringSurvey, RawHumanMonitoringSurveys.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idSurvey |
AlphaNumeric(50) |
Unique identification code of the survey. |
idSurvey |
Yes |
Name |
AlphaNumeric(100) |
Name of the survey. |
Name |
No |
Description |
AlphaNumeric(200) |
Description of the survey. |
Description |
No |
Location |
AlphaNumeric(50) |
The location or country where survey is held. It is recommended to use ISO Alpha-2 country codes. |
Location, Country |
No |
BodyWeightUnit |
AlphaNumeric(50) |
The unit of bodyweight of the individuals of the survey: 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 survey. |
StartDate |
No |
EndDate |
DateTime |
The end date of the survey. |
EndDate |
No |
NumberOfSurveyDays |
Integer |
The number of days each individual participated in the survey. |
NumberOfSurveyDays, NDaysInSurvey |
Yes |
idPopulation |
AlphaNumeric(50) |
Unique identification code of the population. |
IdPopulation, PopulationId |
No |
Human monitoring individuals¶
The individuals of a survey are recorded in the individuals table.
Table aliases: HumanMonitoringIndividuals, HumanMonitoringIndividual, RawHumanMonitoringIndividuals.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idIndividual |
AlphaNumeric(50) |
Unique identification code of the individual. |
idIndividual, IndividualId, Individual, Id |
Yes |
idSurvey |
AlphaNumeric(50) |
The identification code / short name of survey. |
idSurvey |
Yes |
BodyWeight |
Numeric |
The body weight of the individual. |
BodyWeight, Weight |
Yes |
SamplingWeight |
Numeric |
The sampling weight for an individual (default = 1). |
SamplingWeight |
No |
NumberOfDaysInSurvey |
Integer |
The number of days the individual participated in the survey. |
NumberOfSurveyDays, NumberOfDaysInSurvey, DaysInSurvey, NDaysInSurvey |
No |
Age |
Numeric |
The age of the individual. |
Age |
No |
Gender |
AlphaNumeric(50) |
The gender of the individual. Recommendation: use the codes Male/Female for coding the gender. |
Gender |
No |
Other inidividual properties |
Other individual properties can be added just like the fields age and gender. These properties are automatically parsed as co-factors or co-variables. |
No |
Human monitoring samples¶
Contains the samples taken during the study.
Table aliases: HumanMonitoringSamples, HumanMonitoringSample, RawHumanMonitoringSamples.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idSample |
AlphaNumeric(50) |
Unique identification code of the monitoring sample. |
idSample, Sample |
Yes |
idIndividual |
AlphaNumeric(50) |
Unique identification code of the individual. |
idIndividual, IndividualId, Individual, Id |
Yes |
DateSampling |
DateTime(50) |
Date of sampling. |
DateSampling, DateOfSampling, SamplingDate |
No |
DayOfSurvey |
AlphaNumeric(50) |
Identification code of the day of measurement. |
Day, idDay, DayId, DayOfSurvey |
Yes |
TimeOfSampling |
AlphaNumeric(50) |
Identification code of the time of sampling. |
TimeOfSampling, SamplingTime, TimeSampling |
No |
SampleType |
AlphaNumeric(50) |
Type of sample (e.g., pooled, 24h urine, spot urine, serum from blood, etc.). |
SampleType, SamplingType |
No |
Compartment |
AlphaNumeric(50) |
If applicable, the measured compartment of the human body (e.g., blood, urine). When specified, the measurements are considered at the level of internal doses. |
Compartment |
No |
ExposureRoute |
AlphaNumeric(50) |
If applicable, the measured exposure route, e.g., dermal (in case of skin wipes). When specified, the measurements are considered at the level of external doses. |
ExposureRoute |
No |
SpecificGravity |
Numeric |
Specific gravity of the measured person for this particular sample. |
SpecificGrafity, SpecificGravity |
No |
SpecificGravityCorrectionFactor |
Numeric |
Specific gravity of the measured person for this particular sample. |
SpecificGravityCorrectionFactor |
No |
Human monitoring sample analyses¶
Contains the measurements of the samples of human monitoring studies.
Table aliases: HumanMonitoringSampleAnalyses, HumanMonitoringSampleAnalysis, RawHumanMonitoringSampleAnalyses.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idSampleAnalysis |
AlphaNumeric(50) |
Unique identification code of the sample analysis. |
idSampleAnalysis, SampleAnalysis |
Yes |
idSample |
AlphaNumeric(50) |
Code of the measured monitoring sample. |
idSample, Sample |
Yes |
idAnalyticalMethod |
AlphaNumeric(50) |
The code of method of analysis. |
idAnalyticalMethod, AnalyticalMethodName, AnalyticalMethodId |
Yes |
AnalysisDate |
AlphaNumeric(50) |
Date of analysis. |
AnalysisDate, DateAnalysis |
No |
Substance concentration(s) |
AlphaNumeric(100) |
One or more columns with the measured concentrations of the substances in the unit as specified by the analytical method. The column name(s) should match the substance codes of the substances measured by the analytical methods. Empty fields for substances that should have been measured by the analytical method are considered to be non-detects with measurement values below LOR. |
Yes |
Sample concentrations¶
The positive concentration values for substances from analysis in the unit specified in table human monitoring sample analyses. Non-detects (i.e. results ‘less than LOR’) are not included, their existence can be inferred from the tables AnalysisSamples and AnalyticalMethodSubstances, and the LOR itself from the analytical method.
Table aliases: HumanMonitoringSampleConcentrations, HumanMonitoringSampleConcentration, RawHumanMonitoringSampleConcentrations.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idAnalysisSample |
AlphaNumeric(50) |
The identification number of the analysed sample. |
idAnalysisSample, AnalysisSampleId |
Yes |
idSubstance |
AlphaNumeric(50) |
The substance code. |
idSubstance, SubstanceId, Substance, idCompound, CompoundId, Compound |
Yes |
Concentration |
Numeric |
The measured concentration. |
Concentration |
Yes |
Analytical methods¶
The analytical methods used for analyzing the samples are recorded in the analytical methods table. Each analytical method should have a unique identification code (idAnalyticalMethod). The description field may be used for a more detailed description of the analytical method. The records of this table should be linked to one or more analytical method substance properties table, which record the substances that are measured by this method (and their limits of reporting).
Table aliases: AnalyticalMethod, AnalyticalMethods, RawAnalyticalMethods.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idAnalyticalMethod |
AlphaNumeric(50) |
The code for the method of analysis. |
idAnalyticalMethod, AnalyticalMethodId, AnalyticalMethodName, Id |
Yes |
Description |
AlphaNumeric(200) |
Additional description of method of analysis. |
Description |
No |
Analytical method properties for substances¶
Table aliases: AnalyticalMethodSubstances, AnalyticalMethodSubstance, AnalyticalMethodCompounds, AnalyticalMethodCompound, RawAnalyticalMethodCompounds.
| Name | Type | Description | Aliases | Required |
|---|---|---|---|---|
idAnalyticalMethod |
AlphaNumeric(50) |
The code of method of analysis. |
idAnalyticalMethod, AnalyticalMethodName, AnalyticalMethodId |
Yes |
idSubstance |
AlphaNumeric(50) |
The substance code. |
idSubstance, SubstanceId, Substance, idCompound, CompoundId, Compound |
Yes |
LOR |
Numeric |
The limit of reporting (LOR). In MCRA, LOR just means the limit below which no quantitative result has been reported. Depending on a laboratory’s format of reporting, LOR may be a limit of detection (LOD), a limit of quantification (LOQ) or another limit. |
LOR |
Yes |
ConcentrationUnit |
AlphaNumeric(50) |
The code of the unit as used for substance concentration data. Allowed code: kg/kg or kilogram/kilogram; g/kg or gram/kilogram; mg/kg or milligram/kilogram (default); µg/kg or microgram/kilogram; ng/kg or nanogram/kilogram; pg/kg or picogram/kilogram. |
ConcentrationUnit, Units, Unit |
No |