INVITEE

Contains information pertaining to constituents invited to events.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
INVITATIONSENTON	datetime	yes		The date the constituent was invited to the event.
DECLINED	bit		Default = 0	Indicates that the constituent has declined invitations for the event.
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.
EXCLUDEDFROMLASTSEND	bit		Default = 0	Indicates that the constituent was excluded from the last run of the invitation process either due to communication preferences or the householding options of the mailing.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
CONSTITUENTID	uniqueidentifier		CONSTITUENT.LOCALID	The constituent to invite (or that has been invited) to the event.
EVENTID	uniqueidentifier		EVENT.ID	The event to which the constituent is (or will be) invited.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
INVITATIONID	uniqueidentifier		INVITATION.ID	The invitation to which this invitee belongs.
INVITATIONRECIPIENTCONSTITUENTID	uniqueidentifier	yes	CONSTITUENT.LOCALID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_INVITEE_DATEADDED	DATEADDED			yes
IX_INVITEE_DATECHANGED	DATECHANGED
IX_INVITEE_EVENTID	EVENTID
IX_INVITEE_INVITATIONID	INVITATIONID
IX_INVITEE_INVITATIONRECIPIENTCONSTITUENTID	INVITATIONRECIPIENTCONSTITUENTID
PK_INVITEE	ID	yes	yes
UIX_INVITEE_CONSTITUENTID_INVITATIONID	CONSTITUENTID, INVITATIONID	yes

Triggers

Trigger Name	Description
TR_INVITEE_AUDIT_UPDATE
TR_INVITEE_AUDIT_DELETE

Referenced by

Referenced by	Field
INVITEERESEND	INVITEEID