1. Tables and Views for SCM
  2. MSC_SCP_IOT_EXTRACT_COLS

MSC_SCP_IOT_EXTRACT_COLS

Table to store the information about the SCP data extraction for IoT column mapping.

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSC_SCP_IOT_EXTRACT_COLS_PK

IOT_PLAN_ID, EXT_TABLE_TYPE, EXT_COLUMN_DATA_TYPE, EXT_COLUMN_NUM, EXT_COLUMN_PREFIX_TYPE, SRC_OBJECT_TYPE, SRC_OBJECT_ID

Columns

Name Datatype Length Precision Not-null Comments
IOT_PLAN_ID NUMBER 18 Yes The IOT Assigned Plan ID which is a combination of the SCP Plan ID, Forecast Profile ID and Analysis Set ID for Which The Data Set Was Extracted To The IOT Engine.
EXT_TABLE_TYPE NUMBER 9 Yes The type of the data extraction table this column is mapped in.
EXT_COLUMN_DATA_TYPE NUMBER 9 Yes The data type of the mapped extraction column. (1 = Date, 2 = Number, 3 = String.)
EXT_COLUMN_NUM NUMBER 9 Yes The extraction column number in extraction prefix. (Start from 1)
EXT_COLUMN_PREFIX_TYPE NUMBER 9 Yes The column prefix type in the extraction table. (1 = "DATE_", 2 = "NUM_", 3 = "STR_", 4 = "TARGET_VAR_", 5 = "OTHER_NUM_")
SRC_OBJECT_TYPE NUMBER 9 Yes The source object type that is mapped to this extraction column. (1 = Measure, 2 = Attribute, 3 = Level)
SRC_OBJECT_ID NUMBER 18 Yes The id of the source object that is mapped to this extraction column.
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.
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.

Indexes

Index Uniqueness Tablespace Columns
MSC_SCP_IOT_EXTRACT_COLS_U1 Unique Default IOT_PLAN_ID, EXT_TABLE_TYPE, EXT_COLUMN_DATA_TYPE, EXT_COLUMN_NUM, EXT_COLUMN_PREFIX_TYPE, SRC_OBJECT_TYPE, SRC_OBJECT_ID