GoldMine Table Structures.
USERLOG
DBase Directory Location: GMBASE
Table Description: Log file of user logins, duration and amount of work completed. Displayed in the
GoldMine system logs.
| Table Indexes | |||
| Name | DBase Index | SQL Index | ID |
| USERLOG | USERID+LOGIN | USERID+LOGIN | - |
| ULGRECID | RECID | RECID | - |
| Table Relationships | |
| Field | |
| None | |
| Table Fields Structure | |||
| Field Name | Field Type | Length | Description |
| CRC | String | 2 | CRC code used as an integrity check to prevent tampering from outside sources. |
| USERID | String | 8 | User Name |
| LOGIN | String | 14 | Time logged in (Format YYYYMMDD HH:MM) |
| LOGOUT | String | 14 | Time logged Out (Format YYYYMMDD HH:MM) |
| INOUT | Integer | 2 | Number of times user logged in. If more than 1, Track Daily Totals has been turned on for this user. |
| DUR | Long | 4 | Number of minutes logged in. If Track Daily Totals is turned on, this is the total login time for the day. |
| KEYS | Long | 4 | Number of keys pressed |
| CLICKS | Long | 4 | Number of mouse clicks |
| RECID | String | 15 | Record ID |
LinkedIn