Tables for Clinical One and Oracle DMW data flow

The following data flows from Clinical One to Oracle DMW:

Note:

Oracle DMW 3.5 does not support Clinical One dynamic codelists. As a result, any Clinical One trials loading existing optional Codelist and Codelist Items dataset will not load dynamic codelists.

• DHVW_QUERY_V
• DHVW_SUBJECT_FORMITEMS_V
• DHVW_SUBJECT_VISITS_V
• DHVW_FORMS_ASSOCIATIONS_V
• DHVW_DESIGN_DATASET_V
• DHVW_SUBJECTS_DATASET_V
• DHVW_UNBLD_KITS_DATASET_V
• DHVW_RAND_KITS_DESIGN_DATA_V
• DHVW_SUBJECTS_AUDIT_V
• DHVW_UNBLD_KITS_AUDIT_V
• DHVW_RAND_KITS_AUDIT_V
• DHVW_CODELISTS_V
• DHVW_CODELIST_ITEMS_V

For more information on these tables, see section "Data Management Workbench (DMW) extract data dictionary" in the Oracle Life Sciences Clinical One Platform Analytics User Guide.