ODMR_USER_WF_TEST_RESULTS

You can query the combined results of the ODMR_USER_WF_CLAS_TEST_RESULTS and ODMR_USER_WF_REGR_TEST_RESULTS by using the ODMR_USER_WF_TEST_RESULTS repository view.

Table 8-17 provides more information about this view.

Table 8-17 ODMR_USER_WF_TEST_RESULTS Repository Views

Column Data Type Description

PROJECT_ID

NUMBER

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

PROJECT_NAME

VARCHAR2 (30 CHAR)

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.

CONFUSION_MATRIX

VARCHAR2 (128 CHAR)

This is the test Confusion Matrix result table.

LIFTS

DM_NESTED_CATEGORICALS

Table of DM_NESTED_CATEGORICAL, where:

  • ATTRIBUTE_NAME contains target class

  • VALUE contains lift result table

ROCS

DM_NESTED_CATEGORICALS

Table of DM_NESTED_CATEGORICAL, where:

  • ATTRIBUTE_NAME contains target class

  • VALUE contains ROC result table

ROC_AREA

DM_NESTED_NUMERICALS

Table of DM_NESTED_NUMERICAL, where:

  • ATTRIBUTE_NAME contains target class

  • VALUE contains ROC area under curve value

RESIDUAL_PLOT

VARCHAR2 (128 CHAR)

This is the test Residual Plot table.

Parent topic: Repository Views