MOW_ASGN_DIMENSIONS_FINAL_GT

MOW_ASGN_DIMENSIONS_FINAL_GT is a Global Temp Table which we store the records after filling the gap of various dimension mappings from MOW_ASGN_DIMENSIONS

Details

• Schema: FUSION

• Object owner: MOW

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
MOW_ASGN_DIMENSIONS_FINAL_PK	SEQ_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
SEQ_ID	NUMBER		18	Yes	SEQ_ID = To store the primary key value
PARTY_ID	NUMBER		18	Yes	PARTY_ID = Pulled from table MOW_ASGN_ACCOUNTS
SEQUENCE_LOW	NUMBER		18		SEQUENCE_LOW = Pulled from table MOW_ASGN_DIMENSIONS
TERR_DIMENSION_CODE	VARCHAR2	5		Yes	TERR_DIMENSION_CODE = Pulled from table MOW_ASGN_DIMENSIONS
SEQUENCE_HIGH	NUMBER		18		SEQUENCE_HIGH = Pulled from table MOW_ASGN_DIMENSIONS

Indexes

Index	Uniqueness	Columns
MOW_ASGN_DIMENSIONS_FNL_U1	Unique	SEQ_ID