Create Vocab Mapping and Visit Rollup Tables.

This function creates the vocabulary mapping and visit roll-up intermediate tables from created by the
CreateVocabMapTables() and
CreateVisitRollupTables() scripts.

CreateMapAndRollupTables(
  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.",
  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.

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(), and
LoadVocabTables() have all been run.