SQL View Name: | columns_eda_stat_disc |
SQL View Number: | 6068 |
Group: | Analytics |
Base Table: | eda_sts_dsc |
Description: | The previous view fetches duplicated values - with model and without model. In this view we remove the duplicated values |
Flags: | VIEW_OPTIMIZED |
Baseline/Custom: | Baseline |
Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment |
---|---|---|---|---|---|---|---|
disc_value | CHAR | varchar | 255 | Name of the value | |||
objid | LONG | int | 3 | DIRECT | Internal record number | ||
percent_occurences | FLOAT | real | The percentage of records with this value | ||||
struct_list_objid | LONG | int | DIRECT | Internal record number for struct_lst | |||
subset_objid | LONG | int | DIRECT | Internal record number for subset | |||
upper_bound | FLOAT | real | For discretized attribute, the point of the value | ||||
value_count | LONG | int | DIRECT | Number of records with this value | |||
value_formatted | CHAR | varchar | 255 | The percentage + '%' + value_name; e.g '20% NY' |
columns_eda_stat_disc | |||