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:
SELECT
site_name,
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
FROM
r01_123456_1_docetaxel_534_items.crf_status_summary
GROUP BY site_name;
CRF Status by Site (pgAdmin Output Example):
