This repository was archived by the owner on Oct 28, 2025. It is now read-only.
This repository was archived by the owner on Oct 28, 2025. It is now read-only.
Hierarchy and Code Translation Tables #4
Description
We need tables that can be used by our API and models to quickly convert prescription, diagnosis, and lab event codes to AUIs as well as AUIs to a specified level on the UMLS hierarchy.
We need to create scripts to generate then following tables in a new codes database:
- labevents: LOINC to AUI
- prescriptions: CDN to AUI
- diagnoses: ICD9 to AUI
- heirarchy: AUI to (AUI, AUI, AUI, ...)
To save space and increase speed, all tables will only include codes that exist in the MIMIC data set, and the hierarchy table will only have a small number of columns for a decided upon hierarchy set of hierarchy levels.