Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 BUSINESSPROCESSSTATUSGUID nvarchar(36)   Default = '' Value that will identify the corresponding business process status record once it is created.
 PARAMETERSETID nvarchar(36)   Default = '' Value of the parameter set ID, stored to allow filtering before the business process status record exists.
 NAME nvarchar(100)   Default = '' The name of the parameter set at the time invitations were sent.
 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.
 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.
 MAILDATE date

Foreign Key Field Type Null Notes Description
 BUSINESSPROCESSSTATUSID uniqueidentifier BUSINESSPROCESSSTATUS.ID Foreign key to the corresponding business process status record.
 EVENTID uniqueidentifier EVENT.ID Foreign key to the event from which invitees were included in the invitation run.
 BUSINESSPROCESSVIEWID uniqueidentifier BUSINESSPROCESSVIEW.ID A foreign key to the view to used as output format for the invitation run.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 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.
 SEGMENTATIONACTIVATEPROCESSSTATUSID uniqueidentifier MKTSEGMENTATIONACTIVATEPROCESSSTATUS.ID The segmentation activate process status ID for this run of the invitation process.

Index Name Field(s) Unique Primary Clustered
 IX_INVITATIONHISTORY_DATEADDED DATEADDED    
 IX_INVITATIONHISTORY_DATECHANGED DATECHANGED      
 IX_INVITATIONHISTORY_EVENTID EVENTID      
 PK_INVITATIONHISTORY ID  
 UC_INVITATIONHISTORY_BUSINESSPROCESSSTATUSGUID BUSINESSPROCESSSTATUSGUID    

Trigger Name Description
 TR_INVITATIONHISTORY_AUDIT_UPDATE
 TR_INVITATIONHISTORY_AUDIT_DELETE

Referenced by Field
 INVITEEHISTORY INVITATIONHISTORYID

Entity-Relationship diagram of this table