Ok 30 views but no replies. I'm probably asking a bit much as I haven't waited all that long. Sorry for my impatience. From my own analysis it appears that the the extract is taken at end of day, since I have observed a work item that changed states multiple times during the day and the AV extracted the item in its later state. Now, this brings me to a follow on question: Is it possible to create a view containing every change throughout the day, with their associated timestamps? Daily extracts misses some changes and in the situation where nothing has changed a daily extract needlessly duplicates a record, making the table bigger and slowing performance.