teenwyman
commented
8 months ago @catalamarti Thank you for finding the bug in the ETL program. As discussed, data patching is required, and it is ongoing. I will update you once it is completed.
| Here are some findings for your reference. In cdm_gold_202301, the following read codes have been used for mapping the covid-19 vaccination brand name. Read Code | Description |
|---|---|
| 65F0100 | Administration of first dose of severe acute respiratory syndrome coronavirus 2 vaccine (procedure) (SNOMED CT Concept 1324681000000101) |
| 65F0200 | Administration of second dose of severe acute respiratory syndrome coronavirus 2 vaccine (procedure) (SNOMED CT Concept 1324691000000104) |
| 65F0900 | Administration of third dose of severe acute respiratory syndrome coronavirus 2 vaccine (procedure) (SNOMED CT Concept 1363861000000103) |
| 65F0A00 | Administration of fourth dose of severe acute respiratory syndrome coronavirus 2 vaccine (procedure) (SNOMED CT Concept 1363791000000101) |
| 65F0B00 | Administration of fifth dose of severe acute respiratory syndrome coronavirus 2 vaccine (procedure) (SNOMED CT Concept 1363831000000108) |
In cdm_gold_202307, more read codes have been taken into account. You can find all read codes and brands (COVID Immunisation Types) we used for COVID-19 Vaccination here However,
Describe the problem Hi @teenwyman in the previous release (gold_202301) we had millions of records of covid vaccines, now when we instantiate the same cohorts in the new release (gold_202307) they are empty. Has the mapping changed? thank youuu :)
Affected databases cprd_gold_202307
Tag for awareness @ajoedicke @Xintong-Li-ZnCu