ODMR_USER_WF_REGR_TEST_RESULTS

You can query the generated regression results for a specific mining model in the last workflow run by using the ODMR_USER_WF_REGR_TEST_RESULTS repository view.

Table 8-16 provides more information about this view.


Table 8-16 ODMR_USER_WF_REGR_TEST_RESULTS Repository Views

Column Data Type Description

PROJECT_ID

NUMBER

This is the ID of the project under which the workflow is created.

PROJECT_NAME

VARCHAR2 (30 CHAR)

This is the name of the project under which the workflow is created.

WORKFLOW_ID

NUMBER

This is the workflow ID.

WORKFLOW_NAME

VARCHAR2 (30 CHAR)

This is the name of the workflow.

NODE_TYPE

VARCHAR2 (30 CHAR)

This is the type of the node. For example, Build node, Model node, and so on.

NODE_ID

NUMBER

This is the ID of the node.

NODE_NAME

VARCHAR2 (30 CHAR)

This is the name of the node.

NODE_STATUS

VARCHAR2 (10 CHAR)

  • INVALID: Indicates that the node is not ready to be run.

  • WARNING: Indicates that the node has run completely, but with warning.

  • READY: Indicates that the node is ready to be run.

  • FAILURE: Indicates that the node run has failed.

  • COMPLETE: Indicates that the node has run successfully.

MODEL_ID

NUMBER

This is the ID of the model.

MODEL_NAME

VARCHAR2 (30 CHAR)

This is the name of the model.

MODEL_STATUS

VARCHAR2 (10 CHAR)

  • WARNING: Indicates that the model has run, but with warning.

  • READY: Indicates that the model is ready to be run.

  • FAILURE: Indicates that the model run has failed.

  • COMPLETE: Indicates that the model run has completed successfully.

MODEL_CREATION_DATE

VARCHAR2 (30 CHAR)

This is the creation date of the model.

TEST_METRICS

VARCHAR2 (128 CHAR)

This is the test metrics result table that contains Predictive Confidence, Root Mean Square error, and so on.

RESIDUAL_PLOT

VARCHAR2 (128 CHAR)

This is the test Residual Plot table.