LoadEventTables: Load CDM Non-Vocabulary Tables.
In OHDSI/ETL-Synthea: A Builder for Converting the Synthea Data to the OMOP CDM

LoadEventTables

R Documentation

Load CDM Non-Vocabulary Tables.

Description

This function loads the CDM Event tables with Synthea data.

Usage

LoadEventTables(
  connectionDetails,
  cdmSchema,
  syntheaSchema,
  cdmVersion,
  syntheaVersion = "2.7.0",
  cdmSourceName = "Synthea synthetic health database",
  cdmSourceAbbreviation = "Synthea",
  cdmHolder = "OHDSI",
  cdmSourceDescription =
    "SyntheaTM is a Synthetic Patient Population Simulator. The goal is to output synthetic, realistic (but not real), patient data and associated health records in a variety of formats.",
  createIndices = FALSE,
  sqlOnly = FALSE
)

Arguments

`connectionDetails`	An R object of type `connectionDetails` created using the function `createConnectionDetails` in the `DatabaseConnector` package.
`cdmSchema`	The name of the database schema that will contain the CDM. Requires read and write permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'.
`syntheaSchema`	The name of the database schema that contain the Synthea instance. Requires read and write permissions to this database. On SQL Server, this should specify both the database and the schema, so for example 'cdm_instance.dbo'.
`cdmVersion`	The version of your CDM. Currently "5.3" and "5.4".
`syntheaVersion`	The version of Synthea used to generate the csv files. Currently "2.7.0","3.0.0","3.1.0","3.2.0" and "3.3.0" are supported.
`cdmSourceName`	The source name to insert into the CDM_SOURCE table. Default is Synthea synthetic health database.
`cdmSourceAbbreviation`	The source abbreviation to insert into the CDM_SOURCE table. Default is Synthea.
`cdmHolder`	The holder to insert into the CDM_SOURCE table. Default is OHDSI
`cdmSourceDescription`	The description of the source data. Default is generic Synthea description.
`createIndices`	A boolean that determines whether or not to create indices on CDM tables before the ETL.
`sqlOnly`	A boolean that determines whether or not to perform the load or generate SQL scripts. Default is FALSE.

Details

This function assumes
createCDMTables(),
createSyntheaTables(),
LoadSyntheaTables(),
LoadVocabTables(), and
CreateMapAndRollupTables() have all been run.