Public Views

Clinical Data Model Views

This section contains public views related to clinical data models.

Parent topic: Public Views

DME_DATAMODEL_V

Use this view to see study and library clinical data model definitional details.

Parent topic: Clinical Data Model Views

DME_TABLES_V

Use this view to see clinical data model table definitional details.

Parent topic: Clinical Data Model Views

DME_COLUMNS_V

Use this view to see clinical data model table column definitional details.

Parent topic: Clinical Data Model Views

DME_CONSTRAINT_V

Use this view to see clinical data model table constraint definitional details.

Parent topic: Clinical Data Model Views

DME_CONSTRAINT_COLS_V

Use this view to see clinical data model table constraint column definitional details.

Parent topic: Clinical Data Model Views

DME_LOV_VALUES_V

Use this view to see clinical data model table check constraint lists of values.

Parent topic: Clinical Data Model Views

DME_SDTM_COL_IDENTIFIERS_V

Use this view to see SDTM column identifier definitional details.

Parent topic: Clinical Data Model Views

DME_SDTM_TAB_IDENTIFIERS_V

Use this view to see SDTM table identifier definitional details.

Parent topic: Clinical Data Model Views

Codelist Views

This section contains public views related to codelists.

Parent topic: Public Views

DME_PUB_CODELIST_V

Use this view to see codelist definitional details.

Parent topic: Codelist Views

DME_PUB_CODELIST_VALUES_V

Use this view to see codelists with their values.

Parent topic: Codelist Views

DME_PUB_XFM_FILTER_VALUES_V

Use this view to see the codelist codes and values associated with a column in a DMW table that is used as a pivot column in a transformation.

Parent topic: Codelist Views

Discrepancy Views

This section contains public views related to discrepancies.

Parent topic: Public Views

DME_PUB_DISCREPANCIES_V

Use this view to see discrepancy details, including the study, clinical data model, table, and column against whose data the discrepancy was raised.

Parent topic: Discrepancy Views

DME_PUB_DISC_SEND_ERRORS_V

Use this view to help figure out why new or updated discrepancies created by validation checks or TMS that should be sent to InForm (or another integrated EDC system) failed to be sent. It contains a row for each Send failure.

Parent topic: Discrepancy Views

Validation Checks Views

This section contains public views related to validation checks.

Parent topic: Public Views

DME_PUB_VC_BATCHES_V

Use this view to see validation check batch definitional details. The following query returns the validation check batches that read from a given clinical data model:

Select * from DME_PUB_VC_BATCHES_V 
where SRC_MODEL_COMPANY_ID = <company_id> and 
SRC_MODEL_OBJ_ID =<obj> and 
SRC_MODEL_OBJ_VER = <ver>;

The following parameters are required for operations related to a batch; for example, update, check in, uncheck, check out, install, and so on.

BATCH_MAP_COMPANY_ID 
BATCH_MAP_OBJ_ID 
BATCH_MAP_OBJ_VER 
BATCH_MAP_NS_OBJ_ID 
BATCH_MAP_NS_OBJ_VER 
BATCH_MAP_OBJECT_VER_NUM

Parent topic: Validation Checks Views

DME_PUB_VC_DETAILS_V

Use this view to see validation check details. The following query returns the validation checks available for a given validation check batch.

Select * from DME_MT_VC_DETAILS_V 
where vc_company_id=  <vc_batch_map_company_id>  
and VC_BATCH_MAP_OBJ_ID = <vc_batch_map_id> 
and <vc_batch_map_version> 
between VC_MAP_NS_START_OBJ_VER and VC_MAP_NS_END_OBJ_VER;

Parent topic: Validation Checks Views

Transformation Views

This section contains public views related to transformations.

Parent topic: Public Views

DME_PUB_DF_XFORM_MAP_V

Use this view to see transformation map details.

Parent topic: Transformation Views

DME_PUB_DF_MAP_ENTITY_V

Use this view to see map entity details.

Parent topic: Transformation Views

DME_XFM_FILTER_VALUES_V

Use this view to see the codelist codes and values associated with a column in a DMW table that is used as a pivot column in a transformation.

Parent topic: Transformation Views

DME_PUB_XFM_SOURCE_TABLES_V

Use this view to see source database tables involved in table mappings.

Parent topic: Transformation Views

DME_PUB_XFM_SOURCE_COLUMNS_V

Use this view to see details of columns from the source database tables, which are mapped to columns in target database table.

Parent topic: Transformation Views

DME_ PUB_XFM_TARGET_TABLES_V

Use this view to see details for target database tables involved in table mappings.

Parent topic: Transformation Views

DME_ PUB_XFM_TARGET_COLUMNS_V

Use this view to see details of the columns from the target database tables, to which one or more source table are mapped.

Parent topic: Transformation Views

DME_ PUB_XFM_AUTOMAPS_V

Use this view to see details of the available auto maps at table level.

Parent topic: Transformation Views

DME_PUB_XFM_COL_AUTOMAPS_V

Use this view to see details of available auto maps at column level.

Parent topic: Transformation Views

DME_PUB_XFM_CUSTOM_PROGRAMS_V

Use this view to see the details of the available custom programs.

Parent topic: Transformation Views

DME_PUB_XFM_EXPR_STDFUNC_V

Use this view to see supported standard Oracle Scalar functions and their respective function return types. You can refer to these functions while creating the expressions.

Parent topic: Transformation Views

DME_PUB_XFM_EXPR_STATIC_PKGS_V

Use this view to see the user defined LSH stored functions Scalar functions and their respective details. You can check available user-defined functions from this view and can use these functions while dealing with expressions.

Parent topic: Transformation Views