MSC_ST_CSTMHRCHY_INT
MSC_ST_CSTMHRCHY_INT is a staging table.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| DIMENSION_ID | NUMBER | Dimension ID of the given hierarchy. Will be populated for error records only. | ||
| DIMENSION_NAME | VARCHAR2 | 64 | Dimension Name of the given hierarchy. | |
| HIERARCHY_ID | NUMBER | Hierarchy ID of the given hierarchy. Will be populated for error records only. | ||
| HIERARCHY_NAME | VARCHAR2 | 240 | Hierarchy name of the given hierarchy. | |
| LEVEL_0 | VARCHAR2 | 64 | ID of the zeroth Level in the hierarchy. | |
| LEVEL_1 | VARCHAR2 | 64 | ID of the first Level in the hierarchy. | |
| LEVEL_2 | VARCHAR2 | 64 | ID of the second Level in the hierarchy. | |
| LEVEL_3 | VARCHAR2 | 64 | ID of the third Level in the hierarchy. | |
| LEVEL_4 | VARCHAR2 | 64 | ID of the fourth Level in the hierarchy. | |
| LEVEL_5 | VARCHAR2 | 64 | ID of the fifth Level in the hierarchy. | |
| LEVEL_6 | VARCHAR2 | 64 | ID of the sixth Level in the hierarchy. | |
| LEVEL_7 | VARCHAR2 | 64 | ID of the seventh Level in the hierarchy. | |
| LEVEL_8 | VARCHAR2 | 64 | ID of the eighth Level in the hierarchy. | |
| LEVEL_9 | VARCHAR2 | 64 | ID of the ninth Level in the hierarchy. | |
| LEVEL_10 | VARCHAR2 | 64 | ID of the tenth Level in the hierarchy. | |
| COPY_FROM | VARCHAR2 | 64 | Hierarchy from which the target hierarchy tobe copied. | |
| DEFAULT_FLAG | NUMBER | Denotes whether the current hierarchy is the default or not. | ||
| REFRESH_NUMBER | NUMBER | Refresh Number of the current process. | ||
| PROCESS_FLAG | NUMBER | Process Flag of the current record. | ||
| DELETED_FLAG | NUMBER | Deleted Flag of the current record. | ||
| ERROR_CODE | VARCHAR2 | 150 | Error Code of the current record in case of a failed record. | |
| ERROR_TEXT | VARCHAR2 | 2000 | Error Message of the current record in case of a failed record. | |
| 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. | |
| LOAD_REQUEST_ID | NUMBER | Column to store the Load Request ID value of the process |