MOW_MRA_TBA_RESULT

Territory based assginement result

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_MRA_TBA_RESULT_PK	FAMILY_CODE, EXECUTION_NUMBER, MAPPING_SET_ID, MATCH_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MATCH_ID	NUMBER		18	Yes	MATCH_ID
FAMILY_CODE	VARCHAR2	30		Yes	FAMILY_CODE
MAPPING_SET_ID	VARCHAR2	64		Yes	MAPPING_SET_ID
EXECUTION_NUMBER	NUMBER		18	Yes	EXECUTION_NUMBER
OBJECT_ID	NUMBER		18		OBJECT_ID
OBJECT_TYPE	VARCHAR2	60			OBJECT_TYPE
TERRITORY_VERSION_ID	NUMBER		18		TERRITORY_VERSION_ID
COVERAGE_TYPE_CODE	VARCHAR2	30			COVERAGE_TYPE_CODE
DIM_PATTERN	VARCHAR2	900			DIM_PATTERN
COV_TYPE_DV_PATTERN	VARCHAR2	900			COV_TYPE_DV_PATTERN
COVERAGE_PATTERN	VARCHAR2	60			COVERAGE_PATTERN
ADDRESS_PATTERN	VARCHAR2	900			ADDRESS_PATTERN
BATCH_ID	NUMBER		18		BATCH_ID
FUNCTION_CODE	VARCHAR2	30			Function Code of Territory
LEAF_TERRITORY	VARCHAR2	30			Indicates Leaf Territory
REPEATED_TERRITORY_VERSION_ID	NUMBER		18		Holds replaced child territory of parent
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_RESULT_N1	Non Unique	Default	TERRITORY_VERSION_ID, OBJECT_ID
MOW_MRA_TBA_RESULT_U1	Unique	Default	FAMILY_CODE, EXECUTION_NUMBER, MAPPING_SET_ID, MATCH_ID