Edit Checks in Use

Summary

Edit checks are attached directly to items. Master Check report and Annotated CRF show edit checks in the context of a study design. But if you want to get a report showing just edit checks and where they are applied, this SQL is useful.

Note that it is of course possible to include any other fields available on these tables. Below are the key relationships joining edit checks and their use all the way up through the study.

Also note that this query only shows edit checks attached to locked forms. Please adjust the where clause as desired to filter by study or any other conditions appropriate to support your use case.

select rc.name as edit_check_name, i.name as item,
       ig.name as item_group, form.name as form,
       ap.name as activity_plan, study.name as study
from range_check rc
inner join item i on rc.item_id = i.id
inner join item_ref ir on i.id = ir.item_id
inner join item_group ig on ir.item_group_id = ig.id
inner join item_group_ref igr on ig.id = igr.item_group_id
inner join form on igr.form_id = form.id
inner join study_meta_data on form.study_meta_data_id = study_meta_data.id
inner join study on study_meta_data.id = study.study_meta_data_id
left join scheduled_activity sa on form.id = sa.form_id
left join segment on sa.segment_id = segment.id
left join activity_plan ap on segment.activity_plan_id = ap.id
where form.locked = true and i.locked = true
order by study.name DESC, form.name DESC, ig.name DESC

Here is an example output: