Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SEQUENCE int   Default = 0
 USERID nvarchar(50)   Default = ''
 PASSWORD nvarchar(255)   Default = ''
 LASTNAME nvarchar(50)   Default = ''
 FIRSTNAME nvarchar(50)   Default = ''
 MIDDLENAME nvarchar(50)   Default = ''
 NICKNAME nvarchar(50)   Default = ''
 MAIDENNAME nvarchar(100)   Default = ''
 BIRTHDATE UDT_FUZZYDATE   Default = '00000000'
 GENDERCODE tinyint   Default = 0 0=Unknown, 1=Male, 2=Female
 GENDER nvarchar(7) (Computed) CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END Provides a translation for the 'GENDERCODE' field.
 ADDRESS nvarchar(150)   Default = ''
 CITY nvarchar(50)   Default = ''
 POSTCODE nvarchar(12)   Default = ''
 DONOTMAIL bit   Default = 0
 PHONENUMBER nvarchar(100)   Default = ''
 EMAILADDRESS UDT_EMAILADDRESS   Default = ''
 COMPANYNAME nvarchar(100)   Default = ''
 COMPANYURL UDT_WEBADDRESS   Default = ''
 COMPANY_ADDRESS nvarchar(150)   Default = ''
 COMPANY_CITY nvarchar(50)   Default = ''
 COMPANY_POSTCODE nvarchar(12)   Default = ''
 COMPANY_DONOTMAIL bit   Default = 0
 COMPANY_PHONENUMBER nvarchar(100)   Default = ''
 COMPANY_EMAILADDRESS UDT_EMAILADDRESS   Default = ''
 DECLINEBENEFITS bit   Default = 0
 SPONSORSHIPURL UDT_WEBADDRESS   Default = ''
 SPONSORSHIPMESSAGE nvarchar(1000)   Default = ''
 ADDITIONALDONATIONAMOUNT money   Default = 0
 PAYMENTMETHODCODE tinyint   Default = 0 0=Cash, 1=Offline Check, 2=Credit/Debit Cards, 3=Online Check (ACH)
 PAYMENTMETHOD nvarchar(18) (Computed) CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Offline Check' WHEN 2 THEN N'Credit/Debit Cards' WHEN 3 THEN N'Online Check (ACH)' END Provides a translation for the 'PAYMENTMETHODCODE' field.
 CREDITCARDTYPE uniqueidentifier
 CHECKDATE UDT_FUZZYDATE   Default = '00000000'
 BANKACCOUNTTYPECODE tinyint   Default = 0 0=Checking Account, 1=Saving Account
 BANKACCOUNTTYPE nvarchar(16) (Computed) CASE [BANKACCOUNTTYPECODE] WHEN 0 THEN N'Checking Account' WHEN 1 THEN N'Saving Account' END Provides a translation for the 'BANKACCOUNTTYPECODE' field.
 BANKACCOUNTHOLDER nvarchar(100)   Default = ''
 BANKACCOUNTNUMBER nvarchar(100)   Default = ''
 BANKACCOUNTROUTINGCODE nvarchar(100)   Default = ''
 SAMEASPRIMARYADDRESS bit   Default = 1
 BILLING_ADDRESSBLOCK nvarchar(150)   Default = ''
 BILLING_CITY nvarchar(50)   Default = ''
 BILLING_POSTCODE nvarchar(12)   Default = ''
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 CHECKNUMBER nvarchar(20)   Default = ''
 ISCOMPANYSPONSOR bit   Default = 0
 AUTHORIZATIONCODE nvarchar(20)   Default = ''
 TRANSACTIONID uniqueidentifier
 REJECTIONMESSAGE nvarchar(250)   Default = ''
 SENDNOTIFICATIONS bit   Default = 1
 VENDORID nvarchar(50)   Default = ''

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 EVENTID uniqueidentifier   EVENT.ID FK to EVENT
 TITLECODEID uniqueidentifier TITLECODE.LOCALID FK to TITLECODE
 SUFFIXCODEID uniqueidentifier SUFFIXCODE.LOCALID FK to SUFFIXCODE
 MARITALSTATUSCODEID uniqueidentifier MARITALSTATUSCODE.LOCALID FK to MARITALSTATUSCODE
 ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 STATEID uniqueidentifier STATE.LOCALID FK to STATE
 DONOTMAILREASONCODEID uniqueidentifier DONOTMAILREASONCODE.ID FK to DONOTMAILREASONCODE
 PHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID FK to PHONETYPECODE
 COMPANY_ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 COMPANY_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 COMPANY_STATEID uniqueidentifier STATE.LOCALID FK to STATE
 COMPANY_DONOTMAILREASONCODEID uniqueidentifier DONOTMAILREASONCODE.ID FK to DONOTMAILREASONCODE
 COMPANY_PHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID FK to PHONETYPECODE
 SPONSORSHIPTYPEID uniqueidentifier EVENTSPONSORSHIPTYPE.ID FK to EVENTSPONSORSHIPTYPE
 BILLING_ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 BILLING_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 BILLING_STATEID uniqueidentifier STATE.LOCALID FK to STATE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ORIGINALCLIENTUSERID int ClientUsers.ID FK to CLIENTUSERS
 ORIGINALCONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 PHONEID uniqueidentifier PHONE.LOCALID FK to PHONE
 ADDRESSID uniqueidentifier ADDRESS.LOCALID FK to ADDRESS
 EMAILADDRESSID uniqueidentifier EMAILADDRESS.ID FK to EMAILADDRESS
 ORGANIZATIONCONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 CREDITCARDID uniqueidentifier CREDITCARD.ID Stores the credit card details.

Index Name Field(s) Unique Primary Clustered
 IX_BATCHEVENTSPONSORSHIP_ADDRESSID ADDRESSID      
 IX_BATCHEVENTSPONSORSHIP_BATCHID BATCHID      
 IX_BATCHEVENTSPONSORSHIP_DATEADDED DATEADDED    
 IX_BATCHEVENTSPONSORSHIP_DATECHANGED DATECHANGED      
 IX_BATCHEVENTSPONSORSHIP_ORGANIZATIONCONSTITUENTID ORGANIZATIONCONSTITUENTID      
 IX_BATCHEVENTSPONSORSHIP_ORIGINALCONSTITUENTID ORIGINALCONSTITUENTID      
 PK_BATCHEVENTSPONSORSHIP ID  

Trigger Name Description
 TR_BATCHEVENTSPONSORSHIP_AUDIT_UPDATE
 TR_BATCHEVENTSPONSORSHIP_AUDIT_DELETE

Referenced by Field
 BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGES BATCHEVENTSPONSORSHIPID
 BATCHEVENTSPONSORSHIPBATCHUSERMESSAGE ID
 BATCHEVENTSPONSORSHIPENEWSLETTER BATCHEVENTSPONSORSHIPID

Entity-Relationship diagram of this table (ADDRESS-STATE)
Entity-Relationship diagram of this table (SUFFIXCODE-TITLECODE)