createAllVisitTable: Run the query to create the all_visit table.

In OHDSI/ETL-HealthVerityBuilder: A Builder for Converting the HealthVerity Data Model to the OMOP CDM

Description

This function will call and run the sql file to create the all_visit table and the assign_all_visit_ids table which are the first and second steps to creating the visit_occurrence table. Requires that the function chunkData is run first.

Usage

createAllVisitTable(connectionDetails, cdmDatabaseSchema, sourceDatabaseSchema,
  oracleTempSchema = NULL, iteraterNum)

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 contains the OMOP CDM instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'cdm_instance.dbo'.
sourceDatabaseSchema	The name of the database schema that contains the raw data instance. Requires read permissions to this database. On SQL Server, this should specifiy both the database and the schema, so for example 'raw_instance.dbo'.
oracleTempSchema	For Oracle only: the name of the database schema where you want all temporary tables to be managed. Requires create/insert permissions to this database.
iteraterNum	The number of chunks of data the program should be looped over.

OHDSI/ETL-HealthVerityBuilder documentation built on May 19, 2019, 12:40 a.m.