Question

What is the Z00T table?

Answer

The Z00T table is new with version 20. It is described in the v20 Oracle Tables pdf document: "Z00T – Document Tracking.... When a cataloging record is updated, it is possible to keep the old values of selected fields in the Z00T table. The Z00T record will keep each record’s history for the fields that have been defined as parameters of the fix_doc_track fix routine."

When the z00t table is created (via util a/17/1) and a "INS2 fix_doc_track ..." line is added to the xxx01 tab_fix, the programs will write the update information to the Z00T record.

The implementation of the Z00T is described in article " Audit Trails of Catalog Record Fields Deleted and/or Modified " (KB 29475) and in v20 rep_ver 15446. (To view this rep_ver enter the following on the command line, in version 20: rep_ver 15446 .)

The z00t table is used to produce the information in > Edit Actions> View Record history in GUI Cataloging.

Additional Information

KB 29475:  Audit Trails of Catalog Record Fields Deleted and/or Modified

Category: Cataloging

• Article last edited: 26-Apr-2016