Hello,
Is it possible to remove all workers from a plan once a worker is assigned? We're looking to remove all workers from our prospect plans. We have about 290 prospect plans assigned to a primary worker.
Thanks,
Nathaniel
There is no utility in Tessitura that does that, you have to do it through sql.
This is what I use to delete workers from plans:
delete from TX_CUST_PLANfrom TX_CUST_PLAN inner join T_PLAN on TX_CUST_PLAN.plan_no = T_PLAN.plan_nowhere TX_CUST_PLAN.customer_no = 264207 --Worker idand T_PLAN.campaign_no = 1342and T_PLAN.type = 21
Thanks Melissa!