MSC_AGGR_PROF_LEVEL_MEM
This table is used to store distinct combinations of the data available for levels selected in profile. This table has a flag AGGREGATION_REQUIRED which will be used to identify the members for which aggregation is required. This flag will be updated in subsequent runs if there are any changes in hierarchy definition/hierarchy data/profile definition.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MSC_AGGR_PROF_LEVEL_MEM_PK |
PROFILE_ID, PROFILE_LEVEL_ID, PROFILE_MEMBER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROFILE_ID | NUMBER | 18 | Yes | This value indicates the Profile identifier for the record. | |
| PROFILE_LEVEL_ID | NUMBER | 18 | Yes | This value indicates the Level identifier for which dummy members are created. | |
| PROFILE_MEMBER_ID | NUMBER | 18 | Yes | This value indicates the Level Member identifier for which dummy members are created. | |
| PROFILE_MEMBER_NAME | VARCHAR2 | 1600 | Yes | This value indicates the name of member identifier. | |
| PROFILE_MEMBER_NAME_SHORT | VARCHAR2 | 1600 | This column is used to store unique name for level members. If profile level member name already exists or its length exceeds the maximum length of level member field for the respective level, then a unique name is generated using a running sequence. | ||
| LEVEL1_ID | NUMBER | 18 | Yes | Level identifier of the first level in Profile. | |
| LEVEL1_MEMBER_ID | NUMBER | 18 | Yes | Level member identifier of the first level in Profile. | |
| LEVEL2_ID | NUMBER | 18 | Yes | Level identifier of the second level in Profile. | |
| LEVEL2_MEMBER_ID | NUMBER | 18 | Yes | Level member identifier of the second level in Profile. | |
| LEVEL3_ID | NUMBER | 18 | Yes | Level identifier of the third level in Profile. | |
| LEVEL3_MEMBER_ID | NUMBER | 18 | Yes | Level member identifier of the third level in Profile. | |
| LEVEL4_ID | NUMBER | 18 | Yes | Level identifier of the fourth level in Profile. | |
| LEVEL4_MEMBER_ID | NUMBER | 18 | Yes | Level member identifier of the fourth level in Profile. | |
| LEVEL5_ID | NUMBER | 18 | Yes | Level identifier of the fifth level in Profile. | |
| LEVEL5_MEMBER_ID | NUMBER | 18 | Yes | Level member identifier of the fifth level in Profile. | |
| AGGREGATION_REQUIRED | NUMBER | 1 | This column will be used to identify the members for which aggregation is required. | ||
| DELETED_FLAG | NUMBER | 1 | This flag indicates whether the profile level member is deleted for 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_LEVEL_MEM_U1 | Unique | Default | PROFILE_ID, PROFILE_LEVEL_ID, PROFILE_MEMBER_ID |