Building time series data from audit records

Has anyone worked out how to produce time series data from Tessitura audit records. In particular I want to know t_address.postal_code values of over time. What I'm trying to do is determine the postal code at the time of an order is placed going back 3-5 years evan 10 years ago. Or better yet the default account address every time a sublime item is added to an order. We can not use the postal code in the credit card logs (Which could work.) Because for PCI reasons we are actively purging these records. T_address.postal_code values are updated and so we loose past values of postal codes in that table. To really know the postal code "as of" some time in the past one would have to take into account values stored in ta_audit_trail. Has anyone worked out the code to do this? If so, I would like to learn more about what you have been able to do. Thanks.