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 |