| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 FIRSTNAME |
nvarchar(100) | Default = '' | ||
| LASTNAME |
nvarchar(200) | Default = '' | ||
| ADDRESS |
nvarchar(300) | Default = '' | ||
| ADDRESSTYPE |
nvarchar(200) | Default = '' | ||
| CITY |
nvarchar(100) | Default = '' | ||
| STATE |
nvarchar(10) | Default = '' | ||
| ZIP |
nvarchar(25) | Default = '' | ||
| COUNTRY |
nvarchar(200) | Default = '' | ||
| EMAIL |
UDT_EMAILADDRESS | Default = '' | ||
| PHONENUMBER |
nvarchar(200) | Default = '' | ||
| PHONETYPE |
nvarchar(200) | Default = '' | ||
| TITLE |
nvarchar(200) | Default = '' | ||
| SUFFIX |
nvarchar(200) | Default = '' | ||
| AMOUNT |
money | Default = 0 | ||
| ISANONYMOUSGIFT |
bit | Default = 0 | ||
| DONOTCALL |
bit | Default = 0 | ||
| DONOTMAIL |
bit | Default = 0 | ||
| DONOTEMAIL |
bit | Default = 0 | ||
| CREDITCARDTYPE |
nvarchar(200) | Default = '' | ||
| CHECKNUMBER |
nvarchar(40) | Default = '' | ||
| RECEIPTNUMBER |
int | Default = 0 | ||
| CHECKDATE |
datetime |  |
||
| GIFTDATE |
datetime | |
||
| INBOUNDCHANNEL |
nvarchar(200) | Default = '' | ||
| SOLICITATIONCHANNNEL |
nvarchar(200) | Default = '' | ||
| ISONLINEGIFT |
bit | Default = 1 | ||
| TRANSACTIONTYPE |
nvarchar(50) | Default = '' | ||
| PAYMENTMETHOD |
nvarchar(30) | Default = '' | ||
| POSTSTATUS |
nvarchar(25) | Default = '' | ||
| TRIBUTEE |
nvarchar(310) | Default = '' | ||
| TRIBUTEMESSAGE |
nvarchar(510) | Default = '' | ||
| MATCHINGGIFTCLAIMED |
money | Default = 0 | ||
| MATCHINGGIFTPAID |
money | Default = 0 | ||
| MATCHINGGIFTORGANIZATION |
nvarchar(310) | Default = '' | ||
| RECOGNITION |
nvarchar(310) | Default = '' | ||
| ISPREVIOUSDONOR |
bit | Default = 0 | ||
| REGISTRANTROLE |
nvarchar(50) | Default = '' | ||
| GROUPNAME |
nvarchar(200) | Default = '' | ||
| GROUPTYPE |
nvarchar(300) | Default = '' | ||
| COMPANYNAME |
nvarchar(310) | Default = '' | ||
| COMPANYADDRESS |
nvarchar(300) | Default = '' | ||
| COMPANYADDRESSTYPE |
nvarchar(200) | Default = '' | ||
| COMPANYCITY |
nvarchar(100) | Default = '' | ||
| COMPANYSTATE |
nvarchar(10) | Default = '' | ||
| COMPANYZIP |
nvarchar(25) | Default = '' | ||
| COMPANYPHONE |
nvarchar(200) | Default = '' | ||
| COMPANYEMAIL |
UDT_EMAILADDRESS | Default = '' | ||
| COMPANYWEBADDRESS |
UDT_WEBADDRESS | Default = '' | ||
| ISCOMPANYDONATION |
bit | Default = 0 | ||
| REVENUEDATECHANGED |
datetime | |
||
| REVENUECHANGEDBY |
nvarchar(260) | Default = '' | ||
| DATEADDED |
datetime | Default = getdate() | ||
| DATECHANGED |
datetime | Default = getdate() | ||
| TS |
timestamp | |||
 TSLONG |
bigint (Computed) | |
CONVERT(bigint, TS) | |
| DONORLOOKUPID |
nvarchar(200) | Default = '' | ||
| REVENUELOOKUPID |
nvarchar(200) | Default = '' | ||
| BATCHNUMBER |
int | Default = 0 | ||
| TRIBUTETYPE |
nvarchar(200) | Default = '' |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 REVENUEID |
uniqueidentifier | FINANCIALTRANSACTION.ID | ||
| CONSTITUENTID |
uniqueidentifier | CONSTITUENT.LOCALID | ||
| EVENTID |
uniqueidentifier | EVENT.ID | ||
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | ||
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | ||
| RECOGNITIONID |
uniqueidentifier | |
CONSTITUENT.LOCALID |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_FAFDONATION_DATEADDED |
DATEADDED | |
||
 IX_FAFDONATION_DATECHANGED |
DATECHANGED | |||
| IX_FAFDONATION_REVENUEID_EVENTID_CONSTITUENTID_RECOGNITIONID |
REVENUEID, EVENTID, CONSTITUENTID, RECOGNITIONID | |||
| PK_FAFDONATION |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_FAFDONATION_AUDIT_UPDATE |
|
| TR_FAFDONATION_AUDIT_DELETE |