| selection_id | Primary key | PK | No |
| associate_id | Associate who owns the selection | FK associate | No |
| group_idx | Original primary user group of associate | FK UserGroup | No |
| name | Name, freetext indexed | String(219) | No |
| text_id | Description text | FK text | Yes |
| postitText_Id | Postit text | FK text | Yes |
| visibility | Obsolete, but still maintained denormalization of visiblefor | UShort | Yes |
| 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 | Yes |
| searchCat_id | Search category (list) | FK SearchCat | Yes |
| companyUnique | Only one person from a company may be selected as a member | UShort | Yes |
| soundEx | What the name sounds like, for duplicate detection | String(9) | Yes |
| source | How did we get this selection? For future integration needs | UShort | Yes |
| memberCount | How many selectionmembers (for progress bar) | UInt | Yes |
| registered | Registered when | UtcDateTime | No |
| registered_associate_id | Registered by whom | FK associate | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | No |
| updatedCount | Number of updates made to this record | UShort | No |
| includePerson | 0 = Include first person, 1 = Include all persons, 2 = Include no persons | Int | Yes |
| targetTableNumber | Table number that this is a selection of (contact, sale, appointment, …) | TableNumber | No |
| 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 | Yes |
| combinationType | How should the inputs of a combined selection be combined | Enum SelectionUnionType | Yes |
| leftSelectionId | ID of the left selection of a combined selection | FK selection | Yes |
| rightSelectionId | ID of the right selection of a combined selection | FK selection | Yes |
| dashboard_tile_definition_id | The associated tile definition | FK dashboard_tile_definition | Yes |
| SystemType | Selection system type - defines if this selection is one that is managed by the system, and what kind it is | Enum SelectionSystemType | Yes |
| chartKey | ID/key of the last-used chart tile on this selection | String(254) | Yes |
| lastLoaded | The date/time this selection was last loaded (selectionentity fetched) | DateTime | Yes |
| lastLoadedBy | Who last loaded this selection | FK associate | Yes |
| lastMembershipChange | The date/time the membership the selection last changed. Dynamic: change of criteria; Static: add/remove members; Combined: change of algorithm | DateTime | Yes |
| lastMembershipChangeBy | Who last changed the membership | FK associate | Yes |
