34 Public Views

This section includes the public views for the following APIs:

• Section 34.1, "Clinical Data Model Views"

• Section 34.2, "Codelist Views"

• Section 34.3, "Discrepancy Views"

• Section 34.4, "Validation Checks Views"

• Section 34.5, "Transformation Views"

Public views fetch data only if the sys_context setting is enabled by an Oracle DMW login through the API. Public views do not have explicit object-level security checking.

34.1 Clinical Data Model Views

This section contains public views related to clinical data models.

34.1.1 DME_DATAMODEL_V

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

34.1.2 DME_TABLES_V

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

34.1.3 DME_COLUMNS_V

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

34.1.4 DME_CONSTRAINT_V

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

34.1.5 DME_CONSTRAINT_COLS_V

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

34.1.6 DME_LOV_VALUES_V

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

34.1.7 DME_SDTM_COL_IDENTIFIERS_V

Use this view to see SDTM column identifier definitional details.

34.1.8 DME_SDTM_TAB_IDENTIFIERS_V

Use this view to see SDTM table identifier definitional details.

34.2 Codelist Views

This section contains public views related to codelists.

34.2.1 DME_PUB_CODELIST_V

Use this view to see codelist definitional details.

34.2.2 DME_PUB_CODELIST_VALUES_V

Use this view to see codelists with their values.

34.3 Discrepancy Views

This section contains public views related to discrepancies.

34.3.1 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.

34.4 Validation Checks Views

This section contains public views related to validation checks.

34.4.1 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

34.4.2 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;

34.5 Transformation Views

This section contains public views related to transformations.

34.5.1 DME_PUB_DF_XFORM_MAP_V

Use this view to see transformation map details.

34.5.2 DME_PUB_DF_MAP_ENTITY_V

Use this view to see map entity details.

34.5.3 DME_PUB_XFM_SOURCE_TABLES_V

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

34.5.4 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.

34.5.5 DME_ PUB_XFM_TARGET_TABLES_V

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

34.5.6 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.

34.5.7 DME_ PUB_XFM_AUTOMAPS_V

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

34.5.8 DME_PUB_XFM_COL_AUTOMAPS_V

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

34.5.9 DME_PUB_XFM_CUSTOM_PROGRAMS_V

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

34.5.10 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.

34.5.11 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.