getICD10StandardCodes not returning all ICD10 Hierachies

[daniellenewby]

Describe the bug
Not retrieving all ICD10 Hierachies.

To Reproduce
Steps to reproduce the behavior:

icd_hierachy <- CodelistGenerator::getICD10StandardCodes(cdm,
                                                         includeDescendants = TRUE,
                                                         level = c("ICD10 Hierarchy"))

Expected behavior
I would expect codelist for every ICD10 hierachies or at least a warning with a list of which ones have not been found. See example below:

Symptoms and signs involving the digestive system and abdomen (R10-R19).
I would expect codelists from R10, R11, R12...R19. However in my database i only have R10, R16, R17, R19 with no explanation of why the others are missing. R11 for example is Nausea and vomiting so i would expect there to be mapped codes for this in SNOMED. I am unsure if this a mapping issue from non standard to standard.

Screenshots
Below is showing ICD10M code R11.0 and its related SNOMED concept so there is a code for nausea in the database with record counts.

Desktop (please complete the following information):

• OS: windows
• Browser chrome

[martaalcalde]

I had a quick look at the issue and the main problem is that the db (CPRD GOLD) does not have the ICD10 code 1572203 in the concept table