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 |
● |