Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 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) 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) 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
 BANKACCOUNTTYPECODE tinyint   Default = 0 0=Checking Account, 1=Saving Account
 BANKACCOUNTTYPE nvarchar(16) (Computed) 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) 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) 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 = ''
 TRANSACTIONID uniqueidentifier
 REJECTIONMESSAGE nvarchar(250)   Default = ''
 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
 VENDORID nvarchar(50)   Default = ''

Foreign Key Field Type Null Notes Description
 BATCHID uniqueidentifier   BATCH.ID FK to BATCH
 EVENTID uniqueidentifier   EVENT.ID FK to EVENT
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 REGISTRATIONOPTIONID uniqueidentifier   EVENTPRICE.ID FK to EVENTPRICE
 ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 STATEID uniqueidentifier STATE.LOCALID FK to STATE
 TITLECODEID uniqueidentifier TITLECODE.LOCALID FK to TITLECODE
 SUFFIXCODEID uniqueidentifier SUFFIXCODE.LOCALID FK to SUFFIXCODE
 MARITALSTATUSCODEID uniqueidentifier MARITALSTATUSCODE.LOCALID FK to MARITALSTATUSCODE
 PHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID FK to PHONETYPECODE
 DONOTMAILREASONCODEID uniqueidentifier DONOTMAILREASONCODE.ID FK to DONOTMAILREASONCODE
 TEAMFUNDRAISINGTEAMID uniqueidentifier TEAMFUNDRAISINGTEAM.ID FK to TEAMFUNDRAISINGTEAM
 TRIBUTEESTATEID uniqueidentifier STATE.LOCALID FK to STATE
 TRIBUTETYPECODEID uniqueidentifier TRIBUTETYPECODE.LOCALID FK to TRIBUTETYPECODE
 BILLING_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 BILLING_STATEID uniqueidentifier STATE.LOCALID FK to STATE
 ORGANIZATIONID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 ORGANIZATION_ADDRESSTYPECODEID uniqueidentifier ADDRESSTYPECODE.ID FK to ADDRESSTYPECODE
 ORGANIZATION_COUNTRYID uniqueidentifier COUNTRY.LOCALID FK to COUNTRY
 ORGANIZATION_STATEID uniqueidentifier STATE.LOCALID FK to STATE
 ORGANIZATION_DONOTMAILREASONCODEID uniqueidentifier DONOTMAILREASONCODE.ID FK to DONOTMAILREASONCODE
 ORGANIZATION_PHONETYPECODEID uniqueidentifier PHONETYPECODE.LOCALID FK to PHONETYPECODE
 ORIGINALCLIENTUSERID int ClientUsers.ID FK to CLIENTUSERS
 ORIGINALCONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 PHONEID uniqueidentifier PHONE.LOCALID FK to PHONE
 ADDRESSID uniqueidentifier ADDRESS.LOCALID FK to ADDRESS
 EMAILADDRESSID uniqueidentifier EMAILADDRESS.ID FK to EMAILADDRESS
 CREDITCARDID uniqueidentifier CREDITCARD.ID Stores the credit card details.

Index Name Field(s) Unique Primary Clustered
 IX_REGISTRANTBATCH_ADDRESSID ADDRESSID      
 IX_REGISTRANTBATCH_BATCHID BATCHID      
 IX_REGISTRANTBATCH_DATEADDED DATEADDED    
 IX_REGISTRANTBATCH_DATECHANGED DATECHANGED      
 IX_REGISTRANTBATCH_ORGANIZATIONID ORGANIZATIONID      
 IX_REGISTRANTBATCH_ORIGINALCONSTITUENTID ORIGINALCONSTITUENTID      
 PK_REGISTRANTBATCH ID  

Trigger Name Description
 TR_REGISTRANTBATCH_AUDIT_DELETE
 TR_REGISTRANTBATCH_AUDIT_UPDATE

Referenced by Field
 REGISTRANTBATCHBATCHSYSTEMMESSAGES REGISTRANTBATCHID
 REGISTRANTBATCHBATCHUSERMESSAGE ID
 REGISTRANTBATCHENEWSLETTER REGISTRANTBATCHID

Entity-Relationship diagram of this table (ADDRESS-STATE)
Entity-Relationship diagram of this table (SUFFIXCODE-TRIBUTETYPECODE)