| SEQUENCE |
int |
|
Default = 0 |
|
| TRANSACTIONDATE |
date |
|
|
|
| AMOUNT |
money |
|
Default = 0 |
The recurring gift amount. |
| FREQUENCYCODE |
tinyint |
|
Default = 0 |
The recurring gift installment frequency. |
| FREQUENCY |
nvarchar(13) (Computed) |
yes |
CASE [FREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' END |
Provides a translation for the 'FREQUENCYCODE' field. |
| PREVIOUSAMOUNT |
money |
|
Default = 0 |
The previous recurring gift amount. |
| PREVIOUSFREQUENCYCODE |
tinyint |
|
Default = 0 |
The previous recurring gift installment frequency. |
| PREVIOUSFREQUENCY |
nvarchar(13) (Computed) |
yes |
CASE [PREVIOUSFREQUENCYCODE] WHEN 0 THEN N'Annually' WHEN 1 THEN N'Semi-annually' WHEN 2 THEN N'Quarterly' WHEN 3 THEN N'Monthly' WHEN 6 THEN N'Bimonthly' WHEN 7 THEN N'Semi-Monthly' WHEN 8 THEN N'Biweekly' WHEN 9 THEN N'Weekly' END |
Provides a translation for the 'PREVIOUSFREQUENCYCODE' field. |
| AMOUNTCHANGE |
money (Computed) |
yes |
case when SEQUENCE > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then AMOUNT-PREVIOUSAMOUNT end |
The change in recurring gift amount, if the frequency is unchanged. |
| SOURCECODE |
nvarchar(50) |
|
Default = '' |
The direct marketing source code on the recurring gift. |
| FINDERNUMBER |
bigint |
|
Default = ((0)) |
The direct marketing finder number on the recurring gift. |
| 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. |
| ORGANIZATIONAMOUNT |
money |
|
Default = 0 |
The amount of the recurring gift in organization currency. |
| PREVIOUSORGANIZATIONAMOUNT |
money |
|
Default = 0 |
The previous amount of the recurring gift in organization currency. |
| TRANSACTIONAMOUNT |
money |
|
Default = 0 |
The amount of the recurring gift in transaction currency. |
| PREVIOUSTRANSACTIONAMOUNT |
money |
|
Default = 0 |
The previous amount of the recurring gift in transaction currency. |
| ORGANIZATIONAMOUNTCHANGE |
money (Computed) |
yes |
case when SEQUENCE > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then ORGANIZATIONAMOUNT-PREVIOUSORGANIZATIONAMOUNT end |
The change in recurring gift organization amount, if the frequency is unchanged. |
| TRANSACTIONAMOUNTCHANGE |
money (Computed) |
yes |
case when SEQUENCE > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then TRANSACTIONAMOUNT-PREVIOUSTRANSACTIONAMOUNT end |
The change in recurring gift transaction amount, if the frequency is unchanged. |