Database View Reference

Database View Reference

MRX_MAPPINGS

MRX_MAPPINGS

The MRX_MAPPINGS view provides information about all mappings.
The following table describes the columns in the MRX_MAPPINGS view:
Column Name
Datatype
Description
PROJECT_ID
NUMBER
Project ID.
PROJECT_NAME
VARCHAR(3060)
Project name.
PARENT_PATH
VARCHAR(4000)
Path of the object from its root.
MAPPING_ID
NUMBER
Mapping ID.
MAPPING_NAME
VARCHAR(1536)
Mapping name.
MAPPING_TYPE
VARCHAR(22)
Mapping type.
You can view the following object types:
  • Mapping
  • Mapplet
  • Rule
  • Virtual table read mapping
  • Logical data object read mapping
MAPPING_DESC
VARCHAR(4000)
Mapping description.

0 COMMENTS

We’d like to hear from you!