In trying to run queries directly off the [audit_event] table in the AuditTrail database, we are provided with an [event_type] field. 

While the descriptions of these are provided in the help files, it makes writing a large, dynamic query difficult, as you must also write a case statement for each of the [event_type] values returned so that they display their description (e.g. display "Log On" instead of 1, "View Document" instead of 34, ...).  Normally we'd just join the table with another where those descriptions were housed so that they would dynamically show the corresponding description, however I cannot find a table that houses these.  I know the AuditTrail site when it displays reports does show the description for the event instead of the number but I am wondering if that logic is hard-coded into the site and thus there is not a table available.

Has anyone found in the AuditTrail database where the descriptions for the [event_type] are stored?  If they do not exist there then I would have to build a custom table that houses that info to do the joins and that seems like a waste when it should be in the actual database already.