This function will call and run the sql file to create the observation_period tables. Requires that the function chunkData
is run first.
1 2 3 | createObservationPeriodTable(connectionDetails, cdmDatabaseSchema,
sourceDatabaseSchema, oracleTempSchema = NULL,
createWebmdObsPeriod = FALSE, iteraterNum)
|
connectionDetails |
An R object of type |
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. |
createWebmdObsPeriod |
Default is FALSE, set to TRUE if a second observation_period table should be created spanning only the WebMD claims. Table name will be OBSERVATION_PERIOD_WEBMD. |
iteraterNum |
The number of chunks of data the program should be looped over. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.