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 = ''
 ISCOMPANYGIFT bit   Default = 0
 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 = ''
 GIFTTYPE nvarchar(50)   Default = ''
 GIFTAMOUNT money   Default = 0
 NUMPAYMENTS int   Default = 0
 FREQUENCY nvarchar(100)   Default = ''
 AUTOINSTALLMENTS bit   Default = 0
 ANONYMOUS bit   Default = 0
 STARTDATE UDT_FUZZYDATE   Default = '00000000'
 INFINITEGIFT bit   Default = 1
 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 = ''
 TRIBUTETEXT nvarchar(255)   Default = ''
 TRIBUTEANONYMOUS bit   Default = 0
 RECOGNITIONCREDIT nvarchar(50)   Default = ''
 MATCHINGAMOUNT money   Default = 0
 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.
 RECIPIENTROLE nvarchar(50)   Default = ''
 RECIPIENTGROUPID uniqueidentifier
 RECIPIENTREGISTRANTID uniqueidentifier
 SHOWTRIBUTE bit   Default = 0
 TRIBUTEFIRSTNAME nvarchar(200)   Default = ''
 TRIBUTELASTNAME nvarchar(200)   Default = ''
 TRIBUTEEMAIL UDT_EMAILADDRESS   Default = ''
 TRIBUTEADDRESS nvarchar(300)   Default = ''
 TRIBUTECITY nvarchar(100)   Default = ''
 TRIBUTEPOSTCODE nvarchar(24)   Default = ''
 SENDTOACKNOWLEDGE bit   Default = 0
 ACKNOWLEDGEFIRSTNAME nvarchar(200)   Default = ''
 ACKNOWLEDGELASTNAME nvarchar(200)   Default = ''
 ACKNOWLEDGEEMAIL UDT_EMAILADDRESS   Default = ''
 MESSAGETOACKNOWLEDGE nvarchar(1000)   Default = ''
 MATCHINGCOMPANYNAME nvarchar(200)   Default = ''
 SAVETRIBUTEEASCONSTITUENT bit   Default = 0
 CHECKNUMBER nvarchar(20)   Default = ''
 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
 BILLING_ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 BILLING_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 BILLING_STATEID uniqueidentifier STATE.LOCALID FK to STATE
 TRIBUTETYPECODEID uniqueidentifier TRIBUTETYPECODE.LOCALID FK to TRIBUTETYPECODE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 TRIBUTESTATEID uniqueidentifier STATE.LOCALID FK to STATE
 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_DONATIONBATCH_ADDRESSID ADDRESSID      
 IX_DONATIONBATCH_BATCHID BATCHID      
 IX_DONATIONBATCH_DATEADDED DATEADDED    
 IX_DONATIONBATCH_DATECHANGED DATECHANGED      
 IX_DONATIONBATCH_ORGANIZATIONCONSTITUENTID ORGANIZATIONCONSTITUENTID      
 IX_DONATIONBATCH_ORIGINALCONSTITUENTID ORIGINALCONSTITUENTID      
 PK_DONATIONBATCH ID  

Trigger Name Description
 TR_DONATIONBATCH_AUDIT_UPDATE
 TR_DONATIONBATCH_AUDIT_DELETE

Referenced by Field
 DONATIONBATCHBATCHSYSTEMMESSAGES DONATIONBATCHID
 DONATIONBATCHBATCHUSERMESSAGE ID
 DONATIONBATCHENEWSLETTER DONATIONBATCHID

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