REGISTRANT (3.0)

Contains information pertaining to event registrants.

Primary Key
Primary Key Field Type

ID

uniqueidentifier

Foreign Key Fields
Foreign Key Field Type Null Notes Description

EVENTID

uniqueidentifier

false

FK to EVENT

CONSTITUENTID

uniqueidentifier

true

FK to CONSTITUENT

GUESTOFREGISTRANTID

uniqueidentifier

true

Indicates that this registrant is a guest of another registrant.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

Fields
Field Field Type Null Notes Description

ATTENDED

bit

false

0

Designates whether or not the registrant attended the event.

WILLNOTATTEND

bit

false

0

Designates whether or not the registrant will attend or is only registered to allow guests.

EVENTSEATINGNOTE

nvarchar(250)

false

''

BENEFITSWAIVED

bit

false

0

Indicates if this registrant has waived benefits.

ONLINEREGISTRANT

bit

false

0

Indicates if this registrant registered through Blackbaud Internet Solutions.

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.

ISCANCELLED

bit

false

0

Designates whether or not the registrant has cancelled.

CUSTOMIDENTIFIER

nvarchar(100)

false

''

User-definable custom identifier.

SEQUENCEID

int

false

Identity column used to increment the default lookupid.

LOOKUPID

nvarchar(100) (Computed)

true

Unique identifer that supports user defined values as well as system generated values.

NOTES

nvarchar(255)

false

''

This column contains notes about a registrant.

ISWALKIN

bit

false

0

Indicates whether this registrant was a walk-in or if they preregistered.

USERMARKEDATTENDANCE

bit

false

0

True indicates that a user has explicitly marked this registrant either attended or not attended.

Indexes
Index Name Field(s) Unique Primary Clustered

IX_REGISTRANT_CONSTITUENTID

CONSTITUENTID

False

False

False

IX_REGISTRANT_DATEADDED

DATEADDED

False

False

True

IX_REGISTRANT_DATECHANGED

DATECHANGED

False

False

False

IX_REGISTRANT_EVENTID

EVENTID

False

False

False

IX_REGISTRANT_GUESTOFREGISTRANTID

GUESTOFREGISTRANTID

False

False

False

IX_REGISTRANT_ID

ID

False

False

False

PK_REGISTRANT

ID

True

True

False

UC_REGISTRANT_LOOKUPID

LOOKUPID

True

False

False

Triggers
Trigger Name Description

TR_REGISTRANT_TASYNC_I

TR_REGISTRANT_TASYNC_U

TR_REGISTRANT_TASYNC_D

TR_REGISTRANT_AUDIT_UPDATE

TR_REGISTRANT_AUDIT_DELETE

TR_REGISTRANT_MARKASCONSTITUENT

Referenced by
Referenced by Field

BATCHREVENUEAPPLICATION

REGISTRANTID

CREDITITEMEVENTREGISTRATION

REGISTRANTID

EVENTDONOR

REGISTRANTID

EVENTGROUPMEMBER

REGISTRANTID

EVENTREGISTRANTITINERARY

ID

EVENTREGISTRANTPAYMENT

REGISTRANTID

EVENTSEATINGSEAT

REGISTRANTID

FAFADDRESSBOOKCUSTOMTYPE

REGISTRANTID

FAFCOMMENTS

REGISTRANTID

FAFEVENTCOMMUNICATIONCHANNELREGISTRANT

REGISTRANTID

FAFEVENTSOCIALNETWORKPOST

REGISTRANTID

FAFRSSFEED

REGISTRANTID

PARTICIPANTWIDGET

REGISTRANTID

RE7MAPPARTICIPANTS

ID

REGISTRANTBENEFIT

REGISTRANTID

REGISTRANTBENEFITEXTENSION

REGISTRANTID

REGISTRANTDESIGNATION

REGISTRANTID

REGISTRANTDONATION

REGISTRANTID

REGISTRANTEXTENSION

REGISTRANTID

REGISTRANTPREFERENCE

REGISTRANTID

REGISTRANTREGISTRATION

REGISTRANTID

REGISTRANTREGISTRATIONMAP

REGISTRANTID

REGISTRANTRESTRICTIONOPTION

REGISTRANTID

REGISTRANTROLE

REGISTRANTID

REVENUEOFFLINEDONATION

REGISTRANTID

SALESORDERITEMEVENTREGISTRATION

REGISTRANTID

SALESORDERITEMTICKETREGISTRANT

REGISTRANTID

STORY

REGISTRANTID