getConceptSetOccurrenceDate: Given a concept set expression, find the occurrence of the...

In OHDSI/ConceptSetDiagnostics: Concept Set Diagnostics

Given a concept set expression, find the occurrence of the concept set

Description

Given a concept set expression, find the occurrence of the concept set. The query will check for the occurrence of any of the resolved conceptId's in the conceptSetExpression in any domain tables. The domain tables are condition_occurrence, drug_exposure, procedure_occurrence, visit_occurrence, observation. Return objected is the name of the temp table

Usage

getConceptSetOccurrenceDate(
  connection,
  cdmDatabaseSchema,
  vocabularyDatabaseSchema = cdmDatabaseSchema,
  conceptIds,
  subset = c("all"),
  limitToPersonDate = TRUE,
  restrictToObservationPeriod = TRUE,
  tempEmulationSchema = NULL
)

Arguments

connection	An object of type connection as created using the connect function in the DatabaseConnector package. Can be left NULL if connectionDetails is provided, in which case a new connection will be opened at the start of the function, and closed when the function finishes.
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'.
vocabularyDatabaseSchema	The schema name of containing the vocabulary tables.
conceptIds	An array of concept ids
limitToPersonDate	Do you want to limit to person dates
restrictToObservationPeriod	(Default = TRUE) Do you want to restrict to Observation period? i.e Cohort dates are restricted to observation period.
tempEmulationSchema	Some database platforms like Oracle and Impala do not truly support temp tables. To emulate temp tables, provide a schema with write privileges where temp tables can be created.

OHDSI/ConceptSetDiagnostics documentation built on Feb. 26, 2023, 1:31 a.m.