About OC Data Extract View Load Sets

Oracle Clinical Data Extract (DX) Views Load Sets allow you to make Oracle Clinical patient data available in Oracle LSH using the Oracle DX Views your company has already defined in Oracle Clinical. There is no need to redefine the views in Oracle LSH.

You can load views, including union views, from one Access Account at a time.

You can either physically load patient records into Oracle LSH or use the Load Set as a pass-through view to Oracle Clinical; see Oracle Tables and Views.

You can load views of any type—stable, snapshot, or current—that are maintained in the specified access account. However, you can see data in current Oracle Clinical DX Views in Oracle LSH only if you do not physically load the data into Oracle LSH.

There are two types of Oracle Clinical data extract view adapters: regular and incremental. The regular one uses full-mode reload processing. The incremental adapter uses incremental transactional processing, in either full or incremental load. For fastest performance, create the Load Set using the Incremental type and select incremental processing when you run the Load Set.

Table 7-3 OC Data Extract View Load Set Types

Load Set Type	OC DX View Types Allowed	Processing Type Used	Processing Options Available at Runtime	Deletion Behavior
Regular	Stable, Snapshot, or Current	Reload	Full	Soft-deletes records that are not reloaded. See Reload Processing.
Incremental	Stable	Transactional, with or without audit (set in a profile, can be overwritten for a target table instance)	Full or incremental	In Full mode, the adapter first deletes all data and then loads all current data: If you are using Transactional with Audit processing, the original data is soft-deleted. The data remains in the database with an end timestamp reflecting the time of the job. If you are using Transactional without Audit processing, the original data is hard-deleted. No record of the data is maintained. In Incremental mode, uses DML statements to insert, update, or soft-delete changed records. In addition, data that has been hard-deleted in Oracle Clinical is hard-deleted in Oracle LSH.