Can anybody tell me what table the promotions screen is getting it's create date from? I checked t_promotion and tx_appeal_media_type without any luck. I'm sure it's probably somewhere obvious.
Lance -
You mean the Constituent Record->Connections Tab->Promotions (Radio Button) screen? Unless I'm misunderstanding your question - I believe it pulls from the promote_dt field in T_PROMOTION for the corresponding row of customer_no and source_no.
Does that help?
Beth
Hey Lance,
I could be wrong but I believe if it's an inside source then the create date is the promote_dt field in t_promotion. If it's an outside source then the create date matches the response date.
Unfortunately neither promote_dt or response_dt correspond to an account that i'm looking at. the lates promote date i'm seeing in t_promotion for this record is 1/25/13, yet the latest date I have in the promotions screen is 3/8/13. The rows i have in t_promotion correspond to the screen, however it's hard to get the last promotion source number and name if I'm trying to pull the supposed create date instead of the promote date.
Never mind... I goofed. I was pulling from our test db instead of live... Too many windows open at once.
Thanks!