MOW_MRA_TBA_CONDENSING

Helper table to condense territory coverages data to derive cluster

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_MRA_TBA_CONDENSING_PK	FAMILY_CODE, EXECUTION_NUMBER, MAPPING_SET_ID, CONDENSED_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CONDENSED_ID	NUMBER		18	Yes	CONDENSED_ID
FAMILY_CODE	VARCHAR2	30		Yes	FAMILY_CODE
MAPPING_SET_ID	VARCHAR2	64		Yes	MAPPING_SET_ID
EXECUTION_NUMBER	NUMBER		18	Yes	EXECUTION_NUMBER
TERRITORY_VERSION_ID	NUMBER		18		TERRITORY_VERSION_ID
COVERAGE_TYPE_CODE	VARCHAR2	30			COVERAGE_TYPE_CODE
TERR_DIMENSION_CODE	VARCHAR2	5			TERR_DIMENSION_CODE
PATTERN_LIST	VARCHAR2	4000			PATTERN_LIST
CONDENSED_PATTERN	VARCHAR2	4000			CONDENSED_PATTERN
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_TBA_CONDENSING_U1	Unique	Default	FAMILY_CODE, EXECUTION_NUMBER, MAPPING_SET_ID, CONDENSED_ID