MKTFINDERNUMBERCONSTITUENT (4.0SP17)

ID

uniqueidentifier

TITLECODEID

uniqueidentifier

true

FK to TITLECODE

SUFFIXCODEID

uniqueidentifier

true

FK to SUFFIXCODE

MARITALSTATUSCODEID

uniqueidentifier

true

FK to MARITALSTATUSCODE

INDUSTRYCODEID

uniqueidentifier

true

FK to INDUSTRYCODE

PARENTCORPID

uniqueidentifier

true

FK to CONSTITUENT

ADDRESSTYPECODEID

uniqueidentifier

true

FK to ADDRESSTYPECODE

DONOTMAILREASONCODEID

uniqueidentifier

true

FK to DONOTMAILREASONCODE

COUNTRYID

uniqueidentifier

true

FK to COUNTRY

STATEID

uniqueidentifier

true

FK to STATE

COUNTYCODEID

uniqueidentifier

true

FK to COUNTYCODE

CONGRESSIONALDISTRICTCODEID

uniqueidentifier

true

FK to CONGRESSIONALDISTRICTCODE

PHONETYPECODEID

uniqueidentifier

true

FK to PHONETYPECODE

EMAILADDRESSTYPECODEID

uniqueidentifier

true

FK to EMAILADDRESSTYPECODE

CURRENTAPPUSERID

uniqueidentifier

true

FK to APPUSER

GROUPTYPEID

uniqueidentifier

true

Points to a custom group type definition in the GROUPTYPE table

NAMEFORMATFUNCTIONID

uniqueidentifier

true

The name format function which will be used to generate the household name if specified.

TITLE2CODEID

uniqueidentifier

true

FK to TITLECODE

SUFFIX2CODEID

uniqueidentifier

true

FK to SUFFIXCODE

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.

GENDERCODE

tinyint

false

0=Unknown, 1=Male, 2=Female

BIRTHDATE

UDT_FUZZYDATE

false

For individuals, stores the date of birth.

ISORGANIZATION

bit

false

Indicates whether a record is an organization.

NUMEMPLOYEES

int

false

For organizations, stores the number of employees.

NUMSUBSIDIARIES

int

false

For organizations, stores the number of subsidiary organizations.

DONOTMAIL

bit

false

ADDRESSBLOCK

nvarchar(150)

false

Contains the address lines.

CITY

nvarchar(50)

false

Contains the address city.

POSTCODE

nvarchar(12)

false

Contains the address post code.

DPC

nvarchar(8)

false

Contains the address delivery point code

CART

nvarchar(10)

false

Contains the address carrier route (CART).

LOT

nvarchar(5)

false

Contains the address LOT.

OMITFROMVALIDATION

bit

false

Indicates this address should be omitted from validation.

LASTVALIDATIONATTEMPTDATE

datetime

true

Contains the date that this address was last validated.

VALIDATIONMESSAGE

nvarchar(200)

false

Stores the validation message.

CERTIFICATIONDATA

int

false

Contains the certification data which shows with which release of the Postal Datafiles this address was last validated.

NUMBER

nvarchar(100)

false

Stores the phone number.

EMAILADDRESS

UDT_EMAILADDRESS

false

The constituent's email address.

WEBADDRESS

UDT_WEBADDRESS

false

The constituent's web address.

ISGROUP

bit

false

Indicates whether a record is a group

GIVESANONYMOUSLY

bit

false

Indicates whether or not the record gives anonymously.

GROUPTYPECODE

tinyint

false

Indicates the type of group. A group type of Custom indicates that GROUPTYPEID will point to a custom group type record in the GROUPTYPE table.

GROUPTYPE

nvarchar(9) (Computed)

true

Provides a translation for the 'GROUPTYPECODE' field.

GROUPDESCRIPTION

nvarchar(300)

false

Provides a user-friendly description of the purpose of a group.

GROUPSTARTDATE

datetime

true

The date of the group's inception

DONOTCALL

bit

false

Indicates whether the constituent should be called at the phone [NUMBER] in this record

DONOTEMAIL

bit

false

Indicates whether the constituent should be contacted at the [EMAILADDRESS] in this record

NAME

nvarchar(154) (Computed)

true

Returns the constituent name (First + Middle Initial + Last (individuals), Prefix + Org name (orgs)).

GENDER

nvarchar(7) (Computed)

true

IX_MKTFINDERNUMBERCONSTITUENT_PARENTCORPID

False

False

False

PK_MKTFINDERNUMBERCONSTITUENT

True

True

True

MKTFINDERNUMBERCONSTITUENTAPPEAL

CONSTITUENTID

MKTFINDERNUMBERCONSTITUENTSITE

MKTFINDERNUMBERCONSTITUENTID