Table Name:	data_set
Table Number:	5882
Group:	Analytics
Description:	The table that connects all the sub areas in the data set area and to the session area
Flags:
Baseline/Custom:	Baseline

select * from table_data_set

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
activation_dt	CLK_TIME	datetime					The date that the object became active	Search (1)
description	CHAR	varchar		255		ALLOW_NULL	Description of data set	Search (2)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
filter_sentence	CHAR	varchar		1333			The filter sentence of the data set	Search (1)
gen_dt	CLK_TIME	datetime					Generation (last extraction date) date of the object	Search (2)
last_updated	CLK_TIME	datetime					The last update time of the object	Search (1)
name	CHAR	varchar		32			Name of the data set	Search (8)
objid	LONG	int	3			DIRECT	Internal record number	Search (25)
stats_gen_dt	CLK_TIME	datetime					Columns statistics generation date

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Used in Views	Set Name	Type ID Stored in	Objid Stored In
						Exclusive Set Relations
data_set2ds_param_st	OTOP	ds_param_st	ds_param_st2data_set	The parameters set of the data set (e.g. sample type, random seed)	Search (4)
data_set2extract_res	OTM	extract_res	extr_res2data_set	Extracted result for a data set
data_set2gbst_elm	MTO	gbst_elm	status2data_set	Status of the data set	Search (3)
data_set2log	OTOF	log	log2data_set	Log for a data set		log_for	source_type	source_lowid
data_set2model	OTM	model	model2data_set	Model on which this data set is based on
data_set2rule_set	OTM	rule_set	rule_set2data_set	Rule set for the data set
data_set2se_session	MTO	se_session	se_session2data_set	Session for the data set	Search (13)
data_set2struct_lst	OTOF	struct_lst	list_value2data_set	Value field of a data set
data_set2structure	OTOP	structure	structure2data_set	Structure (columns or teaching field) of the data set	Search (6)
data_set2tree_set	OTM	tree_set	tree_set2data_set	Decision tree generated from the data set

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
n5882	name	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5958	ds_attr_view	data_set, gbst_elm, obj_column, struct_lst, structure
5961	ds_total_num_view	data_set, extrnl_data
5962	ds_create_tf_list	att_dsc_vls, data_set, obj_column
5963	subsets_list_view	data_set, subset
5964	ds_load_tf_list_view	data_set, ds_param_st, tch_fld_inf
5966	data_set_view	anls_object, data_set, gbst_elm, structure
5969	dataset_status_view	data_set, gbst_elm, se_session
5970	decisiontree_status	data_set, gbst_elm, tree_set
5971	ruleset_status_view	data_set, gbst_elm, rule_set, tree_set
5972	model_status_view	data_set, gbst_elm, model, rule_set
5976	dt_attr_view	data_set, gbst_elm, obj_column, struct_lst, structure, tree_set
5977	dt_calc_attr_view	data_set, ds_calc_fld, gbst_elm, struct_lst, structure, tree_set
5979	rs_dt_status_view	data_set, gbst_elm, rule_set, tree_set
5980	rs_ds_status_view	data_set, gbst_elm, rule_set
5985	ds_clc_attr_view	data_set, ds_calc_fld, gbst_elm, struct_lst, structure
5992	model_subset_view	data_set, eval_graph, gbst_elm, model, se_session, subset, tch_fld_inf
6002	ds_se_view	data_set, gbst_elm, se_session
6003	dt_se_view	data_set, gbst_elm, se_session, tree_set
6004	rs_dt_se_view	data_set, gbst_elm, rule_set, se_session
6005	rs_ds_se_view	data_set, gbst_elm, rule_set, se_session
6006	model_rs_se_view	data_set, gbst_elm, model, rule_set, se_session
6007	model_ds_se_view	data_set, gbst_elm, model, se_session
6039	eda_context_view	data_set, eda, gbst_elm, model, se_session, subset
6044	ds_log_view	data_set, gbst_elm, log, log_line, se_session
6057	model_rs_list_view	data_set, gbst_elm, model, rule_set, se_session
6058	model_rs_dt_ds_se_view	data_set, gbst_elm, model, rule_set, se_session

My Recent Objects

data_set

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user

alt-s	Execute SQL
alt-t	Execute SQL, getting latest 10 rows
?	Bring up this help dialog