| Table Name: | ana_score_a |
| Table Number: | 6013 |
| Group: | Analytics |
| Description: | internal use table |
| Flags: | |
| Baseline/Custom: | Baseline |
| 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 |
| 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_score_a2bus_org | MTO | bus_org | bus_org2ana_score_a | Organization's score | score_for | key_type | key_objid | |||
| ana_score_a2contact | MTO | contact | contact2ana_score_a | Contact's score | score_for | key_type | key_objid | |||
| ana_score_a2site | MTO | site | site2ana_score_a | Site's score | score_for | key_type | key_objid | |||
| Index Name | Fields | Flags |
|---|---|---|
| I6013 | key_objid:key_type:score_type:update_id | UNIQUE |
| Index Name | Fields | Additional Information |
|---|---|---|
| I6013 | key_objid, key_type, score_type, update_id | nonclustered, unique located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| u6013 | update_id | nonclustered located on PRIMARY |
| View ID | View Name | Tables |
|---|
| ana_score_a | |||