BATCHREVENUECONSTITUENT (4.0SP20)

ID

uniqueidentifier

EXISTINGCONSTITUENTID

uniqueidentifier

true

FK to CONSTITUENT

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

COUNTRYID

uniqueidentifier

true

FK to COUNTRY

STATEID

uniqueidentifier

true

FK to STATE

PHONETYPECODEID

uniqueidentifier

true

FK to PHONETYPECODE

EMAILADDRESSTYPECODEID

uniqueidentifier

true

FK to EMAILADDRESSTYPECODE

CURRENTAPPUSERID

uniqueidentifier

true

FK to APPUSER

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

GROUPTYPEID

uniqueidentifier

true

Points to a custom group type definition in the GROUPTYPE table

COUNTYCODEID

uniqueidentifier

true

FK to COUNTYCODE

CONGRESSIONALDISTRICTCODEID

uniqueidentifier

true

FK to CONGRESSIONALDISTRICTCODE

DONOTMAILREASONCODEID

uniqueidentifier

true

FK to DONOTMAILREASONCODE

NAMEFORMATFUNCTIONID

uniqueidentifier

true

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

SITEID

uniqueidentifier

true

CONSTITUENTSECURITYGROUPID

uniqueidentifier

true

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.

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.

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

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.

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

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.

GROUPTYPE

nvarchar(9) (Computed)

true

Provides a translation for the 'GROUPTYPECODE' field.

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)).

CONSTITUENCYCODEID

uniqueidentifier

true

INFOSOURCECODEID

uniqueidentifier

true

CLASSOF

UDT_YEAR

false

NAMEFORMATS

xml

true

ORIGINAL_LASTNAME

nvarchar(100)

false

ORIGINAL_FIRSTNAME

nvarchar(50)

false

GENDER

nvarchar(7) (Computed)

true

IX_BATCHREVENUECONSTITUENT_DATEADDED

False

False

True

IX_BATCHREVENUECONSTITUENT_DATECHANGED

False

False

False

IX_BATCHREVENUECONSTITUENT_EXISTINGCONSTITUENTID

False

False

False

IX_BATCHREVENUECONSTITUENT_PARENTCORPID

False

False

False

PK_BATCHREVENUECONSTITUENT

True

True

False

TR_BATCHREVENUECONSTITUENT_AUDIT_UPDATE

TR_BATCHREVENUECONSTITUENT_AUDIT_DELETE

BATCHREVENUECONSTITUENTGROUPMEMBER

GROUPID

BATCHREVENUECONSTITUENTGROUPMEMBER

MEMBERID

BATCHREVENUECONSTITUENTRELATION

CONSTITUENTID

BATCHREVENUECONSTITUENTRELATION

RELATIONID