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 |