Find source codes that do not roll up to their ancestor

findOrphanSourceCodes(connectionDetails, cdmDatabaseSchema,
  oracleTempSchema = NULL, conceptName, conceptSynonyms = NULL)

Arguments

connectionDetails

An object of type connectionDetails as created using the createConnectionDetails function in the DatabaseConnector package.

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.

Value

A data frame with orhan source codes, with counts per domain how often the code was encountered in the CDM.

Details

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.