FAFDONATION
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| 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 = '' | ||
| 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 | yes | ||
| GIFTDATE | datetime | yes | ||
| 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 | yes | ||
| REVENUECHANGEDBY | nvarchar(260) | Default = '' | ||
| DATEADDED | datetime | Default = getdate() | ||
| DATECHANGED | datetime | Default = getdate() | ||
| TS | timestamp | |||
| TSLONG | bigint (Computed) | yes | CONVERT(bigint, TS) | |
| DONORLOOKUPID | nvarchar(200) | Default = '' | ||
| REVENUELOOKUPID | nvarchar(200) | Default = '' | ||
| BATCHNUMBER | int | Default = 0 | ||
| TRIBUTETYPE | nvarchar(200) | Default = '' |
Foreign Keys
| 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 | yes | CONSTITUENT.LOCALID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_FAFDONATION_DATEADDED | DATEADDED | yes | ||
| IX_FAFDONATION_DATECHANGED | DATECHANGED | |||
| IX_FAFDONATION_REVENUEID_EVENTID_CONSTITUENTID_RECOGNITIONID | REVENUEID, EVENTID, CONSTITUENTID, RECOGNITIONID | |||
| PK_FAFDONATION | ID | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_FAFDONATION_AUDIT_UPDATE | |
| TR_FAFDONATION_AUDIT_DELETE |