Determining what extraction was used to create a list

If the list was promoted through an extraction, yes. T_PROMOTION has dl_no as a column, which can be tied to an extraction via V_DL_HEADER, then to V_KA_HEADER.

After that, it gets a little murkier. I think you could get a satisfactory  if not precise result by querying TS_EVENTLOG in impresario_cci where the create date is after 'Obtaining list_no and creating t_list row.' rows and before  'Inserting T_LIST_CONTENTS' rows compared to the create date of your list.

Hope that helps.

Matt

If the list was promoted through an extraction, yes. T_PROMOTION has dl_no as a column, which can be tied to an extraction via V_DL_HEADER, then to V_KA_HEADER.

After that, it gets a little murkier. I think you could get a satisfactory  if not precise result by querying TS_EVENTLOG in impresario_cci where the create date is after 'Obtaining list_no and creating t_list row.' rows and before  'Inserting T_LIST_CONTENTS' rows compared to the create date of your list.

Hope that helps.

Matt

In the case of a promotion, you might have to do a join also to t_list on the list name and the number of rows, which isn't the greatest, but it most likely will work.