WPRELATIONSHIP_NPA_IND

Contains WealthPoint Nonprofit Affiliation relationship individual information.

For the full definition of the WPRELATIONSHIP_NPA_IND table, see WPRELATIONSHIP_NPA_IND.

Fields

Field	Change	Field Type	Null	Notes	Description
FULLNAME	Changed	nvarchar(206) (Computed)	yes	CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLE WHEN '' THEN '' ELSE LEFT(MIDDLE,1) + '. ' END + LASTNAME + CASE SUFFIX WHEN '' THEN '' ELSE ', ' + SUFFIX END	Expression changed from CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLE WHEN '' THEN '' ELSE LEFT(MIDDLE,1) + '. ' END + LASTNAME + CASE SUFFIX WHEN '' THEN '' ELSE ', ' + SUFFIX END to CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLE WHEN '' THEN '' ELSE LEFT(MIDDLE,1) + '. ' END + LASTNAME + CASE SUFFIX WHEN '' THEN '' ELSE ', ' + SUFFIX END