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.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
KEYNAME
|
nvarchar(100)
|
false
|
|
Last name for individuals, Org name for organizations.
|
|
KEYNAMEPREFIX
|
nvarchar(50)
|
false
|
|
For organizations, stores the name contents before the sort break slash.
|
|
FIRSTNAME
|
nvarchar(50)
|
false
|
|
For individuals, stores the first name.
|
|
MIDDLENAME
|
nvarchar(50)
|
false
|
|
For individuals, stores the middle name.
|
|
MAIDENNAME
|
nvarchar(100)
|
false
|
|
For individuals, stores the maiden name.
|
|
NICKNAME
|
nvarchar(50)
|
false
|
|
For individuals, stores the nickname.
|
|
SSN
|
nvarchar(4000)
|
false
|
|
For individuals, stores the SSN or other government ID.
|
|
SSNINDEX
|
nvarchar(24)
|
true
|
|
|
|
GENDERCODE
|
tinyint
|
false
|
|
0=Unknown, 1=Male, 2=Female
|
|
BIRTHDATE
|
UDT_FUZZYDATE
|
false
|
|
For individuals, stores the date of birth.
|
|
ISINACTIVE
|
bit
|
false
|
|
Indicates whether or not the record is inactive.
|
|
GIVESANONYMOUSLY
|
bit
|
false
|
|
Indicates whether or not the record gives anonymously.
|
|
WEBADDRESS
|
UDT_WEBADDRESS
|
false
|
|
The constituent's web address.
|
|
PICTURE
|
varbinary
|
true
|
|
A photo or emblem for this constituent.
|
|
PICTURETHUMBNAIL
|
varbinary
|
true
|
|
|
|
ISORGANIZATION
|
bit
|
false
|
|
Indicates whether a record is an organization.
|
|
NETCOMMUNITYMEMBER
|
bit
|
false
|
|
Indicates whether a record is a member of our online community.
|
|
DONOTMAIL
|
bit
|
false
|
|
Indicates whether a constituent does not want to be mailed at any address.
|
|
DONOTEMAIL
|
bit
|
false
|
|
Indicates whether a constituent does not want to be emailed at any email address.
|
|
DONOTPHONE
|
bit
|
false
|
|
Indicates whether a constituent does not want to be called at any phone number.
|
|
CUSTOMIDENTIFIER
|
nvarchar(100)
|
false
|
|
User-definable custom identifier.
|
|
SEQUENCEID
|
int
|
false
|
|
Identity column used to increment the default lookupid.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
ISGROUP
|
bit
|
false
|
|
Indicates whether a record is a group
|
|
DISPLAYNAME
|
nvarchar(100)
|
false
|
|
Display name for households.
|
|
LOOKUPID
|
nvarchar(100) (Computed)
|
true
|
|
Unique identifer that supports user defined values as well as system generated values.
|
|
ISCONSTITUENT
|
bit
|
false
|
|
Indicates if the record is a constituent for fundraising purposes.
|
|
AGE
|
int (Computed)
|
true
|
|
For individuals, returns the age.
|
|
KEYNAMESOUNDEX
|
varchar(5) (Computed)
|
true
|
|
The soundex value of the keyname field.
|
|
NAME
|
nvarchar(154) (Computed)
|
true
|
|
Returns the constituent name (First + Middle Initial + Last (individuals), Prefix + Org name (orgs)).
|
|
GENDER
|
nvarchar(7) (Computed)
|
true
|
|
|
