createDatabaseSettings: Create parameter object for database to be reached
In OHDSI/RiskStratifiedEstimation: Risk Stratified Effect Estimation

createDatabaseSettings

R Documentation

Create parameter object for database to be reached

Description

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`.