Hi, I currently have access to our institution’s EHR records which is OMOP derived. I aim to create a cancer cohort out of this to make it viable for research purposes. Is there any documentation or code in SQL that I can look up in order to identify cancer-diagnosed patients, demographics, survey related data?
I can identify that these data variables exist but have been having a hard time mapping them together in order to create a clean table with all the pateint_id records. i would really appreciate any guidance I can get as I am just getting started.
Thank you in advance!