| 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 | |||