The GPP Database [LOGt] table

The main fields of the or [LOGt] table (or the [LOG] view) are as follows.

Trn_type (Number from 1 to 100. 1 = Access Grant; 3 = Access Denied; 
The meaning of these numbers is on [Log_Events] table, see hereunder.
From_name (Reader name in case of access event. Contains the name as it was defined when the access event actually took place).

Desc3 (Cardholder name. Contains name as it was defined when access event actually took place)
Reader (Reader ID as it appears on [Readers] table)
Controller (Controller ID as it appears on [Controller] table)
Cardholder (Cardholder ID as it appears on [CRDHLD] table)