MOW_MRA_MAPPERS

Attributes from different family objects marked for results.

Details

  • Schema: FUSION

  • Object owner: MOW

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MOW_MRA_MAPPERS_PK

FAMILY_CODE, DATA_SOURCE_NAME, DATA_COLUMN

Columns

Name Datatype Length Not-null Comments
FAMILY_CODE VARCHAR2 30 Yes FAMILY_CODE
DATA_SOURCE_NAME VARCHAR2 30 Yes DATA_SOURCE_NAME
DATA_COLUMN VARCHAR2 30 Yes DATA_COLUMN
DEST_TABLE_NAME VARCHAR2 30 DEST_TABLE_NAME
DEST_COLUMN_NAME VARCHAR2 30 DEST_COLUMN_NAME
COLUMN_DATA_TYPE VARCHAR2 30 Yes COLUMN_DATA_TYPE
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
MOW_MRA_MAPPERS_U1 Unique Default FAMILY_CODE, DATA_SOURCE_NAME, DATA_COLUMN