REGISTRANTBATCH (4.0SP20)

ID

uniqueidentifier

BATCHID

uniqueidentifier

false

FK to BATCH

EVENTID

uniqueidentifier

false

FK to EVENT

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

REGISTRATIONOPTIONID

uniqueidentifier

false

FK to EVENTPRICE

ADDRESSTYPECODEID

uniqueidentifier

true

FK to ADDRESSTYPECODE

COUNTRYID

uniqueidentifier

true

FK to COUNTRY

STATEID

uniqueidentifier

true

FK to STATE

TITLECODEID

uniqueidentifier

true

FK to TITLECODE

SUFFIXCODEID

uniqueidentifier

true

FK to SUFFIXCODE

MARITALSTATUSCODEID

uniqueidentifier

true

FK to MARITALSTATUSCODE

PHONETYPECODEID

uniqueidentifier

true

FK to PHONETYPECODE

DONOTMAILREASONCODEID

uniqueidentifier

true

FK to DONOTMAILREASONCODE

TEAMFUNDRAISINGTEAMID

uniqueidentifier

true

FK to TEAMFUNDRAISINGTEAM

TRIBUTEESTATEID

uniqueidentifier

true

FK to STATE

TRIBUTETYPECODEID

uniqueidentifier

true

FK to TRIBUTETYPECODE

BILLING_COUNTRYID

uniqueidentifier

true

FK to COUNTRY

BILLING_STATEID

uniqueidentifier

true

FK to STATE

ORGANIZATIONID

uniqueidentifier

true

FK to CONSTITUENT

ORGANIZATION_ADDRESSTYPECODEID

uniqueidentifier

true

FK to ADDRESSTYPECODE

ORGANIZATION_COUNTRYID

uniqueidentifier

true

FK to COUNTRY

ORGANIZATION_STATEID

uniqueidentifier

true

FK to STATE

ORGANIZATION_DONOTMAILREASONCODEID

uniqueidentifier

true

FK to DONOTMAILREASONCODE

ORGANIZATION_PHONETYPECODEID

uniqueidentifier

true

FK to PHONETYPECODE

ORIGINALCLIENTUSERID

int

true

FK to CLIENTUSERS

ORIGINALCONSTITUENTID

uniqueidentifier

true

FK to CONSTITUENT

PHONEID

uniqueidentifier

true

FK to PHONE

ADDRESSID

uniqueidentifier

true

FK to ADDRESS

EMAILADDRESSID

uniqueidentifier

true

FK to EMAILADDRESS

CREDITCARDID

uniqueidentifier

true

Stores the credit card details.

SEQUENCE

int

false

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.

REGISTRANTROLECODE

tinyint

false

0=Start a company, 1=Start a team under a company, 2=Start an independent team, 3=Join a team, 4=Start a household under a company, 5=Start a household under a team, 6=Start an independent household, 7=Join as an individual under a company, 8=Join as individual participant, 9=Join a household

USERID

nvarchar(50)

false

PASSWORD

nvarchar(255)

false

FIRSTNAME

nvarchar(50)

false

LASTNAME

nvarchar(50)

false

EMAILADDRESS

UDT_EMAILADDRESS

false

ADDRESS

nvarchar(150)

false

CITY

nvarchar(50)

false

POSTCODE

nvarchar(12)

false

MIDDLENAME

nvarchar(50)

false

NICKNAME

nvarchar(50)

false

MAIDENNAME

nvarchar(100)

false

BIRTHDATE

UDT_FUZZYDATE

false

GENDERCODE

tinyint

false

0=Unknown, 1=Male, 2=Female

GENDER

nvarchar(7) (Computed)

true

Provides a translation for the 'GENDERCODE' field.

PHONENUMBER

nvarchar(100)

false

DONOTMAIL

bit

false

FUNDRAISINGGROUPNAME

nvarchar(100)

false

SAVETRIBUTEEASCONSTITUENT

bit

false

TRIBUTEEFIRSTNAME

nvarchar(200)

false

TRIBUTEELASTNAME

nvarchar(200)

false

TRIBUTEEEMAIL

UDT_EMAILADDRESS

false

TRIBUTEEADDRESS

nvarchar(300)

false

TRIBUTEECITY

nvarchar(100)

false

TRIBUTEEPOSTCODE

nvarchar(24)

false

TRIBUTETEXT

nvarchar(255)

false

TRIBUTEANONYMOUS

bit

false

SAVEASDEFAULTTRIBUTEE

bit

false

SENDTOACKNOWLEDGEE

bit

false

ACKNOWLEDGEEFIRSTNAME

nvarchar(200)

false

ACKNOWLEDGEELASTNAME

nvarchar(200)

false

ACKNOWLEDGEEEMAIL

UDT_EMAILADDRESS

false

MESSAGETOACKNOWLEDGEE

nvarchar(1000)

false

PARTICIPANTPAGEURL

nvarchar(200)

false

WAIVERACCEPTED

bit

false

FUNDRAISINGGOAL

money

false

TARGETFUNDRAISINGGOAL

money

false

ADDITIONALDONATIONAMOUNT

money

false

PAYMENTMETHODCODE

tinyint

false

0=Cash, 1=Offline Check, 2=Credit/Debit Cards, 3=Online Check (ACH)

CREDITCARDTYPE

uniqueidentifier

true

BANKACCOUNTTYPECODE

tinyint

false

0=Checking Account, 1=Saving Account

BANKACCOUNTTYPE

nvarchar(16) (Computed)

true

Provides a translation for the 'BANKACCOUNTTYPECODE' field.

BANKACCOUNTHOLDER

nvarchar(100)

false

BANKACCOUNTNUMBER

nvarchar(100)

false

BANKACCOUNTROUTINGCODE

nvarchar(100)

false

SAMEASPRIMARYADDRESS

bit

false

BILLING_ADDRESSBLOCK

nvarchar(150)

false

BILLING_CITY

nvarchar(50)

false

BILLING_POSTCODE

nvarchar(12)

false

CHECKDATE

UDT_FUZZYDATE

false

PAYMENTMETHOD

nvarchar(18) (Computed)

true

Provides a translation for the 'PAYMENTMETHODCODE' field.

REGISTRANTROLE

nvarchar(37) (Computed)

true

Provides a translation for the 'REGISTRANTROLECODE' field.

PARTICIPANTGOAL

int

false

DONORRETENTIONGOAL

decimal(7, 4)

false

COMMUNICATIONGOAL

int

false

TEAMFUNDRAISINGGOAL

money

false

TEAMMEMBERGOAL

int

false

TEAMMEMBERRETENTIONGOAL

decimal(7, 4)

false

TEAMCOMMUNICATIONGOAL

int

false

TEAMPARTICIPANTGOAL

int

false

COFUNDRAISINGGOAL

money

false

COTEAMSGOAL

int

false

COTEAMRETENTIONGOAL

decimal(7, 4)

false

COMEMBERGOAL

int

false

COMEMBERRETENTIONGOAL

decimal(7, 4)

false

COPARTICIPANTGOAL

int

false

COCOMMUNICATIONGOAL

int

false

HOFUNDRAISINGGOAL

money

false

HOPARTICIPANTGOAL

int

false

HOCOMMUNICATIONGOAL

int

false

CHECKNUMBER

nvarchar(20)

false

TEAMPAGEURL

nvarchar(200)

false

COMPANYPAGEURL

nvarchar(200)

false

ISORGANIZATION

bit

false

ORGANIZATION_NAME

nvarchar(100)

false

ORGANIZATION_WEBADDRESS

nvarchar(500)

false

ORGANIZATION_ADDRESSBLOCK

nvarchar(150)

false

ORGANIZATION_CITY

nvarchar(50)

false

ORGANIZATION_POSTCODE

nvarchar(12)

false

ORGANIZATION_DONOTMAIL

bit

false

ORGANIZATION_NUMBER

nvarchar(100)

false

ORGANIZATION_EMAILADDRESS

UDT_EMAILADDRESS

false

HOUSEHOLDPAGEURL

nvarchar(200)

false

AUTHORIZATIONCODE

nvarchar(20)

false

The authorization code for a credit card payment, if applicable.

TRANSACTIONID

uniqueidentifier

true

The BBPS transaction ID for a card not present transaction.

REJECTIONMESSAGE

nvarchar(250)

false

The reason the credit card couldn't be authorized.

HOMEMBERGOAL

int

false

HOMEMBERRETENTIONGOAL

decimal(7, 4)

false

HOTARGETFUNDRAISINGGOAL

money

false

HODONORRETENTIONGOAL

decimal(7, 4)

false

SENDNOTIFICATIONS

bit

false

DECLINEBENEFITS

bit

false

BENEFITS

xml

true

VENDORID

nvarchar(50)

false

IX_REGISTRANTBATCH_ADDRESSID

False

False

False

IX_REGISTRANTBATCH_BATCHID

False

False

False

IX_REGISTRANTBATCH_DATEADDED

False

False

True

IX_REGISTRANTBATCH_DATECHANGED

False

False

False

IX_REGISTRANTBATCH_ORGANIZATIONID

False

False

False

IX_REGISTRANTBATCH_ORIGINALCONSTITUENTID

False

False

False

PK_REGISTRANTBATCH

True

True

False

TR_REGISTRANTBATCH_AUDIT_UPDATE

TR_REGISTRANTBATCH_AUDIT_DELETE

REGISTRANTBATCHBATCHSYSTEMMESSAGES

REGISTRANTBATCHID

REGISTRANTBATCHBATCHUSERMESSAGE

ID

REGISTRANTBATCHENEWSLETTER

REGISTRANTBATCHID