Hi all,
Can anyone tell me how the constituency_no column in TX_CONST_CUST is calculated? i am trying to update a procedure that updates our subscription constituency and want to make sure i have the right value plugged in there.
thanks!
Frannie
Actually I think I just got the procedure to run without plugging anything into that column. Is is calculated elsewhere?
Thanks ---
Hi Frances,
Our subs constituency is updated by a nightly stored procedure that updates constituent sub history tables (LP_UPDATE_SUB_HIST).
Is that the procedure you were trying to modify?
The constituency column of the TX_CONST_CUST table is a foreign key referenced from id column of TR_CONSTITUENCY.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell Sent: Tuesday, March 26, 2013 3:42 PM To: Guy, Jackie Subject: Re: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST
From: Frances O'Connell <bounce-francesoconnell5073@tessituranetwork.com> Sent: 3/26/2013 3:20:54 PM
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
Hi Beth and Jackie -
Thanks for your responses. I was not very clear--in our db the sub constituency is updated by a custom SP (as opposed to being a part of UPDATE_SUB_HIST). I've got that part of it - it's just that in this proc we add or update the row in TX_CONST_CUST for the customer/constituency in question, and I noticed that TX_CONST_CUST has an additional column in v.11 called constituency_no (separate from the constituency ID, set in TR_CONSTITUENCY. Note that we are not actually Live in v.11, but I was trying to test my udpated proc in there - and hit against this.
I was wondering if I needed to insert a value into the constituency_no column in the UPDATE command in the SP. But I didn't in my test and it seems to have calculated itself? In which case I will not worry...
Thank you--
Oh I see! I did misunderstand the situation. :)
It seems to me that column is just an ID number to identify that specific customer/constituency matching. Much like address_no in T_ADDRESS.
If it seems to fill in automatically then I would also not worry about it.
Hi Frannie -
That column is indeed set up as an identity column type, so it increments itself with every new row. No need to worry about it! I'm guessing that Tessitura is trying to standardize having some sort of ID number in tables where it makes sense.
Heather
Constituency_no is an identity column, so the number is determined by SQL Server automatically. It kind of acts as a unique identifier for each row in this table, although in this case, it isn’t the primary key of the table. So there is no need to include it when inserting rows into this table.
Thanks,
David
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell Sent: Tuesday, March 26, 2013 1:46 PM To: David Frederick Subject: Re: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST
Thanks for the clarification. The constituency_no column is set as an identity column and the value will be populated automatically.
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Frances O'Connell Sent: Tuesday, March 26, 2013 4:22 PM To: Guy, Jackie Subject: RE: [Tessitura Technical Forum] v.11: constituency_no in TX_CONST_CUST
From: Jackie Guy <bounce-jacquelineguy8869@tessituranetwork.com> Sent: 3/26/2013 3:54:38 PM
Thank you all! This makes sense and I love an easy answer!