R/OrphanSourceCodes.R
findOrphanSourceCodes.Rd
Find source codes that do not roll up to their ancestor
findOrphanSourceCodes(connectionDetails, cdmDatabaseSchema, oracleTempSchema = NULL, conceptName, conceptSynonyms = NULL)
connectionDetails | An object of type |
---|---|
cdmDatabaseSchema | Schema name where your patient-level data in OMOP CDM format resides. Note that for SQL Server, this should include both the database and schema name, for example 'cdm_data.dbo'. |
oracleTempSchema | Should be used in Oracle to specify a schema where the user has write priviliges for storing temporary tables. |
conceptName | The exact name of the parent concept. |
conceptSynonyms | Synonyms by which the code might be described. |
A data frame with orhan source codes, with counts per domain how often the code was encountered in the CDM.
Searches for concepts where the name contains the concept name of interest, or any of its synonyms as provided by the user. Then it checks whether these concepts roll up to the main concept.