The metadata columns correspond to the header and contain fields that have special meaning. Metadata columns should include the following information.

• optype contains values indicating if the record is an insert, update, or delete. The default values are I, U, and D.

• timestamp indicates type of value to use for the commit timestamp of the record. The format of the timestamp defaults to YYYY-DD-MM HH:MM:SS.FFF.

• schemaandtable is the full table name for the record in the format SCHEMA.TABLE.

• schema is the record's schema name.

• table is the record's table name.

• txind is a value that indicates whether the record is the beginning, middle, end or the only record in the transaction. The default values are 0, 1, 2, 3.

• id is the value used as the sequence number (RSN or CSN) of the record. The id of the first record (operation) in the transaction is used for the sequence number of the transaction.