I'm working with a hosted instance of OpenClinica, so web services look like the only way to extract data. I've had some success with this approach, for example the Notes and Discrepancies CRF download and the REST interface. However, getting information about when CRFs have been SDVed continues to elude me.
I got all excited when I learnt about the CRF_STATUS_SUMMARY table in the downloadable datamart format of a dataset, with the following columns:
My excitement evaporated when I looked at the script and saw the the insert statements that populate this table:
INSERT INTO xxxxxxxxxx.crf_status_summary
(site_name, ssoid, ssid, study_event_oid, crf_name, crf_version, warehouse_insert_created_timestamp)
VALUES ( xxxxxxx', 'xxx_10001010', 'xxxxxx-010', 'XXXXXXXXX_3827', 'T Xxxxxx Xxxxxx', 'v1.0' ,'2015-01-21T17:56:29.59Z');
Clearly those columns are never going to get populated.
So, am I out of options?