OpenClinica Audit Related Tables

select audit_log_event_type_id from audit_log_event_type where name = 'Study Event signed';

select * from event_crf where event_crf_id = 1227;

select * from audit_log_event where entity_id = 945 and audit_log_event_type_id = 31;

select * from user_account where user_id  in (select user_id from audit_log_event where entity_id = 945 and audit_log_event_type_id = 31) ;

select user_name from user_account where user_id  in
        (select user_id from audit_log_event
            where
            entity_id = (select study_event_id from event_crf where event_crf_id = 1227)
            and
            audit_log_event_type_id = (select audit_log_event_type_id from audit_log_event_type where audit_log_event_type_id = 8)
        );

Pentaho DB's

DB Names:

1) vertica

2) http://www.microstrategy.com