Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 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.
 DESCRIPTION nvarchar(255)   Default = '' The description of the Invitation
 MAILDATE datetime The date the invitations were sent out.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 CUSTOMPARAMETERDATAFORMITEM xml Custom parameters for this process.
 CHANNELCODE tinyint   Default = 0 0=Send through both mail and email, according to each constituents preferences., 1=Send through email only, 2=Send through mail only
 CHANNEL nvarchar(77) (Computed) CASE [CHANNELCODE] WHEN 0 THEN N'Send through both mail and email, according to each constituents preferences.' WHEN 1 THEN N'Send through email only' WHEN 2 THEN N'Send through mail only' END Provides a translation for the 'CHANNELCODE' field.
 CHANNELPREFERENCECODE tinyint   Default = 0 0=Email, 1=Mail
 CHANNELPREFERENCE nvarchar(5) (Computed) CASE [CHANNELPREFERENCECODE] WHEN 0 THEN N'Email' WHEN 1 THEN N'Mail' END Provides a translation for the 'CHANNELPREFERENCECODE' field.
 HOUSEHOLDINGTYPECODE tinyint   Default = 0 The type of household processing to use in this invitation.
 HOUSEHOLDINGTYPE nvarchar(40) (Computed) CASE [HOUSEHOLDINGTYPECODE] WHEN 0 THEN N'All qualifying constituents' WHEN 1 THEN N'Qualifying individuals and organizations' WHEN 2 THEN N'Qualifying households' END Provides a translation for the 'HOUSEHOLDINGTYPECODE' field.
 HOUSEHOLDINGINCLUDEINDIVIDUALSWITHNOHOUSEHOLD bit   Default = 0 Determines whether or not to include qualifying individuals who are not members of any household.
 HOUSEHOLDINGINCLUDEHOUSEHOLDSWITHNOMEMBERS bit   Default = 0 Determines whether or not to include qualifying households which do not have any members.
 HOUSEHOLDINGONERECORDPERHOUSEHOLD bit   Default = 0 Determines whether or not to only accept one person per household during household processing.
 LABELFILENAME nvarchar(255)   Default = '' The original file name for the label template.
 LABELFILE varbinary The actual label template file.

Foreign Key Field Type Null Notes Description
 EVENTID uniqueidentifier EVENT.ID Foreign key to the event from which invitees are included in the invitation process.
 BUSINESSPROCESSVIEWID uniqueidentifier BUSINESSPROCESSVIEW.ID A foreign key to the view to use as output for the parameter set.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by the process.
 MAILPACKAGEID uniqueidentifier MKTPACKAGE.ID FK to MKTPACKAGE
 EMAILPACKAGEID uniqueidentifier MKTPACKAGE.ID FK to MKTPACKAGE
 NAMEFORMATPARAMETERID uniqueidentifier NAMEFORMATPARAMETER.ID The name format options to be used for this invitation.
 ADDRESSPROCESSINGOPTIONID uniqueidentifier ADDRESSPROCESSINGOPTION.ID The address processing options to be used for this invitation.

Index Name Field(s) Unique Primary Clustered
 IX_INVITATION_DATEADDED DATEADDED    
 IX_INVITATION_DATECHANGED DATECHANGED      
 IX_INVITATION_ID ID      
 PK_INVITATION ID  
 UIX_INVITATION_NAME_EVENTID NAME, EVENTID    

Trigger Name Description
 TR_INVITATION_AUDIT_UPDATE
 TR_INVITATION_AUDIT_DELETE

Referenced by Field
 INVITATIONEXPORTFORMAT PARAMETERSETID
 INVITATIONSTATUS PARAMETERSETID
 INVITEE INVITATIONID
 INVITEERESEND INVITATIONID

Entity-Relationship diagram of this table