| ISPAYMENTCOUNTED |
bit |
|
Default = 0 |
|
| ISPLEDGECOUNTED |
bit |
|
Default = 0 |
|
| ISRECURRINGGIFTCOUNTED |
bit |
|
Default = 0 |
|
| INCLUDEPAYMENTACTIVITYTYPECODE |
tinyint |
|
Default = 0 |
|
| INCLUDEPAYMENTACTIVITYTYPE |
nvarchar(25) (Computed) |
yes |
CASE [INCLUDEPAYMENTACTIVITYTYPECODE] WHEN 0 THEN N'any designation' WHEN 1 THEN N'specific designations' WHEN 2 THEN N'the following designation' END |
|
| ISEVENTREGISTRATIONCOUNTED |
bit |
|
Default = 0 |
|
| INCLUDEEVENTTYPECODE |
tinyint |
|
Default = 0 |
|
| INCLUDEEVENTTYPE |
nvarchar(29) (Computed) |
yes |
CASE [INCLUDEEVENTTYPECODE] WHEN 0 THEN N'any event' WHEN 1 THEN N'events in a specific category' END |
|
| ISMEMBERSHIPDUECOUNTED |
bit |
|
Default = 0 |
|
| INCLUDEMEMBERSHIPTYPECODE |
tinyint |
|
Default = 0 |
|
| INCLUDEMEMBERSHIPTYPE |
nvarchar(32) (Computed) |
yes |
CASE [INCLUDEMEMBERSHIPTYPECODE] WHEN 0 THEN N'membership in any program' WHEN 1 THEN N'membership in a specific program' END |
|
| ISMULTIPLEREVENUETRANSACTIONSCOUNTED |
bit |
|
Default = 0 |
|
| WHATHAPPENSIFTHEYGIVEMORECODE |
tinyint |
|
Default = 0 |
|
| WHATDATETOCALCULATEEXPIRATIONDATECODE |
tinyint |
|
Default = 0 |
|
| WHATDATETOCALCULATEEXPIRATIONDATE |
nvarchar(48) (Computed) |
yes |
CASE [WHATDATETOCALCULATEEXPIRATIONDATECODE] WHEN 0 THEN N'the transaction date of the gift' WHEN 1 THEN N'the last day of the month the gift was received' WHEN 2 THEN N'specific dates' END |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|
| WHATHAPPENSIFTHEYGIVEMORE |
nvarchar(21) (Computed) |
yes |
CASE [WHATHAPPENSIFTHEYGIVEMORECODE] WHEN 0 THEN N'as additional revenue' WHEN 1 THEN N'toward an upgrade' WHEN 2 THEN N'toward a renewal' END |
|
| CRITERIADEFINITIONTYPECODE |
tinyint |
|
Default = 0 |
|
| CRITERIADEFINITIONTYPE |
nvarchar(49) (Computed) |
yes |
CASE [CRITERIADEFINITIONTYPECODE] WHEN 0 THEN N'System-defined revenue application filter options' WHEN 1 THEN N'User-created revenue application Query selection' END |
|