TR_NAMESTATUS column

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

[My attempt to reply was truncated coming through, so I'm trying again:]

Hi, Adria:

I have two rows in TR_NAMESTATUS:

id = 1, description = [blank], inactive = N, ignore_for_sal = NULL
id = 2, description = Deceased, inactive = N, ignore_for_sal = Y

From the System Tables help on tessituranetwork.com:

"The entry with the ID 1 is the default value used for new names and should not be deleted or inactivated. ID 2, Deceased, is used by system processes and should not be deleted or edited."

Probably you need to check what you’ve got in your system and recreate something like the above, if you don’t have it. If you have other legitimate values in TR_NAMESTATUS (I’ve heard that some places put things like “Divorced” here), their id’s should be higher than 1 and 2.

 Check T_CUSTOMER for any accounts that have values other than the legitimate ones you’ve identified:

select * from T_CUSTOMER
where name_status not in (1,2) --add any other id values from legitimate rows in TR_NAMESTATUS

Any T_CUSTOMER rows you come up with illegitimate values would need to be updated via the back end.

 You might consider opening a ticket if you or your IT friends can’t fix this easily.

 Lucie