. 2020 Aug 27;36(2):165–178. doi: 10.1007/s10654-020-00677-6

Table 5.

ETL Stage 5: Determining outcome and defining patient exit date

In this stage we ignore the exposure type and criteria properties of the code entities ETL stage 5 user inputs
1	Outcome	Code entity (list)	Ischemic heart disease Stroke Heart failure

In this stage we ignore the exposure type and criteria properties of the code entities
ETL stage 5 user inputs

Variable name

Data type

Example

Outcome

Code entity (list)

Ischemic heart disease

Stroke

Heart failure

ETL stage 5 transformation logic
For each patient from the previous stage, repeat the following • Set value of patient exit date to that of patient end date • Look for first event of required outcome(s) before patient end date and after patient’s index date • Assign exit date as date of the first outcome for each patient

ETL stage 5 transformation logic

Transformation logic

For each patient from the previous stage, repeat the following

• Set value of patient exit date to that of patient end date

• Look for first event of required outcome(s) before patient end date and after patient’s index date

• Assign exit date as date of the first outcome for each patient