Audit Trails of Catalog Record Fields Deleted and/or Modified

• Article Type: General
• Product: Aleph
• Product Version: 20
• Relevant for Installation Type: Dedicated-Direct; Direct; Local;

We require that Aleph keep track of the Catalog record audit trails, including fields deleted and/or modified.

In the CAT module, we use Edit Actions > View Record's Catalogers to view audit trails. It provides the update history of the record but did not provide information on the fields deleted and/or modified. Is this possible with other reports / services?

Resolution:
Logging (auditing or tracking) the change history (or audit trails) of BIB record fields is done via tab_fix and the Z00T table.

A sample XXX01/tab/tab_fix entry is:
INS2 fix_doc_track 100##,310##,500##,651##

Column 1 controls when the fix occurs (when the record is saved in the example) and column 3 indicates which fields should be tracked.

Note that if there are multiple occurrences of a field, only the first one is tracked.

In the above example, if the record has a 10010 field and a 10011 field, then only the one that is found first in the document will be tracked.

Note: Though the preceding example shows the field parameters being separated from the program name by only a single space ( because Salesforce does not allow multiple consecutive blanks in Cases or articles), they, in fact, -- as seen in the tab_fix header -- need to begin in physical column 35.

The change history can be viewed in Cataloging by selecting the Edit Actions > View Records History menu option.  Example: usm01 000000473.

The previous version of the field is recorded. There is no indication of what change was made, that is, what action was taken. This means that
* adding a field will not be displayed as an action in the Record History
* deleting a field results in the deleted field displaying (together with the date/time stamp of the change and which cataloger made the change)

Category: Cataloging

• Article last edited: 10/8/2013