Repository Guide

10.4.0
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.5

Back Next

REP_FLD_MAPPING

This view shows the source fields used by the target fields in a mapping. This is the companion view for the REP_TBL_MAPPING view. It contains both source and target column names and details.

The following table lists the source and target field metadata in the REP_FLD_MAPPING view:

Column Name	Datatype	Descriptions
SOURCE_FIELD_NAME*	VARCHAR2 (240)	Name of the source field.
SRC_FLD_BUSNAME	VARCHAR2 (240)	Business name of the source field.
SOURCE_NAME	VARCHAR2 (240)	Name of the source table.
SRC_BUSNAME	VARCHAR2 (240)	Business name of the source table.
TARGET_COLUMN_NAME*	VARCHAR2 (240)	Name of the target field.
TARG_COL_BUSNAME	VARCHAR2 (240)	Business name of the target column.
TARGET_NAME	VARCHAR2 (240)	Target name.
TARG_BUSNAME	VARCHAR2 (240)	Business name of the target.
SUBJECT_AREA*	VARCHAR2 (240)	Folder name.
SUBJECT_ID*	NUMBER	Folder ID.
MAPPING_NAME	VARCHAR2 (240)	Name of the mapping.
VERSION_ID	NUMBER	Folder version ID.
VERSION_NAME	VARCHAR2 (240)	Folder version name.
TRANS_EXPRESSION	VARCHAR2 (2000)	Target field transformation expression.
USER_COMMENT	VARCHAR2 (2000)	End user comment.
DBA_COMMENT	VARCHAR2 (2000)	Administrator comment.
MAPPING_COMMENT	VARCHAR2 (2000)	Mapping comment.
MAPPING_LAST_SAVED	VARCHAR2 (240)	Time the mapping was saved last.
MAPPING_ VERSION_NUMBER*	NUMBER	Mapping version number.
SOURCE_VERSION_NUMBER*	NUMBER	Source version number.
TARGET_VERSION_NUMBER*	NUMBER	Target version number.
SOURCE_ID*	NUMBER	Source table ID.
TARGET_ID*	NUMBER	Target table ID.
MAPPING_ID*	NUMBER	Mapping ID.
*Indicates that the column is a key column.