Table name: condition_occurrence
Reading from Baseline
NOTE: Secondary cause of death is taken from the death registry. The logic below is not currently used.
The baseline also includes information about the secondary cause of death of a person. This information might also exist in the death registry records. Firstly check if the record is already in the death registry data. If not a script is executed according to the table below.
| Destination Field | Source field | Logic | Comment field |
|---|---|---|---|
| person_id | eid | ||
| condition_start_date | 40000-0.0 | ||
| condition_start_datetime | 40000-0.0 | ||
| condition_type_concept_id | 32815: Death Certificate | ||
| condition_concept_id | 40002-0.1 | vocabulary lookup | |
| condition_source_concept_id | 40002-0.1 | reformat the ICD10 code given | |
| condition_source_value | 40002-0.1 |