About journal codes

The &ENTTYP journal control field generates journal codes that provide you with the information you need to identify the exact table operations on the source system that generated the audit record in the table on the target system.

By mapping the &ENTTYP journal control field to the added audit column in the table on the target system, you can determine the events that generated each audit record. In the target database, the &ENTTYP journal control field contains the two-character journal code that identifies the specific event that happened at the source table level and which generated the audit record on the target system.

CDC Replication generates multiple journal codes. Journal codes represent events that take place in your source database. You can customize the journal codes by building an expression with the %IF column function. For more information, see Translating journal codes into meaningful information.

You can customize the journal codes generated by CDC Replication.