Data Extract View Loader
The Data Extract View Loader allows you to load an externally created data extract view definition statement into the Oracle Clinical database. Once it is loaded, the view definition statement is treated like other Oracle Clinical data extract views: it is used to create data extract views and SAS views specified for the study.
The Data Extract View Loader has a limited purpose: it allows you to load data extract view definition statements, including those you cannot create through the View Builder. It is not an alternative to the View Builder.
Oracle Clinical simply inserts the SQL view definition statement and the SAS view definition statement into a table and acts on them at data extract view maintenance time. At that time, both the data extract view and the SAS view are created from user-provided statements in the data files.
Do not load an extract view you can build through the View Builder, for the following reasons:
-
No definitional information is maintained for externally loaded views. Oracle Clinical does not keep track of which DCMs, DCM question groups, or questions are involved in the loaded view.
Consequently, if an Oracle Clinical element changes, for example, a question referred to in the loaded view is retired, Oracle Clinical does not automatically recognize that the view is no longer valid.
-
No validation is performed on externally loaded views.
Question misspellings or syntactic errors are not detected at load time, and result in a failure status at data extract view maintenance time.
-
Maintaining externally loaded views is a manual process.
If you update your externally loaded view definition statement, Oracle Clinical does not automatically update the corresponding SAS view. You are responsible for updating both the data extract view definition and the SAS view manually.
See the following topics: