selection Table (23)
• 5 minutes to read
• 5 minutes to read
Selections
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| selection_id | Primary key | PK | |
| associate_id | Associate who owns the selection | FK associate | |
| group_idx | Original primary user group of associate | FK UserGroup | |
| name | Name, freetext indexed | String(219) | |
| text_id | Description text | FK text | ● |
| postitText_Id | Postit text | FK text | ● |
| visibility | Obsolete, but still maintained denormalization of visiblefor | UShort | ● |
| seltype | 0 = static selection, 1 = dynamic selection, 2 = combined selection. See the 'SystemType' field to disnguish between user selections, and Temporary or other system-managed kinds of selection | UShort | ● |
| searchCat_id | Search category (list) | FK SearchCat | ● |
| companyUnique | Only one person from a company may be selected as a member | UShort | ● |
| soundEx | What the name sounds like, for duplicate detection | String(9) | ● |
| source | How did we get this selection? For future integration needs | UShort | ● |
| memberCount | How many selectionmembers (for progress bar) | UInt | ● |
| registered | Registered when | UtcDateTime | |
| registered_associate_id | Registered by whom | FK associate | |
| updated | Last updated when | UtcDateTime | |
| updated_associate_id | Last updated by whom | FK associate | |
| updatedCount | Number of updates made to this record | UShort | |
| includePerson | 0 = Include first person, 1 = Include all persons, 2 = Include no persons | Int | ● |
| targetTableNumber | Table number that this is a selection of (contact, sale, appointment, ....) | TableNumber | |
| done | Done (0=false, 1=true). Status implies changes in which fields are shown in GUI, as well as which fields can be updated | Bool | ● |
| combinationType | How should the inputs of a combined selection be combined | Enum SelectionUnionType | ● |
| leftSelectionId | ID of the left selection of a combined selection | FK selection | ● |
| rightSelectionId | ID of the right selection of a combined selection | FK selection | ● |
| dashboard_tile_definition_id | The associated tile definition | FK dashboard_tile_definition | ● |
| SystemType | Selection system type - defines if this selection is one that is managed by the system, and what kind it is | Enum SelectionSystemType | ● |
| chartKey | ID/key of the last-used chart tile on this selection | String(254) | ● |
| lastLoaded | The date/time this selection was last loaded (selectionentity fetched) | DateTime | ● |
| lastLoadedBy | Who last loaded this selection | FK associate | ● |
| lastMembershipChange | The date/time the membership the selection last changed. Dynamic: change of criteria; Static: add/remove members; Combined: change of algorithm | DateTime | ● |
| lastMembershipChangeBy | Who last changed the membership | FK associate | ● |
How the selections in a combined selections should be put together
| combinationType | ID | Comment |
|---|---|---|
| Unknown | 0 | Combination type is unknown/indefined |
| SubtractRightFromLeft | 1 | All of left, except where it overlaps with right |
| SubtractLeftFromRight | 2 | All of right, except where it overlaps with left |
| Intersect | 3 | Those present in left AND right only |
| XOR | 4 | Those present in left or right, but not both |
| Union | 5 | All, but no duplicates for those present in left and right |
Indexes
| Fields | Types | Description |
|---|---|---|
| selection_id | PK | Unique |
| group_idx | FK | Index |
| name | String(219) | Index |
| soundEx | String(9) | Index |
| source | UShort | Index |
| done | Bool | Index |
| associate_id | FK | Clustered |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| dashboard_tile_definition | Describes the contents of a tile |
| s_link | Links in messages to measure success rate of a campaign. |
| s_shipment | Contains info about one shipment. The addresses are stored in s_shipment_addr |
| SearchCat | SearchCat list table |
| selection | Selections |
| selectionmember | Selection detail table Each row in a selection is represented by one record in this table. Contact_id is always filled in, person_id is optional, but if used, must point to a person belonging to the contact in contact_id. |
| text | Long text fields from all over the system |
| UserGroup | Secondary user groups |
| VisibleFor | Visible for rights, who may see this appointment/document, sale, salehist or selection |
Replication Flags
- None
Security Flags
- Sentry controls access to items in this table using user's Role and data rights matrix.
- Visibility controlled via matching VisibleFor row.