Table Name:	model
Table Number:	5910
Group:	Analytics
Description:	Information about the models, connection to other areas
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_model

Keyboard shortcuts available

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 model was activated	Search (4)
active_attr_num	LONG	int				DIRECT	Number of active attributes in the model	Search (1)
active_rules_num	LONG	int				DIRECT	Number of active rules in the model	Search (1)
archived_dt	CLK_TIME	datetime					The date that the model was deactivated (archieved)
description	CHAR	varchar		255			Model description	Search (6)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
eval_dt	CLK_TIME	datetime					The evaluation date of the model
gen_dt	CLK_TIME	datetime					The generation date of the model. This is needed for the evaluation only and relevant only in LR (Logistic Regression) models	Search (2)
last_updated	CLK_TIME	datetime					The last update time of the object	Search (5)
modified_weights_num	LONG	int				DIRECT	Number of weights of the model
name	CHAR	varchar		32			Name of the model	Search (9)
objid	LONG	int	3			DIRECT	Internal record number	Search (16)

Relations:

Relation	Type	Target Object	Inverse Relation	Comment	Flags	MTM Table	Used in Views	Set Name	Type ID Stored in	Objid Stored In
								Exclusive Set Relations
model2data_set	MTO	data_set	data_set2model	The data set used to generate model			Search (2)
model2eda	OTM	eda	eda2model	EDA (Exploratory Data Analysis) for a model
model2eval_graph	OTM	eval_graph	eval_graph2model	Evaluation graph for a model
mod_status2gbst_elm	MTO	gbst_elm	status2model	Stauts of the model			Search (7)
model_type2gbst_elm	MTO	gbst_elm	type2model	Type of the model			Search (6)
model2level_stats	OTM	level_stats	level_stats2model	The levels of the model
model2log	OTOF	log	log2model	Log for a model				log_for	source_type	source_lowid
model2md_lr_param	OTOP	md_lr_param	md_lr_param2model	The lr model parameters for a model
model2rule_set	MTO	rule_set	rule_set2model	The rule_set of the model (relevant in 'best rule' and lr models)			Search (4)
model2score_part	OTM	score_part	score_part2model	Partial scoring SQL for the model
model2tch_fld_inf	MTO	tch_fld_inf	tch_fld_inf2model	Teaching fields used in a model			Search (1)
model2weight_set	OTOF	weight_set	weight_set2model	Weight set assigned to a model
model2wght_model	OTM	wght_model	wght_model2model	Weight of a model

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

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

Referenced in Views:

View ID	View Name	Tables
5972	model_status_view	data_set, gbst_elm, model, rule_set
5975	combined_model_view	gbst_elm, model, weight
5992	model_subset_view	data_set, eval_graph, gbst_elm, model, se_session, subset, tch_fld_inf
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
6047	model_log_view	gbst_elm, log, log_line, model, se_session
6053	br_definition_view	anls_rule, model, rs_cls_simp, rule_stats, weight, weight_set
6054	lr_definition_view	anls_rule, model, rule_stats, weight, weight_set, wgt_att_cnt, wgt_att_dsc
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
6060	weight_rule_view	anls_rule, gbst_elm, model, weight, weight_set
6061	weight_attr_cnt_view	gbst_elm, model, weight, weight_set, wgt_att_cnt
6062	weight_attr_dsc_view	gbst_elm, model, sp_miss_vls, weight, weight_set, wgt_att_dsc
6067	columns_eda_stt_dsc_temp	eda, eda_attr, eda_dsc_vls, model, struct_lst, subset
6069	active_models_view	model

My Recent Objects

model

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user