When looking at Plan Details I can see the Primary Worker for a given plan. Where can I find the table that connects workers to plans and the assumed column labled Primary_worker or some such name that designates said worker for that role?
I ask this because I've been given a request to write a stored procedure that would change the Primary Worker to whatever name is designated in the attribute "Portfolio Owner", and I can't seem to find the specific table that holds that information so that I can "get all algorithmic on it".
Am I going about this wrong? Is there such a table? Who wrote the book of love? What's love got to do, got to do with it?
Thanks in advance, Tessiturians.
Hey Matt -
I think what you're looking for is TX_CUST_PLAN. The column called customer_no refers to the worker_customer_no. Then there is a column called role_no which hooks up to TR_WORKER_ROLE to give you the description of the role. And then there is indeed a primary_ind.
good luck!
frannie