MSC_AGGR_PROF_HIERARCHY_LEVELS
This table is used to store the hierarchies selected in the aggregation profile. In the subsequent runs, this table will be used to identify whether or not the hierarchy setup has changed since the last run.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_AGGR_PROF_HIERARCHY_LE_PK |
PROFILE_ID, DIMENSION_ID, HIERARCHY_ID, LEVEL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROFILE_ID | NUMBER | 18 | Yes | This value indicates the Profile Identifier for the record. | |
| DIMENSION_ID | NUMBER | 18 | Yes | Dimension identifier of the dimension used in the profile. | |
| HIERARCHY_ID | NUMBER | 18 | Yes | Hierarchy identifier of the hierarchy used in the profile. | |
| LEVEL_ID | NUMBER | 18 | Yes | Level identifier of the level used in the profile. | |
| PARENT_LEVEL_ID | NUMBER | 18 | Parent Level identifier of the level used in the profile. | ||
| LEVEL_NUMBER | NUMBER | 5 | Denotes the position of the level in the hierarchy. | ||
| LEVEL_IN_PROFILE | NUMBER | 1 | This flag indicates whether level exists in profile. 1-true; 2-False. | ||
| 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_AGGR_PROF_HIERARCHY_LE_U1 | Unique | Default | PROFILE_ID, DIMENSION_ID, HIERARCHY_ID, LEVEL_ID |