The rcd_cmac column

This column keeps track of the change management status of individual records within an object. It can contain these values:

• 0: The record has not been modified; occurs in checked-ins table only.
• 1: The record is inserted; occurs in checked-outs table only.
• 2: The record is updated.
• 3: The record is deleted.

If the rcd_cmac value of a record in the checked-ins table is non-zero, then a record with identical primary key, rcd_toid, and rcd_cmac values must exist in the checked-outs table.