| NAME |
nvarchar(100) |
|
Default = '' |
|
| DESCRIPTION |
nvarchar(255) |
|
Default = '' |
|
| PAYMENTMETHODVALUE |
xml |
yes |
|
|
| FREQUENCYVALUE |
xml |
yes |
|
|
| PASTDUECODE |
tinyint |
|
Default = 0 |
|
| PASTDUE |
nvarchar(106) (Computed) |
yes |
CASE [PASTDUECODE] WHEN 0 THEN N'Do not make installments past due' WHEN 1 THEN N'Installments are past due when they have an unpaid balance x days past the installment date' WHEN 2 THEN N'Installments are past due when the date of the next installment is on or before the date this process runs' END |
|
| DAYSPASTDUE |
smallint |
|
Default = ((0)) |
|
| LAPSEDCODE |
tinyint |
|
Default = 0 |
|
| LAPSED |
nvarchar(101) (Computed) |
yes |
CASE [LAPSEDCODE] WHEN 0 THEN N'Do not make recurring gifts lapsed' WHEN 1 THEN N'Recurring gifts are lapsed when they have x past due installment(s)' WHEN 2 THEN N'Recurring gifts are lapsed when an installment has an unpaid balance x days past the installment date' END |
|
| LAPSEDINSTALLMENTSPASTDUE |
smallint |
|
Default = ((0)) |
|
| LAPSEDINSTALLMENTSDAYSPAST |
smallint |
|
Default = ((0)) |
|
| TERMINATEDCODE |
tinyint |
|
Default = 0 |
|
| TERMINATED |
nvarchar(105) (Computed) |
yes |
CASE [TERMINATEDCODE] WHEN 0 THEN N'Do not make recurring gifts terminated' WHEN 1 THEN N'Recurring gifts are terminated when they have x past due installment(s)' WHEN 2 THEN N'Recurring gifts are terminated when an installment has an unpaid balance x days past the installment date' END |
|
| TERMINATEDINSTALLMENTSPASTDUE |
smallint |
|
Default = ((0)) |
|
| TERMINATEDINSTALLMENTSDAYSPAST |
smallint |
|
Default = ((0)) |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|
| OTHERPAYMENTMETHODS |
xml |
yes |
|
|
| CHECKLEGACYHELD |
bit |
|
Default = 1 |
|