| AMENDMENTTYPECODE |
tinyint |
|
Default = 0 |
|
| AMENDMENTTYPE |
nvarchar(27) (Computed) |
yes |
CASE [AMENDMENTTYPECODE] WHEN 0 THEN N'Added' WHEN 1 THEN N'Status changed' WHEN 2 THEN N'Edited' WHEN 3 THEN N'Payment information changed' WHEN 4 THEN N'Constituent changed' END |
|
| DATE |
date |
|
|
|
| STATUSCODE |
tinyint |
|
Default = 99 |
|
| PREVIOUSSTATUSCODE |
tinyint |
|
Default = 99 |
|
| TRANSACTIONAMOUNT |
money |
|
Default = 0 |
|
| PREVIOUSTRANSACTIONAMOUNT |
money |
|
Default = 0 |
|
| TRANSACTIONAMOUNTCHANGE |
money (Computed) |
yes |
case when TRANSACTIONAMOUNT > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then TRANSACTIONAMOUNT-PREVIOUSTRANSACTIONAMOUNT end |
|
| BASEAMOUNT |
money |
|
Default = 0 |
|
| PREVIOUSBASEAMOUNT |
money |
|
Default = 0 |
|
| BASEAMOUNTCHANGE |
money (Computed) |
yes |
case when BASEAMOUNT > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then BASEAMOUNT-PREVIOUSBASEAMOUNT end |
|
| ORGANIZATIONAMOUNT |
money |
|
Default = 0 |
|
| PREVIOUSORGANIZATIONAMOUNT |
money |
|
Default = 0 |
|
| ORGANIZATIONAMOUNTCHANGE |
money (Computed) |
yes |
case when ORGANIZATIONAMOUNT > 0 and FREQUENCYCODE = PREVIOUSFREQUENCYCODE then ORGANIZATIONAMOUNT-PREVIOUSORGANIZATIONAMOUNT end |
|
| FREQUENCYCODE |
tinyint |
|
Default = 99 |
|
| PREVIOUSFREQUENCYCODE |
tinyint |
|
Default = 99 |
|
| DESIGNATIONS |
xml |
yes |
|
|
| SOURCECODE |
nvarchar(50) |
|
Default = '' |
|
| FINDERNUMBER |
bigint |
|
Default = ((0)) |
|
| PAYMENTMETHODCODE |
tinyint |
|
Default = 99 |
|
| PREVIOUSPAYMENTMETHODCODE |
tinyint |
|
Default = 99 |
|
| CREDITCARDPARTIALNUMBER |
nvarchar(4) |
|
Default = '' |
|
| PREVIOUSCREDITCARDPARTIALNUMBER |
nvarchar(4) |
|
Default = '' |
|
| EXPIRESON |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| PREVIOUSEXPIRESON |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| REFERENCEDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| PREVIOUSREFERENCEDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| REFERENCENUMBER |
nvarchar(20) |
|
Default = '' |
|
| PREVIOUSREFERENCENUMBER |
nvarchar(20) |
|
Default = '' |
|
| DATEADDED |
datetime |
|
Default = getdate() |
|
| DATECHANGED |
datetime |
|
Default = getdate() |
|
| TS |
timestamp |
|
|
|
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
|
| PREVIOUSNEXTTRANSACTIONDATE |
date |
yes |
|
|
| NEXTTRANSACTIONDATE |
date |
yes |
|
|
| STATUS |
nvarchar(14) (Computed) |
yes |
CASE [STATUSCODE] WHEN 0 THEN N'Active' WHEN 1 THEN N'Held' WHEN 2 THEN N'Terminated' WHEN 3 THEN N'Canceled' WHEN 5 THEN N'Lapsed' WHEN 99 THEN N'Not applicable' END |
|
| PREVIOUSSTATUS |
nvarchar(14) (Computed) |
yes |
CASE [PREVIOUSSTATUSCODE] WHEN 0 THEN N'Active' WHEN 1 THEN N'Held' WHEN 2 THEN N'Terminated' WHEN 3 THEN N'Canceled' WHEN 5 THEN N'Lapsed' WHEN 99 THEN N'Not applicable' END |
|
| STATUSCHANGETYPECODE |
tinyint |
|
Default = 99 |
|
| CARDHOLDERNAME |
nvarchar(255) |
|
Default = '' |
|
| PREVIOUSCARDHOLDERNAME |
nvarchar(255) |
|
Default = '' |
|
| STATUSCHANGETYPE |
nvarchar(32) (Computed) |
yes |
CASE [STATUSCHANGETYPECODE] WHEN 0 THEN N'Manual' WHEN 1 THEN N'Payment applied' WHEN 2 THEN N'Payment deleted or decreased' WHEN 3 THEN N'Write-off added' WHEN 4 THEN N'Write-off deleted or decreased' WHEN 5 THEN N'Skip undone' WHEN 6 THEN N'Changed by Status Update Process' WHEN 7 THEN N'No remaining balance' WHEN 8 THEN N'Schedule changed' WHEN 9 THEN N'Sponsorship canceled' WHEN 10 THEN N'Sponsorship expired' WHEN 11 THEN N'Sponsorship reactivated' WHEN 12 THEN N'Sponsorship reassigned' WHEN 13 THEN N'Sponsorship terminated' WHEN 14 THEN N'Membership canceled' WHEN 99 THEN N'Not applicable' END |
|
| DDISOURCEDATE |
date |
yes |
|
|
| PREVIOUSDDISOURCEDATE |
date |
yes |
|
|
| SENDPMINSTRUCTION |
bit |
|
Default = 0 |
|
| PREVIOUSSENDPMINSTRUCTION |
bit |
|
Default = 0 |
|
| PMINSTRUCTIONTOSENDCODE |
tinyint |
|
Default = 0 |
|
| PMINSTRUCTIONTOSEND |
nvarchar(6) (Computed) |
yes |
CASE [PMINSTRUCTIONTOSENDCODE] WHEN 0 THEN N'' WHEN 1 THEN N'New' WHEN 2 THEN N'Cancel' WHEN 3 THEN N'Set-up' END |
|
| PREVIOUSPMINSTRUCTIONTOSENDCODE |
tinyint |
|
Default = 0 |
|
| PREVIOUSPMINSTRUCTIONTOSEND |
nvarchar(6) (Computed) |
yes |
CASE [PREVIOUSPMINSTRUCTIONTOSENDCODE] WHEN 0 THEN N'' WHEN 1 THEN N'New' WHEN 2 THEN N'Cancel' WHEN 3 THEN N'Set-up' END |
|
| PMINSTRUCTIONDATE_NEW |
date |
yes |
|
|
| PREVIOUSPMINSTRUCTIONDATE_NEW |
date |
yes |
|
|
| PMINSTRUCTIONDATE_CANCEL |
date |
yes |
|
|
| PREVIOUSPMINSTRUCTIONDATE_CANCEL |
date |
yes |
|
|
| PMINSTRUCTIONDATE_SETUP |
date |
yes |
|
|
| PREVIOUSPMINSTRUCTIONDATE_SETUP |
date |
yes |
|
|
| PMADVANCENOTICESENTDATE |
date |
yes |
|
|
| PREVIOUSPMADVANCENOTICESENTDATE |
date |
yes |
|
|
| STANDINGORDERSETUP |
bit |
|
Default = 0 |
|
| PREVIOUSSTANDINGORDERSETUP |
bit |
|
Default = 0 |
|
| STANDINGORDERSETUPDATE |
datetime |
yes |
|
|
| PREVIOUSSTANDINGORDERSETUPDATE |
datetime |
yes |
|
|
| USESYSTEMGENERATEDREFERENCENUMBER |
bit |
|
Default = 0 |
|
| PREVIOUSUSESYSTEMGENERATEDREFERENCENUMBER |
bit |
|
Default = 0 |
|
| FREQUENCY |
nvarchar(14) (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' WHEN 10 THEN N'Every 4 weeks' WHEN 99 THEN N'Not applicable' END |
|
| PREVIOUSFREQUENCY |
nvarchar(14) (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' WHEN 10 THEN N'Every 4 weeks' WHEN 99 THEN N'Not applicable' END |
|
| PAYMENTMETHOD |
nvarchar(27) (Computed) |
yes |
CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit card - automatic' WHEN 3 THEN N'Direct debit - automatic' WHEN 9 THEN N'None' WHEN 10 THEN N'Other' WHEN 11 THEN N'Standing order' WHEN 98 THEN N'Credit card - last 4 digits' WHEN 99 THEN N'Not applicable' WHEN 101 THEN N'PayPal' WHEN 102 THEN N'Venmo' END |
|
| PREVIOUSPAYMENTMETHOD |
nvarchar(27) (Computed) |
yes |
CASE [PREVIOUSPAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Check' WHEN 2 THEN N'Credit card - automatic' WHEN 3 THEN N'Direct debit - automatic' WHEN 9 THEN N'None' WHEN 10 THEN N'Other' WHEN 11 THEN N'Standing order' WHEN 98 THEN N'Credit card - last 4 digits' WHEN 99 THEN N'Not applicable' WHEN 101 THEN N'PayPal' WHEN 102 THEN N'Venmo' END |
|