EMR to OMOP-CDM Mapper, a research data mapping tool designed to facilitate the conversion of Electronic Medical Record (EMR) data into the OMOP Common Data Model (CDM) format. This conversion enables standardized research analysis across different healthcare systems. The tool features a "White Rabbit Scan" which analyzes a selected source database and generates a scan report. This report provides key information about the database's tables, including the table name, row count, number of columns, and a completeness metric, visualized as a progress bar. In the example shown, tables like "patients," "conditions," and "medications" have been scanned, revealing details about their size and data integrity.
![Screenshot 2024-12-20 at 12 23 53](https://private-user-images.githubusercontent.com/28685145/397724104-dfb6d4ca-6295-4948-a6f4-bcc33dcda39a.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk2ODMzMDgsIm5iZiI6MTczOTY4MzAwOCwicGF0aCI6Ii8yODY4NTE0NS8zOTc3MjQxMDQtZGZiNmQ0Y2EtNjI5NS00OTQ4LWE2ZjQtYmNjMzNkY2RhMzlhLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjE2VDA1MTY0OFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTllNWU4ZjdlOTkyMTFhMjljYjlkNWViZmM1NjQwOTJiYWQzMzE4Nzg2MWZiZjcyY2RjMTMzZDAyYTBkZTI0MDMmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.-sda6P9hoQ2jZsboWWc7zhripGZOCaQNIRjoXSvY6Zk)
The tool features a "White Rabbit Scan" which analyzes a selected source database and generates a scan report. This report provides key information about the database's tables, including the table name, row count, number of columns, and a completeness metric, visualized as a progress bar
![Screenshot 2024-12-20 at 12 24 07](https://private-user-images.githubusercontent.com/28685145/397724184-09d813e8-2968-4e09-8ac4-bd1f95b364a2.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk2ODMzMDgsIm5iZiI6MTczOTY4MzAwOCwicGF0aCI6Ii8yODY4NTE0NS8zOTc3MjQxODQtMDlkODEzZTgtMjk2OC00ZTA5LThhYzQtYmQxZjk1YjM2NGEyLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjE2VDA1MTY0OFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTEyMjAxOTc5MDk0ZjhkNzM4ODQ2OTkxY2MyMWE5ZmVlNDNmMjIxZWZkMjY5NGQ5ZGFkYzJjNDAyNWFlYzIzNjcmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.nYFJ3MZKfdsNOuIPPUAdeW-RmXmq0Iu_1zlxwisoffY)
![Screenshot 2024-12-20 at 12 24 14](https://private-user-images.githubusercontent.com/28685145/397724260-f7d0c94d-8303-4d1c-8e7e-437a795e801b.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk2ODMzMDgsIm5iZiI6MTczOTY4MzAwOCwicGF0aCI6Ii8yODY4NTE0NS8zOTc3MjQyNjAtZjdkMGM5NGQtODMwMy00ZDFjLThlN2UtNDM3YTc5NWU4MDFiLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjE2VDA1MTY0OFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPTc2YjliMDgwNGFlYWYwMGVkMDUzYzFiYmFkMWEyZTViNTc4MWJkMDUwZGFmNmNhMjI0NTlhN2E4Y2E1NGE2YjEmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.p80qEh6aW-955bcKohFhaE3cfkztwtGpQyFEB5wnWkE)
The tool features a "White Rabbit Scan" which analyzes a selected source database and generates a scan report. This report provides key information about the database's tables, including the table name, row count, number of columns, and a completeness metric, visualized as a progress bar. In the example shown, tables like "patients," "conditions," and "medications" have been scanned, revealing details about their size and data integrity.
![Screenshot 2024-12-20 at 12 24 22](https://private-user-images.githubusercontent.com/28685145/397724375-9cdf5359-de87-466b-abfe-a8c723c8beae.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk2ODMzMDgsIm5iZiI6MTczOTY4MzAwOCwicGF0aCI6Ii8yODY4NTE0NS8zOTc3MjQzNzUtOWNkZjUzNTktZGU4Ny00NjZiLWFiZmUtYThjNzIzYzhiZWFlLnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjE2VDA1MTY0OFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPWFjMjIwMjI5ZmZhM2I3MDk1ODkzNTEwYWU1ZGM2YzE0NWJjYzJlMmRmZTZlZjIzOGY3MzZlOTUzNDk1MTY5MTkmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.PibCPX4tvrn6msdwKcNagGCqULwsPATTWQc_VmPKBPQ)
![Screenshot 2024-12-20 at 12 24 30](https://private-user-images.githubusercontent.com/28685145/397724422-0d84e604-728b-48e8-983f-216714d5f248.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Mzk2ODMzMDgsIm5iZiI6MTczOTY4MzAwOCwicGF0aCI6Ii8yODY4NTE0NS8zOTc3MjQ0MjItMGQ4NGU2MDQtNzI4Yi00OGU4LTk4M2YtMjE2NzE0ZDVmMjQ4LnBuZz9YLUFtei1BbGdvcml0aG09QVdTNC1ITUFDLVNIQTI1NiZYLUFtei1DcmVkZW50aWFsPUFLSUFWQ09EWUxTQTUzUFFLNFpBJTJGMjAyNTAyMTYlMkZ1cy1lYXN0LTElMkZzMyUyRmF3czRfcmVxdWVzdCZYLUFtei1EYXRlPTIwMjUwMjE2VDA1MTY0OFomWC1BbXotRXhwaXJlcz0zMDAmWC1BbXotU2lnbmF0dXJlPThlOTBkN2EwMzljYzMwZjNmNWI1ZDY3YzNmNjlkNDIzYjY0MDJlMGYyMTg3ODFhYmQ1YzEwMmEyNzNlMmU3ODgmWC1BbXotU2lnbmVkSGVhZGVycz1ob3N0In0.xD4w56d1OCnieCupb-ItOOkCAiMO0yh4ZErSeqoqLiw)