<model name>_COLUMNS table

This table contains all columns that are used by the decision tree algorithm.

From this table, you can determine the columns that are required for the model application.

The table contains one line for each model column.

The following table shows the table columns:

Table 1. Columns of the <model name>_COLUMNS table
Column Data type Description
COLUMNNAME VARCHAR(128) Name of the input column
DATATYPE VARCHAR(64) SQL data type of COLUMNNAME
OPTYPE VARCHAR(16) Operational type of COLUMNNAME

Possible values are categorical, ordinal, and continuous.
USAGETYPE VARCHAR(16) Usage type

Possible values are ignored, active, predicted, supplementary,frequencyWeight, analysisWeight,and group.
COLUMNWEIGHT DOUBLE Apriori factor of the contribution to the training process of the model in relation to other columns

The default value is 1.0.
IMPORTANCE DOUBLE Indicates the importance of the column for the model as specified in the algorithm

The value is in the range 0 - 1.
OUTLIERTREATMENT VARCHAR(16) Outlier treatment

Possible values are asIs, asMissingValues, and asExtremeValues.
LOWERLIMIT DOUBLE Lower limit of valid values in a numeric field

Null indicates negative infinity.
UPPERLIMIT DOUBLE Upper limit of valid values in a numeric field

Null indicates positive infinity.
CLOSURE VARCHAR(12) Indicates whether the outlier limits are contained in the valid value range

Possible values are openClosed, openOpen, closedOpen, and closedClosed.