Retrieving the description for the Audit Journal Entry Types

I have, to date, been disappointed that I could not programmatically retrieve a description for the 420 Audit journal entry types. Referring to IBM's documentation was just not practical. A new SQL View in the Fall 2025 Technical Refreshes has given me what I wanted, a list of all the journal entry types with their descriptions.

The View is JOURNAL_CODE_INFO, which is found in the library QSYS2. It contains the following columns:

1. JOURNAL_CODE:  The journal code
2. JOURNAL_CODE_DESCRIPTION:  Description of the Journal code
3. JOURNAL_ENTRY_TYPE:  Journal entry type
4. JOURNAL_ENTRY_TYPE_DESCRIPTION:  Description for the journal entry type

The journal codes are for a specific "action", while the Journal Entry Type is the type of information. You can see this with the new View with the following statement:

March presentations

I will be presenting at two events this month:

The first is the March meeting of the Central Texas IBM i User Group, CTXiUG, on Tuesday March 3, 6:30 PM (CT). It is online and free to everyone.

You can learn more about the meeting and register here.

The following week I am off to my first conference of 2026: WMCPA's iCon 2026 conference, in Lake Delavan, WI, Tuesday March 10 - Thursday March 12. Attending this event is a great way to kick-off the conference season. WMCPA always make this a wonderful conference, full of great presenters and subject matter.

You can learn more about it, who will be speaking and what about, and register here.

Don't forget to ask for your RPGPGM.COM-unity ribbon when you see me.

I hope to see you there!