D4_study_population
medatata_name
metadata_content
Name of the dataset
D4_study_population
Content of the dataset
contains the list of persons in the study population, with study entry and exit dates
Unit of observation
a person in the study population
Dataset where the list of UoOs is fully listed and with 1 record per UoO
How many observations per UoO
1
Variables capturing the UoO
person_id
Primary key
person_id
Parameters
VarName
Description
Format
Vocabulary
Parameters
Notes and examples
Source tables and variables
Retrieved
Calculated
Algorithm_id
Rule
person_id
unique person identifier
character
from cdm persons
yes
all values of person_id in D3_selection_criteria_from_PERSONS_to_study_population whose binary variables are all == 0
spell_start_date
date when the stdudy spell starts
date
it's the start date of the unique spell of this person_id having D3_clean_spells/is_the_study_spell == 1
yes
study_entry_date
start of the study period
date
latest among 1 january 2019 and
if the unique spell of this person_id having D3_clean_spells/is_the_study_spell == 1 has starts_at_birth == 0: op_start_spell + 365
otherwise: op_start_spell
yes
study_exit_date
end of the observation period
date
earliest among end_of_study (end of the unique of this person_id spell having D3_clean_spells/is_the_study_spell == 1), end of the study, and recommended_end_date
yes
parameter in the variable name
values
name of macro
person_id
spell_start_date
study_entry_date
study_exit_date
P0001
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0002
2018-10-29T00:00:00Z
2019-10-29T00:00:00Z
2021-06-02T00:00:00Z
P0003
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0004
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0005
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0006
2019-12-06T00:00:00Z
2020-12-05T00:00:00Z
2021-06-30T00:00:00Z
P0007
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0008
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0010
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0011
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2019-03-01T00:00:00Z
P0013
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0014
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0015
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0016
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0017
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2019-08-27T00:00:00Z
P0018
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0019
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0020
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0021
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z
P0022
2018-01-01T00:00:00Z
2019-01-01T00:00:00Z
2021-06-30T00:00:00Z