Table AdmUserOpHistory
Purpose
Maintain a log of user actions. This is table is filled using the Auditing service, call UserHistory
Field definitions in table AdmUserOpHistory
| No. | Used | Name | Type | Reqd. | Description |
|---|---|---|---|---|---|
| 1 | Y | UserName | VARCHAR(50) | N | User name |
| 2 | Y | ChangedItem | VARCHAR(50) | N | Code of the item that was changed |
| 3 | Y | ChangedItemType | VARCHAR(50) | N | Type of the item that was changed |
| 4 | Y | Operation | VARCHAR(100) | N | Perfomed operation |
| 5 | Y | Menu | VARCHAR(50) | N | Menu through which the operation was done |
| 6 | Y | SystemDate | TIMESTAMP | N | Insert timestamp |
| 7 | Y | ID | NUMERIC(0,18) | N | Unique ID |
Indexes
Primary key on ID.