Hello @priagopal and welcome to OHDSI!
Are your AE data coded with a common vocabulary such as ICD or SNOMED? If yes, then you just follow the standard process as outlined in the Book of OHDSI Chapter 6, section 3. It explains how data are mapped to standard concept_ids. And the domain_id for a standard concept_id tells you where the data live in the CDM. However, I don’t think there is a standard way to identify an adverse clinical event from any other clinical event. You should ask on the Vocabulary forum, they might be able to help.
I host the Electronic Health Record working group every other Monday. We’re not solely based on EHR data, we help support all OHDSI friends on their journey. Here’s a link to our ongoing forum post. Our December 20th meeting will be open for Q&A. Join us then to introduce yourself and your explain your use case. We’ll be able to give you guidance.