Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    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
    //doorbell.io feedback widged