MSC_XTR_HIERARCHY_MAP
This table stores hierarchy mappings in dimension extraction tables. Each hierarchy has a row with flattened levels as columns.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_XTR_HIERARCHY_MAP_PK |
DIMENSION_ID, HIERARCHY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| DIMENSION_ID | NUMBER | 18 | Yes | Dimension identifier. Reference to msc_dimensions_vl. | |
| HIERARCHY_ID | NUMBER | 18 | Yes | Hierarchy identifier. Reference to msc_hierarchies_vl. | |
| BASE_LEVEL_ID | NUMBER | 18 | Base level identifier. LEVEL_ID of first (lowest) level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_2_ID | NUMBER | 18 | Level 2 identifier. LEVEL_ID of second level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_3_ID | NUMBER | 18 | Level 3 identifier. LEVEL_ID of third level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_4_ID | NUMBER | 18 | Level 4 identifier. LEVEL_ID of forth level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_5_ID | NUMBER | 18 | Level 5 identifier. LEVEL_ID of fifth level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_6_ID | NUMBER | 18 | Level 6 identifier. LEVEL_ID of sixth level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_7_ID | NUMBER | 18 | Level 7 identifier. LEVEL_ID of seventh level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_8_ID | NUMBER | 18 | Level 8 identifier. LEVEL_ID of eighth level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_9_ID | NUMBER | 18 | Level 9 identifier. LEVEL_ID of ninth level of this hierarchy, reference to msc_levels_vl. | ||
| LEVEL_10_ID | NUMBER | 18 | Level 10 identifier. LEVEL_ID of tenth level of this hierarchy, reference to msc_levels_vl. | ||
| 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 |
|---|---|---|---|
| MSC_XTR_HIERARCHY_MAP_U1 | Unique | Default | DIMENSION_ID, HIERARCHY_ID |