BATCHEVENTSPONSORSHIP (4.0SP25)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Stores Sponsorship batch information

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier	false	BATCH.ID	FK to BATCH
EVENTID	uniqueidentifier	false	EVENT.ID	FK to EVENT
TITLECODEID	uniqueidentifier	true	TITLECODE.ID	FK to TITLECODE
SUFFIXCODEID	uniqueidentifier	true	SUFFIXCODE.ID	FK to SUFFIXCODE
MARITALSTATUSCODEID	uniqueidentifier	true	MARITALSTATUSCODE.ID	FK to MARITALSTATUSCODE
ADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
COUNTRYID	uniqueidentifier	true	COUNTRY.ID	FK to COUNTRY
STATEID	uniqueidentifier	true	STATE.ID	FK to STATE
DONOTMAILREASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	FK to DONOTMAILREASONCODE
PHONETYPECODEID	uniqueidentifier	true	PHONETYPECODE.ID	FK to PHONETYPECODE
COMPANY_ADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
COMPANY_COUNTRYID	uniqueidentifier	true	COUNTRY.ID	FK to COUNTRY
COMPANY_STATEID	uniqueidentifier	true	STATE.ID	FK to STATE
COMPANY_DONOTMAILREASONCODEID	uniqueidentifier	true	DONOTMAILREASONCODE.ID	FK to DONOTMAILREASONCODE
COMPANY_PHONETYPECODEID	uniqueidentifier	true	PHONETYPECODE.ID	FK to PHONETYPECODE
SPONSORSHIPTYPEID	uniqueidentifier	true	EVENTSPONSORSHIPTYPE.ID	FK to EVENTSPONSORSHIPTYPE
BILLING_ADDRESSTYPECODEID	uniqueidentifier	true	ADDRESSTYPECODE.ID	FK to ADDRESSTYPECODE
BILLING_COUNTRYID	uniqueidentifier	true	COUNTRY.ID	FK to COUNTRY
BILLING_STATEID	uniqueidentifier	true	STATE.ID	FK to STATE
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
ORIGINALCLIENTUSERID	int	true	ClientUsers.ID	FK to CLIENTUSERS
ORIGINALCONSTITUENTID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
PHONEID	uniqueidentifier	true	PHONE.ID	FK to PHONE
ADDRESSID	uniqueidentifier	true	ADDRESS.ID	FK to ADDRESS
EMAILADDRESSID	uniqueidentifier	true	EMAILADDRESS.ID	FK to EMAILADDRESS
ORGANIZATIONCONSTITUENTID	uniqueidentifier	true	CONSTITUENT.ID	FK to CONSTITUENT
CREDITCARDID	uniqueidentifier	true	CREDITCARD.ID	Stores the credit card details.

Fields
Field	Field Type	Null	Notes	Description
SEQUENCE	int	false	0
USERID	nvarchar(50)	false	''
PASSWORD	nvarchar(255)	false	''
LASTNAME	nvarchar(50)	false	''
FIRSTNAME	nvarchar(50)	false	''
MIDDLENAME	nvarchar(50)	false	''
NICKNAME	nvarchar(50)	false	''
MAIDENNAME	nvarchar(100)	false	''
BIRTHDATE	UDT_FUZZYDATE	false	'00000000'
GENDERCODE	tinyint	false	0	0=Unknown, 1=Male, 2=Female
GENDER	nvarchar(7) (Computed)	true		Provides a translation for the 'GENDERCODE' field.
ADDRESS	nvarchar(150)	false	''
CITY	nvarchar(50)	false	''
POSTCODE	nvarchar(12)	false	''
DONOTMAIL	bit	false	0
PHONENUMBER	nvarchar(100)	false	''
EMAILADDRESS	UDT_EMAILADDRESS	false	''
COMPANYNAME	nvarchar(100)	false	''
COMPANYURL	UDT_WEBADDRESS	false	''
COMPANY_ADDRESS	nvarchar(150)	false	''
COMPANY_CITY	nvarchar(50)	false	''
COMPANY_POSTCODE	nvarchar(12)	false	''
COMPANY_DONOTMAIL	bit	false	0
COMPANY_PHONENUMBER	nvarchar(100)	false	''
COMPANY_EMAILADDRESS	UDT_EMAILADDRESS	false	''
DECLINEBENEFITS	bit	false	0
SPONSORSHIPURL	UDT_WEBADDRESS	false	''
SPONSORSHIPMESSAGE	nvarchar(1000)	false	''
ADDITIONALDONATIONAMOUNT	money	false	0
PAYMENTMETHODCODE	tinyint	false	0	0=Cash, 1=Offline Check, 2=Credit/Debit Cards, 3=Online Check (ACH)
PAYMENTMETHOD	nvarchar(18) (Computed)	true		Provides a translation for the 'PAYMENTMETHODCODE' field.
CREDITCARDTYPE	uniqueidentifier	true
CHECKDATE	UDT_FUZZYDATE	false	'00000000'
BANKACCOUNTTYPECODE	tinyint	false	0	0=Checking Account, 1=Saving Account
BANKACCOUNTTYPE	nvarchar(16) (Computed)	true		Provides a translation for the 'BANKACCOUNTTYPECODE' field.
BANKACCOUNTHOLDER	nvarchar(100)	false	''
BANKACCOUNTNUMBER	nvarchar(100)	false	''
BANKACCOUNTROUTINGCODE	nvarchar(100)	false	''
SAMEASPRIMARYADDRESS	bit	false	1
BILLING_ADDRESSBLOCK	nvarchar(150)	false	''
BILLING_CITY	nvarchar(50)	false	''
BILLING_POSTCODE	nvarchar(12)	false	''
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
CHECKNUMBER	nvarchar(20)	false	''
ISCOMPANYSPONSOR	bit	false	0
AUTHORIZATIONCODE	nvarchar(20)	false	''	The authorization code for a credit card payment, if applicable.
TRANSACTIONID	uniqueidentifier	true		The BBPS transaction ID for a card not present transaction.
REJECTIONMESSAGE	nvarchar(250)	false	''	The reason the credit card couldn't be authorized.
SENDNOTIFICATIONS	bit	false	1
VENDORID	nvarchar(50)	false	''

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_BATCHEVENTSPONSORSHIP_ADDRESSID	ADDRESSID	False	False	False
IX_BATCHEVENTSPONSORSHIP_BATCHID	BATCHID	False	False	False
IX_BATCHEVENTSPONSORSHIP_DATEADDED	DATEADDED	False	False	True
IX_BATCHEVENTSPONSORSHIP_DATECHANGED	DATECHANGED	False	False	False
IX_BATCHEVENTSPONSORSHIP_ORGANIZATIONCONSTITUENTID	ORGANIZATIONCONSTITUENTID	False	False	False
IX_BATCHEVENTSPONSORSHIP_ORIGINALCONSTITUENTID	ORIGINALCONSTITUENTID	False	False	False
PK_BATCHEVENTSPONSORSHIP	ID	True	True	False

Triggers
Trigger Name	Description
TR_BATCHEVENTSPONSORSHIP_AUDIT_UPDATE
TR_BATCHEVENTSPONSORSHIP_AUDIT_DELETE

Referenced by
Referenced by	Field
BATCHEVENTSPONSORSHIPBATCHSYSTEMMESSAGES	BATCHEVENTSPONSORSHIPID
BATCHEVENTSPONSORSHIPBATCHUSERMESSAGE	ID
BATCHEVENTSPONSORSHIPENEWSLETTER	BATCHEVENTSPONSORSHIPID