We've got custom headers running and for the most part everything's fine. But our Ticket Office has noticed that occasionally they find accounts where, even though there's a phone number on the account, it doesn't populate in the phone section of the header. I originally traced this to numbers being on the household then not showing up in the headers for the individuals of that account, but have since been sent some accounts that are individuals (no households) and this is happening.
Anyone have any ideas as to why Tess- could be selectively seeing phone numbers like this?
If this is an element in a custom header, then this is really a debugging issue for your DBA (or whoever programmed it) -- not Tessi. Even if you are using Flex Headers, this would come from "local" code stored in TR_FLEX_HEADER_ELEMENT.
Maybe if you post the code you are using to aggregate and return a single phone number for a constituent we could help you debug?
The person/people who set up all of the custom aspects of our system don't work for the company anymore and I'm kind of flying by the seat of my pants with a lot of this.
From the section of the query labeled "get phones":
Select @addr_no = x.address_no, @phone_mask = c.phone_maskFrom [dbo].T_ADDRESS x WITH (NOLOCK) JOIN [dbo].TR_COUNTRY c WITH (NOLOCK) on x.country = c.idWhere x.customer_no = @customer_noand x.primary_ind = 'Y'Exec [dbo].AP_GET_PHONES @customer_no = @customer_no, @address_no = @addr_no, @day_phone = @day_phone OUTPUT, @eve_phone = @eve_phone OUTPUT, @fax_phone = @fax_phone OUTPUT, @called_from = nullSet @day_phone = [dbo].AF_FORMAT_STRING(@day_phone, @phone_mask)Set @eve_phone = [dbo].AF_FORMAT_STRING(@eve_phone, @phone_mask)Set @fax_phone = [dbo].AF_FORMAT_STRING(@fax_phone, @phone_mask)