Each schema contains a table listing the status of each CRF and Event (crf_status_summary). Use SQL queries to create valuable reports from this data. For example, this SQL query will show the number of CRFs with each status, by Site:

 sum (crf_status_initial_data_entry)as inital,
 sum (crf_status_initial_data_entry_complete) as initial_complete,
 sum (crf_status_double_data_entry) as dde_complete,
 sum (crf_status_data_entry_complete) as complete,
 sum (crf_status_locked) as locked
GROUP BY site_name;

CRF Status by Site (pgAdmin Output Example):

CRF Status by Site (pgAdmin output example)