MSC_SNAPSHOT_OUTPUT_CLOBS
This table stores the output CLOBS that snapshot flushes for consumption by planning engine.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Plan identifier. | |
| ENTITY_NAME | VARCHAR2 | 32 | Yes | Snapshot Entity Name. Eg, Items, BOM, Routing etc. |
| CLOB_NAME | VARCHAR2 | 32 | Yes | Snapshot Entity CLOB Name. |
| ENTITY_CLOB | CLOB | Yes | Snapshot Entity CLOB that holds the actual data | |
| SNAPSHOT_MODE_FLAG | VARCHAR2 | 1 | Yes | Snapshot Mode Flag that indicates if snapshot is run in Complete or NetChange Mode |
| SELECTIVE_SNAPSHOT_RN | NUMBER | Selective Snapshot refresh number | ||
| SELECTIVE_SNAPSHOT_SEQ | NUMBER | This is the selective snapshot sequence number. It will get incremented by each selective snapshot cycle. | ||
| DELETE_LOG_RN | NUMBER | It will be used to track the latest refresh number used by delete log tables. | ||
| PLAN_VERSION | NUMBER | This column contains the value of MSC_PLAN_DEFINITIONS.PLAN_VERSION. This column is mainly used for Forecast Measure User Edits clob | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of 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. |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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_SNAPSHOT_OUTPUT_CLOBS_N1 | Non Unique | FUSION_TS_TX_IDX | PLAN_ID |