Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 FUNDRAISINGGOAL money   Default = 0 Total Fundraising Goal
 ADVOCACYACTIONGOAL int   Default = 0 Advocacy Action Goal
 MEMBERECRUITMENTGOAL int   Default = 0 Total Participant Recruitment Goal
 COMMUNICATIONGOAL int   Default = 0 Total Emails sent Goal
 VOLUNTEERRECRUITMENTGOAL int   Default = 0 Volunteer Recruitment Goal
 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.
 TARGETFUNDRAISINGGOAL money   Default = 0 Target fundraising goal
 DONORRETENTIONGOAL decimal(9, 4)   Default = 0 Percentage of Donors to Retain
 OTHERUNITGOAL int   Default = 0 Other Unit Goal
 STATUSCODE tinyint   Default = 0 Registrant Status
 STATUS nvarchar(7) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Active' WHEN 1 THEN N'Pending' END Provides a translation for the 'STATUSCODE' field.
 ISPRIVATE bit   Default = 0 Link to my personal page from other event pages? 0:yes(public as default) 1:no(private)
 ALLOWADMINACCESSHQ bit   Default = 1 Allow event admin to access participant's HQ page?
 ORGANIZATIONCONSTITUENTID uniqueidentifier The constituent ID of the organization record.
 ISDASHBOARDHELPERVISIBLE bit   Default = 1
 LOCALCORPPOSTCODE nvarchar(12)   Default = ''
 ALLOWOTHERPARTICIPANTSCONTACTME bit   Default = 1

Foreign Key Field Type Null Notes Description
 REGISTRANTID uniqueidentifier   REGISTRANT.ID Foreign Key to REGISTRANT table
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 WAIVERID uniqueidentifier REGISTRATIONWAIVER.ID Foreign Key to REGISTRATIONWAIVER table
 CREDITCARDID uniqueidentifier CREDITCARD.ID Foreign Key to CREDITCARD table
 LOCALCORPID uniqueidentifier LOCALCORP.ID

Index Name Field(s) Unique Primary Clustered
 IX_REGISTRANTEXTENSION_DATEADDED DATEADDED    
 IX_REGISTRANTEXTENSION_DATECHANGED DATECHANGED      
 PK_REGISTRANTEXTENSION ID  
 UIX_REGISTRANTEXTENSION_REGISTRANTID REGISTRANTID    

Trigger Name Description
 TR_REGISTRANTEXTENSION_AUDIT_UPDATE
 TR_REGISTRANTEXTENSION_AUDIT_DELETE

Entity-Relationship diagram of this table