Skip to contents

Create parameter object for database to be reached

Usage

createDatabaseSettings(
  cdmVersion = "5",
  cdmDatabaseSchema,
  databaseName,
  cohortDatabaseSchema = cdmDatabaseSchema,
  outcomeDatabaseSchema = cdmDatabaseSchema,
  resultsDatabaseSchema = cdmDatabaseSchema,
  exposureDatabaseSchema = cdmDatabaseSchema,
  tempEmulationSchema = cdmDatabaseSchema,
  cohortTable,
  outcomeTable,
  exposureTable = "drug_era",
  mergedCohortTable,
  targetCohortId = 1
)

Arguments

cdmVersion

Define the OMOP CDM version

cdmDatabaseSchema

The name of the database schema that contains the OMOP CDM instance. Requires read permissions to this database. On SQL Server, this should specify both the database and the schema, so for example "cdm_instance.dbo"

databaseName

The name of the database.

cohortDatabaseSchema

The name of the database schema that is the location where the cohort data used to define the at risk cohort is available. If cohortTable = DRUG_ERA, cohortDatabaseSchema is not used by assumed to be cdmDatabaseSchema.

outcomeDatabaseSchema

The name of the database schema that is the location where the data used to define the outcome cohorts is available. If cohortTable = CONDITION_ERA, exposureDatabaseSchema is not used by assumed to be cdmSchema. Requires read permissions to this database.

resultsDatabaseSchema

The name of the database schema with write permissions.

exposureDatabaseSchema

Input of function getDbCohortMethodData: The name of the database schema that is the location where the exposure data used to define the exposure cohorts is available.

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.

cohortTable

The tablename that contains the at risk cohort. If cohortTable <> DRUG_ERA, then expectation is cohortTable has format of COHORT table: cohort_concept_id, SUBJECT_ID, COHORT_START_DATE, COHORT_END_DATE.

outcomeTable

The tablename that contains the outcome cohorts. If outcomeTable <> CONDITION_OCCURRENCE, then expectation is outcomeTable has format of COHORT table: COHORT_DEFINITION_ID, SUBJECT_ID, COHORT_START_DATE, COHORT_END_DATE.

exposureTable

The tablename that contains the exposure cohorts. If exposureTable <> DRUG_ERA, then expectation is exposureTable has format of COHORT table: cohort_concept_id, SUBJECT_ID, COHORT_START_DATE, COHORT_END_DATE.

mergedCohortTable

The name of the table where the merged treatment and comparator cohorts will be stored.

targetCohortId

The cohort definition id of of the merged cohort in the mergedCohortTable.