activeuser Table (28)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Currently logged-on users. This table contains encrypted license information. Changing it may disable login for all users and require intervention by SuperOffice support. Recommended use; for determining who is logged on, at what location, etc.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| activeuser_id | Note: This ID is not assigned from sequence, but instead corresponds to the Associate primary key | PK | |
| lastlogin | Date of last login | DateTime | ● |
| netAddress | DNS and numeric IP address | String(127) | ● |
| clientType | 1=CRM , 2=Admin, 3=SOQL, … | UShort | ● |
| computerName | Computer name | String(127) | ● |
| domainName | Domain name | String(127) | ● |
| osUserName | OS user name currently logged on | String(127) | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| activeuser_id | PK | Clustered, Unique |
Relationships
| Table | Description |
|---|---|
| traveller | Associates traveling out from this database |
Replication Flags
- None
Security Flags
- No access control via user's Role.