Add timestamp to all date related dimensions in analytics
Some areas in analytics only have date stamps instead of date+time stamps, so reporting on for example, Events from analytics will only ever bring back the date the event occurred and not the date+time required for auditing.
We'd like all dimension datestamps to have a version of the timestamp which includes the date+time so that they are useful in working out when a transaction occurred and not just the date it happened. This is good for consistency across analytics data as well.
Chris Jones commented
The benefits of this extend beyond internal audit - certainly there are important date fields, e.g. for Requests where the time is not currently available through analytics but where it would be potentially valuable to analyse user behaviour to tailor staff resource to the periods of greatest demand for example. Could this also be achieved just by adding <operation> time as an additional field to the <operation> ID table concerned? e.g. somewhat like Fulfillment/Loan and Return times?