DF_SBhistory — History of Changes
DF_SBhistory
{-id #}
[-visit #]
[-plate #]
[-field #]
DFdiscover maintains a change history of every data value or metadata value that is added/modified/deleted during the course of the study. This report outputs the change history in tabular format, for one specific subject ID. The output includes:
identification of when the change the was made (Date and Time), by whom (User Name) and the type of change (Type)
identification of the value that was changed, including the data keys (Subject, Visit, Plate), the data field that was changed (Data Field and Data Field Description)
the actual change (What Changed, Old Value, New Value, Old Code Label, New Code Label)
and the related metadata (Query Usage/Reason Text, Query Category/Reason Code, Status, Level)
By default, all data and metadata changes are reported. To view only the changes to data, queries or reasons, select the desired view using Change Records in the Options drawer.
The report output can be quite lengthy if there are many data points collected per subject.
To further filter the output, include only a specific visit (-visit #), plate (-plate #)
or field (-field #).
The filters are typically nested so that a specific visit can included (-visit #), a specific plate within
a specific visit (-visit # -plate #), or a specific field of a specific plate of a specific
visit (-visit # -plate # -field #).
However, it is also possible to view the change history for a specific field across the entire database, as well as other
combinations of options.
It is possible to search the output by selecting the field of interest in the Search by dropdown list and then specifying the value to search for. Each column can be sorted in ascending or descending order by clicking the column heading. Each click reverses the previous sort order.
This report is similar in behavior to
> (use -plate #) or
> (use -field #)
available in other views.