Is it possible to remove all workers from a plan once a worker is assigned?

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_PLAN
from TX_CUST_PLAN inner join T_PLAN on TX_CUST_PLAN.plan_no = T_PLAN.plan_no
where TX_CUST_PLAN.customer_no = 264207 --Worker id
and T_PLAN.campaign_no = 1342
and T_PLAN.type = 21

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_PLAN
from TX_CUST_PLAN inner join T_PLAN on TX_CUST_PLAN.plan_no = T_PLAN.plan_no
where TX_CUST_PLAN.customer_no = 264207 --Worker id
and T_PLAN.campaign_no = 1342
and T_PLAN.type = 21

Thanks Melissa!