CONSTITUENT

Every individual or organization, constituent or non-constituent, is represented by a row in the CONSTITUENT table. Each row in the CONSTITUENT table identifies that entity as an individual or organization, a constituent or non-constituent, and contains that entity's name and its various properties, such as gender or matching gift limits.

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

Fields

Field	Change	Field Type	Null	Notes	Description
NAME	Changed	nvarchar(154) (Computed)	yes	CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE ISGROUP WHEN 1 THEN CASE DISPLAYNAME WHEN '' THEN KEYNAME ELSE DISPLAYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END END	Returns the constituent name (First + Middle Initial + Last (individuals), Prefix + Org name (orgs)).Expression changed from CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE ISGROUP WHEN 1 THEN CASE DISPLAYNAME WHEN '' THEN KEYNAME ELSE DISPLAYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END END to CASE ISORGANIZATION WHEN 1 THEN CASE KEYNAMEPREFIX WHEN '' THEN KEYNAME ELSE KEYNAMEPREFIX + ' ' + KEYNAME END ELSE CASE ISGROUP WHEN 1 THEN CASE DISPLAYNAME WHEN '' THEN KEYNAME ELSE DISPLAYNAME END ELSE CASE FIRSTNAME WHEN '' THEN '' ELSE FIRSTNAME + ' ' END + CASE MIDDLENAME WHEN '' THEN '' ELSE LEFT(MIDDLENAME,1) + '. ' END + KEYNAME END END