We are trying to create our own reports directly from the database but are having trouble identifying the key that marks a record as deleted. We have lot's (000's) of tickets that have been deleted over time (mainly from bounces between SD and other systems) this is making the reports a long way out as we can't exclude them.