• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

selection Table (23)

Some tooltip text!
• 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 ●

selection table relationship diagram

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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top