Enhancements to the Dh Metrics dataset

You can now view record count and versioning metrics for queries in the Dh Metrics dataset in Oracle Clinical One Analytics.

The Dh Metrics dataset now includes four new data elements to verify query data completeness. This allows for more efficient data validation. The new data elements are:

• C1_SUBJ_QUERIES_ROWCNT
• DH_SUBJ_QUERIES_ROWCNT
• C1_SUBJ_QUERIES_MAX_VER_START
• DH_SUBJ_QUERIES_MAX_VER_START

These new data elements combined, allow you to review query total counts in both the core Oracle Clinical One Platform system and the data model in the Oracle Clinical One Analytics system. As well as the last versioning change in both tables. This enables users to verify existing data, comparing data in one system against the other, just as you can with other existing metrics: Randomization and Trial Supply Management (RTSM) inventories, study versions, and data collected in form items.

You can find additional information about this dataset and its new data elements in the Analytics User Guide after the Release Assessment Environment (RAE) upgrade.

Additionally, there is a new Data Hub API that allows users to retrieve Dh Metrics from an endpoint instead of through Oracle Clinical One Analytics. This provides Data Hub APIs users the same operational details as users working with the Dh Metrics dataset in Oracle Clinical One Analytics. For more information on the specific endpoint refer to Rest API updates section in this guide and the REST API for Clinical One Platform guide after the RAE upgrade.