omop_tables function

OMOP Tables

Collection of functions to create prearranged views of OMOP patient data when supplied with database connection information and a mapping of the connected database.

omop_table_all_patients(table_map, db_connection)

omop_table_condition_era(table_map, db_connection, subject_id)

omop_table_condition_occurrence(table_map, db_connection, subject_id)

omop_table_death(table_map, db_connection, subject_id)

omop_table_device_exposure(table_map, db_connection, subject_id)

omop_table_dose_era(table_map, db_connection, subject_id)

omop_table_drug_era(table_map, db_connection, subject_id)

omop_table_drug_exposure(table_map, db_connection, subject_id)

omop_table_measurement(table_map, db_connection, subject_id)

omop_table_note(table_map, db_connection, subject_id)

omop_table_observation(table_map, db_connection, subject_id)

omop_table_observation_period(table_map, db_connection, subject_id)

omop_table_payer_plan_period(table_map, db_connection, subject_id)

omop_table_procedure_occurrence(table_map, db_connection, subject_id)

omop_table_specimen(table_map, db_connection, subject_id)

omop_table_visit_occurrence(table_map, db_connection, subject_id)

Arguments

• table_map: A dplyr::tibble containing a mapping between the CDM standard tables and fields to the user connected tables and fields.
• db_connection: A DBI::dbConnect object
• subject_id: A numeric, or coercible to numeric.

Returns

A dplyr::tibble containing pre-coordinated patient information from the connected database.