| DONORPERIOD |
int |
|
Default = 3 |
The number of years in which a constituent must have given revenue in order to be considered a donor. |
| MIDLEVELDONORGIFTAMOUNT |
money |
|
Default = 250 |
The minimum largest gift amount which a constituent must have given to have the Major donor constituency. |
| CONSIDERRECOGNITION |
bit |
|
Default = 0 |
Consider recognition credits when evaluating the Major donor constituency. |
| 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. |
| DONORASOFDATE |
date |
yes |
|
Specifies the as of date used when evaluating whether or not a constituent will be considered a donor. |
| USECONSECUTIVELOYALYEARS |
bit |
|
Default = 1 |
Determines whether or not to consider consecutive years when evaluating whether or not a constituent will be considered a loyal donor. |
| CONSECUTIVELOYALYEARS |
int |
|
Default = 3 |
Number of consecutive years a constituent needs to give in order to be considered a loyal donor. |
| NOAFFINITYPERIOD |
int |
|
Default = 10 |
Number of years to consider when evaluating whether or not a constituent has shown any affinity towards the organization. |
| DONORFILTERTYPECODE |
tinyint |
|
Default = 0 |
0=NODATERANGE, 1=USEYEARRANGE, 2=USEASOFDATE |
| DONORFILTERTYPE |
nvarchar(12) (Computed) |
yes |
CASE [DONORFILTERTYPECODE] WHEN 0 THEN N'NODATERANGE' WHEN 1 THEN N'USEYEARRANGE' WHEN 2 THEN N'USEASOFDATE' END |
Provides a translation for the 'DONORFILTERTYPECODE' field. |
| USEMULTIPLELOYALYEARS |
bit |
|
Default = 1 |
Determines whether or not to consider multiple years when evaluating whether or not a constituent will be considered a loyal donor. |
| LOYALDONORMULTIYEARVALUE |
int |
|
Default = 3 |
The minimum number of years a constituent has to have given in order to be considered a loyal donor. |
| LOYALDONORMULTIYEARRANGE |
int |
|
Default = 6 |
The number of years to look at evaluating whether or not a constituent will be considered a loyal donor. |
| USEMAJORDONORSINGLEGIFT |
bit |
|
Default = 1 |
Determines whether or not a single large gift can qualify a constituent as a major donor. |
| MAJORDONORSINGLEGIFTAMOUNT |
money |
|
Default = 1000 |
Minimum amount required on a single gift to qualify a constituent as a major donor. |
| USEMAJORDONORLIFETIMEGIVING |
bit |
|
Default = 1 |
Determines whether or not a constituent's lifetime giving can qualify them as a major donor. |
| MAJORDONORLIFETIMEGIVINGAMOUNT |
money |
|
Default = 2000 |
Minimum lifetime giving amount required to qualify a constituent as a major donor. |
| INCLUDEMAJORDONORPROSPECTS |
bit |
|
Default = 0 |
Determines whether or not to consider constituents with the 'Major Donor Prospect' constituency as major donors. |
| PLANNEDGIFTMUSTHAVEPAYMENTS |
bit |
|
Default = 0 |
Determines whether or not a planned gift must have at least one payment before a constituent can be considered a planned giver. |