33 Public Views

This section includes the public views for the following APIs:

• Code Lists Views

• Validation Checks Views

• Transformation Views

Code Lists Views

This section contains the following public APIs views:

• DME_PUB_CODELIST_V

• DME_PUB_CODELIST_VALUES_V

DME_PUB_CODELIST_V

Purpose Use this view to see codelist data.

DME_PUB_CODELIST_VALUES_V

Purpose Use this view to see code list values data.

Validation Checks Views

This section contains the following public APIs views:

• DME_PUB_VC_BATCHES_V

• DME_PUB_VC_DETAILS_V

DME_PUB_VC_BATCHES_V

Purpose Use this view to see details about Validation Checks Batches. The following query lists out the Validation Checks Batches available for a given Data model, resulting details about the batch:

Select * from DME_MT_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, e.g. update, checkin, uncheck, checkout, install etc.

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

DME_PUB_VC_DETAILS_V

Purpose Use this view to see details about Validation Checks. The following query lists out 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;

Transformation Views

This section contains the following public APIs views:

• DME_PUB_DF_XFORM_MAP_V

• DME_PUB_DF_MAP_ENTITY_V

• DME_PUB_XFM_SOURCE_TABLES_V

• DME_PUB_XFM_SOURCE_COLUMNS_V

• DME_ PUB_XFM_TARGET_TABLES_V

• DME_ PUB_XFM_TARGET_COLUMNS_V

• DME_ PUB_XFM_AUTOMAPS_V

• DME_PUB_XFM_COL_AUTOMAPS_V

• DME_PUB_XFM_CUSTOM_PROGRAMS_V

• DME_PUB_XFM_EXPR_STDFUNC_V

• DME_PUB_XFM_EXPR_STATIC_PKGS_V

DME_PUB_DF_XFORM_MAP_V

Purpose Use this view to see transformation map details.

DME_PUB_DF_MAP_ENTITY_V

Purpose Use this view to see map entity details.

DME_PUB_XFM_SOURCE_TABLES_V

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

DME_PUB_XFM_SOURCE_COLUMNS_V

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

DME_ PUB_XFM_TARGET_TABLES_V

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

DME_ PUB_XFM_TARGET_COLUMNS_V

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

DME_ PUB_XFM_AUTOMAPS_V

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

DME_PUB_XFM_COL_AUTOMAPS_V

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

DME_PUB_XFM_CUSTOM_PROGRAMS_V

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

DME_PUB_XFM_EXPR_STDFUNC_V

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

DME_PUB_XFM_EXPR_STATIC_PKGS_V

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