The purpose of this study is to assess the completeness of data collection for race and ethnicity in the Electronic Health Record of multiple institutions. If you are interested in participating, SQL queries are available for SQL Server, Oracle and Postgress users.
-
SQL Server
Please use OHDSI_SQL_Server_race_ethnicity_data_collection.sql -
Oracle and Postgres
Please use OHDSI_Postgres_Oracle_race_ethnicity_data_collection.sql
Email the result files (*.csv) to study coordinator.