Employees (internal)
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 |
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.