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 Clinical One Cloud Service.

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.

• Study folder
  
• Metrics folder
  

Study folder

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

Table 3-20 Data elements in the Study folder

Data element	Description
BLINDING_TYPE	Indicates the blinding type of the study (whether the study is open-label or blinded) as specified when the study was created. You can view or update this value in Clinical One Cloud Service from the General tab of the Study's settings. The blinding type is specified by selecting an option from a drop-down list of options, which is populated with the labels from the studyGeneralSettings.openLableBlinded codelist within the system codelist selected for the study. Users with the appropriate permissions can update codelists used within a study at any time. See Create and manage code lists.
STUDY_ID_NAME	The study ID as specified when the study was created. The study ID typically includes the protocol acronym or protocol number and must be unique within a tenant. You can view or update this value in Clinical One Cloud Service from the General tab of the Study's settings.
STUDY_PHASE	The study phase as specified when the study was created. You can view or update this value in Clinical One Cloud Service from the General tab of the Study's settings. The study phase is specified by selecting an option from a drop-down list of options, which is populated with the labels from the studyGeneralSettings.studyPhase codelist within the system codelist selected for the study. Users with the appropriate permissions can update codelists used within a study at any time. See Create and manage code lists.
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	The Study Title as specified when the study was created. You can view or update this value in Clinical One Cloud Service from the General tab of the Study's settings.
THERAPEUTIC_AREA	Indicates the therapeutic area as specified when the study was created. You can view or update this value in Clinical One Cloud Service from the General tab of the Study's settings. The therapeutic area is specified by selecting an option from a drop-down list of options, which is populated with the labels from the studyGeneralSettings.therapeuticArea codelist within the system codelist selected for the study. Users with the appropriate permissions can update codelists used within a study at any time. See Create and manage code lists.
STUDY_MODE	Indicates the study mode used in the referencing data in a custom report. Values can be: Testing Training Active
STUDY_DESIGN_STATUS	Indicates the study mode used in the referencing data in a custom report, such as Testing, Training, or Active.

Metrics folder

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

Table 3-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_SUBJ_QUERIES_MAX_VER_START	Maximum version of the queries table from the core Clinical One system.
C1_SUBJ_QUERIES_ROWCNT	Row counts of the queries 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_SUBJ_QUERIES_MAX_VER_START	Maximum version of the queries table from the data model in the Oracle Clinical One Analytics system.
DH_SUBJ_QUERIES_ROWCNT	Row counts of the queries 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 Clinical One Cloud Service 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.