DONATIONBATCH
Stores donation batch information
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
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) |
yes |
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 |
yes |
|
|
| CHECKDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| BANKACCOUNTTYPECODE |
tinyint |
|
Default = 0 |
0=Checking Account, 1=Saving Account |
| BANKACCOUNTTYPE |
nvarchar(16) (Computed) |
yes |
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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
| RECIPIENTROLE |
nvarchar(50) |
|
Default = '' |
|
| RECIPIENTGROUPID |
uniqueidentifier |
yes |
|
|
| RECIPIENTREGISTRANTID |
uniqueidentifier |
yes |
|
|
| 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 = '' |
The authorization code for a credit card payment, if applicable. |
| TRANSACTIONID |
uniqueidentifier |
yes |
|
The BBPS transaction ID for a card not present transaction. |
| REJECTIONMESSAGE |
nvarchar(250) |
|
Default = '' |
The reason the credit card couldn't be authorized. |
| SENDNOTIFICATIONS |
bit |
|
Default = 1 |
|
| VENDORID |
nvarchar(50) |
|
Default = '' |
|
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_DONATIONBATCH_ADDRESSID |
ADDRESSID |
|
|
|
| IX_DONATIONBATCH_BATCHID |
BATCHID |
|
|
|
| IX_DONATIONBATCH_DATEADDED |
DATEADDED |
|
|
yes |
| IX_DONATIONBATCH_DATECHANGED |
DATECHANGED |
|
|
|
| IX_DONATIONBATCH_ORGANIZATIONCONSTITUENTID |
ORGANIZATIONCONSTITUENTID |
|
|
|
| IX_DONATIONBATCH_ORIGINALCONSTITUENTID |
ORIGINALCONSTITUENTID |
|
|
|
| PK_DONATIONBATCH |
ID |
yes |
yes |
|
Triggers
Referenced by