Table Name:	ana_score
Table Number:	6012
Group:	Analytics
Description:	Analytics indicator, based on scores imported from Analytics,to understand customer behavior and adopt proper customer service to dealwith customer efficiently
Flags:	LOGICAL_OBJECT
Baseline/Custom:	Baseline

Fields
Relations
Indexes
Referenced in Views

select * from table_ana_score

Keyboard shortcuts available

Fields:

Field Name	Common Type	Database Type	Generic Field ID	Array Size	Default	Flags	Comment	Field Used in Views
dev	LONG	int	151		1	DIRECT, ALLOW_NULL	Row version number for mobile distribution purposes
key_objid	LONG	int				DIRECT	Internal record number of the object to be routed (needed to implement exclusive relations)
key_type	LONG	smallint				DIRECT, ALLOW_NULL	Type id of the object to be routed (needed to implement exclusive relations)
last_update	CLK_TIME	datetime					The timestamp of the Analytics run (NOT the Importer)
objid	LONG	int	3			DIRECT	Internal record number
score	FLOAT	real					TNormalized score ultimately presented to the ClarifyCRM User
score_level	CHAR	varchar		32			Grouping abstraction for scores, such as High, Medium or Low
score_type	CHAR	varchar		32			The kind of score. Also known as Analysis_Name. This matches the name used in Analytics database.
update_id	LONG	int				DIRECT	Identifying OBJID of the particular run of the Analytics engine that produced this score. In Clarify, this data is only for auditing and troubleshooting,since the table it maps to exists only on the Analytics server

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
ana_score2bus_org	MTO	bus_org	bus_org2ana_score	Organization's score				score_for	key_type	key_objid
ana_score2contact	MTO	contact	contact2ana_score	Contact's score				score_for	key_type	key_objid
ana_score2site	MTO	site	site2ana_score	Site's score				score_for	key_type	key_objid

Indexes: (Defined in Clarify Schema)

Index Name	Fields	Flags

Indexes (Defined in Database):

An error occurred on the server when processing the URL. Please contact the system administrator.

If you are the system administrator please click here to find out more about this error.

Index Name	Fields	Additional Information