| SEQUENCE |
int |
|
Default = 0 |
|
| 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. |
| REGISTRANTROLECODE |
tinyint |
|
Default = 0 |
0=Start a company, 1=Start a team under a company, 2=Start an independent team, 3=Join a team, 4=Start a household under a company, 5=Start a household under a team, 6=Start an independent household, 7=Join as an individual under a company, 8=Join as individual participant, 9=Join a household |
| USERID |
nvarchar(50) |
|
Default = '' |
|
| PASSWORD |
nvarchar(255) |
|
Default = '' |
|
| FIRSTNAME |
nvarchar(50) |
|
Default = '' |
|
| LASTNAME |
nvarchar(50) |
|
Default = '' |
|
| EMAILADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
|
| ADDRESS |
nvarchar(150) |
|
Default = '' |
|
| CITY |
nvarchar(50) |
|
Default = '' |
|
| POSTCODE |
nvarchar(12) |
|
Default = '' |
|
| MIDDLENAME |
nvarchar(50) |
|
Default = '' |
|
| NICKNAME |
nvarchar(50) |
|
Default = '' |
|
| MAIDENNAME |
nvarchar(100) |
|
Default = '' |
|
| BIRTHDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| GENDERCODE |
tinyint |
|
Default = 0 |
0=Unknown, 1=Male, 2=Female |
| GENDER |
nvarchar(7) (Computed) |
yes |
CASE [GENDERCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Male' WHEN 2 THEN N'Female' END |
Provides a translation for the 'GENDERCODE' field. |
| PHONENUMBER |
nvarchar(100) |
|
Default = '' |
|
| DONOTMAIL |
bit |
|
Default = 0 |
|
| FUNDRAISINGGROUPNAME |
nvarchar(100) |
|
Default = '' |
|
| SAVETRIBUTEEASCONSTITUENT |
bit |
|
Default = 0 |
|
| TRIBUTEEFIRSTNAME |
nvarchar(200) |
|
Default = '' |
|
| TRIBUTEELASTNAME |
nvarchar(200) |
|
Default = '' |
|
| TRIBUTEEEMAIL |
UDT_EMAILADDRESS |
|
Default = '' |
|
| TRIBUTEEADDRESS |
nvarchar(300) |
|
Default = '' |
|
| TRIBUTEECITY |
nvarchar(100) |
|
Default = '' |
|
| TRIBUTEEPOSTCODE |
nvarchar(24) |
|
Default = '' |
|
| TRIBUTETEXT |
nvarchar(255) |
|
Default = '' |
|
| TRIBUTEANONYMOUS |
bit |
|
Default = 0 |
|
| SAVEASDEFAULTTRIBUTEE |
bit |
|
Default = 0 |
|
| SENDTOACKNOWLEDGEE |
bit |
|
Default = 0 |
|
| ACKNOWLEDGEEFIRSTNAME |
nvarchar(200) |
|
Default = '' |
|
| ACKNOWLEDGEELASTNAME |
nvarchar(200) |
|
Default = '' |
|
| ACKNOWLEDGEEEMAIL |
UDT_EMAILADDRESS |
|
Default = '' |
|
| MESSAGETOACKNOWLEDGEE |
nvarchar(1000) |
|
Default = '' |
|
| PARTICIPANTPAGEURL |
nvarchar(200) |
|
Default = '' |
|
| WAIVERACCEPTED |
bit |
|
Default = 1 |
|
| FUNDRAISINGGOAL |
money |
|
Default = 0 |
|
| TARGETFUNDRAISINGGOAL |
money |
|
Default = 0 |
|
| ADDITIONALDONATIONAMOUNT |
money |
|
Default = 0 |
|
| PAYMENTMETHODCODE |
tinyint |
|
Default = 0 |
0=Cash, 1=Offline Check, 2=Credit/Debit Cards, 3=Online Check (ACH) |
| CREDITCARDTYPE |
uniqueidentifier |
yes |
|
|
| BANKACCOUNTTYPECODE |
tinyint |
|
Default = 0 |
0=Checking Account, 1=Saving Account |
| BANKACCOUNTTYPE |
nvarchar(16) (Computed) |
yes |
CASE [BANKACCOUNTTYPECODE] WHEN 0 THEN N'Checking Account' WHEN 1 THEN N'Saving Account' END |
Provides a translation for the 'BANKACCOUNTTYPECODE' field. |
| BANKACCOUNTHOLDER |
nvarchar(100) |
|
Default = '' |
|
| BANKACCOUNTNUMBER |
nvarchar(100) |
|
Default = '' |
|
| BANKACCOUNTROUTINGCODE |
nvarchar(100) |
|
Default = '' |
|
| SAMEASPRIMARYADDRESS |
bit |
|
Default = 1 |
|
| BILLING_ADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
|
| BILLING_CITY |
nvarchar(50) |
|
Default = '' |
|
| BILLING_POSTCODE |
nvarchar(12) |
|
Default = '' |
|
| CHECKDATE |
UDT_FUZZYDATE |
|
Default = '00000000' |
|
| PAYMENTMETHOD |
nvarchar(18) (Computed) |
yes |
CASE [PAYMENTMETHODCODE] WHEN 0 THEN N'Cash' WHEN 1 THEN N'Offline Check' WHEN 2 THEN N'Credit/Debit Cards' WHEN 3 THEN N'Online Check (ACH)' END |
Provides a translation for the 'PAYMENTMETHODCODE' field. |
| REGISTRANTROLE |
nvarchar(37) (Computed) |
yes |
CASE [REGISTRANTROLECODE] WHEN 0 THEN N'Start a company' WHEN 1 THEN N'Start a team under a company' WHEN 2 THEN N'Start an independent team' WHEN 3 THEN N'Join a team' WHEN 4 THEN N'Start a household under a company' WHEN 5 THEN N'Start a household under a team' WHEN 6 THEN N'Start an independent household' WHEN 7 THEN N'Join as an individual under a company' WHEN 8 THEN N'Join as individual participant' WHEN 9 THEN N'Join a household' END |
Provides a translation for the 'REGISTRANTROLECODE' field. |
| PARTICIPANTGOAL |
int |
|
Default = 0 |
|
| DONORRETENTIONGOAL |
decimal(7, 4) |
|
Default = 0 |
|
| COMMUNICATIONGOAL |
int |
|
Default = 0 |
|
| TEAMFUNDRAISINGGOAL |
money |
|
Default = 0 |
|
| TEAMMEMBERGOAL |
int |
|
Default = 0 |
|
| TEAMMEMBERRETENTIONGOAL |
decimal(7, 4) |
|
Default = 0 |
|
| TEAMCOMMUNICATIONGOAL |
int |
|
Default = 0 |
|
| TEAMPARTICIPANTGOAL |
int |
|
Default = 0 |
|
| COFUNDRAISINGGOAL |
money |
|
Default = 0 |
|
| COTEAMSGOAL |
int |
|
Default = 0 |
|
| COTEAMRETENTIONGOAL |
decimal(7, 4) |
|
Default = 0 |
|
| COMEMBERGOAL |
int |
|
Default = 0 |
|
| COMEMBERRETENTIONGOAL |
decimal(7, 4) |
|
Default = 0 |
|
| COPARTICIPANTGOAL |
int |
|
Default = 0 |
|
| COCOMMUNICATIONGOAL |
int |
|
Default = 0 |
|
| HOFUNDRAISINGGOAL |
money |
|
Default = 0 |
|
| HOPARTICIPANTGOAL |
int |
|
Default = 0 |
|
| HOCOMMUNICATIONGOAL |
int |
|
Default = 0 |
|
| CHECKNUMBER |
nvarchar(20) |
|
Default = '' |
|
| TEAMPAGEURL |
nvarchar(200) |
|
Default = '' |
|
| COMPANYPAGEURL |
nvarchar(200) |
|
Default = '' |
|
| ISORGANIZATION |
bit |
|
Default = 0 |
|
| ORGANIZATION_NAME |
nvarchar(100) |
|
Default = '' |
|
| ORGANIZATION_WEBADDRESS |
nvarchar(500) |
|
Default = '' |
|
| ORGANIZATION_ADDRESSBLOCK |
nvarchar(150) |
|
Default = '' |
|
| ORGANIZATION_CITY |
nvarchar(50) |
|
Default = '' |
|
| ORGANIZATION_POSTCODE |
nvarchar(12) |
|
Default = '' |
|
| ORGANIZATION_DONOTMAIL |
bit |
|
Default = 0 |
|
| ORGANIZATION_NUMBER |
nvarchar(100) |
|
Default = '' |
|
| ORGANIZATION_EMAILADDRESS |
UDT_EMAILADDRESS |
|
Default = '' |
|
| HOUSEHOLDPAGEURL |
nvarchar(200) |
|
Default = '' |
|
| AUTHORIZATIONCODE |
nvarchar(20) |
|
Default = '' |
The authorization code for a credit card payment, if applicable. |
| TRANSACTIONID |
uniqueidentifier |
yes |
|
The BBPS transaction ID for a card not present transaction. |
| REJECTIONMESSAGE |
nvarchar(250) |
|
Default = '' |
The reason the credit card couldn't be authorized. |
| HOMEMBERGOAL |
int |
|
Default = 0 |
|
| HOMEMBERRETENTIONGOAL |
decimal(7, 4) |
|
Default = 0 |
|
| HOTARGETFUNDRAISINGGOAL |
money |
|
Default = 0 |
|
| HODONORRETENTIONGOAL |
decimal(7, 4) |
|
Default = 0 |
|
| SENDNOTIFICATIONS |
bit |
|
Default = 1 |
|
| DECLINEBENEFITS |
bit |
|
Default = 0 |
|
| BENEFITS |
xml |
yes |
|
|
| VENDORID |
nvarchar(50) |
|
Default = '' |
|