CreateVisitRollupTables: Create Tables for Visit Rollup Logic.

In chrisroederucdenver/ETL-Synthea: A Builder for Converting the Synthea Data to the OMOP CDM

Description

This function creates tables ALL_VISITS, ASSIGN_ALL_VISIT_IDS, and FINAL_VISIT_IDS.

Usage

CreateVisitRollupTables (connectionDetails, cdmDatabaseSchema, syntheaDatabaseSchema)

Arguments

connectionDetails	An R object of type connectionDetails created using the function createConnectionDetails in the DatabaseConnector package.
cdmDatabaseSchema	The name of the database schema that will contain the different VISIT tables. Requires read and write permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.
syntheaDatabaseSchema	The name of the database schema that contain the Synthea instance. Requires read and write permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.

Details

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

chrisroederucdenver/ETL-Synthea documentation built on Aug. 1, 2020, 4:21 p.m.