MNT_LEARNING_RUNS
The scheduler program runs are logged in this table to track the movement of data between maintenance cloud and IoT analytics. This would also record the learning triggers that were initiated by the maintenance cloud.
Details
-
Schema: FUSION
-
Object owner: MNT
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
MNT_LEARNING_RUNS_PK |
RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RUN_ID | NUMBER | 18 | Yes | The unique system generated system identifier. | |
| 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. | |
| RUN_TYPE_CODE | VARCHAR2 | 30 | The type of run. It could be the run for extraction, learning, or scoring. | ||
| RUN_TIMESTAMP | TIMESTAMP | The exact time when the extraction program was run. This is used to compute delta for the next run. | |||
| EXTRACTION_TYPE_CODE | VARCHAR2 | 30 | The type of extraction. Is it an incremental run or a full run. | ||
| DATA_SET_ID | NUMBER | 18 | The data set reference. When this is referenced, this means there is a criteria applied to either to the extraction or the learning. | ||
| BICC_REQUEST_ID | NUMBER | 18 | The enterprise scheduler request identifier that is captured from the BICC job that was run in the movement of data from fusion applications to IoT analytics application. | ||
| LEARNING_WORKFLOW_ID | VARCHAR2 | 36 | The reference of the work flow that is initiated in the IoT analytics application. | ||
| LEARNING_THREAD_ID | VARCHAR2 | 36 | The reference of the work flow thread that is initiated in the IoT analytics application specifically for training and scoring a specific data set. | ||
| RELIABILITY_RATE | NUMBER | The reliability rate that is going to be used in the mathematical model. | |||
| UTILIZATION_RATE | NUMBER | The utilization rate that is going to be used in the mathematical model. | |||
| RELIABILITY_TOLERANCE | NUMBER | The reliability tolerance in percentage that is going to be fed to the learner program. | |||
| UTILIZATION_TOLERANCE | NUMBER | The utilization tolerance in percentage that is going to be fed to the learner program. | |||
| 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. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| MNT_LEARNING_RUNS_U01 | Unique | Default | RUN_ID |