| EmpUID
|
Employee Unique ID |
BigID |
12 |
|
| CompanyID
|
Company Identifier |
SmallID |
12 |
|
| EventID
|
|
BigID |
12 |
|
| EventType
|
Account Maintenance | Successful Logins | Unsuccessful Login | Unknown User ID |
Enum |
1 |
|
 ENUM
| M | Account Maintenance |
| L | Successful Logins |
| F | Unsuccessful Login |
| U | Unknown User ID |
| E | Email Sent |
| A | Successful Authentication |
| H | Unsuccessful Authentication |
| C | Account Created |
| D | Account Disabled |
| B | Account Enabled |
| P | Password Changed |
|
| Activity
|
Account Create | Account Disabled | Password Changed | |
Enum |
1 |
|
ENUM
| U | Emailed UserID |
| W | Emailed Password |
| B | Bad Password |
| A | Account Lockout |
| D | Invalid Data |
| H | Authenticated Before |
|
| UserIDUsed
|
|
Varchar |
40 |
|
| Conditions
|
|
Varchar |
80 |
|
| SessionTS
|
|
Timestamp |
32 |
|
| IPAddress
|
HTTP IP Address, if available. |
Varchar |
30 |
|
| MachName
|
HTTP machine name, if available |
Varchar |
80 |
|
| ActiveTime
|
|
Long |
12 |
|
| LockSeqNbr
|
*SYSTEM* Row Sequence Nbr |
Long |
12 |
|