I'm still learning about the clinical trial industry... this question has two parts,
a) on the business and operation's side, my guess is, when an AE happens and particularly SAE the PI needs to be notified asap, does finding, recording and reporting such event a site CRC's job? And what's CRA's role in AEs and SAEs if any?
b) I ran a quick test by adding an AE event.
Naturally the following sql query found it,
from study_event se, study_event_definition sed
where se.study_event_definition_id = sed.study_event_definition_id
and sed.name = 'Adverse Events'
question, when or if such an AE or SAE event goes to the event_crf table? If so how does it happen (who and what actions has/have happened, detailed work flow for this)?