Achilles (version 1.5)

conceptHierarchy: execution of concept hierarchy creation

Description

conceptHierarchy executes script to create the concept_hierarchy table.

Usage

conceptHierarchy(connectionDetails, vocabDatabaseSchema,
  oracleTempSchema = vocabDatabaseSchema,
  resultsDatabaseSchema = vocabDatabaseSchema, cdmVersion = "5")

Arguments

connectionDetails

An R object of type ConnectionDetail (details for the function that contains server info, database type, optionally username/password, port)

vocabDatabaseSchema

string name of database schema that contains OMOP Vocabulary. Default is vocabDatabaseSchema. On SQL Server, this should specifiy both the database and the schema, so for example 'results.dbo'.

oracleTempSchema

For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database.

resultsDatabaseSchema

string name of database schema that we can write results to. Default is vocabDatabaseSchema. On SQL Server, this should specifiy both the database and the schema, so for example 'results.dbo'.

cdmVersion

Define the OMOP CDM version used: currently support only "5". Default = "5"

Value

nothing is returned

Details

conceptHierarchy executes script to create the concept_hierarchy table in the results schema, to be used by Atlas for treemap displays.

Examples

# NOT RUN {
  connectionDetails <- DatabaseConnector::createConnectionDetails(dbms="sql server", server="myserver")
  conceptHierarchy <- conceptHierarchy(connectionDetails, resultsDatabaseSchema="scratch", vocabDatabaseSchema="vocabulary")
# }