Dh Metrics dataset

You can use Dh Metrics dataset to ensure that you're looking at the latest version of your study's data in the Oracle Clinical One Analytics.

Modes

Available in all 3 modes: Testing, Training, and Production

What type of data can I obtain from using the Dh Metrics dataset?

With this dataset, you can get custom data such as:

The date and time of the latest study data refresh that occurred.
Whether the system pulled all of the study data to the operational data store and through Oracle Clinical One Analytics.
The exact date and time of when your study's inventory data was pulled from Clinical One and compare it to when that same inventory-related data was then refreshed into Oracle Clinical One Analytics.
Overall, indicators to know if your data in Oracle Clinical One Analytics is currently consistent with what you have in Oracle Clinical One Platform.

There is no specific permission to access this dataset, but you must be assigned with the permission to view and work with at least one other dataset. For information about permissions required to access Oracle Clinical One Analytics and all datasets, see About your access to Oracle Clinical One Analytics.

Browse descriptions of data elements included in this dataset:

Note:

Blank columns in Oracle Clinical One Analytics indicate null or not applicable.

Parent topic: Dataset descriptions

Study folder

This table describes the data elements included in the Study folder.

Table 2-20 Data elements in the Study folder

Data element	Description
BLINDING_TYPE	Indicates whether the study is an open-label type of study or a blinded study, as specified by the study manager when they created the study.
STUDY_ID_NAME	A study ID as specified by the study manager when they created the study, such as a protocol acronym and protocol number.
STUDY_PHASE	A study's phase as indicated by the study manager when they created the study.
STUDY_REFNAME	Indicates the study's reference name used by the system. This value is composed by the STUDY_ID_NAME converted to uppercase with blank spaces removed. Once created, this value never changes, even if STUDY_ID_NAME is changed.
STUDY_TITLE	A protocol's title as specified by the study manager.
THERAPEUTIC_AREA	Indicates the therapeutic area as specified by the study manager when they created the study.
STUDY_MODE	Indicates the study mode used in the referencing data in a custom report, such as Testing, Training, or Active.
STUDY_DESIGN_STATUS	Indicates the study mode used in the referencing data in a custom report, such as Testing, Training, or Active.

Parent topic: Dh Metrics dataset

Metrics folder

This table describes the data elements included in the Metrics folder.

Table 2-21 Data elements in the Metrics folder

Data element	Description
C1_INVENTORIES_MAX_VER_START	Maximum version of the inventories table from the core Clinical One system.
C1_INVENTORIES_ROWCNT	Row counts of the inventores table from the core Clinical One system.
C1_STDY_VER_HIST_MAX_VER_START	Maximum version of the study versions history table from the core Clinical One system.
C1_STUDY_VERSIONS_HIST_ROWCNT	Row counts of the study versions history table from the core Clinical One system.
C1_SUB_FORMITEMS_MAX_VER_START	Maximum version of the subject form items table from the core Clinical One system.
C1_SUBJECT_FORMITEMS_ROWCNT	Row counts of the subject form items table from the core Clinical One system.
DATASOURCE_NUM_ID	This is an Oracle use-only column, used in the return of results to Oracle Clinical One Analytics. Avoid using this data element in your reports.
DH_INVENTORIES_MAX_VER_START	Maximum version of the inventories table from the data model in the Oracle Clinical One Analytics system.
DH_INVENTORIES_ROWCNT	Row counts of the inventories table from the data model in the Oracle Clinical One Analytics system.
DH_STDY_VER_HIST_MAX_VER_START	Maximum version of the study versions history table from the data model in the Oracle Clinical One Analytics system.
DH_STUDY_VERSIONS_HIST_ROWCNT	Row counts of the study versions history table from the data model in the Oracle Clinical One Analytics system.
DH_SUB_FORMITEMS_MAX_VER_START	Maximum version of the subject form items table from the data model in the Oracle Clinical One Analytics system.
DH_SUBJECT_FORMITEMS_ROWCNT	Row counts of the subject form items table from the data model in the Oracle Clinical One Analytics system.
ETL_PROC_WID	This is an Oracle use-only column, used in the return of results to Oracle Clinical One Analytics. Avoid using this data element in your reports.
HEARTBEAT_CONSOLIDATION_TS	Last time that the identified study and mode sent data that was retrieved for Oracle Clinical One Analytics.
IS_DATA_CONSISTENT	Yes/No label for consistency check. Indicates whether the study's data is consistent by comparing row counts and maximum version history from core Oracle Clinical One Platform and the Oracle Clinical One Analytics data model.
LAST_ETL_RUN_TIMESTAMP	Last time that the instance of Oracle Clinical One Analytics was processed for Analytics. Data processing always occurs after data retrieval.
STUDY_ID	Indicates the ID of the study as in the system.

Parent topic: Dh Metrics dataset