Table Name:	ds_calc_fld
Table Number:	5885
Group:	Analytics
Description:	Represents all the calculated attributes of the data set
Flags:
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_ds_calc_fld

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
calc_sentence	CHAR	varchar		1333			SQL statement of the attribute calculation
category	CHAR	varchar		32			Category or business area e.g. billing	Search (2)
description	CHAR	varchar		255			Description of calculated attribute	Search (2)
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
name	CHAR	varchar		32			Name of the calculated attribute	Search (2)
objid	LONG	int	3			DIRECT	Internal record number	Search (2)

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
fld_lg_type2gbst_elm	MTO	gbst_elm	lg_type2ds_calc_fld	Logical type of the column			Search (2)
fld_ph_type2gbst_elm	MTO	gbst_elm	ph_type2ds_calc_fld	Physical data type of the column
ds_calc_fld2struct_lst	OTM	struct_lst	list2ds_calc_fld	Data set's calculated attributes				attr_defn_for	source_type	source_lowid

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

Index Name	Fields	Additional Information
c5885	category	nonclustered located on PRIMARY
n5885	name	nonclustered located on PRIMARY
objindex	objid	clustered, unique located on PRIMARY

Referenced in Views:

View ID	View Name	Tables
5977	dt_calc_attr_view	data_set, ds_calc_fld, gbst_elm, struct_lst, structure, tree_set
5985	ds_clc_attr_view	data_set, ds_calc_fld, gbst_elm, struct_lst, structure

My Recent Objects

ds_calc_fld

Quick Links

act_entry	case	contact	employee
rol_contct	site	site_view	user