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

Employees (internal)

Some tooltip text!
• 2 minutes to read
 • 2 minutes to read

The associate database table represents employees, resources, and other users - except for external persons.

Yet, this table is important for understanding and navigating the relationship between a person and their user account as well as the relationship between employees at the organization running the CRM system and the external parties they interact with.

You may think of associates as the missing link that connects people.

Associate types

Value Type Description
0 Employee Internal person
1 Resource Not a person
Disregard personId
2 Anonymous Not authenticated for SuperOffice
4 ExternalPerson External person
No calendar
7 Anonymous Unknown
(no person (1) + not authenticated (2) + no calendar (4)
8 NoSentry Has full access rights
The Sentry mechanism is bypassed
13 System System user
(no person (1) + no calendar (4) + full access/bypass sentry (8)

Frequently used values

Database field Description
associate_id ID (primary key)
person_id The person
name Initials, sign-in name, database user name
group_idx Primary group membership
ejuserId ID of the user account
0 if not connected to an account

Important timestamps

Database field Description
lastlogin The last time the associate signed in
lastlogout The last time the associate signed out
registered When the associate was registered
updated The last time the associate was updated

Resources

Resources are typically meeting rooms or equipment such as projectors.

Database field Description
isLocation True if it represents a location
locationAddress The address, if it's a location

Database reference

Associate list and cache

In NetServer when you have a session, the session cache will contain a special cache entry named the associate cache. There all the associates listed in the SuperOffice database can be accessed through the cache, which is much faster than retrieving the associates from the database.

The associate list is an MDO list type that you can retrieve from the database. It holds all the associates from the SuperOffice database.

Howto

  • Get associate list - entity
  • Get associate list from cache
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top